The latest from the MySQL community

In some ways, MySQL is a victim of its own success.  Because of the focus on reliability, performance, and ease-of-use, MySQL usage continues to grow at a heavy pace.  This being the case, the demand for skilled MySQL pro’s has quickly outstripped the current supply.  Go to monster and put in ‘mysql’ and you’ll get back thousands of hits. So if you’re wondering whether getting MySQL expertise as a DBA is a good investment, wonder no more.

Without a doubt, one great way to drink in lots of MySQL DBA knowledge is to attend the upcoming MySQL User’s Conference.  At this year’s conference, there are more tracks than ever designed to help the DBA get a handle on security, performance tuning, backup and recovery, high-performance schema design, and much more.  Plus, you’ll get to see some new tools we’ve been working on to …

After some delay we are proud to present MySQL Proxy 0.6.1.

This is a pure bug-fix release and fixes some assert()oins and the win32 support. It was branched off in December and it took a while to clean up the windows package until it passed the tests.

Download it from:

http://dev.mysql.com/downloads/mysql-proxy/index.html

Changes:

• added new features to run-tests.lua (see README.TESTS)
• fixed error handling for socket functions on win32
• fixed sending fake server-greetings in connect_server()
• fixed assert()ions on write-errors

These three open-source databases, now in OpenSolaris SXDE 1/08, offer all the needed features for most of the applications out there.

"Three databases to run them all"...

... and of course, Sun offers solutions with commercial database vendors, like the Sun and Oracle's Enterprise Grid Solutions.

Sun Microsystems has released Solaris Express Developer Edition 1/08, Sun's free OpenSolaris-based distribution targeted at developers.

This release brings together integrated web stack (Apache, MySQL, Ruby, Php, PostgreSQL), NetBeans 6.0, interoperability with Microsoft's CIFS protocol, support for virtual machines via Sun xVM hypervisor, based on  technology developed by the Xen community, Sun HPC ClusterTools based on the Open MPI effort.

There are …

During the last day of the Linux Conference Australia, I and Colin had the choice between joining the crowd for the open day, or meeting a semi-private invitation from Greg Lehey a well known icon in the open source world. He organized a hackers barbecue in his very isolated place, and we could not resist. In his original invitation, Greg said that he lives "down the road", without specifying how long the road is. It turned out that it's a 90 minutes drive, which is an indication of the relative sense of distance that you get in Australia.

In the Australian bush, Greg leads a quiet life with his wife, his horses and dogs, and a few not so distant friends, dealing occasionally with stray kangaroos invading his fields, and brewing open source beer.
The barbecue met everybody's expectations, and so did Greg's famous home brewed beer, thus stimulating that sort of hacker talk …

After some delay we are proud to present MySQL Proxy 0.6.1.

This is a pure bug-fix release and fixes some assert()oins and the win32 support. It was branched off in December and it took a while to clean up the windows package until it passed the tests.

Download it from:

http://dev.mysql.com/downloads/mysql-proxy/index.html

Changes:

• added new features to run-tests.lua (see README.TESTS)
• fixed error handling for socket functions on win32
• fixed sending fake server-greetings in connect_server()
• fixed assert()ions on write-errors

Sun Microsystems has published a case study, Delivering quality service to eleven million users with MySQL, InnoDB,
and the Solaris 10 Operating System, on Fotolog, the third most active social network according to ComScore and 14th most trafficked site according to Alexa.

Challenges:
? Scale to support eleven* million members and more than 100** million page views a day
? Increase performance without increase in database hardware (significant cost savings)

…

I want to create a log table in 5.1 that is partitioned by day.  I want to roll-off old data and create new partitions for each day automatically.  Without writing a script and a cronjob, it seems like this should be possible with Events.  Let's start with the table:

create table log (
    logged datetime not null,
    id int not null auto_increment,
    text varchar(256),
    PRIMARY KEY ( logged, id )
)
PARTITION BY RANGE( TO_DAYS( logged ) ) (
    PARTITION p20080206 VALUES LESS THAN (733444),
    PARTITION p20080207 VALUES LESS THAN (733445),
    PARTITION p20080208 VALUES LESS THAN (733446)
);

This seems pretty straight-forward:  I take my log entry time and convert it TO_DAYS and partition on that.  I have tomorrow's partition all ready to go, just in case I don't get around to adding it today.  Let's create an Event to do add tomorrow's partition for us automatically each day:

…