server 4'],],
You can also configure the master server as follows for multiple master servers. For more information about character delimiter set and table prefix settings, see the preceding section.
// Configure the master server 'masterconfig' => ['username' => 'master', 'Password' => '', 'bubuckets' => [// use a sm
operations
Vim my. cnf: Add the following sentence
Binlog_format = ROW database binlog use ROW mode for synchronization
Grant permissions to the Database Synchronization users respectively.
Grant all on *. * to okooo_rep @ '192. 192. %. % 'identified by 'bjfcmlc @ Mhxzkhl ';
Flush privileges;
Test started
Test the basic synchronization function
?. Use test178 as the slave to synchronize old02 data
Change
Serialization 3Original: fat Liu (please indicate the source and author for reprinting. Thank you .)(2) The master-slave mode is the most common mode in the database design mode and the most common mode in the daily design work. It describes the master-slave relationship bet
MySQL master-slave replication test environment:The 1.centos5.8 x86_64 is minimized, and the system has undergone a basic optimization2.mysql version: 5.1.73-log, multiple instances of the same server, installation method reference: MySQL multi-instance installation method3. Source Package storage Location:/home/oldboy/tools4. Source Package Compilation Installat
Primary server 192.168.7.182 Centos6.5 MYSQL5.6.10From server 192.168.112.7 Centos6.5 MYSQL5.6.10
Primary server configuration (192.168.7.182)
Vi/etc/my.cnf
[Mysqld]Server-id=1Log-bin=mysql-binBinlog-do-db=hello the name of the database that needs to be synchronized (not created in advance)
Save restart MySQL Service
Service MySQL Restart
Master server Configuration Complete
2. View Primary Server info
to synchronize the data in the active request, we choose the active subscription 3. Set up an account to execute the Distribution Agent 4. Set the frequency of Agent request synchronization 5. Set whether to initialize the data immediately 6. Completing the Create subscription Once created, we can verify that the replication was successful by inserting n data into the main library table and then querying from the library. Replication in SQL server2005 is easy to create, and we need to set t
to synchronize the data in the active request, we choose the active subscription 3. Set up an account to execute the Distribution Agent 4. Set the frequency of Agent request synchronization 5. Set whether to initialize the data immediately 6. Completing the Create subscription Once created, we can verify that the replication was successful by inserting n data into the main library table and then querying from the library. Replication in SQL server2005 is easy to create, and we need to set t
After MySQL master-slave replication is built on the two hosts, the showslavestatus displays: Last_IO_Error: errorconnectingtomaster ...... Solve bitsCN.com
After MySQL master-slave replication is built on the two hosts, the show slave status displays: Last_IO_Error: error c
Redis Master/Slave replication failed (master_link_status: down)
The master_link_status: down prompt is displayed when configuring redis master-slave replication today. First, open the redis. conf configuration file of slave and check whether the slaveof and masterauth opti
company does not have DBA ...)
Solution:First, check whether the slave server can be stopped .. In this case, you also have to stop the service) and ask him to stop the mysqld service. Note: before stopping the service, check: show slave status \ G to check the synchronization status of the slave node.
#/Etc/init. d/mysqld stop
Then, locate the relay log direc
The master-slave architecture of Redis enables us to read more and write less, so it's easy to configure the Redis architecture below.
Prepare for the Environment VMware + rhel-server-7.0 (101,102,103) +redis-3.2.0
1, installed in 192.168.137.101 redis3.2.0, I installed the directory as follows
Redis Installation Reference http://blog.csdn.net/yingxiake/article/details/51469364
2. Copy the Redis folder to
Interview MYSQLDBA encountered a problem:
Describes the implementation principle of MSYQL replication mechanism, how to recover data inconsistent slave database nodes without losing the MySQL main library?
MySQL Replication (replication) is an asynchronous replication, copied from a MySQL instace (called master) to another MySQL instance (called slave). Impleme
Recently, the company's MySQL architecture has been upgraded, from the original one-master-many slave to the DRBD + Heartbeat dual-master-many slave, and a new e-commerce website project is coming soon, DRBD + Heartbeat dual master and one
A master-slave table is a data relationship model that restricts the slave table. Take stuinfo in the student information table and stumarks in the exam preparation table as an example. We know that they are a one-to-many relationship. Of course, one is the
start the Resource takeover module to take over the resources or services running on the other host.1.3, MMM (MySQL master-master Replication Manager)--mmm leverages the technology of virtual IP: A network card can use multiple IPs at the same time. (So when using MMM, you need to 2*n+1 a ip,n as the number of MySQL database nodes, including Master,
1. Redis Profile Common Options descriptionDaemonize NoNote: Whether to start the redis-server in the background, the default is "no". If you change to Yes, a PID file is generated.Pidfile/var/run/redis.pidDescription: Redis-server pid file.Port 6379Description: The port number of the Redis-serverDbfilename Dump.rdbDescription: The location of the database files, it is best to add an absolute path, if not added in the start user's home directory.SlaveofDescription: Sets the address and port of t
This period of time, has been summing up the electronic business system related to the basic technology and architecture, wrote a lot of things. But still found a very important, very basic aspect has not mentioned, that is the database reads and writes separates the master and slave architecture. Perhaps after the dev
comma above, and the last is the number without single quotation marks. Then run under the MySQL command line from the library Start slave Then view the status Show Slave Stauts\g Can see Must be this state, if the word "Connecting to master", then there is a problem, the problem arises in four aspects 1, the network does not pass 2, the user name password is n
adding link[[email protected] local]# Groupadd mysql//add MySQL user group[[email protected] local]# useradd-g mysql mysql//add MySQL user account[[Email protected] local]# CD MySQL//Enter the MySQL directory after installation[Email protected] mysql]# chown-r root:mysql. Modify the genus and owner of the file, notice that there is a point behind the command that indicates the current directory[[email protected] mysql]# chown-r mysql:mysql data///Change the owner of the data directory to MySQL[
, such as mongodb, redis, and some relational row data, in order to make the data more secure, we often use the master-slave replication architecture as a backup, when there is a problem with the data on the host, we can connect to the slave machine.
That is, another machine will synchronize data from the host. If we use the linux Command netstat-apn, we will fin
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.