…slaves. You can also use the slave_compressed_protocol option in /etc/my.cnf if bandwidth is…state an obvious disclaimer here in that the aforementioned statements reflect only my opinion and not…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… mysql> reset slave; Query OK, 0 rows affected (0.03 sec) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Master…: 4 Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL_Running: No [...] This is not expected: instead of removing all settings…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… not enjoy running too many servers. For others it becomes space and power constraint. It is also…or dealing with use not fully up to date slaves. Some innovation is coming from third party vendors…get very fast IO and so consolidate system suffering from IO bound workloads. There is KickFire …
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…Slave to make another one you need to use SHOW SLAVE STATUS which provides much more information. mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State…Slave_IO_Running: Yes Slave_SQL_Running…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…is typically along the lines everything is same as before and for some unknown reason the slave is started to lag and not…IO subsystem Could there be any side load on IO subsystem ? This can take many forms. It can be you running…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…states that we often hit the “max_connections” threshold (650) connections. Cpu is…’ ‘Qcache_lowmem_prunes’, ’4314′ ‘Qcache_not_cached’, ’294363493′ ‘Qcache_queries_… ’1104831′ ‘Slave_open_temp_tables’, ’0′ ‘Slave_retried_transactions’, ’0′ ‘Slave_running‘, ‘OFF’ ‘… innodb_file_io_threads=4 innodb_…
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
…is some statistics about the system. With parameters stated… not at one Master-Slave …IO related examples. In these cases failover to working box can be very good solution. Yet the problem is it is…not following best practices and do not test in properly. Lots of unfortunate downtime is result. Running…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
…parameter –log-slow-slave-statements. THE DETAILED…_table will state that. Filesort is for indicating …_distinct: 20 InnoDB_IO_r_ops is the …is more chance for hash collisions. In case InnoDB is not used for the query execution that information is… patch was tested and run successfully under stress…
Post: Announcing Percona XtraBackup 2.0.4
December 4, 2012 By 2 Comments
…. This release is the current GA …parameter values were not normalized to the …slave-backup-timeout was reached when using the safe-slave-backup option, SQL_THREAD was left in stopped state causing the slave… innodb_file_io_threads being deprecated… tests can now be run concurrently. Bug fixed #…
Comment: Implementing Parallel Replication in MySQL
November 16, 2010 By 3 Comments
…is best to avoid the complex mix of states in the “full independence” approach. We need replication state to become _more_ crash resistent, not…slave, more binlog stream will become pending from the IO thread, increasing the opportunities for parallelisation and helping the slave…
