Discover mysql replication status, include the articles, news, trends, analysis and practical advice about mysql replication status on alibabacloud.com
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 configuration file by default:/ETC/MY.CNF[Mysqld]Da
MySQL-master-slave replication bitsCN.com
MySQL replication is often used in the following environments:
1. avoid disaster through hot backup
2. generate reports
Using the slave server to generate reports can greatly reduce the load on the master server.
3 debugging and auditing
For example, check whether some queries
Master(2) Restart Mysql:service mysql restart(3) Check the status of Master: Show Master State;(4) To view binaries in the directory: Ll/var/lib/mysqlAmong them, the Mysql-bin.index deposit is:(5) Location-based backupMysqldump-uroot-p--single-transaction--master-data=2--triggers--routines--all-databases > Xbq.sqlBased on independent transaction//= 2 comment out
192.168.145.226, enhance security.6, log on to the master server MySQL, query the status of MasterMysql>show Master status;+------------------+----------+--------------+------------------+| File | Position | binlog_do_db | binlog_ignore_db |+------------------+----------+--------------+------------------+| mysql-bin.0
The following articles mainly discuss the actual operation steps for optimizing the MySQL built-in replication function, including the configuration of the master server and the actual operation process for configuring the slave server, and create a master-slave relationship and other related content, the following is the main content description. MySQL internal
Rotten mud: Learn the principle of mysql database master-slave synchronous replication, mysql master-slave
This article was sponsored by Xiuyi linfeng and first launched in the dark world.
This article is partly reproduced on the Internet.
MySQL Replication is a master-sla
serial numbers to create continuous relay log files, starting at 000001. Track the relay log index files from the server to identify the relay logs that are currently in use. The default relay log index file name is Host_name-relay-bin.index. By default, these files are created in the data directory from the server. The relay log is the same format as the binary log and can be read with Mysqlbinlog. When the SQL thread finishes all the events in the relay log, the relay log is automatically del
Tags: stat upd extend Inno href amp comm State letA good use of mysqladmin extended-status to view the running state script for MySQL: Mysqladmin-p3306-uroot-p-h127.0.0.1-r-i1Extended-status |awk-F"|" "begin{count=0;}"'{if ($ ~/variable_name/ ((++count)%20 = = 1)) {\Print"----------|---------|---MySQL Command
--DEFAULTS-FILE=/HOME/MYSQL/MYSQL/CONF/MASTER.CNF
Java code
# Slave
# If Mysql is started, turn it off first.
/home/mysql/mysql/bin/mysqladmin-u root-p shutdown
# start MySQL with the modi
Database
Show slave status; view slave database status
Restore data through binlog
Enter the binlog directory
cd /data/mysql/3306/binlog/
Viewing the binlog list ls
View binlog log files
/usr/local/webserver/mysql/bin/mysqlbinlog binlog.000001
Restore data
/Usr/local/webserver/m
= 0Innodb_flush_log_at_trx_commit = 1Sync_binlog = 1
Restart the mysql server of the Master node.
Create a user
Mysql> create user 'repl' @ '192. 168.150.200 'identified by 'pass4repl ';Mysql> grant replication slave on *. * to 'repl' @ '2017. 168.150.200 ';
To obtain binary log coordinates for slave, first make the d
[[email protected] ~]#/etc/init.d/mysqld start [Email protected] ~]# mysql-uroot-p Welcome to the MySQL Monitor. Commands End With; or \g. Your MySQL Connection ID is 2 Server Version:5.1.73-log Source Distribution Copyright (c) and/or, Oracle, its affiliates. All rights reserved. Oracle is a registered trademark of the Oracle Corporation and/or its Affiliates
Mysql replication function-"master-slave" structure bitsCN.com
Mysql replication function-"master-slave" structure
1. configure the master server
1. add content in my. ini
2. create an account with "copy permission"
Create an account
Grant all operation permissions on the database to be copied to the created accou
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 message. That is, the same UUID is used in the
MySQL master-slave Replication
The principle of MySQL master-slave replication is the same as that of MySQL master-slave replication, but slave databases cannot be used for write operations, therefore, some parameter configuration
).######################################## master-Slave Architecture #################################################### #配置 #############Note: The mysql-5.5.28 binary package is used here. The installation process is slightly. Direct-to-master replication configuration# #主服务器1. Change/ETC/MY.CNF:Server-id = 1 #设置服务器唯一标识Log-bin=mysql-bin #开启二进制日志功能2. Add a
account required for replication on master and% indicates that the root user of any remote address can connect to the master host GRANTreplicationslaveON*.*TO[emailprotected]‘%‘IDENTIFIEDBY‘gqb101112‘; Identified is the password. In the host creation test database, a table GQB The structure of the primary table is this way. Configuration of MySQL slave machine Installation of 1.
master slaveMysql software can be downloaded in the http://www.mysql.com [/, source code or rpm package can be, because RHEL6 comesMysql software package, directly install yum.# Yum install mysql-server-yMaster server Configuration1) configure the/etc/my. cnf configuration fileAdd parameters under [mysqld]Log-bin = mysql-bin # Start the binary log systemBinlog-do-db = test # Name of the database to be sync
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.