mysql start replication

System version: CentOS 6.5 mysql version: mysql-5.5.38Production environment, if the same database server to do write service and read services, whether from security, high availability or high concurrency and other angles can not meet the actual demand, therefore, the general use of multiple database servers through master-slave replication to synchronize data t

Mysql master-slave replication bitsCN.com I. environment description Master Database server ip address: 192.168.0.2 Slave Database server ip: 192.168.0.3 Mysql on the master-slave server has been completely installed, but is put into production, so no data is generated. II. master-slave replication configuration 1. mas

MySQL built-in replication function is used to optimize Availability MySQL built-in replication function to optimize availability. in Soundbreak, we play live audio and video continuously 24 hours a day, so for MySQL's new replication feature, we cannot make convincing tests

Tags: completing the Generate Plugins Status tool parameters MySQL database size1 OverviewSemi-synchronous replication refers to a subset of host synchronous replication, and another part of the host asynchronous replicationThe logic of synchronization is that the user writes to the primary server, the primary service is logged to the binary file, the primary ser

MySQL replication can ensure the redundancy of the data and read and write separation to share the system pressure, if the primary master replication can also be good to avoid the primary node single point of failure. But there are some problems with MySQL master replication

, as shown below: Start slave; The master-slave synchronous replication of mysql is enabled. Run the following command to check whether the synchronization is normal. As follows: Show slave status \ G; Check whether the synchronization is mainly to check the Slave_IO_Running and Slave_ SQL _Running options. If synchronization is normal, the two options must be

use a binary log and set a unique ID number.On each slave server, you must set a unique ID number in order to connect to the Maste server(optional) Create an independent user to authenticate the primary server and replicate by accessing the binary logBefore you create a data snapshot or start the replication process, you need to log the master server's binary log location. This information is required at l

= 192.168.113.9 // ip address of the master database serverMaster-user = repuserMasters-password = 111111Master-port = 3306Master-connect-retry = 15Replicate-do-db = testdb // the database to be synchronized. Multiple databases can be separated by commas (,) or multiple lines can be written.Replicate-ignore-db = mysqlLog_bin =/var/log/mysql/mysql-bin.logExpire_logs_days = 10Max_binlog_size = 100 M (3) deb

may be manually restored or modified before the copy is restarted. at this time, when DBA replays the log file, you can find the event to know where to start or stop replay. Incident: This event type was introduced in MySQL 5.1. Compared with the Stop event, this event contains a identifier to specify which type of accident occurred. It is generally used to indicate that the server is forced to execute a

First, the preparation (master and slave need to configure):Yum-y install MySQL mysql-server#安装mysqlYum-y Install ntpdate#安装时间同步Echo ' */1 * * * * */usr/sbin/ntpdate ntp1.aliyun.com >/dev/null '>>/var/spool/cron/root #配置网络时间同步Service mysqld start#启动服务Chkconfig--add mysqld#添加为系统服务Chkconfig mysqld on#开启默认运行级别Second, the primary server configuration: The main config

MySQL replication can ensure the redundancy of the data and read and write separation to share the system pressure, if the primary master replication can also be good to avoid the primary node single point of failure. But there are some problems with MySQL master replication