{"id":1292,"date":"2025-03-11T18:20:36","date_gmt":"2025-03-11T10:20:36","guid":{"rendered":"http:\/\/113.45.254.23\/?p=1292"},"modified":"2025-03-11T18:20:36","modified_gmt":"2025-03-11T10:20:36","slug":"%e6%95%b0%e6%8d%ae%e5%ba%93%e7%9a%84%e4%b8%bb%e4%bb%8e%e5%a4%8d%e5%88%b6","status":"publish","type":"post","link":"http:\/\/113.45.254.23\/?p=1292","title":{"rendered":"\u6570\u636e\u5e93\u7684\u4e3b\u4ece\u590d\u5236"},"content":{"rendered":"\n

db1:  192.168.7.10   \u4e3b<\/p>\n\n\n\n

db2:  192.168.7.11   \u4ece<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n
[root@server10 ~]# vim \/etc\/chrony.conf \t\t\u7f16\u8f91\u65f6\u95f4\u540c\u6b65\u914d\u7f6e\u6587\u4ef6<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
pool ntp.aliyun.com iburst\t\t\u540c\u6b65\u963f\u91cc\u4e91\u7684\u65f6\u95f4<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
[root@server10 ~]# systemctl enable --now chronyd \u542f\u52a8\u65f6\u95f4\u540c\u6b65\u5e76\u8bbe\u7f6e\u5f00\u673a\u542f\u52a8\nCreated symlink \/etc\/systemd\/system\/multi-user.target.wants\/chronyd.service \u2192 \/usr\/lib\/systemd\/system\/chronyd.service.\n[root@server10 ~]# \n[root@server10 ~]# chronyc sources -v\t\t\t\u8fd0\u884c\u65f6\u95f4\u540c\u6b65\n\n  .-- Source mode  '^' = server, '=' = peer, '#' = local clock.\n \/ .- Source state '*' = current best, '+' = combined, '-' = not combined,\n| \/             'x' = may be in error, '~' = too variable, '?' = unusable.\n||                                                 .- xxxx [ yyyy ] +\/- zzzz\n||      Reachability register (octal) -.           |  xxxx = adjusted offset,\n||      Log2(Polling interval) --.      |          |  yyyy = measured offset,\n||                                \\     |          |  zzzz = estimated error.\n||                                 |    |           \\\nMS Name\/IP address         Stratum Poll Reach LastRx Last sample               \n===============================================================================\n^* 203.107.6.88                  2   6    17     1  +1025us[+1170us] +\/-   14ms\n[root@server10 ~]# \n[root@server10 ~]# date\t\t\u67e5\u770b\u65f6\u95f4\u65e5\u671f\nMon Mar 10 11:56:43 AM CST 2025\n[root@server10 ~]# \n[root@server10 ~]# clock -w\t\u5c06\u65f6\u95f4\u65e5\u671f\u4fdd\u5b58\u5230\u7cfb\u7edf\u4e2d<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
[root@server10 ~]# vim \/etc\/my.cnf.d\/mariadb-server.cnf \t\u7f16\u8f91\u6570\u636e\u5e93\u7684\u4e3b\u914d\u7f6e\u6587\u4ef6<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
[mysqld]\n\nserver-id=1\t\t\t\t\t\t\u8bbe\u7f6e\u670d\u52a1\u5668\u7684id\u53f7\u4e3a1\uff08\u8868\u793a\u4ed6\u662f\u4e3b\u6570\u636e\u5e93\uff09\nlog-bin=mysql-bin\t\t\t\t\u5f00\u542f\u4e8c\u8fdb\u5236\u65e5\u5fd7<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
[root@server10 ~]# systemctl restart mariadb\t\t\u91cd\u542f\u6570\u636e\u5e93<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
[root@server10 ~]# mysql\t\t\t\t\t\t\u767b\u5f55\u6570\u636e\u5e93\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\nYour MariaDB connection id is 4\nServer version: 10.5.27-MariaDB-log MariaDB Server\n\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nMariaDB [(none)]> stop slave;\t\t\t\t\t\u505c\u6b62\u4ece\u6570\u636e\u5e93\nQuery OK, 0 rows affected, 1 warning (0.000 sec)\n\nMariaDB [(none)]> grant replication slave on *.* to 'sk'@'%' identified by 'centos';\t\u5c06\u6570\u636e\u5e93\u7684\u6240\u6709\u5185\u5bb9\u5168\u90e8\u6388\u6743\u7ed9\u4ece\u6570\u636e\u5e93 \u590d\u5236\u6388\u6743\u7684\u5185\u5bb9\u4e3ask \u5141\u8bb8\u4ece\u4efb\u4f55IP\u8bbf\u95ee\uff0c\u8ba4\u8bc1\u7684\u5bc6\u7801\u4e3acentos\uff0c\nQuery OK, 0 rows affected (0.002 sec)\n\nMariaDB [(none)]> flush privileges;\t\t\u5237\u65b0\u6388\u6743\nQuery OK, 0 rows affected (0.001 sec)\n\nMariaDB [(none)]> flush tables with read lock;\t\t\u5237\u65b0\u8868\u7684\u8bfb\u9501\u5b9a\nQuery OK, 0 rows affected (0.001 sec)\n\nMariaDB [(none)]> show master status;\t\t\t\u67e5\u770b\u4e3b\u6570\u636e\u5e93\u7684\u72b6\u6001\n+------------------+----------+--------------+------------------+\n| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |\n+------------------+----------+--------------+------------------+\n| mysql-bin.000001 |      635 |              |                  |\u65e5\u5fd7\u6587\u4ef6\u7684\u540d\u5b57\t\t\t\u65e5\u5fd7\u6587\u4ef6\u7684\u4f4d\u7f6e\n+------------------+----------+--------------+------------------+\n1 row in set (0.000 sec)<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
[root@server10 ~]# mysqldump --all-databases --user=root --password --master-data > masterdatabase.sql\t\t\t\t\t\t\u5c06\u6240\u6709\u6570\u636e\u5e93\u5168\u90e8\u5907\u4efd\u51fa\u6765\t\t\u5907\u4efd\u7684\u540d\u79f0masterdatabase.sql\t\t--user=root\u6570\u636e\u5e93\u7684\u7528\u6237 \t--password\u6570\u636e\u5e93\u7684\u5bc6\u7801\t--master-data\u6307\u5411\u4e3b\u6570\u636e\nEnter password: \n[root@server10 ~]# ls\nanaconda-ks.cfg  employees_db  employees_db-full-1.0.6.tar.bz2  masterdatabase.sql\n[root@server10 ~]# ll\ntotal 192568\n-rw-------. 1 root root      1494 Feb 17 10:00 anaconda-ks.cfg\ndrwxr-xr-x  2 root root      4096 Mar  7 09:07 employees_db\n-rw-r--r--  1 root root  26715056 Feb 19  2016 employees_db-full-1.0.6.tar.bz2\n-rw-r--r--  1 root root 170461946 Mar 10 12:18 masterdatabase.sql\n\n\n[root@server10 ~]# mysql\t\t\t\t\u767b\u5f55\u6570\u636e\u5e93\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\nYour MariaDB connection id is 6\nServer version: 10.5.27-MariaDB-log MariaDB Server\n\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nMariaDB [(none)]> unlock tables;\t\t\u89e3\u9501\u8868\nQuery OK, 0 rows affected (0.000 sec)<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
MariaDB [(none)]> quit\n'Bye<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
[root@db2 ~]# vim \/etc\/my.cnf.d\/mariadb-server.cnf \u7f16\u8f91\u6570\u636e\u5e93\u7684\u4e3b\u914d\u7f6e\u6587\u4ef6<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
init-connect='SET NAMES utf8mb4'\t\t\t\t\t\u521d\u59cb\u94fe\u63a5\u8bbe\u7f6eutf8mb4\u7684\u4e2d\u6587\u7f16\u7801\uff08\u4e0d\u7136\u63d2\u5165\u6570\u636e\u90fd\u662f\uff1f\uff1f\uff1f \u4e0d\u8bc6\u522b\uff09\ncharacter-set-server=utf8mb4\t\t\t\t\t\t\u5728\u5b57\u7b26\u8bbe\u7f6e\u670d\u52a1\u5668\u7684\u7f16\u7801\u4e3autf8mb4\n\nserver-id=2\t\t\t\t\t\t\t\t\t\t\u4ece\u6570\u636e\u5e93\nlog-bin=mysql-bin\t\t\t\t\t\t\t\t  \u5f00\u542f\u4e8c\u8fdb\u5236\u65e5\u5fd7<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
[root@db2 ~]# systemctl restart mariadb\t\t\t\u91cd\u542f\u6570\u636e\u5e93<\/code><\/pre>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
db1:  192.168.7.10   \u4e3b db2:  192.16 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[31,61],"class_list":["post-1292","post","type-post","status-publish","format-standard","hentry","category-linux","tag-mariadb","tag-61"],"_links":{"self":[{"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/posts\/1292","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/113.45.254.23\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1292"}],"version-history":[{"count":1,"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/posts\/1292\/revisions"}],"predecessor-version":[{"id":1312,"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/posts\/1292\/revisions\/1312"}],"wp:attachment":[{"href":"http:\/\/113.45.254.23\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/113.45.254.23\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1292"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/113.45.254.23\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}