MySQL - How do I upgrade on a hot replication se

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

MySQL - How do I upgrade on a hot replication setup?

If you are upgrading pre-3.23.26 versions, you should just lock the master tables, let the slave catch up, then run FLUSH MASTER on the master, and FLUSH SLAVE on the slave to reset the logs, then restart new versions of the master and the slave. Note that the slave can stay down for some time - since the master is logging all the updates, the slave will be able to catch up once it is up and can connect.
After 3.23.26, we have locked the replication protocol for modifications, so you can upgrade masters and slave on the fly to a newer 3.23 version and you can have different versions of MySQL running on the slave and the master, as long as they are both newer than 3.23.26.

(Continued on next question...)

Other Job Interview Questions

• If you specify the data type as DECIMAL (5,2), what’s the range of values that can go in this table?
• MySQL - How can I use replication to improve performance of my system?
• Functionality Missing from MySQL - SELECT INTO TABLE
• How MySQL Optimizes DISTINCT
• MySQL - What the Privilege System Does
• Explain TIMESTAMP DEFAULT ‘2006:09:02 17:38:44? ON UPDATE CURRENT_TIMESTAMP.
• If I created a column with data type VARCHAR(3), what would I expect to see in MySQL table?
• If the value in the column is repeatable, how do you find out the unique values?
• How do you convert a string to UTF-8?
• Explain the difference between MyISAM Static and MyISAM Dynamic.
• More...