MariaDBProxy implementation of read/write splitting MariaDB
Implementation of MariaDB Proxy read/write splitting
1. create an lvm device for storing data directories
Install mysql-proxy-0.8.3
MariaDB details: Click hereMariaDB's: Click here
--
1, installation Mysql-proxyThe implementation of read-write separation is implemented with LUA scripting, now mysql-proxy inside is integrated, no need to installDownload:
Note: This is an installation failure version, so the Mysql-proxy installation process is not necessary to see.
I've already talked about MySQL master-slave synchronization.
Atlas
Official documents:
There are two steps to read and write for MySQL: The first step is to Configure master-slave replication for MySQL; the second step is to use mysql-proxy as MySQL does a read-write separation. Mysqlmaster-slave replicationto ensure MySQL The
Now the two servers used have installed MySQL, all in rpm packaging, can be used normally.In order to avoid unnecessary trouble, master and slave server MySQL version as far as possible to keep consistent;Environment: 192.168.0.1 (Master)192.168.0.2
Configure MySQL master-slave backup and read/write splitting as required, and take the following notes on the Setup steps, problems, and solutions.
Configure MySQL master-slave backup and read/write splitting as required, and take the following
Simple configuration of Mysql database read/write splitting bitsCN.com
Simple configuration of Mysql database read/write splitting
Environment:
Master:192.168.71.128 mysql-sql-node1Slave:192.168.71.140 mysql-data-node1Mysql-Proxy:192.
Now use the two servers have been installed MySQL, are all rpm packaging, can be used normally.
In order to avoid unnecessary trouble, master server MySQL version as much as possible to maintain consistency;
Environment: 192.168.0.1 (Master)
192.168.
MySQL read-write separation needs to be implemented based on master-slave architectureMySQL master-slave configuration: http://hongchen99.blog.51cto.com/12534281/1917137Mysql-proxy: for MySQL master-slave separation, based on master-slave
MySQL Proxy MySQL Proxy is a simple program that is located between your client side and the MySQL server to monitor, analyze, or change their communications. It is flexible, unlimited, and common uses include: load balancing, failure, query
Mysql-proxy: For short, MySQL read-write separation; The main purpose is to improve the speed of Web site access.First build MySQL master and slave, reference: http://syklinux.blog.51cto.com/9631548/1737317Download Mysql-proxy:Cd/usr/local/srcwget
Now the two servers used have installed MySQL, all in rpm packaging, can be used normally.In order to avoid unnecessary trouble, master and slave server MySQL version as far as possible to keep consistent;Environment: 192.168.0.1 (Master)192.168.0.2
MySQL master/slave synchronization and read/write splitting configuration steps bitsCN.com
Configure MySQL master-slave backup and read/write splitting as required, and take the following notes on the setup steps, problems, and solutions;MySQL has
MySQL has been installed on the two servers, which are all packaged in rpm and can be used properly.To avoid unnecessary troubles, the MySQL versions of the master and slave servers should be consistent as much as possible;Environment: 192.168.0.1
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.