MySQL Configuration Wizard Updated
We've released an updated version of the MySQL Configuration Wizard we announced at the end of last year. If you don't remember that announcement, here's the short version: this is a tool to help you generate my.cnf files based on your server's hardware and other characteristics. We've gotten really good feedback on this tool, including this nice mention on Stack Exchange: Percona just built … [Read More]
How to recover a single InnoDB table from a Full Backup
Sometimes we need to restore only some tables from a full backup maybe because your data loss affect a small number of your tables. In this particular scenario is faster to recover single tables than a full backup. This is easy with MyISAM but if your tables are InnoDB the process is a little bit different story. With Oracle's stock MySQL you cannot move your ibd files freely from one server to … [Read More]
Schedule for MySQL Conference 2012 is Published
I am pleased to announce the schedule for Percona Live: MySQL Conference And Expo 2012 is now published. This is truly great selection of talks with something for MySQL Developers, DBAs, Managers, people just starting to use MySQL as well as looking for advanced topics. We have talks about running MySQL on extremely large scale in a Web as well as running MySQL In the Enterprise Environments. … [Read More]
linux.conf.au 2012 roundup
I spent last week at linux.conf.au in Ballarat, Victoria (that's the Victoria in Australia, not wherever else there may be one) which is only a pleasant two hour drive from my home town of Melbourne (Australia, not Florida). I sent an email internally to our experts detailing bits of the conference that may interest them - and I thought that it may also interest our wider readers who are … [Read More]
Preventing MySQL Emergencies Webinar
On the 25th of January at 10 am PST, I will present a webinar on preventing MySQL emergencies titled “Preventing Downtime in Production MySQL Servers”. The material I will present is based on in-depth research done by Percona across many production servers. We analyzed more than 150 emergency cases and categorized our findings to help you learn ways to avoid production downtimes. Join us to … [Read More]
