Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 18

Displaying posts with tag: Use cases (reset)

Some use-cases for MMM for MySQL
+4 Vote Up -0Vote Down

In this blog, I would like to mark myself as a power-user of MMM.  For more then 3 years now I'm engineering high-traffic websites and none of them was a small project. In the beginning I worked behind the livejasmin.com project (warning: NSFW!) which is an Alexa top100 site and now I'm working at ustream.tv which is in the top500 (so far). In this area, your greatest enemy is downtime. Thousands of users want to see your dynamic content by executing thousand of queries against your MySQL servers and what they don't have is the patience and they don't even tolerate critical security-upgrades. In both sites I mentioned above there is no point in time during the day at which less then 10k visitors are hitting the sites.  Now one question comes up: How can you do an upgrade on your MySQL servers or how can you alter a larger table?
So you have a new feature and that means

  [Read more...]
Cluster + Dolphin DX = Sweet!
+0 Vote Up -0Vote Down
At a customer I have had the opportunity to work with some really state of the art equipment.

The customer is in the online gaming industry and we are building a platform based on MySQL Cluster where we are consolidating a number of applications. Workload is mainly inserts, updates, pk reads, and index scans (quite frequent), and a few joins. The cluster handles the transient data (current working set), and is replicating to a long term data store (following this approach), and we are also feeding other back-end support systems from this.

The cluster (>8 computers) is interconnected with Dolphin DX adapters. Computers are SUNs



  [Read more...]
How do MySQL users keep track of digital pictures?
Employee +0 Vote Up -0Vote Down

On my non-MySQL blog, I just wrote a blog post called “Photo Manager: How do you keep track of your pictures?“. I’m looking for Open Source Software that helps me keep track of my 100,000+ digital pictures. I wrote specs on dreamt-up software called “Robfat” (for rename, order, backup, find, archive, tag) as I want to remove excess fat from my HDs (and CD/DVD cabinets).

And then I thought this may have a MySQL dimension:

  [Read more...]
Do as the Swedish Police: Save money on Open Source!
Employee +0 Vote Up -0Vote Down

Yesterday, I had the pleasure of meeting with Per-Ola Sjöswärd, executive IT strategist at the Swedish National Police. That organisation is already way ahead of most of us when it comes to Open Source adoption. But they have higher ambitions still.

The Rikspolisstyrelsen logotype is on many Sun slides, as an example of an “Enterprise 2.0″ type MySQL customer. Besides sounding cool, the ”Enterprise 2.0″ name is supposed to portray what all the organisations in that group have in common: They’re generic enterprises in any industry, and they use the same internal IT architecture as Web 2.0 companies use externally.

The Swedish Police, to be specific,

  [Read more...]
MySQL 5.1 Use Case Competition: Position 1
Employee +0 Vote Up -0Vote Down

MySQL 5.1 is here! It’s announced! And it’s time for the overall winner, Position 1 in the MySQL 5.1 Use Case Competition.

1. Greg Haase (Lotame Solutions Inc., Elkridge, Maryland, USA): Using Partitioning and Event Scheduler to Prune Archive Tables. See Greg’s DevZone article, and his blog.

Thanks and congratulations,

  [Read more...]
MySQL 5.1 Use Case Competition: Position 2
Employee +0 Vote Up -0Vote Down

The GA announcement of MySQL 5.1 is coming, and for downloading, it’s already available, as I hope you have noticed from Giuseppe’s blog. We continue our preparations, this time by announcing Position 2 in the MySQL 5.1 Use Case Competition.

2. Guy Adams (Parallel Ltd., Milton Keynes, United Kingdom): Using Partitioning to Manage Satellite Networks. See Guy’s DevZone article.

  [Read more...]
MySQL 5.1 Use Case Competition: Position 3
Employee +0 Vote Up -0Vote Down

The GA announcement of MySQL 5.1 is getting closer by the minute! So it’s time for Position 3 in the MySQL 5.1 Use Case Competition.

3. Corrado Pandiani (Football Club Internazionale Milano Spa, Milan, Italy): Using Partitioning and Event Scheduler for online logging & real-time stats. See Corrado’s DevZone article, and his blog.

Thanks and congratulations, Corrado! I hope you are in a position to take

  [Read more...]
MySQL 5.1 Use Case Competition: Position 4
Employee +0 Vote Up -0Vote Down

The GA announcement of MySQL 5.1 is close, so close that we’re seeding the mirrors (I hope you noted Giuseppe’s blog entry)! So it’s time for Position 4 in the MySQL 5.1 Use Case Competition.

4. Volker Oboda (TeamDrive Systems GmbH, Hamburg, Germany): Using the Pluggable API for TeamDrive. See Volker’s DevZone article, and

  [Read more...]
MySQL 5.1 Use Case Competition: Positions 5 to 10
Employee +0 Vote Up -0Vote Down

With the GA announcement of MySQL 5.1 coming up, we have picked the winners in the MySQL 5.1 Use Case Competition.

To keep you in suspense, let me first announce those on positions 5 to 10:

5. Fourat Zouari (TriTUX.com, Tunis, Tunisia): Using Partitioning for Data Warehousing. See Fourat’s DevZone article, and

  [Read more...]
Football galore — Inter using MySQL 5.1
Employee +0 Vote Up -0Vote Down

