… the binary log and slows replication down. If the load takes 4 hours on the master, it will cause the slave to fall… setup that I have, with one slave having the data file in the same directory as master, and another without the file. This… in the slave(s) first and then run it on master (BEWARE: you should make sure to delete the INFILE from the slave‘s…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
… since mysql 5.5 the statement “CHANGE MASTER TO MASTER_HOST=” ” will make an error and stop this script. As I can see… for to say that this server is a slave, but later the test of “Slave_SQL_Running: Yes” fails, because the server… as a slave. So the 2nd start of pacemaker would be fail. Yesterday, I fix this up very dirty and it works…
Comment: Load management Techniques for MySQL
May 10, 2012 By 3 Comments
… dedicated slave is to write all batch jobs to use Gearman MySQL UDF interface to apply update transactions to the master (but having the batch job only use the slave connection). You only need to implement… Worker to take update transactions to apply and pace MySQL transactions to the real master db. You can configure multiple workers for…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
… to the binlog would likely show what you’ve said and I do agree that turning off session binlog is the… verbatim on our master / slave pairs? To reiterate, are you suggesting that the actual data would be transferred across the slaves via replication when LOAD DATA INFILE command is executed on master? (cuz that’s not what…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
… file that’s loaded on the master is actually inlined into the binary log, and the replica writes out a copy of the file into the directory indicated by slave_load_tmpdir. Then…
Comment: Is DRBD the right choice for me?
March 14, 2012 By 17 Comments
… MySQL replication is resyncing a master and slave on a database with high write activity. Locking the master and dumping the master database via mysqldump can… limiting or halting all write activity on the master. This essentially places the master ‘out of service’ which is not ideal for…
Comment: Emulating global transaction ID with pt-heartbeat
April 24, 2012 By 6 Comments
Whenever i hear the talk about failover from intermediate slaves to master and knowing that mysql does not have a way match the… A——>B——->C and B crashed and captured information is telling that B ( relay_master_log_file: test_file , exec_master_log_pos: 2399… start replicating from A with “relay_master_log_file: test_file , exec_master_log_pos: 2399″ and ignore the duplicate key errors for…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… all nodes or none. Multi-master replication. You can write to any node. Parallel applying events on slave. Real “parallel replication”. Automatic… generic Synchronous Multi-Master replication plugin for transactional applications. The Galera library is developed by Codership Oy company and Galera 2.x…. Links: We provide tar.gz and RPM binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and Debian packages. Downloads: http://www.percona…
Comment: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… as Master -> Slaves and in case of the master being evicted (intentionally or not) from the cluster the “best” slave will be promoted as Master. Your howto seems very interesting and…
Comment: How Does Semisynchronous MySQL Replication Work?
March 17, 2012 By 23 Comments
… on the master side and there is at least one semisynchronous slave, a thread that performs a transaction commit on the master blocks after the commit is done and waits until at least one semisynchronous slave acknowledges that it has…
