… (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated to other nodes Improvements to XtraBackup SST methods, better error handling New….04, they are coming soon. If you want to know more how to migrate to XtraDB Cluster, we will be giving a free webinar…. This is an General Availability release. We did our best to eliminate bugs and problems during alpha and beta testing release…
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…’.I agree that matching logs is very tedious but how about ‘row based replication‘ ? i think it can help.Or may be…_log_pos: 2399 ) was replicating from these positions before crashing then we can tell C to start replicating from A with “relay_master…
Post: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… slides from Yves Trudeau, you may have heard about Percona Replication Manager (PRM), a new high availability tool for MySQL. Percona… take cares of MySQL and manages the replication. Corosync allows any number of servers to be part of the cluster using any… Vagrant). In the follow “terminalcast” you can see how to deploy the setup and some basic commands to check and manage your cluster:
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… much easier to use. The key is that it is replication-aware and inspects replicas, throttles its operation to avoid causing replication delay, watches… talk about using it to verify replication Peter will discuss using it to verify upgrades I’ll show how to use it to forecast scalability and…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
March 7, 2012 By 94 Comments
… on the cluster. What I 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… your normally prepare a slave. Now change the “replication_info” manually in corosync to the new binlog and logpos position from when…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
… write load but needs additional precautions to avoid phantom reads and to get a consistent Statement based replication. To accomplish that, row level locking… gap lock preventing the insertion of data to other sessions. How to troubleshoot gap locks? Is possible to detect those gap locks using SHOW…
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
…. Major features include: Multi sourced replication XtraBackup included IPv6 data type ZeroMQ plugin Log output to syslog is enabled by default Updated… Drizzle Launchpad download area. Please see the Drizzle manual on how to install Drizzle 7.1.33-stable from source tar package… how to install from the PPA are in the Drizzle manual. CentOS 6 packages are available from download.drizzle.org. Instructions on how to…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…hours for this statement to complete. Here is example how it can look: mysql> show processlist; …option, as preventing writes to the slave can be done by simply pausing replication…
Comment: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… (but it can be any other MySQL version using standard replication). PRM works with “normal” MySQL acting as Master -> Slaves and… similar to this setup. I know Yves plans to look on how to use MHA with PRM. The goal of my approach here it to automate the installation and to allow everybody 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… XtraDB Cluster provides: Synchronous replication. Transaction either commited on all nodes or none. Multi-master replication. You can write to any node. Parallel applying events on slave. Real “parallel replication”. Automatic node provisioning. Data…
