…to avoid causing replication delay, watches for load on the master, and so forth. In this respect it is quite similar to…-summary and pt-mysql-summary tools. The changes are not so obvious to the user, but… to verify replication Peter will discuss using it to verify upgrades I’ll show how to use it to…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… explain what Percona XtraDB Cluster is and how does it work, you still have time to register today. I expect XtraDB Cluster… chance to ask us any questions. Related talks: Tutorial on PL MySQL Conference Galera Synchronous Multi-Master Replication for MySQL. My talk on PL MySQL… either commited on all nodes or none. Multi-master replication. You can write to any node. Parallel applying events on slave. Real…
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 seems very interesting and it’s similar to this setup. I know Yves plans to look on how to use…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
March 7, 2012 By 94 Comments
… wanted to do is add another server to the cluster. The “replication_info” config setting is only changed when a new master is elected. So how to add a… get an error when you try to edit it, so use the command that the mysql RA uses, which is: crm_attribute…
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… id’.I agree that matching logs is very tedious but how about ‘row based replication’ ? i think it can help.Or… then we can tell C to start replicating from A with “relay_master_log_file: test_file , exec_master_log_pos: 2399″ and…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
… an apply batch of log records to the database… … InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 15906301, file… says Master_Log_File: binlog.000062 Relay_Log_File: relaylog.000181 That does not match. So what is this information, and how is it useful to print this?
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… the downtime caused by ALTER TABLE — a typical reason to think about master-master with failover and failback for maintenance. As with anything… in MySQL 5.0 and earlier, doing the work on a slave, then piping the results back up to the master with LOAD… overcome, but how much time do you have? And the gains are simply limited by some of MySQL‘s weaknesses in…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…MySQL Master-Master replication (often in active-passive mode) is popular pattern used by many companies using MySQL for …. So what does this tool do and how it works ? Currently it is implemented based … the server is master when it is not ? To take care of this Master Master Manager makes sure …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… lot of things like how to build for massive scalability, how to do read-write splitting without breaking the user experience, how to take online non… there’s practically nothing else running (this is a dedicated master server). The machine has a lot of swap, but basically… you don’t know how to read these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
… tool included with Flexviews. It continues with an overview of how to install and run FlexCDC, and concludes with a demonstration of… to set up a dedicated MySQL slave which has log_slave_updates=1 and binlog_format=row to process SBR changes from a MySQL master… table: $ mysql -e ‘select * from flexviews.binlog_consumer_status\G’ -uroot *************************** 1. row *************************** server_id: 999 master_log_file: binary_log.000001 master_log…
