MySQL8.0主从复制.pdf - 墨天轮文档

MySQL8.0主从复制.pdf

小年青。

7页

6次

2024-04-11

10墨值下载

1.配置host文件

1 echo"192.168.10.50">>/etc/hosts

2.检查系统是否自带mysql数据库

1 rpm‐qa|grepmysql&rpm‐qa|grepmariadb

2 rpm‐e‐‐nodeps包名&rpm‐e‐‐nodeps包名

3.解压安装包

1 tarxfmysql‐8.0.16‐linux‐glibc2.12‐x86_64.tar.xz

4.开始安装

1 mvtarxfmysql‐8.0.16‐linux‐glibc2.12‐x86_64.tar/u01/mysql

2 cd/u01/mysql

创建mysql相关目录

1 mkdir‐p/u01/mysql/{data,logs}

创建mysql用户和组并授权目录

1 groupaddmysql

2 useradd‐r‐gmysql‐s/sbin/falsemysql

3 chown‐Rmysql:mysql/u01/mysql

设置mysql环境变量，

1 vim~/.bash_profile

2 PATH=$PATH:/u01/mysql/bin:$HOME/bin

3 exit

4 whichmysql

配置mysql配置文件

1 [mysql]

2 default‐character‐set=utf8mb4

3 socket=/tmp/mysql.sock

4 [mysqld]

5 port=3306

6 socket=/tmp/mysql.sock

7 basedir=/u01/mysql

8 datadir=/u01/mysql/data

9 character‐set‐server=utf8mb4

10 default_storage_engine=InnoDB

11 innodb_buffer_pool_size=200M

12 max_allowed_packet=16M

13 explicit_defaults_for_timestamp=1

14 log‐output=FILE

15 general_log=0

16 general_log_file=/u01/mysql/logs/mysql‐general.err

17 slow_query_log=ON

18 slow_query_log_file=/u01/mysql/log/mysql‐query.err

19 long_query_time=10

20 log‐error=/usr/u01/log/mysql‐error.err

21 default‐authentication‐plugin=mysql_native_password

22 log_timestamps=SYSTEM

初始化数据库（mysql8）

1 /u01/mysql/bin/mysqld‐‐initialize‐‐user=mysql‐‐basedir=/u01/mysql‐‐da

tadir=/u01/mysql/data

查看是否初始化成功，并记录初始化密码

1 tail‐100fmysql‐error.err

2 ls‐l/u0/mysql/data

创建启动脚本

1 vim/usr/lib/systemd/system/mysqld.service

2 #添加如下内容

3 [Unit]

4 Description=MYSQLServer

5 Documentation=man:mysqld(8)

6 Documentation=http://dev.mysql.com/doc/refman/en/using‐systemd.html

7 After=network.target

8 After=syslog.target

9 [Install]

10 WantedBy=multi‐user.target

11 [Service]

12 User=mysql

13 Group=mysql

14 ExecStart=/u01/mysql/bin/mysqld‐‐defaults‐file=/etc/my.cnf

15 LimitNOFILE=65536

16 LimitNPROC=65536

修改权限并设置开机启动

1 chmodu+x/usr/lib/systemd/system/mysqld.service

2 systemctldaemon‐reload

3 systemctlstatusmysqld

4 systemctlstartmysqld

5 systemctlenablemysqld

关闭系统防火墙/或在防火墙开放端口

1 systemctlstopfirewalld.service

2 systemctldisbalefirewalld.service

3 firewall‐cmd‐‐zone=public‐‐add‐port=3306/tcp‐‐permanent

4 firewall‐cmd‐‐reload

修改初始密码

1 alteruser'root'@'localhost'identifiedwithmysql_native_passwordby'r

oot@123';

准备主库参数

1 bind‐address=192.168.10.51

2 server_id=330603

3 skip_name_resolve=ON

4 binlog_expire_logs_seconds=604800

5 binlog_cache_size=1M

6 max_binlog_size=1073741824

7 log_bin_trust_function_creators=1

8 innodb_flush_log_at_trx_commit=1

9 sync_binlog=1

10 transaction‐isolation=READ‐COMMITTED

11 gtid_mode=ON

12 enforce_gtid_consistency=1

13 log‐slave‐updates=1

14 binlog_gtid_simple_recovery=1

15 log_bin=/u01/mysql/logs/mysql‐bin

16 log_bin_index=/u01/mysql/logs/mysql‐bin.index

17 binlog_format=ROW

18 binlog_rows_query_log_events=on

19 plugin_dir=/u01/mysql/lib/plugin

20 plugin_load="rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave

=semisync_slave.so"

21 loose_rpl_semi_sync_master_enabled=1

22 loose_rpl_semi_sync_slave_enabled=1

23 loose_rpl_semi_master_timeout=5000

24 rpl_semi_sync_master_wait_point=AFTER_SYNC

25 rpl_semi_sync_master_wait_for_slave_count=1

准备从库参数

1 bind‐address=192.168.10.52

2 server_id=330604

3 skip_name_resolve=ON

4 binlog_expire_logs_seconds=604800

5 binlog_cache_size=1M

of 7

10墨值下载

mysql 主从切换 mysql8.0

相关文档

评论