MySQL

The world's most popular open source database

Contact a MySQL Representative


  • MySQL.com
  • Developer Zone
  • Partners & Solutions
  • Customer Login
  • DevZone
  • Downloads
  • Documentation
  • Articles
  • Forums
  • Bugs
  • Forge
  • Blogs
 
  • Pages

    • About me
    • Bio
    • Press Release: “Kaj Arnö Appointed MySQL VP of Community Relations”
  • Calendar

    January 2009
    M T W T F S S
    « Dec    
     1234
    567891011
    12131415161718
    19202122232425
    262728293031  
  • Recent Posts

    • In 2008, I flew 273649 km or 200 times longer than I ran, which was 1382 km
    • Back to work & Personal New Year Resolutions
    • Meet MySQL’s everyday heroes
    • Recipe for celebrating MySQL 5.1 GA
    • MySQL 5.1 is GA — including a behind-the-scenes report
    • Back from Ukraine and Russia
    • Freedom to work anywhere
    • MySQL 5.1 release schedule
    • MySQL 5.1 Use Case Competition: Position 1
    • MySQL 5.1 Use Case Competition: Position 2
    • MySQL 5.1 Use Case Competition: Position 3
    • MySQL 5.1 Use Case Competition: Position 4
    • Career trap: Internet
    • Google Summer of Code 2008 Update
    • Facebook: From 0 to 100 in less than 24h
  • Archives

  • Blogroll

    • Kaj fotografiert
    • No Software Patents!
    • Planet MySQL


  • Tags

    Alexander Arnö Argentina Black Swan Blogging Blogs Brazil Business Model Call for Papers Call for Participation CfP Community Database design David Axmark Dups Event scheduler Football Growth Innovation Ivan Nikitin Language Launch Mårten Mickos Michael "Monty" Widenius MySQL MySQL 5.1 MySQL AB MySQL Forge MySQL User Conference MySQL Users Conference Nassim Nicholas Taleb Open Source Paris Partitioning PostgreSQL Social Networking South Africa Spanish Sun Microsystems Sun Tech Days Thank you Travel Uruguay Use case Web 2.0 Workbench
  • Categories

    • Architecture of Participation
    • Connectors
    • Documentation
    • Events
    • Falcon
    • GPL
    • GUI
    • Licensing
    • MySQL
    • MySQL Cluster
    • MySQL Proxy
    • MySQL Server
    • MySQL Users Conferences
    • MySQL Workbench
    • Photography
    • PHP
    • Release Policy
    • Ruby on Rails
    • Running
    • Summer of Code
    • Sun
    • Sun visits
    • Travel
    • Use cases
    • Virtual company
Observations by Kaj Arnö @Sun

MySQL 5.1 Use Case Competition: Position 1

Monday, December 1st, 2008

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, Greg! I absolutely hope you are in a position to take advantage of your free MySQL Conference & Expo 2009 Pass, including a dinner with MySQL co-founder Michael “Monty” Widenius.

Links:

  • http://blogs.mysql.com/kaj/2008/07/18/mysql-51-use-case-competition/
  • http://blogs.mysql.com/kaj/2008/08/26/mysql-51-use-case-competition-until-end-of-september
  • http://dev.mysql.com/tech-resources/articles/partitioning-event_scheduler.html
  • http://blog.onefreevoice.com/

Posted in Architecture of Participation, MySQL, MySQL Server, MySQL Users Conferences, Use cases | No Comments »

MySQL 5.1 Use Case Competition: Position 2

Saturday, November 29th, 2008

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.

Thanks and congratulations, Guy! I hope you too are in a position to take advantage of your free MySQL Conference & Expo 2009 Pass, including a dinner with MySQL co-founder Michael “Monty” Widenius.

Links:

  • http://blogs.mysql.com/kaj/2008/07/18/mysql-51-use-case-competition/
  • http://blogs.mysql.com/kaj/2008/08/26/mysql-51-use-case-competition-until-end-of-september
  • http://dev.mysql.com/tech-resources/articles/partitioning_manage_satellite.html

Posted in Architecture of Participation, MySQL, Use cases | No Comments »

MySQL 5.1 Use Case Competition: Position 3

Friday, November 28th, 2008

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 advantage of your free MySQL Conference & Expo 2009 Pass, including a dinner with MySQL co-founder Michael “Monty” Widenius.

