… 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… int not null auto_increment primary key); Executing SHOW TABLES FROM test on both slaves shows that the table has been created…
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 …just running the query in a suboptimal form. Q: Doesn’t the primary key…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
… from slave to master. One of the key things to protect your data integrity is to make sure that the promoted slave is…-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
… configured on machines with running database servers. We’ve…keys option it produced invalid SQL for cases when there was an explicitly named foreign key…). In the event that a slave was disconnected from the master… –innodb-optimize-keys and –no-data options, all secondary key definitions would…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…keys option it produced invalid SQL for cases when there was an explicitly named foreign key… fixed #1104977 (Ignacio Nin). Running the DDL statement while…). In the event that a slave was disconnected from the master… –innodb-optimize-keys and –no-data options, all secondary key definitions would…
Post: How to STOP SLAVE on Amazon RDS read replica
December 20, 2012 By 4 Comments
… null primary key); replica> INSERT INTO percona.test VALUES (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” on query. Default database: ‘percona…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…: Slave_IO_Running: No Slave_SQL_Running: Yes Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘The slave …slave io_thread; slave1> show slave status\G [...] Slave_IO_Running: Yes Slave_SQL_Running: Yes [...] Now, if you don’t get any error like primary/unique key …
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…_Pos: 744615788 Relay_Master_Log_File: db01-bin.003814 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do…_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind… MASTER TO to set start position for the slave you’re specifying position for SQL thread and so you should use Relay…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
… replication slave which does not find a row referenced in a row-based log will immediately return an error: HA_ERR_KEY… fields omitted): SHOW SLAVE STATUS\G Relay_Log_File: mysql_sandbox25162-relay-bin.000002 Relay_Log_Pos: 340718 Slave_SQL_Running: No Last_Errno: 1032 Last… on the master can not be found on the slave:HA_ERR_KEY_NOT_FOUND. It doesn’t tell us what row…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… can (if used properly) help increase security against sql injection. > For example I have little wrapper which…to a slave, there is no reason why you can’t remove the foreign key references on the slave(s)…reasonable > amount of data in it. And do run EXPLAIN for your queries, especially > if you see…
