…in /usr/lib/ocf/resource.d/heartbeat/ directory. To use this agent, you’ll need a Pacemaker configuration. As a starting…MySQL configuration, Pacemaker will automatically add “skip-start-slave” for a saner behavior. One of the important setting is “log_slave_updates = OFF” (default value). In…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…to write a blog post about these infinite loop of binary log statements in MySQL Replication. To explain what they are, how to identify them… and how to…in the loop, you can try to skip the statements by stopping the slave, set global SQL_SLAVE_SKIP_COUNTER and start the slave…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
…option query_cache_limit was implemented which limits result set which can be stored in query cache. If you need larger queries to…to use query cache ? Third party application – You can’t change how it works with MySQL to…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…in this case ? Your main options are using Backup or Slave with delayed replication (which you already could have set up with mk-slave…to MySQL bugs or wrong use. Interesting enough very few people have their data recovery practices ironed out so they can answer how…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…how do you determine the memory consumption per connection in average? This leads to…select’, ’378247551′ ‘Com_set_option‘, ’285487367′ ‘Com_show…’, ’8′ ‘Com_slave_start‘, ’0′ ‘Com_slave_stop’, ’0…used before. skip…USE ALL MEMORY AVAILABLE #innodb_log_buffer_size=8M # Lowered from 32M according to MySQL…
