… set of databases and tables. With this method, every event is still written to the binary log on the master, but the… a relay master (it can be on the same machine if you use the BLACKHOLE storage engine) in between the actual master and… of the SQL nodes in a MySQL Cluster installation are going to be talking to the same set of data nodes on…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
It may not be easy to simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE… the same transaction. The same issue can arise if slave host is using different storage engine for the respective table on master databases. Also…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… implied an implicit secondary index with the same name. Fixed by detecting such cases and … event that a slave was disconnected from the master, under certain conditions, upon reconnect, it would … for MySQL would re-create the test database when using rpm on server upgrade, even if the database …
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… flipped into service if the active master server has an issue. At Groupon, our standard MySQL database configuration follows this active/passive pattern… next one. As an additional experiment we tried replaying the same chunk again. We expected everything to be cached if we…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… implied an implicit secondary index with the same name. Fixed by detecting such cases and … event that a slave was disconnected from the master, under certain conditions, upon reconnect, it would … for MySQL would re-create the test database when using rpm on server upgrade, even if the database …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…how they will affect your database workload. For example: Transaction …MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL…try to update the same row within the same RTT? This …s caught up with the master?). Synchronous replication with PXC and…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
… against a galera-head of a master/master pair right now and don’t see the same kind of disk i/o on… I have seen when running mysql 5.1 or mariadb 5.5 on the same hardware in a master/slave. I wonder if… with six 300G SAS drives in a raid10 for the database and four 2TB SATA drives in a raid10 for the…
Post: Master-Master or Master with Many Slaves
April 6, 2007 By 7 Comments
… for same amount of servers. For example if we have 6 boxes we can use 1 master and 5 slaves or 3 master-master pairs. In this case each of the master-master nodes gets 1/3rd of database size… MySQL database caches you can get 12GB effective cache on the master-N-slave configuration compared to 36GB of effective cache on 3 master-master…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
…’ve gotten database backup and set of queries which is representative enough you should set it up on 2 same boxes and… master. Finally as you have your slave running on new MySQL version you want to promote it to the master and upgrade Master too… cases however it is not possible as MySQL only fully support slaves newer than the master. Older slaves may have issues unable…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… entry is needed for each role, Master and Slave. Intervals must not be the same. Following the mysql primitive declaration, the primitives for… a master and slaves. The only thing that may change here is clone-max=”3″ which should match the number of database…_only setting on the slave so, make sure the application database use doesn’t have the SUPER privilege which overrides read…
