…-Server-5.0/Percona-Server-5.0.91-22/ Release Percona Server/XtraDB 5.1.45-rel10.2 is available also ( we backported patches from 5.1.47 to 5.1.45): http://www.percona.com/downloads/Percona-Server-5.1/Percona-Server-5.1.45-10.2…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… 23:45:30 [ERROR] WSREP: Local state seqno (6) is greater than group seqno (5): states …percona2) 120724 10:58:09 [Note] WSREP: Quorum results: version = 2, component = PRIMARY, conf_id = 2, members = 1/1 (joined/… or SST. In conclusion: 2 nodes cluster is possible with Percona XtraDB Cluster but it’s…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… Min: 0.81 ms; Max: 275.94 ms Avg: 5.06 ms Surprise! results are actually better than …case we could observe the replication delay for over 45 seconds which is quite nasty. Note though delay … port: 3306 Percona XtraDB Cluster (GPL), wsrep_23.7.2.r3843 wsrep_node_address=10.9.9.1 wsrep_provider=/usr/…
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
…TABLE `c` ( `tracker_id` int(10) unsigned NOT NULL, `username` …Value | +——————————+——-+ | Innodb_scan_pages_contiguous | 45 | | Innodb_scan_pages_jumpy | 35904 | +——————————+——-+ 2 rows in set … statistics in 5.0-percona releases (coming to 5.1-XtraDB…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
…have XtraDB with innodb_expand_import extension and with innodb_expand_import=1 setting) 4) run alter table IMPORTEDTABLE discard tablespace; 5) copy… 3 indexes are detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17…35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
… our binary builds with 5.1.36. On new server we run set global innodb_expand_import=1; to put XtraDB into extended import… is started. InnoDB: import: 2 indexes are detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14… 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…5.5.11 with XtraDB. Requires m1.large or larger. ami-f65ea19f shard-query-infobright-demo i686 ICE 3.5…1,Q8.2,Q8.3,Q8.4,Q9,Q10,Q11 34.354,60.978,114.175,27.138,45…
