file position

One, master-slave replication conditions1, turn on Binlog function2, the main library to establish a synchronization account3, configure master from the library. info (change mast. ）4,start slave Copy SwitchKnowledge Points: # # # #1, 3 threads,

First, the environment1 6.5 2 5.6. - 3 Host A:192.168. 1.1 (Master) 4 slave B:192.168. 1.2 (Slave) 5 slave B:192.168. 1.3 (Slave)Second, the basic Environment configurationMySQL is accessed via port 3306, so make sure the firewall is on for Port 330

MySQL Master-Slave introductionMySQL master-slave is also called replication, AB replication. Simply said that A and b two machines from the back, on a to write the data, the other B will follow the writing data, the two data in real-time

Problem-handling for reference to online contentRe-master from, fully synchronizedAfter you create a new table in the main library, you find that the data is not synchronized in the slave segment.MySQL version:5.6.10Os:rhel 5.6The steps to resolve

MySQL master-Slave synchronization experiment Fine SolutionI. Experimental environmentLab environment 192.168.9.108 to master192.168.9.109 to SlaveDatabase versions: Version 5.1.73Installation method: The source of the Yum installation source is

In order to realize the redundancy of MySQL database, backup, recovery, load balancing and other functions, the two days have been learning and studying MySQL dual-machine hot standby, in fact, MySQL's dual-machine hot standby is the use of MySQL

MySQL Master master synchronization and master-slave synchronization are the same principle, but both sides are the master-slave role.EnvironmentOperating system version: CentOS7 64-bitMySQL version: mysql5.6.33Node 1ip:192.168.1.205 host Name:

1 OverviewThis article will cover the following six types of MySQL logs related conceptsQuery log: General_logSlow query log: log_slow_queriesError log: Log_error, log_warningsBinary log: BinlogRelay log: Relay_logTransaction log: Innodb_log2 Query

MySQL Master-slave replication principleMysql Master-Slave synchronization is actually an asynchronous replication process, in order to achieve replication first need to open the Bin-log log on master, the entire process needs to open 3 threads,

MySQL primary master (AA)Experimental environmentMaster-1 192.168.3.1Master-2 192.168.3.10Shut down the firewall (two units)[[Email protected] ~]# service iptables stop[Email protected] ~]# Setenforce 0Set Password[Email protected] ~]# mysqladmin-u

One, login database refresh Binlog1.1) View the current BinlogMysql> Show master status;+---------------------+----------+--------------+------------------+-------------------+| File | Position | binlog_do_db | binlog_ignore_db | Executed_gtid_set |+

For a detailed explanation of Binlog, please refer to:http://zlyang.blog.51cto.com/1196234/1833062The Binlog log is used to record all statements that have updated data or that have potentially updated data. Statements are saved as "events," which

Environment:3306 Main Library3307 from Library1 Setting the Server-id value and turning on the Binlog function parameterEdit the configuration file for MySQL/data/3306/my.cnf[mysqld]Server-id = 6----Each machine or instance Sever-id used for

1. Modify the configuration on the basis of the original single instance/USR/MY.CNF[Mysqld_multi]Mysqld=/usr/bin/mysqld_safeMysqladmin=/usr/bin/mysqladminUser=root[mysqld3306]port=3306Socket=/var/lib/mysql/mysql.sockPid-file=/var/lib/mysql/localhost.

Installation Environment6.55.6.27主机A：192.168.1.1 （Master）主机B：192.168.1.2 （Slave）The version of the database highlighted here is because MySQL is installed differently before and after 5.6.I was in the configuration of the time, also encountered this

StatementThe Stars last nightBlog:http://yestreenstars.blog.51cto.com/This article by oneself creation, if need reprint, please indicate source, thank cooperation!ObjectiveConfigure the MySQL server to implement primary master

The essence of a backup is to save a copy of the dataset, but the original data is constantly changing, so the backup can only revert to the data before the data changes. What about the changes? So it's important to develop a good backup strategy.I.

First, the primary database configuration assumes that the primary database IP address is: 192.168.1.1 Modify my.cnf Add configuration under [Mysqld] server-id=1Log-bin=syslog ##################################### Open LogBinlog-do-db=cmstop ########

Method one: After ignoring the error, continue syncingThis method is applicable to the case that the data of master-slave database is not very different, or the data can not be completely unified, the data requirements are not strict.Solve:Stop

VI Editor: Full-screen text editorVi:visual Interface, visual interface;Vim has more new features relative to VI:1. Syntax coloring display;2. More orders;3. Historical records;VI: Modal text editor mode: Edit mode (Command mode), default mode of