Within minutes after Finland was just about to win 3:2 over Germany in the football world championship qualifications (but it ended 3:3), I got a bit of consolation for myself, my dual-citizenship son cheering for Finland, and my fellow countrymen using MySQL:

We have the next MySQL 5.1 Use Case article live, and it’s about FC Inter Milan. No Finns playing there (but stars such as Ibrahimovic, Materazzi, Luis Figo, and Adriano). And, from a MySQL perspective, the interesting point is that FC Inter Milan is using both MySQL 5.1 Partitioning and the Event Scheduler in an innovative way.

  [Read more...]
MySQL University Session on OpenSolaris Web Stack — 11 Sep 2008
Employee +0 Vote Up -0Vote Down

Tomorrow, there’s a particularly interesting MySQL University session coming up: The OpenSolaris Web Stack.

This session is presented by key experts outside the Database Group, but inside Sun:

  • Jyri Virkki, lead for OpenSolaris Web Stack community, Sun Microsystems
  • Murthy Chintalapati, Web Stack development, Sr Engineering Manager, Sun Microsystems

For practical reasons, this session happens three hours later than normal. To decipher that into a timezone which may be familiar

  [Read more...]
First MySQL 5.1 Use Case Article
Employee +0 Vote Up -0Vote Down

We’re getting some high quality Use Cases from our user base, related to the MySQL 5.1 Use Case Competition.

The first one is by Greg Haase of Lotame, based in Elkridge, Maryland (USA), a company dedicated to providing solutions within social media. His article is about an innovative use of MySQL 5.1 partitioning and Event Scheduler to prune ARCHIVE tables.

There are more articles in the pipeline. And there is still time for you to

  [Read more...]
Call for Papers for MySQL Conference — by 22 Oct 2008
Employee +0 Vote Up -0Vote Down

Innovation Everywhere! That’s the motto of the MySQL Conference & Expo 20-23 April 2009, in Santa Clara.

If April next year sounds like the distant future to you, then you’re evidently not planning to be a presenter. Since if you do plan to present, there’s a very close date relevant for you: 22 October 2008. That’s when the Call for Papers closes.

If you’re an innocent bystander and don’t plan on presenting, you may still enjoy lurking at the MySQL Conference Website, for instance looking at some of the



  [Read more...]
MySQL 5.1 Use Case Competition — until end of September!
Employee +0 Vote Up -0Vote Down

We timed our Use Case Competition to coincide with summer holidays, and are now prolonging the duration of the Use Case Competition with one month, until 30 September 2008.

To recap, here’s the original posting (with an updated deadline):

With 5.1 having officially been in Release Candidate status since September 2007 and soon approaching GA status, the MySQL Community Team launches a competition for the users of new features of MySQL 5.1:

Submit your MySQL 5.1 Use Case Report to community(at)mysql.com by 30 September 2008 and have a chance of winning one of our prizes:

      [Read more...]
    Symbian is FOSS
    Employee +0 Vote Up -0Vote Down

    If you for some reason missed the news yesterday: Symbian, the largest mobile operating system, will soon be Open Source. The software will be made available “over the next two years” and is intended to be released under Eclipse Public License (EPL) 1.0.

    Looking at the Symbian press release:

    Mobile leaders to unify the Symbian software platform and set the future of mobile free

    Foundation to be established to provide royalty-free open platform and accelerate innovation

    LONDON, UK; June 24, 2008 - Nokia, Sony Ericsson, Motorola and NTT DOCOMO announced today their intent to unite Symbian OS?, S60, UIQ

      [Read more...]
    Senna & Tritonn: Fast full text search in Japanese
    Employee +0 Vote Up -0Vote Down

    Friday afternoon, I met with Tetsuro Ikeda-san and Teruyoshi Hazama-san of MySQL’s long-time key partner in Japan, Sumisho. Ikeda-san and Hazama-san taught me about their work on full text search in Japanese.

    Senna is an engine for fast full text search in Japanese. The Senna project derives its name from Formula I driver Ayrton Senna. “But he’s dead”, I protested. “Sure, but he is a legend and will always be associated with speed.” I cannot protest there — and the numbers I saw for Senna’s full-text search defend the choice of name.

    Tritonn is the combination of Senna into

      [Read more...]
    Navigating categories within my blog
    Employee +0 Vote Up -0Vote Down

    With 130 entries in the “MySQL” category and no MySQL-related subcategories, my blog had become impossible to search and navigate easily.

    And thus I created a number of new categories for the MySQL entries within my blog. They’re listed in the left navigation bar, below the months, as well as below:

      [Read more...]
    Symbian enlightened by LAMP
    Employee +0 Vote Up -0Vote Down

    Followers of the Forum Nokia Developer Discussion Boards saw interesting pre-announcements last month:

    Nokia has ported MySQL and PHP to Symbian.

    With 165 million cumulative Symbian smartphones shipped since the formation of Symbian and currently 134 Symbian smartphone models commercially available, it would be interesting to see the effects on the 8,134 third-party Symbian applications commercially available by what Nokia calls “PAMP”.

    Availability is planned for next month, at the CCNC 2008 (Fifth IEEE Consumer Communications &Networking Conference, 10 - 12 January 2008 in Las

      [Read more...]
    Showing entries 1 to 18

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.