To avoid the pressure of downed services while I address any Filemaker Server issues, I would like to have a
second server ready in waiting.
What’s the best way to go about this?
Obviously I need a second machine.
I am waffling on whether this second machine needs to be powerful or not. I suppose if the primary server goes
down, I would rather have a slow but functional backup database running to handle queries while I fix the
primary server than to have the services down (the state I was in yesterday). However, if the problem is
severe and the primary server is down for three days while I wait for a new part to arrive, I would rather have
comparable hardware running the backup server.
Also obvious, I need a second copy of FMS running.
I assume I have to purchase a second copy of FMS; unfortunately that’s $1950 at a minimum. Sure, I can pay
$650 a year to have it sit there doing nothing 99.9% of the time; peace of mind, yes but I is that the best way
(economically, strategically, convenience, etc.). Can I have my current copy installed and ready to go
on a second machine if and only if I am not using it?
There are syncing solutions out there so this is an issue that requires time to solve but the answers are
already out there. I suspect that given what generally goes wrong, I can either copy the then current
database over to this second machine, switch the Lasso or web connection and away I go. Lesser solution,
copy the hourly backups to the second machine and go with that. Yes I lost an hours' worth of data, but again I
am back up and running in just a few minutes.
I suppose another strategy is to simply have two FMS servers running all the time. Split my databases across
the two of them and if one goes down just move one to the other and proceed. Arguably this allows me to extract
value out of the second copy throughout the year. Of course, if lightning strikes or if it is a real disaster
then I probably lose both servers to the problem at the same time; then I would be wishing for that unused but
prepared spare machine in the corner ready to be plugged in at a moment’s notice.