… do with MySQL Replication, such as filtered replication or cross storage engine replication, though which are not typically used for HA purposes. Time Delayed replication is… for MySQL as they use for PostgreSQL for example instead of investing time to learn about MySQL Replication or just looking to keep MySQL…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… the bin-log and thus isn’t replicated, why ? without any replication filters or relevant args, the replication breaks reliably on the __tmp_x table why ? The first question sounds like a potential MySQL…
Post: Webinar: Looking for Painless MySQL High Availability ?
November 19, 2012 By Leave a Comment
…software very successfully to implement advanced filtering, achieve much higher replication performance with parallel replication as well as make failover a lot more painless and easy to use. If you’re using MySQL Replication…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
It is easy for MySQL replication to become bottleneck when Master server is not seriously loaded … all queries MySQL server ran with their times and run mk-query-digest with filter to only check queries from replication thread: mk-query-digest slow-log –filter ‘($event->{user} || “”) =~ m/[SLAVE…
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… last byte read from ‘./mysql-bin.000001′ at 2896.’ Conclusion You should not assume that replication checksums in MySQL 5.6 will ensure…
Post: Thank you for joining us at Percona Live, NYC 2012
October 7, 2012 By 1 Comment
… and Parallel replication, filtering, cross database replication. It feature set beats MySQL 5.6 but as Robert Hodges puts it , “it works with MySQL 5.0″. Robert shared his vision for the place of MySQL in future data processing systems and his vision for Continuent replication…
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
…-table-checksum doesn’t ignore tables for –replicate-check-only. When using –replicate-check-only, filter options like –databases and –tables were not…: pt-heartbeat handles timezones inconsistently. Previously, pt-heartbeat respected the MySQL time zone, but this caused false readings (e.g. very…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… executed more promptly than they would be in single-threaded MySQL replication. Therefore all nodes stay in sync much more reliably. Also… are advantages/disadvantages of filtering-out tables from replication in master side vs slave side? A: You can configure filtering either on the…
Post: Why MySQL's binlog-do-db option is dangerous
May 14, 2009 By 15 Comments
…see a lot of people filtering replication with binlog-do-db, binlog-ignore-db, replicate-do-db, and replicate-ignore-db. Although there …: $ mysql mysql> delete from garbage.junk; mysql> use garbage; mysql> update production.users set disabled = 1 where user = “root”; You just broke replication, …
Comment: Announcement of Percona XtraDB Cluster 5.5.23
May 23, 2012 By 16 Comments
… you wanna mean about replicate_* filters. Those filters are used with mysql replication so it means that I have to configure replication on the node where…
