Using MySQL 5.6? Tell us what you think!
The MySQL Community Team would like to know what you folks using MySQL 5.6 think of the new features. From time to time we would like to quiz you admittedly good looking and brilliant group about how MySQL 5.6 is being evaluated, if it is solving problems that previously existed, and just how well it works for you. We need feedback from you cutting edge explorers to improve the breed. So please reply to this blog or send me a note at David.Stokes AT Oracle.
Last time I checked there was one test in the MySQL test suite (mtr) that covers one case for crash recovery. Perhaps there is a private test suite. Given that I modify InnoDB and replication code and that I frequently debug crashes at work I wish there were more tests. I added many tests in the Facebook patch for crash recovery to confirm that recovery works for the replication slave, replication master and InnoDB. While doing so I found at least one bug in rpl_transaction_enabled.
MySQL databases are a great workhorse of the internet. They back tons of modern websites, from blogs and checkout carts, to huge sites like Facebook. But these technologies don't run themselves. When you're faced with a system that is slowing down, you'll need the right tools to diagnose and troubleshoot the problem. MySQL has a huge community following and that means scores of great tools for your toolbox.
1. Use innotop
It’s August 1st, 2011, and five years ago on or about this date (who can remember clearly?) Peter Zaitsev and Vadim Tkachenko founded Percona. What’s happened in the last five years?
href="http://d1wcmuriwzc7sn.cloudfront.net/wp-content/uploads/2011/08/electric-symbol-2.png"> class="alignleft size-full wp-image-1416" title="electric symbol 2" src="http://d1wcmuriwzc7sn.cloudfront.net/wp-content/uploads/2011/08/electric-symbol-2.png" alt="" width="221" height="197" />1. Backup outside of the Cloud
Keith Larson (Oracle’s MySQL Community Manager) nominated me to become an Oracle ACE. Thank you Oracle — it feels very good to receive this award.
I will be presenting Care and Feeding of a MySQL Server for Linux Adminstrators twice in August. The first is August 2nd at the Oracle Office in Frisco, Texas at 4:30 PM (Suite 300 ,7640 Warren Parkway, Frisco, TX). We will have refreshments, door prizes, and a discussion about having a meeting (or two) in the Irving office.
MySQL in the Cloud
href="http://d1wcmuriwzc7sn.cloudfront.net/wp-content/uploads/2011/07/cloud-computing.png"> class="alignleft size-full wp-image-1401" title="cloud computing" src="http://d1wcmuriwzc7sn.cloudfront.net/wp-content/uploads/2011/07/cloud-computing.png" alt="" width="258" height="212" />Deploying in the Amazon cloud is touted as a great way to achieve high scalability while paying only for the computing power you use. How do you get the best scalability from the technology?
1. Use Auto-scaling