Direct Upgrade from MySql 5.1 to Maria DB 10.1 - Source

Revision: 47908
User: Rajeev Joshi
Date: 2016-09-14 13:51

Hello,

We are migrating our product from MySQL 5.1 to MariaDB 10.1. Given the tricky nature of our product's upgrade we cant give an additional hop of MariaDB 5.5 and then upgrade to MariaDB10.1.

So before upgrade we are taking backup of complete database using mysqldump. Remove all the MySQL RPMs. Install MariaDB 10.1 RPMs, set password and privileges and restore the MySQL dump back on MariaDB.

We are able to restore all the tables properly and did not face any issue in particular. However we dont want to take any chance with the data integrity post upgrade so planning to write steps which can ascertain data is proper and no customer data is lost.

We would like to know 
1. Is this process of Migration is proper, if not what challenges we may face while restoring mysql dump on MariaDB?

2. Before restoring the dump we are changing the Engine type to InnoDB. Since InnoDB do not support repair table what alternative we can use?

3. Is it ok to run Check table on InnoDB tables or there is any better utility? If Check table is ok and it returns some error how can we resolve it?

Answer

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

Direct Upgrade from MySql 5.1 to Maria DB 10.1 - Source

Answer

Products

Services

Pricing

Resources

About Us

Download MariaDB