… beta release towards Percona XtraBackup 2.0! We call this version 1.9.1 as we are using the 1.9.x version numbers for betas of 2.0 to clearly… a slave, this means your new slave will end up with a warmed up buffer pool to mimic that of the master. Streaming…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
…all nodes or none. Multi-master replication. You can write to any node. Parallel applying events on slave. Real “parallel replication”. Automatic…this topic: Percona XtraDB Cluster Feature 1: High Availability Percona XtraDB Cluster Feature 2: Multi-Master replication Create 3 nodes XtraDB Cluster in…
Post: Percona XtraDB Cluster 5.5.20 - Beta release
February 23, 2012 By 10 Comments
…all nodes or none. Multi-master replication. You can write to any node. Parallel applying events on slave. Real “parallel replication”. Automatic…on this topic: Percona XtraDB Cluster Feature 1: High Availability Percona XtraDB Cluster Feature 2: Multi-Master replication Follow @VadimTk !function(d,s…
Comment: How Does Semisynchronous MySQL Replication Work?
March 15, 2012 By 23 Comments
… correct. With semi-sync the protocol is: 1) commit to master 2) wait for a slave to ack it 3) return to the user… been written to at least one slave’s relay log and flushed to disk before doing the commit on the master node.”
Comment: Introducing new type of benchmark
February 27, 2012 By 16 Comments
… 1) By turning logs into benchmarks so you use real user input (real queries) and not “made up” queries 2) with a master, slave…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 93 Comments
… master fails, a new master is promoted from the slaves, no master to master setup needed. Selection of master is based on scores published by the slaves…=”Master” OCF_CHECK_LEVEL=”1” \ op monitor interval=”2s” role=”Slave” OCF_CHECK_LEVEL=”1” primitive reader_vip_1 ocf:heartbeat:IPaddr2 \ params ip=”10.2.2…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… the passive master Server 3 is a normal slave Step1 Stop the replication on the active master (server 1): mysql> stop slave; Step 2: there are writes on the active master, the…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
… 1 and 2^32 – 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted server-id = 1 # Replication Slave… between 2 and 2^32 – 1 # (and different from the master) # defaults to 2 if master-host is set # but will not function as a slave if omitted #server-id = 2…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
…=0 use test/*!*/; SET TIMESTAMP=1323814581/*!*/; insert into t VALUES(1),(2),(3) This behavior can be a problem to take in….net/percona-server/+bug/860910. In a master-master setup a master can show a wrong ‘SHOW SLAVE STATUS’ output when using SET user….5.17-22.1. AUTO INCREMENTAL VALUES In order to have the same auto incremental values on master and slaves the actual used…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’ ‘Com_kill’, ’47′ ‘Com_load’, ’0′ ‘Com_load_master_data’, ’0′ ‘Com_load_master_table’, ’0′ ‘Com_lock_tables’, ’102′ ‘Com_optimize…_master‘, ’0′ ‘Com_show_open_tables’, ’0′ ‘Com_show_privileges’, ’0′ ‘Com_show_processlist’, ’20′ ‘Com_show_slave_hosts’, ’61′ ‘Com_show_slave… cs us sy id wa 2 2 553604 18116 37400 3349360 0 0 0 0 0 0 1 0 1 1 0 0 553604 18548…
