… replication while its broken or do the master-master/master-slave switchover when master is dying/dead. Yes, there are wrappers… this time node1, node2 are up). After this, a subsequent run of chef-client is done to update the cnf files…
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 1
May 21, 2013 By 8 Comments
… create a simple replication configuration with one master and two slaves, all running MySQL 5.6 with GTIDs disabled. First try: configure… 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 error log…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT a specified set of databases and… data being sent down to the lower-level slaves. You can also use the slave_compressed_protocol option in /etc/my.cnf….frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I saw that it was…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…vip (ocf::heartbeat:IPaddr2): Started percona1 Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona2 ] Slaves: [ percona3 percona1 ] [root@percona1 ~]# cat /…: Transport endpoint is not connected… …but MySQL is still running: [root@percona2 percona]# mysqladmin ping mysqld is alive [root@…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… are running on 127.0.0.1 with ports ranging from 10000 for s0 to 10004 for s4. Scenario #1: All slaves… 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: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… different from standard mysql replication. 1 master with 5 async slaves is going to send a separate replication stream to each… master from taking writes if bandwidth is constrained and the slaves lag for a bit, not so in Galera. So, let… the network throughput on an interface every second. I’m running a sysbench test on one node and measuring the outbound…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… raid controllers and 192GB of RAM. These servers will run a few slave instances each of production database servers and will perform…, the snapshots are free, no performance penalty. You can easily run a server with hundreds of snapshots. With LVM, your IO… the first snapshot so keeping a large number of snapshots running is simply not an option. With ZFS you can easily…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… when using replication, a temporary table could vanish if the slave restarts and then subsequent queries against the temp table fail… optimizing a query automatically would be more costly than just running the query in a suboptimal form. Q: Doesn’t the…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… to older OpenSSL version. Bug fixed #1183610. If a slave was running with its binary log enabled and then restarted with the…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…, run STOP SLAVE, CHANGE MASTER TO MASTER_HOST=” and then RESET SLAVE. For MySQL 5.5 and 5.6, run STOP SLAVE and then RESET SLAVE….000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL_Running: No [...] This is not expected: instead of removing….000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL_Running: No [...] Connection settings are automatically restored, which makes…
