slave master names

Label:MySQL master-slave Replication Principle IntroductionFirst, the principle of replicationMySQL replication tracks all changes to the database (updates, deletions, and so on) based on the primary server in the binary log. Each slave server receives a saved update from the primary server that the primary server has logged to the binary log so that the server c

Recently, when I deployed The MySQL master-slave replication architecture, I encountered "Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work. "error me

MySQL replication (2) Master-Slave replication practices, mysqlmaster-slave1. Preparations First, prepare two machines to install mysql My version here is 5.1.73, mysql database installation refer to: http://www.cnblogs.com/tangyanbo/p/4289753.html Centos for linux The machines are: Master: 192.168.1.227 Slave: 19

MySQL Master-slave replicationDeployment Environment:MySQL Master 192.168.40.21MySQL slave 192.168.40.22Ideas:When the data on the main MySQL operation or changes, the main MySQL binary log files (binary logs) will be changed, when the I/O thread and SQL thread from MySQL;The I/O thread reads the binary log file on the

Mongodb provides a Replication mechanism that helps us easily implement read/write splitting solutions and supports data security in unexpected situations such as disaster recovery (server power failure. In earlier versions (1.6), Mongo provides two replication modes: master-slave and replica pair (note: mongodb's latest supported replset replica set method can be regarded as an upgraded version of pair. It

-pywxi123-s/data/3306/mysql.sockWelcome to the MySQL Monitor. Commands End With; or \g.Your MySQL Connection ID is 1Server Version:5.5.32-log MySQL Community Server (GPL)Copyright (c) and/or, Oracle, its affiliates. All rights reserved.Oracle is a registered trademark of the Oracle Corporation and/or itsAffiliates. Other names trademarks of their respectiveOwners.Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.Mys

Label:MySQL master-slave replication Scenario Description:Primary database server: 192.168.10.130,mysql is already installed and has no application data.From the database server: 192.168.10.131,mysql is installed and no application data is applied. 2.1 Operations on the primary server Start the MySQL service /opt/mysql/init.d/mysql start Managing MySQL server via command line login /opt/mysql/bin/mysql-ur

) Slave copies the binary log events of master to its trunk logs (relay log);(3) Slave redo the event in the trunk log and change the data to reflect its own.650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/56/FD/wKiom1SOwveBlyTdAADpsdSzYhI977.jpg "title=" Mysql_ Master_slave.jpg "alt=" Wkiom1sowveblytdaadpsdszyhi977.jpg "/>2. Replication Configuration

The second part was intended to test whether the master server was suspended and the slave server was upgraded. However, an accident occurred. Instead, it was used to test how to recover a slave server when it was suspended. Put the failure of the master server in the third part. Continue to test with mysql: sandbox. T

Label: In a MySQL replication environment, we usually only judge the latency of the slave based on the value of the seconds_behind_master . This is acceptable in most cases, but is not accurate enough and should be considered for more factors. First, let's look at the state of slave: [Email protected] [(none)]> show slave status\g *************************** 1. R

1. View the status of MasterShow master status; Position should not be 0show Processlist; //state status should be have sent all binlog to slave; waiting for Binlog to be updated2. View slave statusshow slave status;//slave_io_running and slave_sql_running states must be Yesshow Processlist;//There should be two rows w