Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Old data are not detected #33

Closed
hhorak opened this issue Apr 25, 2017 · 2 comments
Closed

Old data are not detected #33

hhorak opened this issue Apr 25, 2017 · 2 comments
Assignees
@hhorak

Comments

@hhorak
Copy link
Member

hhorak commented Apr 25, 2017

MySQL and MariaDB use versions that consist of three numbers (e.g. 5.6.23). When two versions are different only in the last part, they are compatible, but when upgrading from e.g. 5.6 to 5.7, we need to consider upgrading as described in https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html. Currently, there is no check whether the data come from a different version (incompatible) so it can happen that users by mistake change the version of the image and they can see errors or even data corruption when not using the standard upgrading scenario described in the documentation.
@hhorak hhorak self-assigned this Apr 25, 2017
hhorak added a commit to hhorak/mariadb-container that referenced this issue Apr 25, 2017
@hhorak
Add logic for upgrading datadir
625bca9 
Based on the MYSQL_UPGRADE variable and based on the datadir version detected,
we either warn user about incompatibilities, or run one of the specified
tools:
* mysql_upgrade
* mysqlcheck --analyze --all-databases
* mysqlcheck --optimize --all-databases

This should also fix sclorg#33
hhorak added a commit to hhorak/mariadb-container that referenced this issue Apr 25, 2017
@hhorak
Add logic for upgrading datadir
763cb44 
Based on the MYSQL_UPGRADE variable and based on the datadir version detected,
we either warn user about incompatibilities, or run one of the specified
tools:
* mysql_upgrade
* mysqlcheck --analyze --all-databases
* mysqlcheck --optimize --all-databases

This should also fix sclorg#33
@hhorak hhorak mentioned this issue Apr 25, 2017
Merged
@hhorak
Copy link
Member Author

hhorak commented May 10, 2017

test comment..

@hhorak
Copy link
Member Author

hhorak commented Apr 10, 2024

The upgrade is already implemented for a long time.

@hhorak hhorak closed this as completed Apr 10, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@hhorak hhorak

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@hhorak