New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Web Server failover w/ database
Hi guys,
I’m not very knowledgable on this topic. However, I’ve been looking into failover for one of my websites but seem to be confused on the database part. Should I have a remote database of which the failover servers connect to? What would be the best solution, and what would you use for failover? I’ve seen Cloudflare’s solution, but is there a free/self hosted solution that you use or would use?
Thank you, and I’m looking forward to your advice!
Comments
You can create a custom solution for your website, required 3-6 or more VPS servers so your solution can be also geo redundant.
You can set the web and database servers cluster
There are so many ways you can do this. For the database failover, unfortunately cloudflare cannot do it for you. We have a tutorial here from our beloved LEB.
https://lowendbox.com/blog/how-to-setup-a-highly-available-wordpress-from-scratch-part-4/
Generally you need a cluster and you can simply google keywords like database cluster or high availability database. Recently, there have been templates created for this kind of thing. You just have to search on github
Store your data as a flat file over a replicated Gluster volume