… the MySQL manual. You can configure the slave …master, you leave all filters disabled; on the relay master… I’d suggest reading over the …ERROR] /usr/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
…configuration with one master and two slaves, all running MySQL 5.6 with GTIDs disabled. First try: configure…configuration and restart it: mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
….04 sec) mysql> show slave status\G Empty set (0.00 sec) mysql> start slave; ERROR 1200 (HY000): The server is not configured as slave…: Master_Host: 127.0.0.1 Master_User: rsandbox Master_Port: 35301 Connect_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Bugs Fixed: Due to parse error in the percona-… was disconnected from the master, under certain conditions, upon… #1032139 (Alexey Bychko). UDF/configure.ac was incompatible with … Server for MySQL was missing help texts in the MySQL … InnoDB to misclassify internal read operations as synchronous …
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… if the active master server has an issue. At Groupon, our standard MySQL database configuration follows this … never-ending stream of queries to playback. Read-only playback Using the –session-init-query… or insert statements that have duplicate key errors may be faster than an actual database write…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… Bugs Fixed: Due to parse error in the percona-… was disconnected from the master, under certain conditions, upon… #1032139 (Alexey Bychko). UDF/configure.ac was incompatible with … Server for MySQL was missing help texts in the MySQL … InnoDB to misclassify internal read operations as synchronous …
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…configuration method of GTID: slave1 > CHANGE MASTER TO MASTER_HOST=”127.0.0.1″, MASTER_USER=”msandbox”, MASTER_PASSWORD=”msandbox”, MASTER_PORT=18675, MASTER…Error: Got fatal error 1236 from master when reading data from binary log: ‘The slave is connecting using CHANGE MASTER TO MASTER…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…, and their causes and preventions. You can read more about that research in our white papers…the replica is not logically identical to its master. The server is allocating too much memory. …handle or log this error appropriately. The pmp-check-mysql-status plugin can be configured to alert when …
Post: Confusing MySQL Replication Error Message
June 4, 2008 By 11 Comments
…MySQL Error Messages which are confusing, here is one more: 080603 20:53:10 [Note] Slave: connected to master…configuration error) two slave servers got the same server-id. Seriously in this case Master…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… practically nothing else running (this is a dedicated master server). The machine has a lot of swap, …if I’m on a 64-bit OS. Examining MySQL configuration Then I’ll look at my.cnf quickly …read easily). But what I will do is scan the output for something strange that might be caused by a syntax error…
