… things like how to build for massive scalability, how to do read-write splitting without breaking the user experience, how to take online non-blocking backups, or… you don’t know how to read these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s… now I’m ready to see what’s up with the database. The first step is to find out what MySQL instances are on…
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
… bottleneck for MySQL: CPU, disks, memory, network; and how to use diagnostic tools in Linux. Investigate database trends via the counters exposed in MySQL‘s SHOW GLOBAL STATUS. Backup & restore MySQL and InnoDB…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…to other database systems. MySQL has to do more than one fsync() for the log because it internally implements XA to…to minimize recovery time significantly by switching to that backup – no data copy will be required which can be significant concern to 1TB+ databases…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… by space and how much data we can comfortably put in MySQL Instance without getting in too much trouble with backups etc – because Sphinx is doing all search heavy lifting we only need to…, database buffer management can be rather complex but you need to have at least basic understanding of the processes to be able to reliably…
Post: Feature preview: Compact backups in Percona XtraBackup
January 29, 2013 By 11 Comments
… a backup where all InnoDB tables contain only Primary Keys and not secondary. It allows to safe some space on a backup storage. How much? Well, it depends on how many indexes you have. For… compact backup: 2228M. You may suspect that there is a catch somewhere, and yes, there is. To recovery a usable database, we need to…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…to complete. Here is example how it can look: mysql> show processlist; …mysql client, so you might get a feel you can’t connect to the database at all (use mysql -A in this case, to…backup or kill long running SELECT queries to let backup to…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…how to handle it, or be able to learn it. It is also important to adjust processes as required to…databases from the Slave to the dev envinronment works great for MyISAM but does not work with Innodb. Backup…
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 7 Comments
…queries against multiple MySQL servers and reports on how each type of…to your target version and let it replicate until such time you are ready to test. Another is populating spare servers from backup…) to all objects within the database server and has all privileges to the specified –temp-database…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
…to consider. The Amazon cloud platform can work very well when you don’t need high concurrency from your MySQL database…to the system’s performance and ability to mount them on other machines. This is really nice for making replicas and backups…
Post: How reliable RAID really is
June 30, 2006 By 13 Comments
… file system and MySQL database is good idea. So my story had a happy ending with only minimal (yet to be discovered) data… want backups. Do not trust to any single piece of hardware in HA scenarios. Have backups ready. If you care about your data backups…. Backups with Instant recovery – could be interesting to try to integrate DRBD with LVM so snapshot could be taken and synchronized to network as backup…
