Some weeks ago I had to migrate some independent MySQL servers (some standard MySQL masters, and some just standalone) to a Percona… also standard slave (standard asynchronous replication of MySQL), it can spread in the cluster all statements received from the master if log_slave_updates is…
Post: Migrating several single standalone MySQL server to one Percona XtraDB Cluster... MariaDB to the rescue !
December 18, 2012 By 3 Comments
Post: What is exec_time in binary logs?
January 31, 2011 By 2 Comments
If you’ve used MySQL‘s mysqlbinlog tool, you’ve probably seen something like the …. This gets logged into the binary log and copied to replicas for replay. Now suppose that you have also set log_slave_updates on the replica. When the statement executes in the replication thread, it will be logged to the replica’s binary log…
Post: How to know if you're updating Slave you should not ?
April 11, 2010 By 8 Comments
… reason to have binary log on the slave if you do not need it for anything else. By default MySQL will only write… at once. In many cases however log_slave_updates is enabled which makes slave to write all updates to binary logs – the ones executed directly on… Slave binary log which has updates one on Master and another on Slave directly: # at 666 #100411 19:24:01 server id 1 end_log…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… you have master-master with slaves or if you want to backup one master, you need log_slave_updates[3] to be enabled. This is for example the case if you re using MMM with slaves. But if… [3] http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates [4] http://dev.mysql.com/doc/refman…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… have MySQL 5.1 or aren’t using RBR, then it is possible to set up a dedicated MySQL slave which has log_slave_updates=1 and binlog_format=row to process SBR changes from a MySQL master. I’ll…: MySQL 5.1+ row based logging (binlog_format=1) unique server_id in the my.cnf log_slave_updates=1, if this is a MySQL slave transaction…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… MySQL is not impossible but surely more complicated and has much higher performance overhead – you can run slave with –sync-binlog and –log-slave-updates so you can see what last statement was executed before the crash and then find matching position in the master logs…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…_format=ROW log_bin=mysql-bin wsrep_cluster_address=gcomm:// wsrep_provider=/usr/lib/libgalera_smm.so datadir=/var/lib/mysql wsrep_slave_threads=2 wsrep_cluster_name=pxctest wsrep_sst_method=xtrabackup wsrep_node_name=ip-10-112-39-98 log_slave_updates innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 innodb_buffer_pool_size=400M innodb_log_file…
Post: Percona Server 5.1.60-13.1
December 16, 2011 By Leave a Comment
….1 downloads and from the Percona Software Repositories). Based on MySQL 5.1.60, including all the bug fixes in it….1.60-13.1 milestone at Launchpad. Bug Fixes SHOW SLAVE STATUS could give incorrect output with master-master replication and… master-master replication and –log-slave-updates enabled. This is also filed in MySQL bug tracker, but not fixed in upstream MySQL at the time…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… 1 end_log_pos 829 Update_rows: table id 17 flags: STMT_END_F BINLOG ‘ L5cLURMBAAAALwAAAAUDAAAAABEAAAAAAAEABHRlc3QABHRlc3QAAwMD/gL+CQY= L5cLURgBAAAAOAAAAD0DAAAAABEAAAAAAAEAA///+AIAAAAAAAAAA2JhcvgCAAAAAAAAAANob3A= ‘/*!*/; ### UPDATE test.test…:39 server id 1 end_log_pos 856 Xid = 85 COMMIT/*!*/; Note how ALTER is logged before the UPDATE, because ALTER did not… application that use MySQL versions prior to 5.5: I remember a customer case where there is a reporting slave that daily…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… stock MySQL. Yet another way is using DRBD to get a standby MySQL server or at least synchronously replicated master binary logs. If… they should be on promoted slave and slave should have –log-slave-updates enabled so it somethat has copy of master logs. In many cases I… Slave running out of space, Slave crashing (and loosing its position on master), Replication breakage (or running out of sync) due to MySQL…