Links:

  • http://blogs.mysql.com/kaj/2008/07/18/mysql-51-use-case-competition/
  • http://blogs.mysql.com/kaj/2008/08/26/mysql-51-use-case-competition-until-end-of-september
  • http://dev.mysql.com/tech-resources/articles/pandiani-use-case.html
  • http://blog.pandiani.com/category/mysqlen/

Posted in Architecture of Participation, Events, MySQL, MySQL Users Conferences, Use cases | No Comments »

MySQL 5.1 Use Case Competition: Position 4

Wednesday, November 26th, 2008

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 the Wikipedia article on TeamDrive.

Thanks and congratulations, Volker! Your MySQL Community Contributor T-shirt is underway.

Links:

  • http://blogs.mysql.com/kaj/2008/07/18/mysql-51-use-case-competition/
  • http://blogs.mysql.com/kaj/2008/08/26/mysql-51-use-case-competition-until-end-of-september
  • http://dev.mysql.com/tech-resources/articles/teamdrive_pluggable_api.html

Posted in Architecture of Participation, MySQL, Use cases | 2 Comments »

MySQL 5.1 Use Case Competition: Positions 5 to 10

Saturday, November 22nd, 2008

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 his blog entry from May 2008.

6. Ryan Thiessen (Big Fish Games, Seattle, Washington, USA): Logging Game Downloads with Partitioning. See Ryan’s DevZone article.

7. Christopher Lavigne (Breadboard BI, Inc., Pleasanton, California, USA): Using MySQL 5.1 for Data Warehousing / Business Intelligence. See Christopher’s DevZone article.

8. Jianzy Zhaoyang (Alibaba.com, Hangzhou, Zhejiang Province, China): Using the MySQL 5.1 Event Scheduler for an Online Chat System. When Jian’s ongoing migration is done, he has promised a DevZone article.

9. Jakub Vrána (phpMinAdmin, Prague, Czech Republic): Managing Events in phpMinAdmin. See Lenz Grimmer’s blog entry.

10. Santo Leto (HoneySoftware, Trieste, Italy): 5.1 Use Case Reports. See Santo’s blog entries.

Thanks an congratulations, Fourat, Ryan, Christopher, Jian, Jakub and Santo! Your MySQL Community Contributor T-shirts are underway.

Links:

  • http://blogs.mysql.com/kaj/2008/07/18/mysql-51-use-case-competition/
  • http://blogs.mysql.com/kaj/2008/08/26/mysql-51-use-case-competition-until-end-of-september
  • http://dev.mysql.com/tech-resources/articles/tritux_partitioning_datawarehousing.html
  • http://dev.mysql.com/tech-resources/articles/big_fish_games_partitioning.html
  • http://dev.mysql.com/tech-resources/articles/breadboardbi_data_warehouse.html

Posted in Architecture of Participation, MySQL, MySQL Server, Use cases | No Comments »

First MySQL 5.1 Use Case Article

Monday, September 8th, 2008

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 submit your story by 30 September 2008. We’re all excited to read them, and with your permission, we’ll share them with our user base.

Links:

  • Greg Haase’s article Using Partitioning and Event Scheduler to Prune Archive Tables: http://dev.mysql.com/tech-resources/articles/partitioning-event_scheduler.html
  • Greg’s blog about Databases and Linux: http://blog.onefreevoice.com/
  • The MySQL 5.1 Use Case Competition announcement: http://dev.mysql.com/tech-resources/articles/mysql-5.1-use-case-competition.html

Posted in MySQL, MySQL Server, Use cases | No Comments »

MySQL 5.1 Use Case Competition — until end of September!

Tuesday, August 26th, 2008

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:

  • 1st-3rd prize: A MySQL Conference & Expo 2009 Pass, including a dinner with MySQL co-founder Michael “Monty” Widenius
  • 4th-10th prize: MySQL Community Contributor T-shirts
  • 11th-20th prize: A Sakila mascot (MySQL’s pet dolphin)

You may phrase your MySQL 5.1 Use Case Report freely, but the more colour you give it, the better your chances of winning.

By submitting the report, you also volunteer for appearing in our upcoming Use Case articles. We will consider any data you submit in your Use Case Report as public and quotable in our reports. However, you may ask us to anonymise certain aspects of your use case, should you otherwise not be able to participate in our competition.

This is the desired format of your submissions:

From: <you>
To: Community(at)mysql.com
Cc: <any of your colleagues you wish to inform>
Subject: MySQL 5.1 Use Case Report: <Feature> / <App Name>

