Disable setting MASTER_AUTO_POSITION=0 which is not compatible with

yoshinorim / mha4mysql-manager

Development tree of Master High Availability Manager and tools for MySQL (MHA), Manager part

http://code.google.com/p/mysql-master-ha/

GNU General Public License v2.0

1.46k stars 501 forks source link

Closed gregorg closed 10 years ago

gregorg commented 10 years ago

Disable setting MASTER_AUTO_POSITION=0 which is not compatible with MariaDB 10. Set MASTER_AUTO_POSITION to 1 only if gtid_mode=1 as it is required :

Extract from official documentation: http://dev.mysql.com/doc/refman/5.6/en/change-master-to.html "gtid_mode must also be enabled before issuing CHANGE MASTER TO ... MASTER_AUTO_POSITION = 1. Otherwise, the statement fails with an error."

yoshinorim commented 10 years ago

There are some distributions (i.e. fb mysql) supporting dynamically switching GTID settings, so "MASTER_AUTO_POSITION=0" is still needed.

I'd rather like:

gregorg commented 10 years ago

Is it better for you Yoshinori ?