# System Upgrade Advice **URL:** \ **Category:** Ignition\ **Created:** [January 18, 2023, 9:06pm UTC](https://forum.inductiveautomation.com/t/system-upgrade-advice/68755 "2023-01-18T21:06:08Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![wpmccormick](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wpmccormick/32/13940_2.png) [@wpmccormick](https://forum.inductiveautomation.com/u/wpmccormick)\ **Post date:** [January 18, 2023, 9:06pm UTC](https://forum.inductiveautomation.com/t/system-upgrade-advice/68755/1 "2023-01-18T21:06:08Z")
I have a client that would like to upgrade Ignition 7.7.5. It's running on Windows Server 2012 and uses MySQL 5.6 as the DB. Everything is EOL; or just about. At a minimum, I would propose a installing a VM client to run separate Ignition 8.1 and MariaDB 11. Optimally, I would propose new hardware with EsXI, and run Ignition and MariaDB in separate VM's. Is there other, in-between (or better) options? Cheers! ---
**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Post date:** [January 18, 2023, 9:17pm UTC](https://forum.inductiveautomation.com/t/system-upgrade-advice/68755/2 "2023-01-18T21:17:45Z")
I can vouch for separating the DB and Ignition instances as well as MariaDB. It's a drop-in replacement for MySQL and I've had no issues since transitioning myself. I also really love the HeidiSQL db gui it comes with. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [January 18, 2023, 9:21pm UTC](https://forum.inductiveautomation.com/t/system-upgrade-advice/68755/3 "2023-01-18T21:21:46Z")
What Daniel said, but also note VMs probably should not be deployed on-prem unless there's someone who knows how to care for them. And knows not to overcommit CPU and RAM resources. (Opinions vary within IA on this topic... I've not had VM issues where the above conditions are true.) ---
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [January 18, 2023, 11:17pm UTC](https://forum.inductiveautomation.com/t/system-upgrade-advice/68755/4 "2023-01-18T23:17:09Z")
Wouldn't be wise to go from 7.7. to 8.1 in one leap, I would think. I would do 7.8.latest, 7.9.latest, think you could maybe safely skip 8.0, 8.1.latest ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 19, 2023, 12:12am UTC](https://forum.inductiveautomation.com/t/system-upgrade-advice/68755/5 "2023-01-19T00:12:26Z")
I wouldn't bother with 7.8 or 8.0. If you can guarantee there's no legacy FPMI or FSQL resources, you should be able to go straight to 8.1. Look and feel changes may cause you some headaches for Vision projects 🤷‍♂️ ---
**Author:** ![wpmccormick](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wpmccormick/32/13940_2.png) [@wpmccormick](https://forum.inductiveautomation.com/u/wpmccormick)\ **Post date:** [January 23, 2023, 4:19pm UTC](https://forum.inductiveautomation.com/t/system-upgrade-advice/68755/6 "2023-01-23T16:19:13Z")
Thanks for all that. I'm not sure how to guarantee the (lack of) legacy FPMI or FSQL resources. I assume there part of MySQL? In any event, lot's of headaches with all this: First, there's no (that I can find) installer for MySQL 5.6. Options were to "hand install" from the available binary archive, of install 5.5 from MSI and upgrade from binary archive. I chose the latter, but an the incompatible my.cnf setting _table\_cache_ needed to be change to _table\_open\_cache_. Other than that, just copy/replace the binary folder structure seems to have worked. There was also an issue with the client's mysqldump/schema, where a table index built from a field varbinary(some\_large\_number) needed to be changed to a more reasonable field(small\_number) in the index. Obviously not Ignition related. The last remaining issue is Java related: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/b/5b5b48ee287aabffb7455c0ae13c9961e87bcea6.png) [Java exception.txt](https://forum.inductiveautomation.com/uploads/short-url/hCOb01CpUz6qCrGnJHz7vV0bA3V.txt) (3.6 KB) Seems that no matter how I muck with Java (1.8.361) security settings, can't get the designer or client to load. I'm not worried about security since this is not a production environment. Thanks! ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [January 23, 2023, 4:27pm UTC](https://forum.inductiveautomation.com/t/system-upgrade-advice/68755/7 "2023-01-23T16:27:31Z")
> [@wpmccormick](#): > > I'm not sure how to guarantee the (lack of) legacy FPMI or FSQL resources. Just try the upgrade in your dev environment. If it succeeds, there weren't any. If it fails, you may need to study the wrapper log to see if you can identify the culprits. > [@wpmccormick](#): > > I assume there part of MySQL? No. > [@wpmccormick](#): > > installer for MySQL 5.6 It was suggested you use MariaDB. I concur. You should not be installing ancient DBs. Take a full backup of the production server. Restore it into a recent MariaDB installation. (When MariaDB forked from MySQL, most of the developers went with the MariaDB fork. MariaDB is far more advanced.) > [@wpmccormick](#): > > I muck with Java (1.8.361) security settings, can't get the designer or client to load. Ignition 8+ comes with its own Java. It doesn't use the system java unless forced to, and java 11 is the minimum version. Mucking with java8's settings does nothing. Your IT department is preventing your system from running the java included with Ignition, it seems. ---
**Author:** ![avaughn](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/avaughn/32/38972_2.png) [@avaughn](https://forum.inductiveautomation.com/u/avaughn)\ **Post date:** [January 23, 2023, 4:49pm UTC](https://forum.inductiveautomation.com/t/system-upgrade-advice/68755/8 "2023-01-23T16:49:21Z")
> [@wpmccormick](#): > > Seems that no matter how I muck with Java (1.8.361) security settings, can't get the designer or client to load. If this is being run into before the upgrade with 7.7.5, then [this](https://support.inductiveautomation.com/hc/en-us/articles/360047135532-Ignition-Client-Blocked-by-Java-Security-Settings-Certificate-Expired-) KBA should provide you the changes needed. Alternatively, I don't think you need to adjust security settings if you use the Native Client Launcher instead of the Java Web Start (.jnlp) file. ---
**Author:** ![wpmccormick](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wpmccormick/32/13940_2.png) [@wpmccormick](https://forum.inductiveautomation.com/u/wpmccormick)\ **Post date:** [January 23, 2023, 4:52pm UTC](https://forum.inductiveautomation.com/t/system-upgrade-advice/68755/9 "2023-01-23T16:52:50Z")
Thanks @pturmel. Unfortunately, I'm locked into MySQL 5.6 until the client is willing to commit to more. I'm also locked into getting everything working (including java) in my dev env on 7.7.5. I understand the Java headaches will ease as I move forward, but I need to be sure I'm starting from a working env. ---
**Author:** ![wpmccormick](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wpmccormick/32/13940_2.png) [@wpmccormick](https://forum.inductiveautomation.com/u/wpmccormick)\ **Post date:** [January 23, 2023, 4:53pm UTC](https://forum.inductiveautomation.com/t/system-upgrade-advice/68755/10 "2023-01-23T16:53:45Z")
Yes, I saw that. Didn't work. ---
**Author:** ![avaughn](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/avaughn/32/38972_2.png) [@avaughn](https://forum.inductiveautomation.com/u/avaughn)\ **Post date:** [January 23, 2023, 4:54pm UTC](https://forum.inductiveautomation.com/t/system-upgrade-advice/68755/11 "2023-01-23T16:54:28Z")
Have you tried the Native Client Launcher? ---
**Author:** ![wpmccormick](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wpmccormick/32/13940_2.png) [@wpmccormick](https://forum.inductiveautomation.com/u/wpmccormick)\ **Post date:** [January 23, 2023, 4:57pm UTC](https://forum.inductiveautomation.com/t/system-upgrade-advice/68755/12 "2023-01-23T16:57:50Z")
Yes, client launcher works. However, the issue is with the designer. I forgot to say. ---
**Author:** ![avaughn](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/avaughn/32/38972_2.png) [@avaughn](https://forum.inductiveautomation.com/u/avaughn)\ **Post date:** [January 23, 2023, 5:05pm UTC](https://forum.inductiveautomation.com/t/system-upgrade-advice/68755/13 "2023-01-23T17:05:28Z")
Does the same thing happen if you launch the designer from within the client launcher? There should be a button in the top right of the client launcher. ---
**Author:** ![wpmccormick](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wpmccormick/32/13940_2.png) [@wpmccormick](https://forum.inductiveautomation.com/u/wpmccormick)\ **Post date:** [January 23, 2023, 5:13pm UTC](https://forum.inductiveautomation.com/t/system-upgrade-advice/68755/14 "2023-01-23T17:13:51Z")
I forgot about that one, and yes, that does work. However, on the client/customer's machine/VM, the designer launches (directly) without any issue from the gateway web page link. On my test VM, it downloads the jnlp file, and then I still can't run/launch it. I suppose I could just ignore all this, but being the sort that wants everything perfect, I was trying to make it the same as on the client's system. ---
**Author:** ![avaughn](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/avaughn/32/38972_2.png) [@avaughn](https://forum.inductiveautomation.com/u/avaughn)\ **Post date:** [January 23, 2023, 5:18pm UTC](https://forum.inductiveautomation.com/t/system-upgrade-advice/68755/15 "2023-01-23T17:18:05Z")
I get that, I'm the same way. I've personally never run into the settings from that KBA not working to get around the expired certificate. You could share screenshots of the java security settings if you'd like, but reaching out to support is probably your best option to see if they might be able to help get it working. ---
**Author:** ![wpmccormick](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wpmccormick/32/13940_2.png) [@wpmccormick](https://forum.inductiveautomation.com/u/wpmccormick)\ **Post date:** [January 23, 2023, 5:27pm UTC](https://forum.inductiveautomation.com/t/system-upgrade-advice/68755/16 "2023-01-23T17:27:04Z")
I've spent way too much time on this already and am out of time. I'll need to opt for the ignore options I guess.