Implementing high availability for a database
Implementing high availability for a database is not an easy task. There are a lot of ways to implement a high-availability configuration using different software and complexity.
The architecture proposed here is fully redundant; it is one of the possible solutions that are widely used in large environments. You need two database servers and two installations of the same software and operating system to implement this solution. Obviously, since servers are twins and tied together, they need to have the same software, have the same release patch, and basically, be identical.
Since we are going to have two different servers, it is clear that the data needs to be replicated between them; this implies that ...
Get Zabbix: Enterprise Network Monitoring Made Easy now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.