Separating JSS / DMZ / MySQL

[ImAMacGuy]

Currently we have our one Xserve that's hosting the JSS/MySql and one mac mini hosting the DMZ access. Our Xserve seems to be struggling under the load of this and jamf recommended splitting the JSS and the mysql onto 2 different machines.

Has anybody tried this? Jamf was able to get me a diagram of how it should look, but didn't have any actual documentation on how to get to that point.

My plan is to keep the Mac Mini on the DMZ, and I have 2 Mac Pro's that I want to use to split up the SQL and JSS.

[lisacherie]

When you are ready to cut over to the new DB host - have an outage scheduled.
-Stop tomcat on both of your web app hosts.
-Take a full DB backup.
-Restore DB backup to new DB host.
-Make sure grants are set up correctly on the new host for mysql.
-Change the database connection properties in the <pathtojsstomcat>/tomcat/webapps/ROOT/WEB-INF/xml/DataBase.xml file on both web app hosts.
-Make sure things look ok. If they don't look ok, stop tomcat again, and change the <pathtojsstomcat>/tomcat/webapps/ROOT/WEB-INF/xml/DataBase.xml host back, start tomcat so your JSS is up, and figure out what went wrong.
-Should be a quick and mostly painless swap over. Longest part will be the backup/restore.
(Hopefully you can practice on a test environment first).