MySQL Community Team,

At <company/organisation> we've used <new 5.1 feature> since <date>.

We're now on MySQL 5.1.<n> and we started development using
<new 5.1 feature> with MySQL.5.1.<m>.


Purpose of our appication:

Reason we need <new 5.1 feature>:

Development environment, OS, language:

Deployment environment, OS, hardware:

Relevant metrics on size/type of application:

Our comment on how <new 5.1 feature> meets our needs:
- comments on usability of feature
- comments on clarity of documentation
- comments on performance
- comments on bugs encountered [1]

Our greetings to the MySQL Engineering Team:

Name and email of submitter / developer:

Name of organisation:

Geographic location (city, country):

MySQL Enterprise customer: (YES/NO)

[1] If you’ve found bugs, then please follow our bug reporting instructions and share bug numbers from bugs.mysql.com in your use case report.

We’re looking for Use Cases on all new MySQL 5.1 features, but especially on

  • Partitioning: Doc * Forum * Articles JonS & PeterG, RobinS, RS2, Giuseppe
  • Row-Based Replication: Doc * Forum
  • Event Scheduler: Doc * Forum
  • Logs on demand / Table logging: Doc * Forum * Article Giuseppe
  • Plugin API: Doc
  • XML functions: Doc * Article: Bar & PeterG
  • but also other improvements: Doc *Article Jay

Links:

  • MySQL 5.1 Article Recap: http://dev.mysql.com/tech-resources/articles/mysql-5.1-recap.html

Posted in Architecture of Participation, Events, MySQL, MySQL Server, MySQL Users Conferences, Use cases | 1 Comment »

MySQL 5.1 Use Case Competition

Friday, July 18th, 2008

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 31 August 2008 and have a chance of winning one of our prizes:

  • 1st-3rd prize: A MySQL Conference & Expo 2009 Pass, including a dinner with MySQL co-founder Michael “Monty” Widenius
  • 4th-10th prize: MySQL Community Contributor T-shirts
  • 11th-20th prize: A Sakila mascot (MySQL’s pet dolphin)

You may phrase your MySQL 5.1 Use Case Report freely, but the more colour you give it, the better your chances of winning.

By submitting the report, you also volunteer for appearing in our upcoming Use Case articles. We will consider any data you submit in your Use Case Report as public and quotable in our reports. However, you may ask us to anonymise certain aspects of your use case, should you otherwise not be able to participate in our competition.

This is the desired format of your submissions:

From: <you>
To: Community(at)mysql.com
Cc: <any of your colleagues you wish to inform>
Subject: MySQL 5.1 Use Case Report: <Feature> / <App Name>

MySQL Community Team,

At <company/organisation> we've used <new 5.1 feature> since <date>.

We're now on MySQL 5.1.<n> and we started development using
<new 5.1 feature> with MySQL.5.1.<m>.


Purpose of our appication:

Reason we need <new 5.1 feature>:

Development environment, OS, language:

Deployment environment, OS, hardware:

Relevant metrics on size/type of application:

Our comment on how <new 5.1 feature> meets our needs:
- comments on usability of feature
- comments on clarity of documentation
- comments on performance
- comments on bugs encountered [1]

Our greetings to the MySQL Engineering Team:

Name and email of submitter / developer:

Name of organisation:

Geographic location (city, country):

MySQL Enterprise customer: (YES/NO)

[1] If you’ve found bugs, then please follow our bug reporting instructions and share bug numbers from bugs.mysql.com in your use case report.

We’re looking for Use Cases on all new MySQL 5.1 features, but especially on

  • Partitioning: Doc * Forum * Articles JonS & PeterG, RobinS, RS2, Giuseppe
  • Row-Based Replication: Doc * Forum
  • Event Scheduler: Doc * Forum
  • Logs on demand / Table logging: Doc * Forum * Article Giuseppe
  • Plugin API: Doc
  • XML functions: Doc * Article: Bar & PeterG
  • but also other improvements: Doc *Article Jay

Links:

  • MySQL 5.1 Article Recap: http://dev.mysql.com/tech-resources/articles/mysql-5.1-recap.html

Posted in Architecture of Participation, Events, MySQL | 5 Comments »

Observations by Kaj Arnö @Sun is proudly powered by WordPress MU running on Blogs.mysql.com.
Entries (RSS) and Comments (RSS).