octoleo
/
gh-ost
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
gh-ost/doc/azure.md

1.2 KiB
Raw Permalink Blame History

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]