I’ll be presenting at Oracle Open World on the causes of downtime in MySQL, and how to prevent it. This is a research-based session that presents an easy-to-digest post-mortem of hundreds of emergency issues filed by Percona customers. The real causes and types of downtime surprised me quite a bit, and the preventions run counter to a lot of conventional wisdom. I’ll just give a preview by saying that you should consider it a top priority to monitor how full your disks are!

Amazon EC2 and cloud computing offer great promise for startups to ramp up their online presence quickly.  Navigate those challenges with an strong partner.  We bring 20 years experience to the table with each new client.

• Scaling Web Applications
• MySQL High Availability in Amazon EC2
• Amazon Multi-AZ Deployments
• Amazon RDS Deployments
• Migrating to Amazon EC2
• Migrating to MySQL
• Managing Backups and Disaster Recovery in the Cloud
• Horizontal Scalability of MySQL on EC2
• Horizontal Scalability on Cloud Hosted Servers
• Evaluating Cloud Providers
• Evaluating MySQL Distributions and Platforms
• Strong Customer Facing Skills
• Integrate Directly with Development Team
• Agile …

These are the rules of the Freenode #mysql drinking game.

1. Any non op posts a pastebin link either either the query and no error or the error and no query drink
2. Any non op posts a query with, “why doesn’t this work?” without any explanation about the results they want or what they’re getting drink
3. Domas trolls the channel with a legit issue drink
4. When a postgres guy answers a question about sqlite in #mysql 3 drinks
5. Someone answers a question with, “kill yourself” drink
6. Someone asks a phpmyadmin question
7. Someone asks a workbench question
8. Someone can’t figure out how to reset the root password
9. Someone says they are getting an access denied error but they insist the username and password are correct.
10. Someone asks a mssql question but tries to disguise it as a mysql question because there is no mssql channel.
…

So far, we have looked at connecting to a MySQL database via Perl and Python. Next, we will look at connecting via PHP. I am assuming that you have already installed PHP or have the ability to run PHP scripts on your server, and that you have MySQL installed as well.

This example will use the same address table from the previous post, Inserting Data into MySQL with Perl.

Here is the SQL statement that we used to create the table:

SET NAMES latin1;
SET FOREIGN_KEY_CHECKS = 0;

CREATE TABLE `address` (
`name_first` varchar(30) NOT NULL,
`name_last` varchar(30) NOT NULL,
`address_01` varchar(40) NOT NULL,
`address_02` varchar(40) NOT NULL,
`address_city` varchar(30) NOT NULL,
`address_state` varchar(20) NOT NULL,
…

After much feedback from the community who have been using mydumper I have created the first bugfix release of the 0.5 series of mydumper.  Changes in this release are as follows:

• 
  
• Fix MySQL 5.0 compile issue
  
• Make the metadata file visible (after muliple requests)
  
• Add --no-lock option to mydumper
  
• First --daemon snapshot is now at execution instead of the first timed interval
  
• Fix CentOS 5.x compile issue (also affected Mac OSX)
  
• Fix libmysqlclient search bug
  
• Add cppcheck target
  
• Fix errors flaged by cppcheck
  
• Add option to turn off docs build
  
• Add status output at end of CMake
  

To obtain this release you can download it from …

After much feedback from the community who have been using mydumper I have created the first bugfix release of the 0.5 series of mydumper.  Changes in this release are as follows:

• Fix MySQL 5.0 compile issue
• Make the metadata file visible (after muliple requests)
• Add –no-lock option to mydumper
• First –daemon snapshot is now at execution instead of the first timed interval
• Fix CentOS 5.x compile issue (also affected Mac OSX)
• Fix libmysqlclient search bug
• Add cppcheck target
• Fix errors flaged by cppcheck
• Add option to turn off docs build
• Add status output at end of CMake

To obtain this release you can download it from Launchpad.

Many thanks to everyone who has been …

Couchbase raises $14m. AppFog raises $8m. Much ado about Percona Live MySQL Conference and Expo. And more.

# Couchbase raised $14m in series C funding for its NoSQL database.

# AppFog raised $8m series B funding for its PHP-based platform-as-a-service.

# Percona announced its plans to host a Percona Live MySQL Conference and Expo on April 10-12, effectively replacing the O’Reilly MySQL Conference and Expo.

# The announcement sparked some rumblings of discomfort around the MySQL community with Giuseppe Maxia and …

As a MySQL DBA, I guess you use the SHOW GLOBAL STATUS command or the corresponding INFORMATION_SCHEMA.GLOBAL STATUS table to show current mySQL status quite often. And many of us use different tools to collect that data and view it.

But sometimes we use same command from the SQL prompt, because we have to, because it's the only option or just because that is the most convenient way. And often you kick of two such command in a row, a few seconds apart, just to see how things are moving:
SHOW GLOBAL STATUS LIKE 'innodb%rows%';
... DBA picks his or her nose for a few seconds ...
SHOW GLOBAL STATUS LIKE 'innodb%rows%';

And then you can see how things are advancing. But how much? To figure of how much, you have to calculate the differnce between the values returned by those two statements. And then there is another issue. How much is the difference per second? To know what the difference is per second, we …

Last week, Baron Schwartz announced the Percona Live MySQL Conference and Expo 2012.

Percona organized MySQL related conferences and seminars before, and from what I've heard, with considerable success and to satisfaction of its attendees, and there's one coming up in London in October 2011. But arguably, last week's announcement is quite different from the prior Percona conferences. It's different, because it seeks to replace the annual O'Reilly MySQL Conference and Expo.

Everyone that has read the announcement will have no trouble recognizing it as a replacement, …

The season of conferences, webinars and seminars is coming. As the summer vacations are coming to a sumptuous and fulfilling end, the techies are getting ready towards sharpening and sharing their technical know-how with the public through the events. From MySQL to Oracle to SQL Server, the things are all set to appease your technical [...]