… a results comparison on a single-node (on the left) vs. two-node (on the right) configuration. No surprises here, the…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… 5 and CentOS 5. Bug fixed #1144777 (Ignacio Nin). When mysqldump was used with –innodb-optimize-keys option it produced invalid…_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
… 6.3 during installation. Bugs fixed #1031427 and #1051874. When mysqldump was used with –innodb-optimize-keys option it produced invalid… keys from deferred key creation optimization. Bug fixed #1081016. When mysqldump was used with –innodb-optimize-keys and –no-data options…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
It’s not uncommon to promote a server from slave to master. One of the key things to protect your data integrity is to make sure that the promoted slave is permanently disconnected from its old master. If not, it may get writes from the old master, which can cause all kinds of data corruption. …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… 5 and CentOS 5. Bug fixed #1144777 (Ignacio Nin). When mysqldump was used with –innodb-optimize-keys option it produced invalid…_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
April 3, 2013 By 10 Comments
More simplistic Memcache vs. Memcache observations: http://blog.ulf-wendel.de/2013/toying-with-peclmysqlnd_memcache-and-mysql-5-6-memcache-innodb/ HandlerSocket vs Memcache is hard to compare as one would compare apples…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… comparison between performance of 5.6 memcached innodb write/read vs 5.6 innodb write/read with no memcached layer? Currently…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… rough code for this benchmark: // Identical config/code for memcached vs InnoDB $frontendOpts = array( ‘caching’ => true, ‘lifetime’ => 3600, ‘automatic_serialization’ => true…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… almost to zero. We will run benchmarks with Thread Pool vs no-Thread Pool so we will see exact curve there…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… backups Strong Points: Very fast for logical backups – compared to mysqldump Consistent backups between myisam and innodb tables. Global read lock… as painless as possible. Compressed mydumper typically 3x-5x smaller vs compressed xtrabackup Typically we upload mydumper backups to s3…
