Use Atlas to implement MySQL read/write splitting and implement mysql read/write through atlas
1. MySQL Machine
192.168.29.128 (Master)
192.168.29.129 (Slave)
Configure master-slave synchronization, refer to
Whether your webapp system is using a MySQL
DatabaseSystem? Does your customer always complain that the page results are very slow? Is the load of your MySQL system always in a very high state? This article will provide you with a method to share
Turn from (http://blog.sina.com.cn/s/blog_821512b50101hyc1.html) MySQL sharding detailed
A backgroundWe know that when the amount of data in a database gets bigger, the pressure gets bigger, whether it's reading or
Is your WebApp system using a MySQL database system? Does your customer always complain that the page results are very slow? Is the load of your MySQL system always in a very high state? This article will provide you with a method to share the load
master-Slave synchronization1 Main ConfigurationConfiguring 237 as the primary database serverpermission to copy data when an authorized user connects themselves from a database serverGrant Replication Slave on * * to [e-mail protected] "172.40.7.42"
Mixer: An Introduction to mysqlproxy implemented with go
Mixer is a mysql proxy implemented by go and supports basic mysql proxy functions.
Mysql has a lot of middleware. for the existing powerful proxies on the market, I mainly examine the
Content Abstract: sharding is not a function attached to a specific database software, but abstract Processing Based on specific technical details. It is horizontal scaling (scale out, or horizontal scaling) the main purpose of this solution is to
Author:
Fenng| Reprinted, but the original source, author information, and copyright statement of the article must be indicated in hyperlink form
Web: http://www.dbanotes.net/database/database_sharding.html
Note: This article was first published in
Tip: To remove SQL filtering (no WHERE clause update and delete) function, you can first modify the source code :Modify File Atlas-2.2.1\plugins\proxy\proxy-plugin.cModify method Is_in_blacklist, return false directlyDependent
A few days ago, the user wrote to help achieve such a framework: only two machines, the need to implement one of the crash after another can take over the service of this machine, and two machines in normal service, both machines can be used. The
SpockProxy is an open-source project generated by a real project (Spock is a Rails application, and SpeckProxy should be used outside Rails, such as PHP or. is a branch of MySQLProxy and supports range-basedhorizontalparitioning. His improvements to
Mysqlproxy was the first time I heard this word in a new project. Can anyone tell me why I want to use him. We did this in the previous master-slave database. There is a way to execute the SQL statement to him every time, and then he chooses whether
Data segmentation-Atlas introduction and segmentation atlas Introduction
Atlas is a MySQL-based Data Middle Layer project developed and maintained by the infrastructure team of Qihoo 360 Web platform department. Based on MySQL-Proxy 0.8.2 officially
Mysql-15-mysql distributed application, mysql-15-mysql
1. Concepts and advantages of distributed applications
A Distributed Database is a logical and unified database that uses a high-speed network to connect multiple physically dispersed data
One Master one from (important), one master more from (most commonly used), master-slave from, the main structure;When controlling the master-slave fabric, back up the specified database instead of backing up all the libraries:1 configuration on the
Because of the drbd+mysql+heartbeat done before. Feel high available to do is not thorough enough. Just understand the next amoeba.
Document Address:http://docs.hexnova.com/amoeba/index.html
Download:
1. The machine where MySQL is located192.168.29.128 (Master)192.168.29.129 (Slave)Configure master-Slave synchronization, refer to Http://www.cnblogs.com/luxh/p/4088420.html2. Download and install AtlasHttps://github.com/Qihoo360/Atlas/releasesNote
ObjectiveUse MySQL proxy and MySQL replication for read-write separation mysql Replication You can distribute master data replication across multiple slave, and then use slave to share the read pressure of master. For foreground applications, it
Installs the 64-bit version of the RPM packagewget https://github.com/Qihoo360/Atlas/releases/download/sharding-1.0.1/Atlas-sharding_1.0.1-el6.x86_64.rpmrpm- IVH atlas-2.2.el6.x86_64_2.rpmpreparing ... ###############################
Compile and install dbproxy altas and compile dbproxyaltas
Preface: there are already many mysql middle layers, such as dbproxy of baidu, tddl of taobao, corba of 126 and alibaba, altas of 360, mysql-proxy, oneproxy of Lou fangxin, and dbproxy of
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.