June 19, 2013

Post: Galera Flow Control in Percona XtraDB Cluster for MySQL

… any node in the synchronous replication group from getting too far behind the others in… a blocking SST method like rsync or mysqldump. So, flow control kicks in when …. This setting traditionally defaulted to 0.5, meaning the queue had to fall below…1 109 0 0 09:22:23 myclu P 3 3 node3 Sync T/T 0 …

Post: Announcing Percona Server 5.5.27-28.0

from the Percona Software Repositories). Based on MySQL 5.5.27, including all the bug fixes in it, Percona Server 5.55.5.23-25.3. Bug fixed #1026926 (Stewart Smith). Fixed regression introduced in Percona Server 5.5.23-25.3… query in the output of mysqldump with –include-master-host-port option….

Post: MySQL Installation and upgrade scripts.

…painful recently. In MySQL 3.22->3.23 upgrades or 3.23->4.0 upgrades you …change a lot of applications. MySQL 5.0 added more issues to …significantly. Making sure you can afford mysqldump and reload in worse case scenario…area of marketing and taking money from the customers and have limited technical …

Post: Impossible - possible, moving InnoDB tables between servers

… hear from customers who migrated from MyISAM to InnoDB – can I just copy .ibd files from one server to another and answer “use mysqldump” is quite disappointed. Jokes aside, I see real needs in this: – when we need to restore only single table from backup… 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24…