…using Percona Replication Manager (PRM) with RHEL/CentOS prior to 6…percona3 Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona2 ] Slaves: [ percona3 ] Stopped: [ p_mysql:2 ] After the update and after… ‘/var/log/corosync.log‘ for reason: Permission denied (13).#012. So now you need to update all…
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 … these basics. log_slave_updates is REQUIRED You need to have log_slave_updates enabled on the cluster node acting as async slave for replicated events from the… transactions first. Under normal async replication, an event will not be written to the slave‘s binary unless log_slave_updates is enabled, this is…
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…log_at_trx_commit to something besides 1 and suddenly you can update…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…common theme in the questions our MySQL Support customers ask is MySQL Replication Lag. The story is typically along the lines … with replication lag (and performance in general). Typical problems for replication include setting sync_binlog=1, enabling log_slave_updates, setting innodb_flush_log_…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…log_short_formatblogpercona.commanual log_slave_updatesblogpercona.commanual log_slow_admin_statementsblogpercona.commanual log_slow_queriesblogpercona.commanual log_slow_slave_statementsblogpercona.commanual log_tcblogpercona.commanual log_tc_sizeblogpercona.commanual log…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…/replication-options-slave.html#option_mysqld_replicate-same-server-id [3] http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates [4] http://dev.mysql…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
….6/en/replication-gtids-concepts.html One thing that worths to mention is that if you want GTID support log_slave_updates will need to be enabled in slave server and the performance impact should be… which GTID is the master and set it on the slave. MySQL keeps two global variables with GTID numbers on it: gtid…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…slave” for a saner behavior. One of the important setting is “log_slave_updates = OFF” (default value). In some cases, if slaves are logging replication updates…
Post: Migrating several single standalone MySQL server to one Percona XtraDB Cluster... MariaDB to the rescue !
December 18, 2012 By 3 Comments
… is not really recommended with Galera replication even if it’s now supported. Preparing the slaves would then become a loop : for… 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 enabled…
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 so…
