备查：MySQL Client CLI - CTRL+W 只删除一个单词
Intellij IDEA: cannot resolve symbol
Dec
14
MySQL/MariaDB 主从同步 
== Master ==
$ vi /etc/mysql/mariadb.conf.d/50-server.cnf
$ mysql
== Slave ==
$ vi /etc/mysql/mariadb.conf.d/50-server.cnf
另：如果报错
需要把 sql 里的 utf8mb4_0900_as_cs 替换成 MariaDB 的 utf8mb4_unicode_520_ci
转载请注明出自 ，如是转载文则注明原出处，谢谢:)
RSS订阅地址: https://www.felix021.com/blog/feed.php 。
$ vi /etc/mysql/mariadb.conf.d/50-server.cnf
引用
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 1024M
binlog_do_db = testdb
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 1024M
binlog_do_db = testdb
$ mysql
CREATE USER 'username'@'%' IDENTIFIED BY '12345678';
GRANT ALL PRIVILEGES ON giteadb.* TO 'username'@'%';
GRANT REPLICATION SLAVE ON testdb.* TO 'username'@'%';
[/code
[code]
mysqldump --databases testdb --master-data > testdb.sql
GRANT ALL PRIVILEGES ON giteadb.* TO 'username'@'%';
GRANT REPLICATION SLAVE ON testdb.* TO 'username'@'%';
[/code
[code]
mysqldump --databases testdb --master-data > testdb.sql
== Slave ==
$ vi /etc/mysql/mariadb.conf.d/50-server.cnf
引用
server-id = 2
relay_log = /var/log/mysql/mysql-relay-bin.log
log_bin = /var/log/mysql/mysql-bin.log
binlog_do_db = testdb
read_only = 1
relay_log = /var/log/mysql/mysql-relay-bin.log
log_bin = /var/log/mysql/mysql-bin.log
binlog_do_db = testdb
read_only = 1
mysql> CHANGE MASTER TO
MASTER_HOST='HOSTNAME',
MASTER_USER='testdb',
MASTER_PASSWORD='12345678',
MASTER_HOST='HOSTNAME',
MASTER_USER='testdb',
MASTER_PASSWORD='12345678',
$ mysql < testdb.sql
mysql> start slave;
mysql> SHOW SLAVE STATUS\G
mysql> SHOW SLAVE STATUS\G
另：如果报错
引用
mysql error 1273 (hy000) at line 33: unknown collation: 'utf8mb4_0900_as_cs'
需要把 sql 里的 utf8mb4_0900_as_cs 替换成 MariaDB 的 utf8mb4_unicode_520_ci
欢迎扫码关注：
转载请注明出自 ，如是转载文则注明原出处，谢谢:)
RSS订阅地址: https://www.felix021.com/blog/feed.php 。
