Comments - Down/crossgrading MySQL 5.more to MariaDB 5.less?

12 years, 7 months ago colin charles

Hi!

Are you using InnoDB? The file formats in theory should be the same (MySQL 5.5's InnoDB format with XtraDB in MariaDB 5.3). But your mileage may vary -- we haven't tested such downgrades.

If its just MyISAM, I think you shouldn't have too many issues.

Why not do this on a test server and let us know the results?

 
12 years, 7 months ago Sanford Whiteman

Thank you for the response. As I noted, we are using MyISAM. Certainly, there will be testing on lab boxes, but there's only so much coverage for edge incompatibilities as we have 10,000+ tables across many clients and scores of access patterns. I was looking for known downgrade scripts or the like. Guess we'll have to set out alone!

 
12 years, 7 months ago colin charles

MyISAM in MySQL 5.5 and MariaDB 5.3 does not have many changes... MariaDB 5.3 has a more enhanced MyISAM (segmented key caches for example, were introduced in 5.2 already).

Good luck with testing, and remember to report any bugs to https://bugs.launchpad.net/maria/+bugs

 
12 years, 7 months ago Sanford Whiteman

Thanks for the more detailed addendum. That makes me a bit more confident.

 
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.