… master. This can be useful if you’re trying to limit the amount of data sent over the wire, but it… 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
…as much as you think. While the theoretical limit of 1Gbps is actually 120MBps, I start…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: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… ideas of GTIDs: having for each event across the cluster a monotonically incremental identifier for each event. Notice that …! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check …, it is good to be aware of the current limitations.
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
… MySQL Conference but want to take advantage of the keynotes, BOFs, and Community Networking Reception, I’m pleased to offer a limited number of $5 Expo Only passes. Use discount code “KEY” when registering for the Percona Live MySQL Conference. Hurry…” Jay Janssen, Consulting Lead, Percona Topic: “Migrating to Percona XtraDB Cluster” Mark Atwood, Vipul Sabhaya, and Jim Cooley, HP Topic: “Using…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… flow control in a master/slave cluster might be: mysql> set global wsrep_provider_options=”gcs.fc_limit=500; gcs.fc_master_slave… control on your cluster. The cost of increasing the fc_limit Keeping the fc_limit small has two three purposes: It limits the amount of delay any node in the cluster might have applying cluster…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… 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 … This means more waiting, and after the limit is exceeded you will still get the…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… some highlights: Official support for MySQL 5.6 and Percona XtraDB Cluster We started beta support for MySQL 5.6 in 2.1.8 when 5.6 was still beta. Now that MySQL… forever by default, so specify –iterations or –run-time to limit how long they run. There are more changes in addition…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… important to avoid swapping with HA that NDB cluster basically forbids calling malloc after the startup phase …need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file… is about 28GB and the file upload size limit is 5GB. So, about 28GB was written to…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… a high throughput despite the response time limitations. Even with parallel replication, the response time limits the number of transactions / second that…, galera and built-in mysql replication are independent from each other. Q: I installed Percona as cluster database working with Zabbix (innodb…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…cluster_conf_id | 18446744073709551615 | | wsrep_cluster_size | 1 | | wsrep_cluster_state_uuid | 8dccca9f-d4b8-11e1-0800-344f6b618448 | | wsrep_cluster…mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL…: options: gcs.fc_limit=9999999; gcs.fc…
