(1)master\u5c06\u6539\u53d8\u8bb0\u5f55\u5230\u4e8c\u8fdb\u5236\u65e5\u5fd7(binary log)\u4e2d\uff08\u8fd9\u4e9b\u8bb0\u5f55\u53eb\u505a\u4e8c\u8fdb\u5236\u65e5\u5fd7\u4e8b\u4ef6\uff0cbinary log events\uff09\uff1b
(2)slave\u5c06master\u7684binary log events\u62f7\u8d1d\u5230\u5b83\u7684\u4e2d\u7ee7\u65e5\u5fd7(relay log)\uff1b
(3)slave\u91cd\u505a\u4e2d\u7ee7\u65e5\u5fd7\u4e2d\u7684\u4e8b\u4ef6\uff0c\u5c06\u6539\u53d8\u53cd\u6620\u5b83\u81ea\u5df1\u7684\u6570\u636e\uff1b<\/p>\n\n\n\n
\u4e3b\u5e93\uff1a \u4ece\u5e93\uff1a (1)master\u5c06\u6539\u53d8\u8bb0\u5f55\u5230\u4e8c\u8fdb\u5236\u65e5\u5fd7(binary log)\u4e2d\uff08\u8fd9\u4e9b\u8bb0\u5f55\u53eb\u505a\u4e8c\u8fdb\u5236\u65e5\u5fd7\u4e8b\u4ef6\uff0cbinary … \u7ee7\u7eed\u9605\u8bfb\u201cMysql\u4e3b\u4ece\u540c\u6b65\u201d<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-70","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/v4.oracle.20241010.xyz\/index.php?rest_route=\/wp\/v2\/posts\/70"}],"collection":[{"href":"https:\/\/v4.oracle.20241010.xyz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/v4.oracle.20241010.xyz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/v4.oracle.20241010.xyz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/v4.oracle.20241010.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=70"}],"version-history":[{"count":2,"href":"https:\/\/v4.oracle.20241010.xyz\/index.php?rest_route=\/wp\/v2\/posts\/70\/revisions"}],"predecessor-version":[{"id":72,"href":"https:\/\/v4.oracle.20241010.xyz\/index.php?rest_route=\/wp\/v2\/posts\/70\/revisions\/72"}],"wp:attachment":[{"href":"https:\/\/v4.oracle.20241010.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=70"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/v4.oracle.20241010.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=70"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/v4.oracle.20241010.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=70"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
1. vim \/etc\/mysql\/mariadb.conf.d\/50-server.cnf
[mysqld]
server-id=1
log-bin=\/var\/log\/mysql\/mysql-bin.log
2.
create user ‘apollo’@’%’ identified by ‘apollo123’;
grant replication slave on .<\/em> to ‘apollo’@’%’;
flush table with read lock;
show master status; \/\/ \u8bb0\u5f55\u4e0bFile\u3001Position\u540e\u9762\u4ece\u5e93\u4f1a\u7528\u5230\uff0c\u4f8b\u5982a-mysql-bin.000001\uff0c615
3.
mysqldump -uroot -p –all-databases > \/root\/root.sql<\/p>\n\n\n\n
1. vim \/etc\/mysql\/mariadb.conf.d\/50-server.cnf
[mysqld]
server-id=2
2.scp root@192.168.13.183:\/root\/root.sql \/root\/root.sql
\u767b\u5f55mysql\uff1a
source \/opt\/root.sql
3. \u6dfb\u52a0master\u914d\u7f6e\uff1a
change master to master_host=’192.168.13.189′,
master_user=’apollo’,
master_password=’apollo123′,
master_log_file=’a-mysql-bin.000001′,
master_log_pos=615;
4.
start slave;
\u68c0\u67e5\u540c\u6b65\u72b6\u6001\uff1a
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
\u6536\u5c3e\uff1a
\u4e3b\u5e93\u6267\u884c\uff1aunlock tables;<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"