mysql replication status

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

Tags: mysql First, preparation (master and slave need to configure): yum-yinstallmysqlmysql-server #安装mysql yum-yinstallntpdate #安装时间同步 echo ' */1**** /usr/sbin/ntpdatentp1.aliyun.com>/dev/null ' >>/var/spool/cron/root #配置网络时间同步 servicemysqldstart #启动服务 chkconfig--addmysqld #添加为系统服务 chkconfigmysqldon #开启默认运行级别 Two, primary server configuration: The main profile defaults to:/etc/my.cnf [mysqld ] datadir=/

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

library: Slave2 3308#mastervim/data/3306/my.cnf[mysqld]...server-id = 1log-bin =/data/3306/ Mysql-bin/data/3306/mysql restartmysql-uroot-p123456-s/data/3306/mysql.sockmysql>show variables like ' server_id '; mysql>show variables like ' Log_bin ', mysql>grant replication Sla

--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