[MDEV-10047] Upgrade from MySQL to extract data into master.info file WAS: table-based master info repository Created: 2016-05-09 Updated: 2023-02-16 Due: 2020-04-24 Resolved: 2020-03-13 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Replication |
| Fix Version/s: | 10.2.32, 10.3.23, 10.4.13, 10.5.2 |
| Type: | Task | Priority: | Major |
| Reporter: | Kolbe Kegel (Inactive) | Assignee: | Sujatha Sivakumar (Inactive) |
| Resolution: | Fixed | Votes: | 9 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
Upon upgrade from MySQL to MariaDB master-info-repository and relay-log-info-repository are completely ignored without even warning in .err log. This causes troubles when migrating slave servers. There should be at least warning if not error in .err log. Ideally mysql_upgrade script should take care of that and extract the data from mysql.slave_master_info and mysql.slave_relay_log_info to store them in master.info file. The ticket description is edited to stress on the missed warnings at or after upgrade to mariadb, the former description text is below. In fact its aim to have table-based master info is addressed through mysql.gtid_slave_pos which in combination with CHANGE MASTER TO ... master_use_gtid = slave_pos provides failure tolerance to slave. |
| Comments |
| Comment by Alexander Keremidarski [ 2019-10-18 ] | |||
|
Upon upgrade from MySQL to MariaDB master-info-repository and relay-log-info-repository are completely ignored without even warning in .err log. This causes troubles when migrating slave servers. There should be at least warning if not error in .err log. Ideally mysql_upgrade script should take care of that and extract the data from mysql.slave_master_info and mysql.slave_relay_log_info to store them in master.info file. | |||
| Comment by Andrei Elkin [ 2020-01-29 ] | |||
|
julien.fritsch: to why would it be possible to do.. - I merely offered an option if this feature request can be rated as a bug. After all no new option seem need to be provided for the user. But now when I dwelt into the matter better, the ultimate goal's changes in the upgrade script do not look significant at all.
I am not sure where to place those lines but the mysql_upgrade docs leaves hope we can
| |||
| Comment by Sujatha Sivakumar (Inactive) [ 2020-03-10 ] | |||
|
Code changes: https://github.com/MariaDB/server/commit/9ae015878f11be3e3033fd1b35357ea5927c6c51 Build Bot testing: http://buildbot.askmonty.org/buildbot/grid?category=main&branch=bb-10.5-sujatha Changes were reviewed and approved by Andrei. |