…. There I will cover XtraDB Cluster features and usage scenarios. MySQL and SSD: usage and tuning. This talk I’ve been… to MySQL, XtraBackup, XtraDB Cluster, etc. More interesting, by the time of conference we will have published our new book: High Performance MySQL: Optimization, Backups…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… read these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… the discussion to topics such as monitoring, alerting, backups, caching, reverse proxies, and high availability solutions, all of which we can frequently…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…it is many month projects. Why is that ? Performing MySQL upgrade two things should normally worry you. It…for any reason). As you’ve gotten database backup and set of queries which is representative …number of scalability bugs in MySQL history when issues would only happen at high load. You can …
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… more in MySQL 5.0 Baron has spotted it by incident when we were verifying some of examples for High Performance MySQL book. In the bug Heikki explains the code was probably removed in MySQL 5.0 during XA… cases – for example when you’re taking LVM snapshot (for backup or to clone slave from the master) and can’t…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…mysql binary logs for point-in-time recovery after a restoring a backup. Since the backup… performance …mysql> select sum(total_lines) from complete_example2; +——————+ | sum(total_lines) | +——————+ | 155187034 | <-- too high +——————+ 1 row in set (0.68 sec) mysql…
Page: Consulting for MySQL
July 31, 2006 By
…High Performance Application Architecture Design If you application architecture is flawed there is only limited gain you can achieve by MySQL…
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 18 Comments
… Cluster. The first feature is High Availability. But before jumping to HA… that you can convert your existing MySQL / Percona Server into Node and …you can shutdown any Node to perform maintenance or make configuration changes. …frm files (the same as with regular backup). Even with that, SST may be…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…MySQL/MariaDB + Galera 0.8 is interesting? It allows to solve following problems: A Real High… an average MySQL master-slave setup. Potential performance penalty: Although to have performance numbers I …integration with Percona XtraBackup and its incremental backup features, it is possible to have …
Post: Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 7 Comments
… Cycle problems and its impact to MySQL Performance. Here are couple of links (1,… battery discharge/learn cycle many Battery Backup Unit (BBU) based controllers help but … Disabled Automatic Failover : Enabled Global task priority : High Performance Mode : Default/Dynamic Stayawake period : Disabled …
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… the local system performance independently from anything else. Performance This is perhaps …you want SAN like high availability I would highly consider DRBD which can…MySQL replication is a showstopper) and it also solves the other big pain of semi-online MySQL/OS upgrades and Schema changes. Backups…
