…Master/Slave Set: ms_MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona2 (unmanaged) p_mysql:1 (ocf::percona:mysql): Started percona3 (unmanaged) Stopped: [ p_mysql…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… replication topology. On the top-level master, you leave all filters disabled; on the relay master you add binary log filters; this… 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: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…master_user=’rsandbox’,master_password=’rsandbox’,master_port=10001,master_auto_position=1; s0> start slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master…the ideas of GTIDs: having for each event across the cluster a monotonically incremental identifier for each event. Notice that this…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… your cluster, the more the bandwidth required for replication multiplies. Now, this isn’t really much different from standard mysql replication. 1 master… 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…
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
… a potent open source clustering solution. RSF-1 costs a lot. So OmniOS should only be used as MySQL read slaves behind a pair of Linux based MySQL Masters using Pacemaker. Maybe you guys can get Galera working on OmniOS to solve our lack of clustering problem on…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump …_slave_updates enabled on the cluster node acting as async slave for replicated events from the async master to be applied to… from an async master, for example like the one described on these two bugs. Galera use writesets to replicate cluster events to…
Post: My Sessions at Percona Live MySQL Conference and Expo 2013
April 1, 2013 By Leave a Comment
….percona.com/live/mysql-conference-2013/sessions/migrating-percona-xtradb-cluster The Hazards of Multi-writing in a Dual-Master setup This talks…://www.percona.com/live/mysql-conference-2013/sessions/hazards-multi-writing-dual-master-setup BOF: Galera / Percona XtraDB Cluster for MySQL I also submitted…
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…. Bug fixed #1132974 (Seppo Jaakola). Conflicting prepared statements in multi-master use case could cause node to hang. This was happening…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… committing transactions from the cluster. gcs.fc_master_slave The fc_limit is modified dynamically if you have fc_master_slave disabled (which… control in a master/slave cluster might be: mysql> set global wsrep_provider_options=”gcs.fc_limit=500; gcs.fc_master_slave=YES; gcs…, which minimizes replication conflicts on a cluster where writes happen on all nodes. On a master/slave cluster, therefore, it’s reasonable to…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually…-sync replication master] you can’t commit (at all) more than once per RTT. Applied to a Galera cluster In the cluster we… can be modified cluster-wide is once per RTT. What about WAN clusters? Callaghan’s law applies to WAN clusters as well. LANs…
