The latest from the MySQL community

These two builds represent a major milestone for Virtual Appliances- they are the first appliances we have released that have shell access enabled!

That’s right! For everybody who asked for shell access, it is now enabled! Tasks such as migrating existing Cacti data, adding/editing cronjobs, or editing the php.ini file in the LAMP VA are now easily possible using the shell.

Other new/improved features include:

• Improved networking configuration - now supports static routes (user requested feature)
• Cacti VA exports pseudo-root filesystem containing scripts and resource directory from Cacti installation. This allows end-user installed Cacti plugins & extensions.
• Cacti VA is now an easily expandable two virtual hard disk configuration, which allows for simple expansion to accomodate polling more data for large sites.
• Updated PHP, MySQL, and other binaries.
…

This is a distilled version of the talk I gave at the phpug Dortmund in March. I'll concentrate on the High Availability aspect here but I won't leave out Load Balancing completely. Also, this is in English while the talk was in German.

High Availability and Load Balancing

High Availability and Load Balancing are often used in combination if not synonymous which is as wrong as it can get. They certainly do have some things in common (several machines do something) and they are often needed at similar times (when a website becomes more important) but the fundamental ideas are quite different.

While Load Balancing spreads incoming http requests over several machines this is not a highly available setup. High Availability …

Proven Scaling will sponsor three people to attend the MySQL Conference and Expo 2007 in Santa Clara, California, April 23-26!

That’s right, we will pay for your airfare and hotel, transport from the airport, and even a stipend for meals! MySQL AB has graciously provided us with conference passes for the Free Ride winners, so the winners will each receive a full conference pass.

Go to Proven Scaling Free Ride to enter. The deadline is midnight PDT (GMT-7), Friday March 23rd (just over a week away), so do it soon!

I look forward to reading your entries — and I hope to see you there!

Today I had a hard time dealing with mysql and transactions. Somehow my transaction has been committed in the middle of the statements. A short look into the manual revealed that there are SQL command that implicit commit a transaction. While I do understand that CREATE TABLE commits a transaction, I was surprised that LOAD DATA INFILE does it too!

And since I use the nice REPLACE INTO SELECT ... workaround found on mysqlperformanceblog (Hint: Always a great resource!) I had to upgrade my development mysql server because since version 5.0.28 LOAD DATA INFILE does not commit a transaction.

MySQL manual

Today I spoke on MySQL at PHP Quebec. Here are my slides.. It was a first time giving this presentation, so feel free to email feedback to morgan [[at]] mysql.com.

Database migration is an old favorite, so I'm looking forward on speaking again tomorrow!

Event Information

Topic:
Zmanda Management Console for Amanda Enterprise Edition

Date and Time:
Thursday, March 22, 2007 10:00 am
Pacific Daylight Time (GMT -07:00, San Francisco)

Panelist(s) Info:
Shailen Patel - Professional Services Engineer,
Dmitri Joukovski - VP of Product Management,
Ram “TK” Krishnamurthy - VP of Services and Support

Duration: 1 hour

Description:
The recently released Amanda Enterprise Edition 2.6, contains Zmanda Management Console [ZMC]. ZMC is a web-based services that is integrated with the Zmanda Network. This release also includes Amanda Rapid Installer, a very simple and easy to use installation mechanism that installs MySQL, PHP, Apache and all …

Reading last few days worth of planet MySQL and commenting on some entries as you can see. The post by Oli catches my attention. There is also PDF with more details available

Oli is saying you can use MySQL with Active Active Clustering and MyISAM tables if you follow certain rules like enabling external locking, disabling query cache and delayed key writes etc. This is as far as many articles on this point go, and in theory this is what should work. In practice however you should think about what exactly are you looking for with this setup.

Performance ? This configuration adds effectively global table locks besides extra overhead you get from external locking. Plus key cache have to be invalidated with remote writes which makes even less …

Looking at post by Konstantin Osipov we should finally get Query Cache working with prepared statements in MySQL 5.1

The interesting thing Konstantin notes it just took few days to fix it - I believe MySQL Support Team alone spent much more times explaining customers why is it not done or troubleshooting cases with wrong customer assumptions regarding this problems. I think I alone spent tens of hours in various cases related to this problem.

This is one thing MySQL Development Management could consider - if the thing is annoying and it does not take a long to fix it why not to go ahead and make it done instead of spending longer time explaining over and over again why this stuff is not high priority

This feature should help MySQL getting even better results in SpecJAppServer benchmarks as previously it was hard choice - if you want to have …

Send me your resume, and I'll hook you up with a job at Yahoo!

Specifically I'm looking for a mySQL DBA, with 64-bit Linux Experience.
If you have more sys-admin / development skills then actually DBA skills no worries, if your good I'll give you a crash course in how to tune / improve uses of mysql.


Send your inquires to

mysqldba1@yahoo.com

or comment on this blog.

We'd like to test few things in regards to MySQL and Innodb scalability with multiple CPUs but we seems to be short of boxes right now, all stuff we have access to is in production right now which makes it not good for benchmark.

Could anyone lend us access to the box with at least 4 cores running Linux or Solaris ?