mariadb master master replication

Tags: test error:end systemctl ORM amp Command database outDocker container Master node: 172.17.0.9Docker Container Sub-node: 172.17.0.10Asynchronous replication: First confirm that the main library and from the library is consistent, preferably a clean database that has just been initialized if the main library is in use cannot initialize, it is necessary to first copy the contents of the main library to t

MySQL is an open-source relational database system. Replication is a process that replicates data from a MySQL database server (master server) to another server (slave server slave.Configure the master server)1. Edit the database configuration file my. cnf, which is usually in the/etc/directory.1. # vi/etc/my. cnfAdd the following code under [mysqld:1. log-bin =

;+------------------+----------+--------------+------------------+| File | Position | binlog_do_db | binlog_ignore_db |+------------------+----------+--------------+------------------+| mysql-bin.000010 | 327 | WordPress | MySQL |+------------------+----------+--------------+------------------+1 row in Set (0.00 sec) Unlocking the Database MariaDB [(None)]> UNLOCK TABLES; 0 rows affected (0.00 sec) When executing from the server [email protected] ~

MyIsam is relatively simple to publish, just copy all the files in the library. The procedure of copying Innodb is similar to that of MyIsam, except that the table content in the Innodb Engine no longer exists in the same database directory (MyIsam does this). In the Innodb engine, data files are stored in files such as ibdata1, and operation logs are stored in files such as ib_logfile0, ib_logfile1, and ib_logfile2 by default.Innodb replication and p

connections may also have firewalls blocking remote connection failures加入对应mysql端口的 允许-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT结果：[[emailprotected] /]# vi /etc/sysconfig/iptables // 打开防火墙配置# Firewall configuration written by system-config-firewall# Manual customization of this file is not recommended.*filter:INPUT ACCEPT [0:0]:FORWARD ACCEPT [0:0]:OUTPUT ACCEPT [0:0]-A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT-A INPUT -p icmp -j ACCEPT-A INPUT -i lo -j ACCE

| 359 |TABLE_ID: -Flags:stmt_end_f| |Host2-Bin.000001 | 359 |Xid| 1 | 390 | COMMIT /*xid=423*/ | |Host2-Bin.000001 | 390 |Stop| 2 | 413 | | +------------------+-----+----------------+-----------+-------------+----------------------------------------- --------------------------+ 8Rowsinch Set(0.00Sec The following are some of the deletions are bin

Reference Document: http://www.178linux.com/60625Node OneModify configuration file Settings unique ID open binary log[[email protected] ~]# VIM/ETC/MY.CNF Add the following [mysqld] log-bin=master_bin open binary log server_id=1 to the primary node a unique ID number Innodb_file_per_table=on InnoDB open Independent table space Skip_name_resolve=on turn on bypass hostname reverse SolutionStart the service create an account with Remote copy permission[[Email protected] ~]# service

Tags: mariadb mariadb Master1./etc/my.cnf on the master nodeService-id=1Permissions of the MySQL authorized backup user in the main libraryGrant Replication Slave on * * to [e-mail protected] '% ' identified by ' password ';Export the whole library at the terminal to ensure database offset consistency join--

Host172.16.0.21172.16.0.22centos6.2Use yum to install MySQL separately Create a new library for MySQL on 21 CREATE DATABASE ' replytest1 '/*!40100 DEFAULT CHARACTER SET UTF8 * *; Building a table CREATE TABLE ' replytest1 '. ' Test1 ' (' ID ' INT UNSIGNED not NULL auto_increment,' Test1col ' VARCHAR () NULL,PRIMARY KEY (' id ')); Inserting data INSERT into ' replytest1 ' test1 ' (' Test1col ') VALUES (' 1′);INSERT into ' replytest1 ' test1 ' (' Test1col ') VALUES (' 2′); —————————————————

Tags: mysql master and slave replicationMySQL master-slave replication and semi-synchronous replication principle1, master-slave replication is mainly based on the binary log (binlog), the binary logging is a complete event. 2. Ta

Attached the command to view the information in the certificate: openssl x509 -in /PATH/FROM/CERT_FILE -noout -text|subject|serial|dates ----------------------------- Send the certificate to the mysql server And send CA self-signed certificates to the slave server. Certificate preparation ends here To implement master-slave Replication Based on the ssl function, both the

Label:1, first off B, the data of a to export, mysqldump-hlocalhost-uroot-p123456--database IBPRPU >ibprpu.sql2. Turn off A, start B, enter MySQL to create a new database Ibprpu3, Import Database mysql-hlocalhost-uroot-p123456 or go to MySQL and import the database via command Source/root/ibprpu.sql4, modify a and B configuration files, my.cnf, restart A and B5, Note: Some version my.cnf in the Replication property configuration does not work, first c

Firewall rule/sbin/iptables-i input-p TCP--dport 3306-j ACCEPT/etc/rc.d/init.d/iptables Save/etc/init.d/iptables restart2) slave Perform the same operation(ii) Setting up a remote user on the master server allows access to data on the primary server from the server through this userMariaDB [(None)]> GRANT REPLICATION SLAVE on * * to ' SLAVE ' @ ' 192.168.3.133 ' identified by ' 123456 '; (Allows user slave

Mysql5.5 master-slave synchronous replication Configuration In the previous article "mud: learning the principles of mysql database master-slave synchronous replication", we introduced the basic principles of mysql master-slave replicati