Skip to content

Latest commit

 

History

History
26 lines (20 loc) · 1.18 KB

azure.md

File metadata and controls

26 lines (20 loc) · 1.18 KB

gh-ost has been updated to work with Azure Database for MySQL however due to GitHub does not use it, this documentation is community driven so if you find a bug please open an issue!

Azure Database for MySQL

Limitations

  • gh-ost runs should be setup use --assume-rbr and use binlog_row_image=FULL.
  • Azure Database for MySQL does not use same user name suffix for master and replica, so master host, user and password need to be pointed out.

Step

  1. Change the replica server's binlog_row_image from MINIMAL to FULL. See guide on Azure document.
  2. Use your gh-ost always with additional 5 parameter
gh-ost \
--azure \
--assume-master-host=master-server-dns-name \
--master-user="master-user-name" \
--master-password="master-password" \
--assume-rbr \
[-- other paramters you need]