Posted on 03-07-2019 05:09 PM
Hey all,
Wondering how you have your JAMF test servers setup? I am told by JAMF support to not migrate our database to a test instance to test, but when I am faced with an upgrade that will change my database from MyISAM to InnoDB I want to test upgrading my actual production database if possible.
What are your thoughts on this? What do you use for testing?
Thanks!
Posted on 03-07-2019 06:03 PM
If you have a good backup right before you convert you should be fine. If everything fails you can always spin up a fresh MySQL instance and restore from the backup. I have converted to InnoDB back to MyISAM and back to InnoDB over the last two + years. I have not had a single issue with any conversion. That is not to say problems aren't possible hence the need to the backup.