We?re a cPanel NOC partner but I really want to look at replacing cPanel with something that clusters. NodeWorx seems like it might be a good way to go, but there are still single points of failure.
I have some spare servers and a 24TB 10GbE NAS and am thinking about giving NodeWorx a try. I?m just curious what people have done to work around the single points of failure. Some questions I have are:
Do people typically have a standby master in case the primary goes down? If MySQL is handled by remote servers and storage is on a NAS, is there much data to replicate between the master and a standby so the standby can replace the master quickly in the event of a problem with the master?
Can the cluster be set up to automatically alternate mysql databases per account? I?m thinking of having at least two separate MySQL servers, each set up to replicate to a backup (i.e. 4 servers, 2 primary and 2 replication slaves). I?d like each new account to alternate mysql servers to sort of distribute the mysql load without having to think about it. If you use MySQL replication to keep a spare database server ready in the event the primary goes down, is it fairly simple to switch over?
Has anyone set things up similarly? I?m looking at something like:
1 Master (+ 1 for standby, kept in sync somehow)
2 MySQL DB Servers (+ 2 being replicated)
1 NAS for data.
2nd NAS for backup of the first NAS.