… my.cnf pid_file setting. socket: The MySQL unix socket file replication_user: The user to use when setting up replication. It is also currently used for… example configuration has no stonith devices defined so stonith is disable. At the end of the configuration, you’ll notice the replication…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…it in my.cnf file, the remaining part of the configuration will not matter, because the log file won’…you to filter queries logged by execution plan. For example to log only queries doing full table … of connection pooling. Rate limiting is disabled for the replication thread. Can be changed at run …
Post: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 6 Comments
…to generate its own copy of the table, for example by running the same cron jobs MASTER …replication and just want to do a restart without replication breaking you can do the following: Add skip-slave-start in your my.cnf… which would save table to on disk file on shutdown and load it back on startup…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
… 16gigs or ram. Here is our my.cnf # sammple MySQL config file for very large systems. # # # This is for a large system with memory of… case you choose this method, then # start replication for the first time (even unsuccessfully, for example # if you mistyped the password in master-password…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
… rows that change. Feed third party replication systems. Provide data to “external triggers”…format=1) unique server_id in the my.cnf log_slave_updates=1, if this…example file to consumer.ini and edit it, making appropriate changes. The file is well commented. The example settings file should work for…
