I am running a VPS with CentOS and have many sub cPanel accounts. Most of them are running wordpress with databases using myisam storage engine. I first considering upgrading to InnoDB but ran into "strict" policy issues where my default date values were 00-00-0000 etc.
I thought It may be easier to update to mariaDB first but see that it has some of the same issues. Now I'm a bit concerned with moving forward and not being able to go back if it breaks all my (client) sites.
Can any kind person please help me figure out my steps?
do I need to upgrade all database tables to InnoDB first (and deal with "strict" issues) then move to Maria? Or do change to Maria First?
do I deal with strict issues at all or just ignore them?
If I do change to Maria and all the sites break...what then? Is there a way to back up every thing and revert or is there a solid process to identify breaking issues and fix them?
Sorry for the naivety here, and I appreciate all help!
I thought It may be easier to update to mariaDB first but see that it has some of the same issues. Now I'm a bit concerned with moving forward and not being able to go back if it breaks all my (client) sites.
Can any kind person please help me figure out my steps?
do I need to upgrade all database tables to InnoDB first (and deal with "strict" issues) then move to Maria? Or do change to Maria First?
do I deal with strict issues at all or just ignore them?
If I do change to Maria and all the sites break...what then? Is there a way to back up every thing and revert or is there a solid process to identify breaking issues and fix them?
Sorry for the naivety here, and I appreciate all help!