… are: Make the master read-only so that the slaves can execute all events and be in sync with the master Change configuration for… not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a new table on the master: mysql> create…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… post. Tuning flow control Flow control is triggered when a Synced node exceeds a specific threshold relative to the size of… from the cluster. gcs.fc_master_slave The fc_limit is modified dynamically if you have fc_master_slave disabled (which it is by… control in a master/slave cluster might be: mysql> set global wsrep_provider_options=”gcs.fc_limit=500; gcs.fc_master_slave=YES; gcs.fc…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… has no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually…’re making them (anyone obsessively testing slave position to ensure it’s caught up with the master?). Synchronous replication with PXC and…
Comment: How to lag a slave behind to avoid a disaster
April 25, 2013 By 5 Comments
…mysql ‘start slave until master-log-file master-log-pos’ reliable enough to synch up two slaves with their master…slave 2 behind slave1 to make it a chain replication , master => slave 1 = > slave 2. The only option I see to stop slave…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… to the amazing MySQL manual, especially the option and variable reference table…sync_master_wait_sessionsblogpercona.commanual Rpl_semi_sync_master_yes_txblogpercona.commanual rpl_semi_sync_slave_enabledblogpercona.commanual Rpl_semi_sync_slave_statusblogpercona.commanual rpl_semi_sync_slave…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… need to know in which GTID is the master and set it on the slave. MySQL keeps two global variables with GTID numbers… MASTER TO MASTER_HOST=”127.0.0.1″, MASTER_USER=”msandbox”, MASTER_PASSWORD=”msandbox”, MASTER_PORT=18675, MASTER_AUTO_POSITION = 1; How to restore a slave in… run the pt-table-checksum and pt-table-sync. How to restore a slave in a good and slow way The good…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… it in traditional master-slave setups, but with big difference – with Galera we have Semi-synchronous slaves. How it works on slaves: slaves just acknowledge… on both masters and do not worry about conflict resolution and get rid of those “slave is out of sync with master” pain-in… three node cluster is much more complex than an average MySQL master-slave setup. Potential performance penalty: Although to have performance numbers I…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… posted the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot… used. sync_master_info = 10000 Quite useless change in my opinion. Syncing master info every 10000 events is no better than not syncing it at all as replication will be badly out of sync if slave…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES | 50000 | 445 | | SYNC_RELAY_LOG_INFO | 0 | 10000 | | SLAVE_LOAD_TMPDIR | /mnt/data/sandboxes/msb_… | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE_PER_TABLE | OFF | ON | | SYNC_MASTER_INFO | 0 | 10000 | | DATADIR |…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL…master splits from several slaves it still remains operational. Use with extreme caution even in master-slave setups, because slaves won’t automatically reconnect to master… | Synced (6) | | …
