… the part about replication, can you help re-affirm this statement about replication? I’ve observed things differently in MySQL 5.5 (vanilla… clogs the binary log and slows replication down. If the load takes 4 hours on the master, it will cause the slave… run this on master LOAD DATA INFILE ‘/tmp/data.out’ INTO TABLE some_data_table; Using this strategy, replication continues to happen…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
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 HA solution. Percona XtraDB Cluster provides: Synchronous replication. Transaction…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… tool, one of the most painful things anyone experiences with MySQL is significantly alleviated. If you’ve ever delayed a project… it is replication-aware and inspects replicas, throttles its operation to avoid causing replication delay, watches for load on the master, and so… on Tuesday Daniel will talk about using it to verify replication Peter will discuss using it to verify upgrades I’ll…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
… disable) and not print the position of slave thread in master logs at all. Here is some old post of mine…: http://www.mysqlperformanceblog.com/2008/01/29/no-more-mysql-crash-safe-replication-in-50/ We have fixed it in Percona Server… LOCK anyway you can consider doing SHOW SLAVE STATUS/SHOW MASTER STATUS to get proper position instead of relying on that…
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… is telling that B ( relay_master_log_file: test_file , exec_master_log_pos: 2399 ) was replicating from these positions before crashing then we can tell C to start replicating from A with “relay_master…
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: Is DRBD the right choice for me?
March 14, 2012 By 17 Comments
… experienced 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: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
March 7, 2012 By 94 Comments
… server to the cluster. The “replication_info” config setting is only changed when a new master is elected. So how to add… other way your normally prepare a slave. Now change the “replication_info” manually in corosync to the new binlog and logpos… the command that the mysql RA uses, which is: crm_attribute –type crm_config –name replication_info -s mysql_replication -v “||” Now start corosync…
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 promoted as Master. Your howto…
Comment: Percona XtraDB Cluster Feature 1: High Availability
April 20, 2012 By 18 Comments
… act as slave of a regular mysql does get all the transactions from it’s master, but the other nodes do not see them. Transactions directly applied on any of the nodes (not through regular mysql replication) do get to all the others. The source MySQL uses MIXED format, all nodes in…
