… the risk with automated failover come from two elements – first failover itself involves short downtime, which means failover triggered in the wrong… such for these solutions there is certain hardcoded level of automation involved, for example if node discovers the problem in Percona…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… timestamps may not be flexible enough. The trigger method has a lot of problems. Triggers add a significant overhead. When the structure…, the triggers must be changed. The work in the trigger is immediate and affects every transaction. Finally, MySQL has limited trigger support, some… utility included with FlexCDC called ‘add_table.php’. This script automates the process of adding a table to the list of…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
December 7, 2011 By 102 Comments
… or interpretation of some configuration parameter. We have approximately 500 automated regression tests to avoid relying on people’s memory. > For… was something that if I set unique=”1″ it will trigger a restart of > the resource (as a side effect, it…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… set for ease of reference (an easy task with an automated too, or a quick Vim command if I’m doing… from InnoDB, for example. (The INFORMATION_SCHEMA query will surely trigger errors about this.) There are a bunch of other things…
Comment: MySQL Architecture meeting at Google
April 25, 2008 By 2 Comments
… then automate pushing them to the new storage engine. And if the change capture mechanism is to use a trigger on every…
