[MDEV-24316] cross upgrade from MySQL - have precheck tool Created: 2020-12-01 Updated: 2020-12-02 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Scripts & Clients |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Daniel Black | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | None | ||
| Description |
|
MySQL has a check if its able to be upgrade before it does it. This is largely internal in the checks of the document/code: A similar test for example was suggested that we need to do in MariaDB. Given the large kb pages on incompatibilities I think this is something that can at least be partially automated in a check program. The goal is to advice users if an existing MySQL instance has any incompatibilities to note before a user tries to cross-upgrade to MariaDB. So the goal would be to check on a database/global scale looking at tables, at features used, at settings, at character sets in table and determine the migratablilty |
| Comments |
| Comment by Daniel Black [ 2020-12-02 ] |
|
So from a requirements point of view this is automating the knowledge base documents on feature differences and incompatibilities as much as practically possible. Extreme idea: bpftrace script that hooks mysql and counts when incompatible functions are used for those harder to identify aspects that aren't static as table structures. |