…Server 5.5.20. With this release we make clustering very easy and affordable for everyone. You can convert your existing MySQL replication… Cluster Feature 2: Multi-Master replication Create 3 nodes XtraDB Cluster in 3 minutes Benchmarking Galera replication overhead Percona Server 5.5.15 + Galera …
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…masters. Let’ s have a look first at the normal flow: Replication flow: [1] When you setup MySQL replication, you define the global variable server…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…MySQL replication reliable…master > show binlog events in ‘mysql-bin.000007′\G *************************** 1. row *************************** Log_name: mysql-bin.000007 Pos: 4 Event_type: Format_desc Server…3. row *************************** Log_name: mysql-bin.000007 Pos: 207 Event_type: Query Server…
Post: Master-Master or Master with Many Slaves
April 6, 2007 By 7 Comments
… gets replicated to all the slaves ? When you compare master-master to multiple slaves you should compare it for same amount of servers. For… MySQL database caches you can get 12GB effective cache on the master-N-slave configuration compared to 36GB of effective cache on 3 master-master…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
… by only 50%. – Delays in replication MySQL replication is fast which means in … high availability you probably need 2-3 copies. If you need significantly…replication with median servers to avoid master overload in such case. – No long queries – As I already wrote these cause delay in replication…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.10.171 Master_User: replicant Master…
Post: Percona Server 5.5.15 + Galera 21.1-beta2
October 3, 2011 By 18 Comments
… to ANY node. Setup of 3-master active MySQL Replication is practically impossible. 2. In contrast to MySQL replication, in Percona Server+Galera schema all nodes are… with master. 3. Nodes are able to apply events in parallel. And this is true parallel replication, not “per-schema” as in MySQL 5…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
… insert into t VALUES(1),(2),(3) This behavior can be a …replicate all your stored procedures in your slaves servers. Example: mysql> create procedure this_pyear() BEGIN INSERT INTO t VALUES(YEAR(CURDATE())); END;// mysql….net/percona-server/+bug/860910. In a master-master setup a master can show a…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
It is easy for MySQL replication to become bottleneck when Master server is not seriously loaded and the more cores and hard … may need to adjust regular expression for finding users replication thread uses. 3) Processlist Polling This method is simple – the Slave thread…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… 100% safe MySQL replication no Master-Master with MMM manager no Heartbeat/SAN (depends on SAN) yes Heartbeat/DRBD yes NDB Cluster yes 3. Does… capacity of a database server. In term of write capacity here are you choices. Write capacity MySQL replication Fair Master-Master with MMM manager Fair…
