…in most cases your virtual disk is basically nothing more than a file on the host filesystem rather than an actual physical volume. So, in…One way is to set up replication filters on the slave, as described in the MySQL manual. You can configure the slave…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…master] you can’t commit (at all) more than once per RTT. Applied to a Galera cluster In… one RTT between the two nodes in…run a transaction that adds the relationship …MySQL Innodb with asynchronous slaves. We may not think about the tradeoffs, but we’re making them (anyone obsessively testing slave…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…more. I always smile at “nothing has changed” claim as it usually wrong, and one…Slave Role Changing Slave role, such as swapping active and passive masters in Master-Master setup is often cause of the problem for similar reason as MySQL…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… for the above user max_slave_lag: The maximum allowed slave lag in seconds, if a slave lags by more than that value, it will lose… promoted to master. There are not many requirements regarding the MySQL configuration, Pacemaker will automatically add “skip-start-slave” for a saner behavior. One of…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…in case 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 in…no more than one primary component in the cluster. In our …you can also add records: percona2 mysql> insert into …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…slave that is behind. Until it catches up, the view of the data on the slave is “behind” the changes on the master…in set (43 min 10.11 sec) As an added benefit, if you build more than one complete refresh view from an incrementally refreshable one…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 7 Comments
…in MySQL binary log can’t proceed. It is either more than than just…one large update to help MySQL replication lag it is not going to work. This brings us to rule number one… multiple update queries which add up to long time…. thumb depending on differences in master/slave configuration, their load and…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…master tooâ€, however, is plain false. DRBD won’t “destroy the original master†any more than it already was if the filesystem on top of DRBD was fried beforehand. Let us again compare MySQL Replication to DRBD in…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
…Slave Server Load – MySQL Replication goes in…MySQL Replication executes queries one after another on the slave, so if you have query which takes certain time on the master…slaves as efficient on the Master and the more powerful the Master…. Idea: MySQL Should add “Replication… time rather than break is…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…other tool. Store your backups on more than one server. In addition to local copies, store …master and slave Re-transfer files that are partially transferred Compress the files after successful transfer Amazon S3 for MySQL…with little additional work Tips/Tricks: –add-header=x-amz-server-side-…
