…. The post focuses on the key aspects of synchronous replication setup with high-availability guarantees like split-brain immunity. Nobody likes… replication while its broken or do the master-master/master-slave switchover when master is dying/dead. Yes, there are wrappers… simple and uncomplicated. Their post focuses on following aspects: Initial setup Setup of other nodes with SST (Xtrabackup SST) Integration of chef…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… one here. Our goal will be to go from setup #1 to setup #2 on the picture below, following various scenarios: For… new master), we remove its configuration as a slave s1> stop slave; s1> reset slave all; # For s0 s0> change master to master… have to promote the most up-to-date slave and reconfigure the other slaves as we did above. So we will suppose…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…(ocf::heartbeat:IPaddr2): Started percona1 Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona2 ] Slaves: [ percona3 percona1 ] [root@percona1 ~]# cat…disabled at boot… [ OK ] Checking Network Manager… [ OK ] Global setup… [ OK ] Loading kernel modules… [ OK ] Mounting configfs… [ OK ] …
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… focused on the implications of enabling GTIDs on a production setup. The manual describes very nicely how to switch to GTID… GTIDs Let’s stop slave #2, change configuration and restart it: mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The… field, Auto_Position: # Slave #1 mysql> show slave status\G [...] Auto_Position: 1 -> GTID-based positioning # Slave #2 mysql> show slave status\G [...] Auto_Position: 0…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… other one with Linux servers. The Solaris side is cleverly setup using zones and ZFS and this provides a very low… and 192GB of RAM. These servers will run a few slave instances each of production database servers and will perform the… spare drives per controller, I have 2 for the whole setup. A small but yet interesting saving. All put together, ZFS…
Comment: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 13, 2013 By 5 Comments
… run for other reasons – much akin to doing a stop slave/start slave in traditional mysql replication setups?
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… 1024001) * pmp-check-mysql-replication-running reported OK when a slave is in “Connecting” state (bug 1089506) Update note: Cacti templates… addition as part of Percona’s Remote DBA installation and setup of these tools are included with our services. You can…
Post: Percona Toolkit for MySQL Webinar Followup Questions
April 5, 2013 By 1 Comment
…. My setup was the following: 1 instance installed by the package manager, with the sakila database 1 master and 2 slaves installed…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… in traditional master-slave setups, but with big difference – with Galera we have Semi-synchronous slaves. How it works on slaves: slaves just acknowledge reception… observation, the task to setup three node cluster is much more complex than an average MySQL master-slave setup. Potential performance penalty: Although…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… master splits from several slaves it still remains operational. Use with extreme caution even in master-slave setups, because slaves won’t automatically reconnect… is a dangerous setting in multi-master setup, but should simplify things in master-slave cluster (especially if only 2 nodes are…
