… from the cluster. gcs.fc_master_slave The fc_limit is modified dynamically if you have fc_master_slave disabled (which it is by… write to a single node in PXC, then it is recommended you disable this feature by setting fc_master_slave=YES. Despite its… only lagging nodes will be the slaves with no writes coming from them. However, with multi-node writing, larger queues will make…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…Innodb at a time is a single row, so the most any single row can be modified … This is not implemented for full BEGIN … COMMIT multi-statement transactions since it cannot be assumed …them (anyone obsessively testing slave position to ensure it’s caught up with the master?). Synchronous replication …
Post: Making MySQL Replication Parallel
January 30, 2007 By 1 Comment
… only single CPU and single disk effectively which is getting worse and worse as computers are getting “wider” these days with multi-core… to come quite soon. On other hand if support for Multi-Master is implemented for many applications Parallel Replication could be implemented… written to its own binary log file and setup multi-master replication so slave can read all of them in parallel you can…
Post: Migrating several single standalone MySQL server to one Percona XtraDB Cluster... MariaDB to the rescue !
December 18, 2012 By 3 Comments
… the single production servers where more than 3 ? So I decided to use a wonderful feature of MariaDB 10: Multi-source replication… standard slave (standard asynchronous replication of MySQL), it can spread in the cluster all statements received from the master if log_slave_updates…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… master splits from several slaves it still remains operational. Use with extreme caution even in master-slave setups, because slaves won’t automatically reconnect to master… brain? This is a dangerous setting in multi-master setup, but should simplify things in master-slave cluster (especially if only 2 nodes are… nodes communicating each others and 1/3 (33%) on the single one. In this case the service will be stopped on…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…with no delays. Finally, the analysis is usually multi-dimensional. The typical user wants to … of a single server (or if you’re using replication, the capacity of a single slave). Sharding … TABLE — a typical reason to think about master-master with failover and failback for maintenance. As with…
Comment: MySQL Replication vs DRBD Battles
April 29, 2008 By 12 Comments
… database/application designs that just don’t allow for friendly multi-master setups. More real-time data warehouse applications that log tons…, merely having a slave sitting ready to take master can be troublesome in some situations because the slave is still single-threaded. You end up getting a beefier slave than your production system just so that a single thread on the slave…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… Because of features like multi-threadeded apply, changes are executed more promptly than they would be in single-threaded MySQL replication. …tables from replication in master side vs slave side? A: You can configure filtering either on the master or the slave. Master-side filtering records…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…slave-info when backing up from a slave so you know what the position you are in the master…mydumper restores: Restoring a single file Restoring a single schema or rolling forward a single schema to a … been using the version from github, Mostly for multi-part upload support. This prevents us from …
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
… single node. The cluster contained the tuning: wsrep_provider_options = “gcs.fc_limit = 256; gcs.fc_factor = 0.99; gcs.fc_master_slave = yes” based on Codership’s recommended tuning for single-node writing. I was running wsrep_slave_threads=16 and… on which it is based offers a much more realistic multi-datacenter system for high availability and disaster recovery than semi…
