… this statement about replication? I’ve observed things differently in MySQL 5.5 (vanilla version). “The big LOAD DATA INFILE clogs…. If the load takes 4 hours on the master, it will cause the slave to fall 4 hours behind.” Yes, I agree… 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
… boxs with MySQL 5.5 (Ubuntu Server 12.04 LTS) the pacemaker mysql plugin (ocf:heartbeat:mysql) doesn’t work, because since mysql 5.5 the statement “CHANGE MASTER TO MASTER_HOST=” ” will make… his the last version on gitub. But in my MySQL – installation a “SHOW SLAVE STATUS” will ALWAYS produce a completely output. Maybe…
Comment: Load management Techniques for MySQL
May 10, 2012 By 3 Comments
… a 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… MySQL Cluster to have a dedicated master for all batch job processing and use Gearman Workers to apply updates to this dedicated master…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
…: Tutorial on PL MySQL Conference Galera Synchronous Multi-Master Replication for MySQL. My talk on PL MySQL Conference Percona XtraDB…slave. Real “parallel replication”. Automatic node provisioning. Data consistency. No more unsyncronised slaves. Percona XtraDB Cluster is fully compatible with MySQL…
Comment: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… be any other MySQL version using standard replication). PRM works with “normal” MySQL acting as Master -> Slaves and in case of the master being evicted (intentionally or not) from the cluster the “best” slave will be…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… a slave, this means your new slave will end up with a warmed up buffer pool to mimic that of the master. Streaming…
Comment: Introducing new type of benchmark
February 27, 2012 By 16 Comments
… (real queries) and not “made up” queries 2) with a master, slave system so we could also benchmark virtualized servers with different…. We have applied it to MS SQL Server, not to MySQL yet, but it is the same idea and only a…
Comment: How Does Semisynchronous MySQL Replication Work?
March 17, 2012 By 23 Comments
Official MySQL documentation says the following : “If semisynchronous replication is enabled on the master side and there is at least one semisynchronous slave, a thread that performs a transaction commit on the master blocks…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
March 7, 2012 By 94 Comments
… only changed when a new master is elected. So how to add a new slave? Create a new slave by dumping/binary copying… mysql RA uses, which is: crm_attribute –type crm_config –name replication_info -s mysql_replication -v “||” Now start corosync on your slave and let it join the cluster, it will now correctly start slaving from…
Comment: Emulating global transaction ID with pt-heartbeat
April 24, 2012 By 6 Comments
… i hear the talk about failover from intermediate slaves to master and knowing that mysql does not have a way match the transactions… and captured information is telling that B ( relay_master_log_file: test_file , exec_master_log_pos: 2399 ) was replicating from these… C to start replicating from A with “relay_master_log_file: test_file , exec_master_log_pos: 2399″ and ignore the duplicate…
