…. Q: What is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based… MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL/NDB Cluster is also somewhat similar to Oracle RAC; all of the SQL nodes in a MySQL Cluster installation are…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
…the multicast address space routes to my Galera replication interface, eth1: [all nodes...mysql]# service mysql stop [root@node1 mysql]# service mysql stop [root@node1 mysql]# service mysql start –wsrep_cluster_address=gcomm:// [root@node2 mysql]# service mysql start [root@node3 mysql]# service mysql…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… commented about this on my last webinar, but …0 Duplicates: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level… # Key redundant ends with a prefix of the clustered index # Key definitions: # KEY `redundant` (`…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…of GTIDs: having for each event across the cluster a monotonically incremental identifier for each event. … For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And … a solution of course, but very poor in my opinion: look for the binlog file/position …
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
MySQL can be deployed in several ways, and that means …threaded replication is not enough, people can use Percona XtraDB Cluster, which has some of its own caveats, but you … at next month’s RAMP conference in Budapest, Hungary. My presentation will provide an overview of some possible deployment …
Comment: Percona XtraBackup 2.1.2 for MySQL available for download
May 22, 2013 By 4 Comments
…-cluster/10198-can-not-get-percona-xtradb-cluster-to-link-up-start-mysql-its-a-cluster-f). When I update i could not start my…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… to announce the release of Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL on April 17, 2013. Binaries are….user_send_window could trigger cluster crash under high load. Bug fixed #1080539 (Teemu Ollakka). Standard MySQL port would be used when… the tmpdir was specified more than once in the MySQL configuration file (my.cnf). Bugs fixed #1160047 and #1086978 (Raghavendra D Prabhu…
Post: My Sessions at Percona Live MySQL Conference and Expo 2013
April 1, 2013 By Leave a Comment
…/live/mysql-conference-2013/sessions/percona-xtradb-cluster-galera-practice-part-1 http://www.percona.com/live/mysql-conference-2013/sessions/percona-xtradb-cluster-galera-practice-part-2 Migrating to Percona XtraDB Cluster for MySQL This is a…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication…cluster-wide is once per RTT. What about WAN clusters? Callaghan’s law applies to WAN clusters … start to lag. So what about my application? Think about your workload. How …
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…, I delivered a six-hour tutorial about Percona XtraDB Cluster (PXC) for MySQL. I actually had more material than I covered (by… mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack of understanding of this system… example configuration tuning flow control in a master/slave cluster might be: mysql> set global wsrep_provider_options=”gcs.fc_limit=500…
