… MySQL manual, especially the option and…replicate_do_dbblogpercona.commanual replicate_do_tableblogpercona.commanual replicate_ignore_dbblogpercona.commanual replicate_ignore_tableblogpercona.commanual replicate_rewrite_dbblogpercona.commanual replicate_same_server_idblogpercona.commanual replicate…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
…load growth by only 50%. – Delays in replication MySQL replication is fast which means in average delay…the master, even on completely unrelated table, replication lag may increase dramatically. Besides monitoring which …object version information so you can quickly check if version you read from the …
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
… 1074179: pt-table-checksum doesn’t ignore tables for –replicate-check-only. When using –replicate-check-only, filter options like –databases and –tables were…, pt-heartbeat respected the MySQL time zone, but this caused false readings (e.g. very high lag) with slaves running in different…
Post: MySQL Partitioning - can save you or kill you
December 11, 2010 By 45 Comments
…a while to write about using MySQL Partitioning for Performance Optimization and I just … buffer pool size. The first problem was replication lag, which are mainly due to modifying the …replication became CPU bound (single thread) instead of IO bound. You could celebrate but hey…. you need to check…
Post: Percona Toolkit versions 2.0.5 and 2.1.2 released
June 12, 2012 By 1 Comment
…-schema-change to add even more safety checks, and to detect and deal with some MySQL optimizer misbehaviors, as well as to handle more edge-case behaviors related to things like replication lag. We fixed… our test coverage to include more MySQL versions, more operating system platforms, more types of MySQL server settings, and more versions of…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…is a synchronous replication technology, therefore the slaves should never lag behind the master. It’s not necessary to check the “seconds behind…for environments that use traditional MySQL asynchronous replication. edit: PXC is really a bit like semi-synchronous replication, in that changes are …
Post: Using pt-table-checksum with Percona XtraDB Cluster
October 15, 2012 By 2 Comments
…it doesn’t work quite like a traditional replication setup because cluster nodes are not like traditional …checking replica lag on node4000 because it is a cluster node. Not checking replica lag on node5000 because it is a cluster node. Not checking… 0 0 0 1 0 0.025 mysql.columns_priv 10-05T14:02:17 0…
Comment: Is DRBD the right choice for me?
July 8, 2009 By 18 Comments
… more here – ALTER TABLEs, MySQL Upgrades, Storage Engine changes etc….replication lag may be allowed to appear. 5) Yves: Yes… Replication is a risk here. The monitoring for replication of course must be in place as well as regular checks…
Post: Percona Toolkit 2.1.9 is ready
February 15, 2013 By Leave a Comment
…release switched the time authority from Perl to MySQL, and from local time to UTC. Unfortunately, … made the tool report a huge amount of replication lag. This release makes the tool compatible with … PRIMARY KEY”, and you have to specify –no-check-alter to acknowledge this case. * Fixed bug 1099933…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 27, 2012 By 102 Comments
…/local/mysql/etc/my.cnf” pid=”/usr/local/mysql/mysqld.pid” socket=”/tmp/mysqld.sock” replication_user=”root” replication_passwd=”repl” max_slave_lag=”15… interval=”5s” role=”Master” OCF_CHECK_LEVEL=”1″ \ op monitor interval=”2s” role=”Slave” OCF_CHECK_LEVEL=”1″ primitive reader_vip_1…
