…will allow you to stripe a TCP connection over multiple ports, and with a two-NIC bonded pair you…from master to slave, and if so, how? A: Yes. There are a few of ways to do it. One way is to set up replication filters on the slave, as described in the MySQL manual. You can configure the slave…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
…multiplication and synchronous clusters I’ve seen a lot of people…’t really much different from standard mysql replication. 1 master with 5 async slaves is going to send a separate replication … every second. I’m running a sysbench test on one node and measuring the outbound (UP) bandwidth on that …
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users …slave for replicated events from the async master to be applied to the other nodes, that is if you have more than one… on multiple nodes. Have PRIMARY KEYS If you still have tables without PRIMARY KEYs, then its time to make one…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL…can’t modify data on multiple cluster nodes simultaneously. You can…Instead of updating global counters one at a time (from Example …testing slave position to ensure it’s caught up with the master…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
… longer. There are multiple reasons why application falls behind and why we see those lag spikes: Slave Server Load – MySQL Replication goes in… Queries – MySQL Replication executes queries one after another on the slave, so if you have query which takes certain time on the master you…
Post: Master-Master or Master with Many Slaves
April 6, 2007 By 7 Comments
…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…multiple master-master pairs. I however agree if you have small database (compared to memory size) with insignificant write load master-N-slave…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
… data is necessary to define the same Triggers in Master and Slave servers. Example: mysql> create trigger Copy_data AFTER INSERT on t… values on master and slaves the actual used auto incremental value is logged as an extra event just before the statement. MySQL uses… was for a insert with only one value. What is the behavior if we insert multiple values and we have gaps? Example…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…snapshot campatibility – this is obvious one. May need root …multiple volumes If you have logs on separate devices or just your database spanning across multiple…MySQL Server. Wait for it to perform recovery. 11) Use CHANGE MASTER TO to point slave to saved binary log position: change master to master…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…one thread on the slave can handle the write operations. If the replication master is multi-cores servers and is heavily writing using multiple…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…one you need to use SHOW SLAVE STATUS which provides much more information. mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master…
