… all batch jobs to use Gearman MySQL UDF interface to apply update transactions to the master (but having the batch job only… to take update transactions to apply and pace MySQL transactions to the real master db. You can configure multiple workers for quicker… MySQL Cluster to have a dedicated master for all batch job processing and use Gearman Workers to apply updates to this dedicated master…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
… this statement about replication? I’ve observed things differently in MySQL 5.5 (vanilla version). “The big LOAD DATA INFILE clogs… replication down. If the load takes 4 hours on the master, it will cause the slave to fall 4 hours behind… slave having the data file in the same directory as master, and another without the file. This is a great strategy…
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… in his the last version on gitub. But in my MySQL – installation a “SHOW SLAVE STATUS” will ALWAYS produce a completely…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
…. Related talks: Tutorial on PL MySQL Conference Galera Synchronous Multi-Master Replication for MySQL. My talk on PL MySQL Conference Percona XtraDB Cluster: New… the Galera library, version 2.x, a generic Synchronous Multi-Master replication plugin for transactional applications. The Galera library is developed…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
…. Percona Toolkit is the essential suite of administrative tools for MySQL. With this release we introduce a new version of pt… tool, one of the most painful things anyone experiences with MySQL is significantly alleviated. If you’ve ever delayed a project… to avoid causing replication delay, watches for load on the master, and so forth. In this respect it is quite similar…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… a warmed up buffer pool to mimic that of the master. Streaming incremental backups. It is now possible to stream incremental…
Comment: Emulating global transaction ID with pt-heartbeat
April 24, 2012 By 6 Comments
… 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…
Comment: Is DRBD the right choice for me?
March 14, 2012 By 17 Comments
… with MySQL replication is resyncing a master and slave on a database with high write activity. Locking the master and dumping the master database… limiting or halting all write activity on the master. This essentially places the master ‘out of service’ which is not ideal for…
Comment: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… 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 promoted as Master. Your howto…
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… data exists in at least two places” – (cf http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html) Of…
