Instead of the usual text-heavy blog posts that appear here, I thought it would be fun to mix things up and do a screencast showing exactly how easy it is to upgrade MySQL to MariaDB: http://www.youtube.com/watch?v=rF7wChx0uzQ
- The laptop I’m using had MySQL 5.1.55 installed with one database (apart from the system database). Installing MariaDB does not impact existing data in any way and once the install completed I had instant access to my data.
- As part of the install you are given the option to set a new password for the root user. I choose to do it in the video, but you don’t need to. If you leave the password field blank the root password will not be changed. Other database users are preserved, of course.
- As with any database upgrade, before doing this to a production system you should have backups and test.
Links shown or mentioned in the video:
- and of course: http://mariadb.org/
What do you think? Should we make more screencasts? If so, what would you like to see demonstrated?