boudjIf you are looking at setting up a second, independent K server to help distribute the load (where each server hosts 5000 agents and with no crossover) then of course you can do this, call your sales rep at K to make sure the licensing for this is in the clear.
Now if you are looking for high availability (if one K server goes down the other will be up), you're SOL pal. Sorry! ......sucks doesn't it???? Many of us have brought this concern to Kaseya over the years and while we've heard promises, nothing has been done (at least nothing visible). Do call your Sales Rep, and submit a ticket to support and raise a fit about it. If enough of us complain about this, maybe K will finally do something about this.
rblochI am struggling with the same issue...surprise!
What I want to do, is have a standby server in another datacenter. Install Kaseya on that server and then disable all of the Kaseya services.
Then, setup transactional replication using MS SQL 2008 Standard at each end.
The theory, if the primary server fails, we redirect dns (5 minute TTLs) to the backup server, and then fire up the services.
Failing back (since I want a one way replication to avoid any corruption) would mean backing up the database on the 2ndary server and then restoring it to the primary. Reconfigure replication, and you are ready for the next disaster.
What's the problem with that method?
SQL replication (of any kind from what I know) requires primary keys in each table you want to replicate. Why is that an issue? Somebody decided it was a good idea not to have primary keys in 1/4 of the Kaseya tables.
So, I am writing to my sales rep tomorrow to see if I can get their DBA/support to sign off on me adding some primary key / auto increment columns to those tables.
Right now, I am running a daily backup (18 gb currently) and then incrementals every hour. I use robocopy to replicate to the standby server at another datacenter.
Geez...the hassle! Thanks for listening, I feel a bit better!!
raymondmWhy not make it simpler with VMware vMotion?