… avoid that kind of mistakes? Having a slave server lagging behind. pt-slave-delay pt-slave-delay is another tool that comes with Percona… slave status\G *************************** 1. row *************************** [...] Slave_IO_Running: Yes Slave_SQL_Running: No [...] With “–delay=10m” I’m asking the tool to lag the slave 10…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
….sock” replication_user=”root” \ replication_passwd=”rootpass” max_slave_lag=”15″ evict_outdated_slaves=”false” \ binary=”/usr/bin/mysqld_safe” test_user=”root…: The password for the above user max_slave_lag: The maximum allowed slave lag in seconds, if a slave lags by more than that value, it will lose its reader VIP(s) evict_outdated_slaves: A…
Post: Getting use of Slave in MySQL Replication
February 14, 2007 By 15 Comments
… take time to replicate to the slave replication lag can be significant. Also even very small lag can cause the problems – for example… and if replication lag is within the limit. It may be good idea to exclude slaves from the reads if lag is high or adjust behavior to make sure you only read slaves if you…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… the slaves and there are others which are fetched but not processed. There is a chance for replication to be lagging, broken… for MySQL replication is tricky it can be long – consider slaves lagging and need few minutes to catch up and also not… failover process is still complicated and you still can have slaves lagging as semi synchronous replication does not wait for execution only…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 27, 2012 By 102 Comments
…_replication_port_default=”3306″ OCF_RESKEY_max_slave_lag_default=”3600″ OCF_RESKEY_evict_outdated_slaves_default=”false” OCF_RESKEY_reader_attribute_default….sock” replication_user=”root” replication_passwd=”repl” max_slave_lag=”15″ evict_outdated_slaves=”false” binary=”/usr/local/mysql/bin/mysqld_safe” test…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 28, 2012 By 102 Comments
…, check_slave has a bug: if replication is not working, $secs_behind is NULL, so [ $secs_behind -gt $OCF_RESKEY_max_slave_lag... is [ $secs_behind = NULL ] || [ $secs_behind -gt $OCF_RESKEY_max_slave_lag ] I added code for setting “writable” to the master and… file and log position when coming back online as a slave); it is less of a problem after fixing the secs…
Comment: Getting use of Slave in MySQL Replication
February 16, 2007 By 15 Comments
… master if the slave is lagged is very dangerous. Consider what happens if an ALTER TABLE is replicated: all slaves lag at the same…. It’s good to track but switching to a different slave or giving up and providing out of date information for…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 30, 2011 By 102 Comments
… Slave lag is adjustable, so adjust it to what makes sense to you. MMM was also removing slaves from cluster if the were lagging…
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… slaves) – Slaves perform some verification to guarantee that transaction can be committed without conflicts – Slaves return the commit – Master returns commit to client – Slaves… other application threads, it will usually be enough that any slave lag remains “small”.) Finally, I’m interesting to find out if…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 8, 2012 By 102 Comments
…|106″ Still, on the slave node, I find no slave configuration: mysql -u repl -p7la4epa99 -e’show slave statusG’ returns an empty set….sock” replication_user=”repl” replication_passwd=”7la4epa99″ max_slave_lag=”15″ evict_outdated_slaves=”false” binary=”/usr/sbin/mysqld” test_user=”root” test…” OCF_CHECK_LEVEL=”1″ \n op monitor interval=”30s” role=”Slave” OCF_CHECK_LEVEL=”1″ primitive p_writer_vip ocf:heartbeat…
