… order on one slave than on another (or on the master). So in general “last executed GTID” makes little sense, rather…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
… pick the correct binlog position when switching to a new master. Old-style replication will work. That being said, I agree…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 22, 2013 By 8 Comments
… to GTID. Simply STOP SLAVE on the slave server, CHANGE MASTER to make it use GTID to connect, START SLAVE. There…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… specify the master-user, master-password, master-host and master-port in the my.cnf file? # cat my.cnf [...] master-user=rsandbox master-password=rsandbox master-host=127.0.0.1 master…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… acting as async slave for replicated events from the async master to be applied to the other nodes, that is if…. However, this may work differently when replicating from an async master, for example like the one described on these two bugs… your async master can use ROW based binlog format as well to achieve better consistency, if you have an async master <= 5…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… from the cluster. gcs.fc_master_slave The fc_limit is modified dynamically if you have fc_master_slave disabled (which it… current fc_limit (adjusted by the above calculation if fc_master_slave=NO). This yields the number of transactions the recv… in a master/slave cluster might be: mysql> set global wsrep_provider_options=”gcs.fc_limit=500; gcs.fc_master_slave=YES…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
…? I am running mysqlslap against a galera-head of a master/master pair right now and don’t see the same kind… or mariadb 5.5 on the same hardware in a master/slave. I wonder if it is writing as synchronous? I…
Comment: How to lag a slave behind to avoid a disaster
April 25, 2013 By 5 Comments
… master-log-file master-log-pos’ reliable enough to synch up two slaves with their master? I have a set up now with master… slave 2 behind slave1 to make it a chain replication , master => slave 1 = > slave 2. The only option I see to… make sure master_log_position on slave 1 is ahead of slave 2 and stop slave 2, take the master positions off…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
…- Take a backup from any server on the replication environment, master or slave: # innobackupex /destination/ In the destination folder there will…-080027635ef5:1-4″; slave1 > CHANGE MASTER TO MASTER_HOST=”10.0.1.1″, master_user=”msandbox”, master_password=”msandbox”, MASTER_AUTO_POSITION = 1; 5- Check…
Comment: Using Flexviews - part two, change data capture
March 22, 2013 By 26 Comments
…select * from binlog_consumer_status; +———–+—————–+—————–+———————+ | server_id | master_log_file | master_log_size | exec_master_log_pos | +———–+—————–+—————–+———————+ | 11111 | binlog.000006 | 262934935 | 16450550…
