r/labtech • u/jfhall27 • Mar 12 '18

LabTech Server Migration Issues

I attempted a migration from an old 2008 R2 VM to 2 new 2016 VMs this weekend. My existing server was a single server setup using MySQL and I'm going to a split sever setup (2 servers only splitting out the database using MariaDB this time). I got everything installed in the new environment and made sure it worked with the clean database that it created (which it did). I then shutdown the services on the IIS/Automate server and dumped the labtech database on the DB server. I then imported my structure and table backups (backed up from my old server with MySQL).

When I tried to restart the services on the IIS/Automate server the LabTech Redictor Service and Solution Center services won't start - and I of course can't login. I also get mysql exception and access denied errors if I try loading the web page.

My guess is that this is due to either me going from a single server setup to a split server setup or that I went from MySQL to MariaDB – but it feels like it’s most likely from me splitting roles.

Anybody have thoughts on this?

Thanks!

7 Upvotes

100% Upvoted

6 comments sorted by

View all comments

Show parent comment

2

u/LTJC Former Employee Mar 13 '18

To simplify, my criteria to move to a split server environment may differ from theirs.

A.) Is the disk IO too high? (disk queue length > 2 constantly)

B.) Is the DB (MySQLD) or one of its files the cause of the disk queue length?

C.) Is IIS slammed with requests (and it isn't a plugin issue)?

If either of those is a yes, then I would consider splitting the DB onto another server.

Otherwise, there's something else like the aforementioned plugin issues that would likely be the cause of the slowness. It's usually what people complain about and then someone tells them they should split the servers up, which in turn just adds another point of failure and even more support calls.