Detail mycat+haproxy+keepalived to build high availability load balancing mysql Cluster

Summary Nowadays, clustering is widely used to optimize database performance, while oracle cluster is expensive to invest in software and hardware. mysql is more recommended to use mycat to build database cluster. Here is how to use mycat+haproxy+keepalived to build a high available load balancing system belonging to mysql database. Main id ...

Posted on Wed, 09 Oct 2019 11:31:24 -0700 by smarty_pockets

Mycat Realizes Reading and Writing Separation of Mysql Database

I. overview Mycat's role in applications is described as follows: Mysql master is responsible for reading and writing for master library and Mysql slave is responsible for reading from slave library. In this way, programmers can only care about business code compilation, without worrying about load balancing of back-end database cluster, separa ...

Posted on Mon, 27 May 2019 10:56:43 -0700 by robert.access

mycat Implements MySQL Database Subtable

In fact, the installation of Mycat is as simple as unzipping the downloaded directory.After installation, the directory is as follows: Catalog Explain bin mycat command, start, restart, stop, etc catlet catlet is an extended function of Mycat conf Mycat configuration information, focus on lib Mycat refers to the jar package Mycat wa ...

Posted on Fri, 25 Jan 2019 03:42:13 -0800 by poelinca