Database platform Architecture

数据库平台架构

<br/>一、LVS<br/>
In this platform, LVS acts as the portal's role, that is, the database connection address provided externally is vip:port. In a set of LVS systems (master and Standby, DR), there are two VIPs, which are distinguished by port. are read IP and write IP is often said to read and write separation.

二、Redir

Redir is a lightweight port mapping tool, we need to access the database through the intranet, and the database server is an intranet address, so you need a port mapping tool. The same can be achieved with iptables.

三、DB服务器

Used to deploy MySQL instances as a primary standby server. Basic requires at least one primary two from, cold standby + incremental backup.

四、管理平台

A dispatch center, management scheduling lvs,redir, DB server resources, the underlying use of Saltstack, the management platform is the master role, the other is the client role, the implementation language is Python, the framework is Django.

Database platform Architecture