Shulou(Shulou.com)06/03 Report--

The following brings you the experiment of mycat to achieve read-write separation and database load balancing, hoping to bring some help to you in practical application. Load balancing involves more things, there are not many theories, and there are many books on the Internet. Today, we will use the accumulated experience in the industry to do an answer.

There are two Mariadb 10.3 database master-slave clusters in the system.

Database masterslave username password mall192.168.1.100192.168.1.110root123456member192.168.1.150192.168.1.160root123456

The schema.xml file is as follows:

Select user () select user ()

Server.xml local

123456 mall,member 123456 mall 123456 member 123456 mall,member true

After reading the above experiments on mycat to achieve read-write separation and database load balancing, if there is anything else you need to know, you can find what you are interested in in the industry information or find our professional and technical engineers for answers. Technical engineers have more than ten years of experience in the industry.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.