… create a simple replication configuration with one master and two slaves, all running MySQL 5.6 with GTIDs disabled. First try: configure… with 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 tells…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…of having binary logs which are no longer complete or useful for point…to the lower-level slaves. You can also use the slave_compressed_protocol option …to Oracle RAC; all of the SQL nodes in a MySQL Cluster …Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… temporary table could vanish if the slave restarts and then subsequent queries …easy it is? ;-) Generative grammars like SQL can produce an infinite variety of …would be more costly than just running the query in a suboptimal form….s between 47000 and 50000 with no movies, but your random number …
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL_Running: No [...] This is not expected: instead of removing all settings…-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL_Running: No [...] Connection settings are automatically restored, which makes disconnecting the…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…upgrading was configured on machines with running database servers. We’ve now…optimize-keys option it produced invalid SQL for cases when there was…Alexey Kopytov). In the event that a slave was disconnected from the master, …used with –innodb-optimize-keys and –no-data options, all secondary key …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…optimize-keys option it produced invalid SQL for cases when there was…. Bug fixed #1104977 (Ignacio Nin). Running the DDL statement while variable…Alexey Kopytov). In the event that a slave was disconnected from the master, …used with –innodb-optimize-keys and –no-data options, all secondary key …
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…be used to create/restore a slave can be found in this blogpost…. file, because rpm packages from Oracle no longer satisfied mysql dependency which … Bug fixed #1169971. innobackupex would still run with FLUSH TABLES WITH READ … #1170806. innobackupex would fail if the SQL_MODE was set to ANSI_QUOTES. …
Post: How to lag a slave behind to avoid a disaster
September 11, 2012 By 5 Comments
… slave running 672 seconds behind at master position mysql-bin.000001/233713063 slave1 [localhost] {msandbox} ((none)) > show slave status\G *************************** 1. row *************************** [...] Slave_IO_Running: Yes Slave_SQL_Running: No [...] With “–delay=10m” I’m asking the tool to lag the slave 10 minutes…
Post: How to STOP SLAVE on Amazon RDS read replica
December 20, 2012 By 4 Comments
… (and won’t get) privileges to do that: replica> STOP SLAVE; ERROR 1045 (28000): Access denied for user ‘usr’@'%’ (using password… (1); master> INSERT INTO percona.test VALUES (1); replica> show slave status\G … Slave_SQL_Running: No Last_Error: Error ‘Duplicate entry ’1′ for key ‘PRIMARY…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
…, restart the sql thread), we now have a nice error message: slave1 [localhost] {msandbox} ((none)) > show slave status\G [...] Slave_IO_Running: Yes Slave_SQL_Running: No [...] Last_Errno… on slaves, the corruption will be obvious as replication will stop with an error: slave1 [localhost] {msandbox} ((none)) > show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running…
