… to set up replication filters on the slave, as described in the MySQL manual. You can configure the slave to only replicate a specific… replication filtering rules are processed. There are some informative flowcharts in addition to the textual explanation. Q: What is my recommendation for MySQL… server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication,… will be disallowed in a future release. 1 row in set (0.00 sec) As the message… for filtering on both columns, but also for filtering by just the first one. Why can’t MySQL enforce …
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…(PXC) for MySQL is a hot thing right now …MyISAM tables. You can still try by filtering MyISAM tables though if you can … if your async master can use ROW based binlog format as well to … through the replication stream expect some replication lag. This is because because synchronous replication inside…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…in the questions our MySQL Support customers ask is MySQL Replication Lag. The story is typically along… 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 cause…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
…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: 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: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… would be in single-threaded MySQL replication. Therefore all nodes stay in sync…filtering-out tables from replication in master side vs slave side? A: You can configure filtering…replicating vs SBR replication? RBR is faster than statement based, correct? A: Often that’s true, Row-Based Replication…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
… bad use of replication filters rollback of transactions mixing transactional and non-transactional tables The real problem is that replication may keep on…)) > change master to master_log_file=’mysql-bin.000001′, master_log_pos=2690; Query OK, 0 rows affected (0,06 sec) slave1… last byte read from ‘./mysql-bin.000001′ at 2896.’ Conclusion You should not assume that replication checksums in MySQL 5.6 will ensure…
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_…
