…of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication itself and getting things right with filtering can…shared here mainly applies to logical level replication. MySQL 5.1 can use row level replication which alleviates some of these issues but I…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
… MySQL replication hierarchy? We have, too. As consultants, a lot of times we need to get a quick overview of the whole replication hierarchy and specific things about it, such as replication filters, versions, whether replication is running, how far behind…:16) Replication Is a slave, has 0 slaves connected, is not read_only Filters replicate_wild_ignore_table=foo%.mount% Binary logging ROW Slave…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what…filter out events) so you can see whenever there are any suspicious events in the replication …possible queries become more complicated scanning more rows than before. Data growth is frequent …
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…MySQL replication to become bottleneck …mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql…filter to only check queries from replication thread: mk-query-digest slow-log –filter ‘($event->{…
Post: Why audit logging with triggers in MySQL is bad for replication
September 29, 2008 By 10 Comments
….local,u=root,p=xxx –replicate=checksum.checksum –emptyrepltbl –chunksize=500000 –… http://hackmysql.com/mysqlsla_filters for how to filter by statement. Looking through…: Foo Event_Manipulation: UPDATE *************************** 2. row *************************** trigger_name: Foo_Delete event_…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… MySQL configurations for high availability is master-master replication, which is just like normal master-slave replication… master: mk-query-digest –processlist h=active \ –filter ‘$event->{arg} =~ m/^SELECT/i’ –execute h…no database or table name — the second row in the table above. Those are a…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…change at runtime from MySQL console wit SET or SET GLOBAL command. log_slow_filter=name Log only…connection pooling. Rate limiting is disabled for the replication thread. Can be changed at run time with… log queries which examine less than min_examined_row_limit rows to file. If you are not …
