u9ad8u53efu7528u6027MySQL u7b2c2u7248...

This preview shows page 1 out of 1 page.

After updating the options file, you need to restart the server for the changes to take effect. Once you've done this for all servers that are going to be used in the setup, youre set for doing a failover. Using the GTID support in MySQL 5.6, switching masters just requires you to issue the command: CHANGE MASTER TO MASTER_HOST = hos t_ of_new_naster, MASTER_PORT = porof_new_naster, MASTER_USER = replication_user_name, MASTER_PASSWORD = replication_user_password, MASTER AUTO POSITION = 1 The MASTER_AUTO_POSITION causes the slave to automatically negotiate what transac - tions should be sent over when connecting to the master. To see status of replication in GTID positions, SHOW SLAVE STATUS has been extended with a few new columns. You can see an example of those in Example 8-18. Example 8-18. Output of SHOW SLAVE STATUS with GTID Enabled

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture