主从版本升级_主从_8.0.32_软链接_基于二进制日志文件

最新推荐文章于 2024-04-27 16:49:37 发布
最新推荐文章于 2024-04-27 16:49:37 发布
阅读量967 收藏 18
点赞数 24
文章标签： adb android
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq961573863/article/details/135491401
版权

升级需求

将一套MySQL 8.0.32主从环境版本升级到8.0.35版本，主从环境如下：

主服务器

登录账号密码

端口

当前版本

目标版本

主服务器

59.217.250.226

root/topnet@123

3306

8.0.32

8.0.35

从服务器

59.217.250.227

root/topnet@123

3306

8.0.32

8.0.35

升级步骤

关键步骤如下：

1.断开应用 2.确定主从无延时 3.关闭主库 4.关闭从库 5.备份主库数据目录 6.启动主库 7.启动备库 8.查看主从同步状态

查数据库版本

主服务器数据库版本

mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.32    |
+-----------+
1 row in set (0.00 sec)

mysql> show variables like '%version%';
+--------------------------+------------------------------+
| Variable_name            | Value                        |
+--------------------------+------------------------------+
| admin_tls_version        | TLSv1.2,TLSv1.3              |
| immediate_server_version | 999999                       |
| innodb_version           | 8.0.32                       |
| original_server_version  | 999999                       |
| protocol_version         | 10                           |
| replica_type_conversions |                              |
| slave_type_conversions   |                              |
| tls_version              | TLSv1.2,TLSv1.3              |
| version                  | 8.0.32                       |
| version_comment          | MySQL Community Server - GPL |
| version_compile_machine  | x86_64                       |
| version_compile_os       | Linux                        |
| version_compile_zlib     | 1.2.13                       |
+--------------------------+------------------------------+
13 rows in set (0.00 sec)


mysql> exit
Bye
[root@localhost ~]# mysql -V
mysql  Ver 8.0.32 for Linux on x86_64 (MySQL Community Server - GPL)

从服务器数据库版本

mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.32    |
+-----------+
1 row in set (0.00 sec)

mysql> show variables like '%version%';
+--------------------------+------------------------------+
| Variable_name            | Value                        |
+--------------------------+------------------------------+
| admin_tls_version        | TLSv1.2,TLSv1.3              |
| immediate_server_version | 999999                       |
| innodb_version           | 8.0.32                       |
| original_server_version  | 999999                       |
| protocol_version         | 10                           |
| replica_type_conversions |                              |
| slave_type_conversions   |                              |
| tls_version              | TLSv1.2,TLSv1.3              |
| version                  | 8.0.32                       |
| version_comment          | MySQL Community Server - GPL |
| version_compile_machine  | x86_64                       |
| version_compile_os       | Linux                        |
| version_compile_zlib     | 1.2.13                       |
+--------------------------+------------------------------+
13 rows in set (0.01 sec)

mysql> exit
Bye
[root@xzdcweb1 ~]# mysql -V
mysql  Ver 8.0.32 for Linux on x86_64 (MySQL Community Server - GPL)

停止应用

确保业务已停止，保证数据一致性

--查询数据库中哪些线程正在执行
show processlist;

确定主从无延时

--查询主库
mysql> show master status;
+---------------+-----------+--------------+------------------+-------------------+
| File          | Position  | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+---------------+-----------+--------------+------------------+-------------------+
| binlog.000002 | 568694023 |              |                  |                   |
+---------------+-----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)

--查询备库
mysql> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for source to send event
                  Master_Host: 59.217.250.226
                  Master_User: slave
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: binlog.000002
          Read_Master_Log_Pos: 568627797
               Relay_Log_File: xzdcweb1-relay-bin.000037
                Relay_Log_Pos: 568474217
        Relay_Master_Log_File: binlog.000002
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 568627797
              Relay_Log_Space: 568474776
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
                  Master_UUID: 5e53417b-c152-11ed-b3a0-a8494daa8138
             Master_Info_File: mysql.slave_master_info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Replica has read all relay log; waiting for more updates
           Master_Retry_Count: 86400

1.如下的两参数代表主从同步能够正常的运行网络

若是是Slave_IO_Running的参数不是YES则说明从库读取不到主库的bin-log日志,

若是是Slave_SQL_Running参数不是YES，则说明从库在读取中继日志发生问题。

Slave_IO_Running: Yes

Slave_SQL_Running: Yes同步

2.查看Seconds_Behind_Master参数，若是为0的话，则表示主从复制良好

原文链接：mysql如何准确判断主从延时情况_判断mysql主从延时的方法(不依赖中间件)-CSDN博客

停止数据库

停止从库
--查正在运行的MySQL进程,确定安装目录和数据目录
[root@xzdcweb1 ~]# ps -ef | grep mysql
root     33033     1  0  2023 ?        00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data1/mysql/data --pid-file=/data1/mysql/data/xzdcweb1.pid
mysql    33383 33033  0  2023 ?        03:44:54 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data1/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=xzdcweb1.err --pid-file=/data1/mysql/data/xzdcweb1.pid --socket=/var/lib/mysql/mysql.sock
root     50368 45094  0 20:01 pts/0    00:00:00 grep --color=auto mysql
[root@xzdcweb1 ~]# systemctl status mysqld
● mysqld.service - LSB: start and stop MySQL
   Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)
   Active: active (running) since Mon 2023-09-18 12:41:33 CST; 3 months 21 days ago
     Docs: man:systemd-sysv-generator(8)
    Tasks: 83
   CGroup: /system.slice/mysqld.service
           ├─33033 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data1/mysql/data --pid-file=/data1/mysql/data/xzdcweb1.pid
           └─33383 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data1/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin -...

Sep 18 12:41:27 xzdcweb1 systemd[1]: Starting LSB: start and stop MySQL...
Sep 18 12:41:33 xzdcweb1 mysqld[33022]: Starting MySQL......[  OK  ]
Sep 18 12:41:33 xzdcweb1 systemd[1]: Started LSB: start and stop MySQL.

--查看从同步情况
show slave status\G

--停止同步
mysql>stop slave;

--停止数据库
--1.进入原8.0.23 mysql命令行 正确关闭数据库
法1：
mysqladmin -uroot -p shutdown

[root@mysql]# mysql -uroot -p
Enter password: 
#使用mysql shell 命令util.checkForServerUpgrade('root@127.0.0.1:3307', {"password":"XXXXX", "targetVersion":"8.0.26", "configPath":"/etc/my3307.cnf"}) 检查升级到目标版本8.0.26，确认没有error级别的问题
Errors:   0
Warnings: 17
Notices:  0

#检查没有未提交的xa事务
mysql> xa recover;
Empty set (0.00 sec)

# 确保数据都刷到硬盘上，更改成0
mysql> show variables like 'innodb_fast_shutdown';
+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| innodb_fast_shutdown | 1     |
+----------------------+-------+
1 row in set (0.00 sec)

mysql> set global innodb_fast_shutdown=0;
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like 'innodb_fast_shutdown';
+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| innodb_fast_shutdown | 0     |
+----------------------+-------+

mysql> shutdown;
Query OK, 0 rows affected (0.00 sec)

mysql> exit

#查看进程和端口后，已无输出记录，确保已停止
[root@xzdcweb1 ~]# ps -ef | grep mysql
root     51658 45094  0 20:07 pts/0    00:00:00 grep --color=auto mysql
[root@xzdcweb1 ~]# ss -nlt | grep 3306
停止主库
--查正在运行的MySQL进程,确定安装目录和数据目录
[root@localhost ~]# ps -ef | grep mysql
root     41766 41065  0 19:52 pts/0    00:00:00 grep --color=auto mysql
root     45742     1  0  2023 ?        00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data1/mysql/data --pid-file=/data1/mysql/data/localhost.localdomain.pid
mysql    46126 45742  0  2023 ?        04:18:50 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data1/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=localhost.localdomain.err --pid-file=/data1/mysql/data/localhost.localdomain.pid --socket=/var/lib/mysql/mysql.sock
[root@localhost ~]# systemctl status mysqld
● mysqld.service - LSB: start and stop MySQL
   Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)
   Active: active (running) since Mon 2023-09-18 11:54:00 CST; 3 months 22 days ago
     Docs: man:systemd-sysv-generator(8)
   CGroup: /system.slice/mysqld.service
           ├─45742 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data1/mysql/data --pid-file=/data1/mysql/data/localhost.localdomain.pid
           └─46126 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data1/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin -...

Sep 18 11:53:57 localhost.localdomain systemd[1]: Starting LSB: start and stop MySQL...
Sep 18 11:54:00 localhost.localdomain mysqld[45731]: Starting MySQL... SUCCESS!
Sep 18 11:54:00 localhost.localdomain systemd[1]: Started LSB: start and stop MySQL.

--记下输出中的 File 和 Position 值，后续在从服务器上使用。

mysql> show master status;
+---------------+-----------+--------------+------------------+-------------------+
| File          | Position  | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+---------------+-----------+--------------+------------------+-------------------+
| binlog.000002 | 568694023 |              |                  |                   |
+---------------+-----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)


参数说明：
Binlog_Do_DB：同步数据库
Binlog_Ignore_DB：忽略数据库即不同步的数据库
Executed_Gtid_Set：空


--停止数据库
--1.进入原8.0.23 mysql命令行 正确关闭数据库
法1：
mysqladmin -uroot -p shutdown

[root@mysql]# mysql -uroot -p
Enter password: 
#使用mysql shell 命令util.checkForServerUpgrade('root@127.0.0.1:3307', {"password":"XXXXX", "targetVersion":"8.0.26", "configPath":"/etc/my3307.cnf"}) 检查升级到目标版本8.0.26，确认没有error级别的问题
Errors:   0
Warnings: 17
Notices:  0

#检查没有未提交的xa事务
mysql> xa recover;
Empty set (0.00 sec)

# 确保数据都刷到硬盘上，更改成0
mysql> show variables like 'innodb_fast_shutdown';
+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| innodb_fast_shutdown | 1     |
+----------------------+-------+
1 row in set (0.00 sec)

mysql> set global innodb_fast_shutdown=0;
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like 'innodb_fast_shutdown';
+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| innodb_fast_shutdown | 0     |
+----------------------+-------+

mysql> shutdown;
Query OK, 0 rows affected (0.00 sec)

mysql> exit

#查看进程和端口后，已无输出记录，确保已停止
[root@localhost ~]# ps -ef | grep mysql
root     43674 43397  0 20:04 pts/0    00:00:00 grep --color=auto mysql
[root@localhost ~]# ss -ntl | grep 3306

主库升级

主服务器备份安装目录

--查正在运行的MySQL使用的配置文件
[root@localhost ~]# cat /etc/my.cnf | grep basedir
basedir=/usr/local/mysql  #安装目录
[root@localhost ~]# cat /etc/my.cnf | grep datadir
datadir=/data1/mysql/data #数据目录


--备份安装目录
[root@localhost ~]# cd /usr/local/
[root@localhost local]# ls -l
total 0
drwxr-xr-x.  2 root root   6 Apr 11  2018 bin
drwxr-xr-x.  2 root root   6 Apr 11  2018 etc
drwxr-xr-x.  2 root root   6 Apr 11  2018 games
drwxrwxr-x. 11 root root 208 Jul 31 23:00 hb
drwxr-xr-x.  2 root root   6 Apr 11  2018 include
drwxr-xr-x.  2 root root   6 Apr 11  2018 lib
drwxr-xr-x.  2 root root   6 Apr 11  2018 lib64
drwxr-xr-x.  2 root root   6 Apr 11  2018 libexec
lrwxrwxrwx.  1 root root  42 Mar 22  2023 mysql -> /data1/mysql-8.0.32-linux-glibc2.12-x86_64
drwxr-xr-x.  2 root root   6 Jul 31 23:00 process_temp
drwxr-xr-x.  2 root root   6 Apr 11  2018 sbin
drwxr-xr-x.  5 root root  49 Dec 15  2022 share
drwxr-xr-x.  2 root root   6 Apr 11  2018 src


[root@localhost data1]# cp -r mysql-8.0.32-linux-glibc2.12-x86_64 mysql-8.0.32-linux-glibc2.12-x86_64_bak_`date +%F`
[root@localhost data1]# ls -l
total 428996
-rwxr--r--. 1 root  root       1530 Sep 18 15:43 bf.sh
drwxr-xr-x. 2 root  root        278 Jan  9 01:00 db
drwxr-xr-x. 2 root  root         27 Jan  9 01:00 log
drwxr-xr-x. 4 mysql mysql        29 Mar 13  2023 mysql
drwxr-xr-x. 9 root  root        129 Mar 22  2023 mysql-8.0.32-linux-glibc2.12-x86_64
drwxr-xr-x. 9 root  root        129 Jan  9 20:11 mysql-8.0.32-linux-glibc2.12-x86_64_bak_2024-01-09
-rw-r--r--. 1 root  root  439284500 Jan  8 17:12 mysql-8.0.35-linux-glibc2.17-x86_64.tar.xz

--删除/usr/local目录下mysql的软链接
lrwxrwxrwx.  1 root root  42 Mar 22  2023 mysql -> /data1/mysql-8.0.32-linux-glibc2.12-x86_64

[root@localhost local]# unlink mysql
[root@localhost local]# ls -l
total 0
drwxr-xr-x.  2 root root   6 Apr 11  2018 bin
drwxr-xr-x.  2 root root   6 Apr 11  2018 etc
drwxr-xr-x.  2 root root   6 Apr 11  2018 games
drwxrwxr-x. 11 root root 208 Jul 31 23:00 hb
drwxr-xr-x.  2 root root   6 Apr 11  2018 include
drwxr-xr-x.  2 root root   6 Apr 11  2018 lib
drwxr-xr-x.  2 root root   6 Apr 11  2018 lib64
drwxr-xr-x.  2 root root   6 Apr 11  2018 libexec
drwxr-xr-x.  2 root root   6 Jul 31 23:00 process_temp
drwxr-xr-x.  2 root root   6 Apr 11  2018 sbin
drwxr-xr-x.  5 root root  49 Dec 15  2022 share
drwxr-xr-x.  2 root root   6 Apr 11  2018 src

不建议rm mysql（规避误操作）

主服务器备份数据目录

--备份数据目录
[root@localhost mysql]# cd /data1/mysql
[root@localhost mysql]# ls -l
total 4
drwxr-xr-x. 10 mysql mysql 4096 Jan  9 20:04 data
drwxr-xr-x.  2 mysql mysql    6 Jan  8 23:54 tmp
[root@localhost mysql]# cp -r data data_bak_`date +%F`
[root@localhost mysql]# ls -l
total 8
drwxr-xr-x. 10 mysql mysql 4096 Jan  9 20:04 data
drwxr-xr-x. 10 root  root  4096 Jan  9 20:14 data_bak_2024-01-09
drwxr-xr-x.  2 mysql mysql    6 Jan  8 23:54 tmp
[root@localhost mysql]# du -sh data
14G     data
[root@localhost mysql]# du -sh data_bak_2024-01-09/
14G     data_bak_2024-01-09/
[root@localhost mysql]# chown -R mysql:mysql data_bak_2024-01-09/
[root@localhost mysql]# ls -l
total 8
drwxr-xr-x. 10 mysql mysql 4096 Jan  9 20:04 data
drwxr-xr-x. 10 mysql mysql 4096 Jan  9 20:14 data_bak_2024-01-09
drwxr-xr-x.  2 mysql mysql    6 Jan  8 23:54 tmp

主服务器备份配置文件

--备份配置文件
[root@localhost mysql]# cp /etc/my.cnf /etc/my.cnf_bak_`date +%F`
[root@localhost mysql]# ls -l /etc/my.cnf
-rw-r--r--. 1 root root 782 Sep 18 11:53 /etc/my.cnf
[root@localhost mysql]# ls -l /etc/my.cnf_bak_2024-01-09
-rw-r--r--. 1 root root 782 Jan  9 20:15 /etc/my.cnf_bak_2024-01-09

安装数据库软件

上传mysql-8.0.35-linux-glibc2.17-x86_64.tar.xz至/data1

--解压
[root@localhost data1]# cd /data1
[root@localhost data1]# tar -xvf mysql-8.0.35-linux-glibc2.17-x86_64.tar.xz -C /data1/

--/usr/local目录下创建mysql的软链接
[root@localhost local]# ln -s /data1/mysql-8.0.35-linux-glibc2.17-x86_64 /usr/local/mysql
[root@localhost local]# ls -l
total 0
drwxr-xr-x.  2 root root   6 Apr 11  2018 bin
drwxr-xr-x.  2 root root   6 Apr 11  2018 etc
drwxr-xr-x.  2 root root   6 Apr 11  2018 games
drwxrwxr-x. 11 root root 208 Jul 31 23:00 hb
drwxr-xr-x.  2 root root   6 Apr 11  2018 include
drwxr-xr-x.  2 root root   6 Apr 11  2018 lib
drwxr-xr-x.  2 root root   6 Apr 11  2018 lib64
drwxr-xr-x.  2 root root   6 Apr 11  2018 libexec
lrwxrwxrwx.  1 root root  42 Jan  9 20:25 mysql -> /data1/mysql-8.0.35-linux-glibc2.17-x86_64
drwxr-xr-x.  2 root root   6 Jul 31 23:00 process_temp
drwxr-xr-x.  2 root root   6 Apr 11  2018 sbin
drwxr-xr-x.  5 root root  49 Dec 15  2022 share
drwxr-xr-x.  2 root root   6 Apr 11  2018 src

启动主库

查看版本
[root@localhost local]# mysql -V
mysql  Ver 8.0.35 for Linux on x86_64 (MySQL Community Server - GPL)

显示是新版本的版本号，升级成功

启动主库

建议重开一会话启动服务

[root@localhost init.d]# systemctl start mysqld
[root@localhost init.d]# systemctl status mysqld
● mysqld.service - LSB: start and stop MySQL
   Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)
   Active: active (running) since Tue 2024-01-09 20:40:36 CST; 2s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 48107 ExecStop=/etc/rc.d/init.d/mysqld stop (code=exited, status=0/SUCCESS)
  Process: 49535 ExecStart=/etc/rc.d/init.d/mysqld start (code=exited, status=0/SUCCESS)
   CGroup: /system.slice/mysqld.service
           ├─49546 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data1/mysql/data --pid-file=/data1/mysql/data/localhost.localdomain.pid
           └─49915 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data1/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin -...

Jan 09 20:40:28 localhost.localdomain systemd[1]: Starting LSB: start and stop MySQL...
Jan 09 20:40:36 localhost.localdomain mysqld[49535]: Starting MySQL........ SUCCESS!
Jan 09 20:40:36 localhost.localdomain systemd[1]: Started LSB: start and stop MySQL.
[root@localhost init.d]# ps -ef | grep mysql
root     49546     1  0 20:40 ?        00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data1/mysql/data --pid-file=/data1/mysql/data/localhost.localdomain.pid
mysql    49915 49546 36 20:40 ?        00:00:08 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data1/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=localhost.localdomain.err --pid-file=/data1/mysql/data/localhost.localdomain.pid --socket=/var/lib/mysql/mysql.sock
root     50341 48949  0 20:40 pts/0    00:00:00 grep --color=auto mysql
问题处理
启库服务运行但是未加载目录和配置文件
--问题描述
升级后启库后查看服务状态不正常
[root@xzdcweb1 data1]# mysql -V
mysql  Ver 8.0.35 for Linux on x86_64 (MySQL Community Server - GPL)
[root@xzdcweb1 ~]# systemctl start mysqld
[root@xzdcweb1 ~]# systemctl status mysqld
● mysqld.service - LSB: start and stop MySQL
   Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)
   Active: active (exited) since Mon 2023-09-18 12:41:33 CST; 3 months 22 days ago
     Docs: man:systemd-sysv-generator(8)

Sep 18 12:41:27 xzdcweb1 systemd[1]: Starting LSB: start and stop MySQL...
Sep 18 12:41:33 xzdcweb1 mysqld[33022]: Starting MySQL......[  OK  ]
Sep 18 12:41:33 xzdcweb1 systemd[1]: Started LSB: start and stop MySQL.
[root@xzdcweb1 ~]# ps -ef | grep mysql
root     64535 64356  0 21:10 pts/1    00:00:00 grep --color=auto mysql

以下是升级前关库前查看的服务和进程：
[root@localhost ~]# ps -ef | grep mysql
root     41766 41065  0 19:52 pts/0    00:00:00 grep --color=auto mysql
root     45742     1  0  2023 ?        00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data1/mysql/data --pid-file=/data1/mysql/data/localhost.localdomain.pid
mysql    46126 45742  0  2023 ?        04:18:50 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data1/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=localhost.localdomain.err --pid-file=/data1/mysql/data/localhost.localdomain.pid --socket=/var/lib/mysql/mysql.sock
[root@localhost ~]# systemctl status mysqld
● mysqld.service - LSB: start and stop MySQL
   Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)
   Active: active (running) since Mon 2023-09-18 11:54:00 CST; 3 months 22 days ago
     Docs: man:systemd-sysv-generator(8)
   CGroup: /system.slice/mysqld.service
           ├─45742 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data1/mysql/data --pid-file=/data1/mysql/data/localhost.localdomain.pid
           └─46126 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data1/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin -...

Sep 18 11:53:57 localhost.localdomain systemd[1]: Starting LSB: start and stop MySQL...
Sep 18 11:54:00 localhost.localdomain mysqld[45731]: Starting MySQL... SUCCESS!
Sep 18 11:54:00 localhost.localdomain systemd[1]: Started LSB: start and stop MySQL.

--问题原因
mysql8.0.13之后启库时会自动进行升级字典，需要一些时间

--解决办法
缓一会儿再启动就正常了

可查看日志，时间关系未进行查看
如果配置文件中无日志文件参数，默认在数据目录下
查看主库信息
mysql> show master status;
+---------------+----------+--------------+------------------+-------------------+
| File          | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+---------------+----------+--------------+------------------+-------------------+
| binlog.000003 |     7562 |              |                  |                   |
+---------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)

备库升级

备服务器备份安装目录

--查正在运行的MySQL使用的配置文件
[root@xzdcweb1 ~]# cat /etc/my.cnf | grep basedir
basedir=/usr/local/mysql   #mysql安装根目录
[root@xzdcweb1 ~]# cat /etc/my.cnf | grep datadir
datadir=/data1/mysql/data  #mysql数据文件所在目录


--备份安装目录
[root@xzdcweb1 ~]# cd /usr/local/
[root@xzdcweb1 local]# ls -l
total 0
drwxr-xr-x   6 root root  58 Jul  5  2021 apr
drwxr-xr-x.  2 root root 177 Dec 29 10:40 bin
drwxr-xr-x.  2 root root 225 Jun  9  2023 etc
drwxr-xr-x.  2 root root   6 Apr 11  2018 games
drwxrwxr-x  11 root root 208 Jul 31 23:00 hb
drwxr-xr-x.  3 root root  21 Dec 29 10:40 include
drwxr-xr-x.  2 root root   6 Apr 11  2018 lib
drwxr-xr-x.  4 root root 159 Dec 29 10:40 lib64
drwxr-xr-x.  2 root root  90 Jun  9  2023 libexec
lrwxrwxrwx   1 root root  42 Mar 22  2023 mysql -> /data1/mysql-8.0.32-linux-glibc2.12-x86_64
drwxr-xr-x  11 root root 151 Jul  3  2021 nginx
drwxr-xr-x   2 root root   6 Jul 31 23:00 process_temp
drwxr-xr-x   6 root root  56 Jul  3  2021 python3
drwxr-xr-x.  2 root root  18 Jun  9  2023 sbin
drwxr-xr-x.  6 root root  60 Dec 29 10:41 share
drwxr-xr-x.  3 root root  47 Jul  5  2021 src
drwxr-xr-x   5 root root 140 Dec 29 10:40 ssl

[root@xzdcweb1 local]# cd /data1
[root@xzdcweb1 data1]# ls -l
total 428992
drwxr-xr-x 2 rsync rsync         6 Sep 18 19:04 fdfsbak
drwxr-xr-x 4 mysql mysql        29 Mar 13  2023 mysql
drwxr-xr-x 9 root  root        129 Mar 22  2023 mysql-8.0.32-linux-glibc2.12-x86_64
-rw-r--r-- 1 root  root  439284500 Jan  8 17:17 mysql-8.0.35-linux-glibc2.17-x86_64.tar.xz
[root@xzdcweb1 data1]# cp -r mysql-8.0.32-linux-glibc2.12-x86_64 mysql-8.0.32-linux-glibc2.12-x86_64_bak_`date +%F`
[root@xzdcweb1 data1]# ls -l
total 428992
drwxr-xr-x 2 rsync rsync         6 Sep 18 19:04 fdfsbak
drwxr-xr-x 4 mysql mysql        29 Mar 13  2023 mysql
drwxr-xr-x 9 root  root        129 Mar 22  2023 mysql-8.0.32-linux-glibc2.12-x86_64
drwxr-xr-x 9 root  root        129 Jan  9 20:57 mysql-8.0.32-linux-glibc2.12-x86_64_bak_2024-01-09
-rw-r--r-- 1 root  root  439284500 Jan  8 17:17 mysql-8.0.35-linux-glibc2.17-x86_64.tar.xz

--删除软链接
[root@xzdcweb1 data1]# cd /usr/local/
[root@xzdcweb1 local]# ls -l
total 0
drwxr-xr-x   6 root root  58 Jul  5  2021 apr
drwxr-xr-x.  2 root root 177 Dec 29 10:40 bin
drwxr-xr-x.  2 root root 225 Jun  9  2023 etc
drwxr-xr-x.  2 root root   6 Apr 11  2018 games
drwxrwxr-x  11 root root 208 Jul 31 23:00 hb
drwxr-xr-x.  3 root root  21 Dec 29 10:40 include
drwxr-xr-x.  2 root root   6 Apr 11  2018 lib
drwxr-xr-x.  4 root root 159 Dec 29 10:40 lib64
drwxr-xr-x.  2 root root  90 Jun  9  2023 libexec
lrwxrwxrwx   1 root root  42 Mar 22  2023 mysql -> /data1/mysql-8.0.32-linux-glibc2.12-x86_64
drwxr-xr-x  11 root root 151 Jul  3  2021 nginx
drwxr-xr-x   2 root root   6 Jul 31 23:00 process_temp
drwxr-xr-x   6 root root  56 Jul  3  2021 python3
drwxr-xr-x.  2 root root  18 Jun  9  2023 sbin
drwxr-xr-x.  6 root root  60 Dec 29 10:41 share
drwxr-xr-x.  3 root root  47 Jul  5  2021 src
drwxr-xr-x   5 root root 140 Dec 29 10:40 ssl
[root@xzdcweb1 local]# unlink mysql
[root@xzdcweb1 local]# ls -l
total 0
drwxr-xr-x   6 root root  58 Jul  5  2021 apr
drwxr-xr-x.  2 root root 177 Dec 29 10:40 bin
drwxr-xr-x.  2 root root 225 Jun  9  2023 etc
drwxr-xr-x.  2 root root   6 Apr 11  2018 games
drwxrwxr-x  11 root root 208 Jul 31 23:00 hb
drwxr-xr-x.  3 root root  21 Dec 29 10:40 include
drwxr-xr-x.  2 root root   6 Apr 11  2018 lib
drwxr-xr-x.  4 root root 159 Dec 29 10:40 lib64
drwxr-xr-x.  2 root root  90 Jun  9  2023 libexec
drwxr-xr-x  11 root root 151 Jul  3  2021 nginx
drwxr-xr-x   2 root root   6 Jul 31 23:00 process_temp
drwxr-xr-x   6 root root  56 Jul  3  2021 python3
drwxr-xr-x.  2 root root  18 Jun  9  2023 sbin
drwxr-xr-x.  6 root root  60 Dec 29 10:41 share
drwxr-xr-x.  3 root root  47 Jul  5  2021 src
drwxr-xr-x   5 root root 140 Dec 29 10:40 ssl

注意：
不建议rm mysql (规避误操作)

备服务器备份数据目录

--备份数据目录
[root@xzdcweb1 local]# cd /data1/mysql
[root@xzdcweb1 mysql]# ls -l
total 4
drwxr-xr-x 10 mysql mysql 4096 Jan  9 20:07 data
drwxr-xr-x  2 mysql mysql    6 Sep 18 12:41 tmp
[root@xzdcweb1 mysql]# du -sh data/
4.0G    data/
[root@xzdcweb1 mysql]# cp -r data data_bak_`date +%F`
[root@xzdcweb1 mysql]# ls -l
total 8
drwxr-xr-x 10 mysql mysql 4096 Jan  9 20:07 data
drwxr-xr-x 10 root  root  4096 Jan  9 21:01 data_bak_2024-01-09
drwxr-xr-x  2 mysql mysql    6 Sep 18 12:41 tmp
[root@xzdcweb1 mysql]# du -sh data
4.0G    data
[root@xzdcweb1 mysql]# du -sh data_bak_2024-01-09/
4.0G    data_bak_2024-01-09/

备服务器备份配置文件

--备份配置文件
[root@xzdcweb1 mysql]# cp /etc/my.cnf /etc/my.cnf_bak_`date +%F`
[root@xzdcweb1 mysql]# ls -l /etc/my.cnf
-rw-r--r-- 1 root root 747 Sep 18 12:16 /etc/my.cnf
[root@xzdcweb1 mysql]# ls -l /etc/my.cnf_bak_2024-01-09
-rw-r--r-- 1 root root 747 Jan  9 21:02 /etc/my.cnf_bak_2024-01-09

安装数据库软件

上传mysql-8.0.35-linux-glibc2.17-x86_64.tar.xz至/data1

--解压
[root@xzdcweb1 mysql]# cd /data1
[root@xzdcweb1 data1]# ls -l
total 428992
drwxr-xr-x 2 rsync rsync         6 Sep 18 19:04 fdfsbak
drwxr-xr-x 5 mysql mysql        56 Jan  9 21:01 mysql
drwxr-xr-x 9 root  root        129 Mar 22  2023 mysql-8.0.32-linux-glibc2.12-x86_64
drwxr-xr-x 9 root  root        129 Jan  9 20:57 mysql-8.0.32-linux-glibc2.12-x86_64_bak_2024-01-09
-rw-r--r-- 1 root  root  439284500 Jan  8 17:17 mysql-8.0.35-linux-glibc2.17-x86_64.tar.xz
[root@xzdcweb1 data1]# tar -xvf mysql-8.0.35-linux-glibc2.17-x86_64.tar.xz -C /data1/

[root@xzdcweb1 data1]# ls -l
total 428992
drwxr-xr-x 2 rsync rsync         6 Sep 18 19:04 fdfsbak
drwxr-xr-x 5 mysql mysql        56 Jan  9 21:01 mysql
drwxr-xr-x 9 root  root        129 Mar 22  2023 mysql-8.0.32-linux-glibc2.12-x86_64
drwxr-xr-x 9 root  root        129 Jan  9 20:57 mysql-8.0.32-linux-glibc2.12-x86_64_bak_2024-01-09
drwxr-xr-x 9 root  root        129 Jan  9 21:05 mysql-8.0.35-linux-glibc2.17-x86_64
-rw-r--r-- 1 root  root  439284500 Jan  8 17:17 mysql-8.0.35-linux-glibc2.17-x86_64.tar.xz

--/usr/local目录下创建mysql目录的软链接
[root@xzdcweb1 data1]# ln -s /data1/mysql-8.0.35-linux-glibc2.17-x86_64 /usr/local/mysql
[root@xzdcweb1 data1]# ls -l /usr/local/
total 0
drwxr-xr-x   6 root root  58 Jul  5  2021 apr
drwxr-xr-x.  2 root root 177 Dec 29 10:40 bin
drwxr-xr-x.  2 root root 225 Jun  9  2023 etc
drwxr-xr-x.  2 root root   6 Apr 11  2018 games
drwxrwxr-x  11 root root 208 Jul 31 23:00 hb
drwxr-xr-x.  3 root root  21 Dec 29 10:40 include
drwxr-xr-x.  2 root root   6 Apr 11  2018 lib
drwxr-xr-x.  4 root root 159 Dec 29 10:40 lib64
drwxr-xr-x.  2 root root  90 Jun  9  2023 libexec
lrwxrwxrwx   1 root root  42 Jan  9 21:08 mysql -> /data1/mysql-8.0.35-linux-glibc2.17-x86_64
drwxr-xr-x  11 root root 151 Jul  3  2021 nginx
drwxr-xr-x   2 root root   6 Jul 31 23:00 process_temp
drwxr-xr-x   6 root root  56 Jul  3  2021 python3
drwxr-xr-x.  2 root root  18 Jun  9  2023 sbin
drwxr-xr-x.  6 root root  60 Dec 29 10:41 share
drwxr-xr-x.  3 root root  47 Jul  5  2021 src
drwxr-xr-x   5 root root 140 Dec 29 10:40 ssl

启动备库

查看版本
[root@xzdcweb1 data1]# mysql -V
mysql  Ver 8.0.35 for Linux on x86_64 (MySQL Community Server - GPL)

显示是新版本的版本号，升级成功

启动备库
[root@xzdcweb1 ~]# systemctl start mysqld
[root@xzdcweb1 ~]# systemctl status mysqld
● mysqld.service - LSB: start and stop MySQL
   Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)
   Active: active (running) since Tue 2024-01-09 21:15:36 CST; 6s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 64762 ExecStop=/etc/rc.d/init.d/mysqld stop (code=exited, status=0/SUCCESS)
  Process: 65533 ExecStart=/etc/rc.d/init.d/mysqld start (code=exited, status=0/SUCCESS)
    Tasks: 46
   CGroup: /system.slice/mysqld.service
           ├─345 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data1/mysql/data --pid-file=/data1/mysql/data/xzdcweb1.pid
           └─719 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data1/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --u...

Jan 09 21:15:25 xzdcweb1 systemd[1]: Starting LSB: start and stop MySQL...
Jan 09 21:15:36 xzdcweb1 mysqld[65533]: Starting MySQL...........[  OK  ]
Jan 09 21:15:36 xzdcweb1 systemd[1]: Started LSB: start and stop MySQL.
[root@xzdcweb1 ~]# ps -ef | grep mysql
root       345     1  0 21:15 ?        00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data1/mysql/data --pid-file=/data1/mysql/data/xzdcweb1.pid
mysql      719   345 55 21:15 ?        00:00:14 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data1/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=xzdcweb1.err --pid-file=/data1/mysql/data/xzdcweb1.pid --socket=/var/lib/mysql/mysql.sock
root      1147 64356  0 21:15 pts/1    00:00:00 grep --color=auto mysql
问题处理
启库服务运行但是未加载目录和配置文件
--问题描述
升级后启库后查看服务状态不正常
[root@xzdcweb1 data1]# mysql -V
mysql  Ver 8.0.35 for Linux on x86_64 (MySQL Community Server - GPL)
[root@xzdcweb1 ~]# systemctl start mysqld
[root@xzdcweb1 ~]# systemctl status mysqld
● mysqld.service - LSB: start and stop MySQL
   Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)
   Active: active (exited) since Mon 2023-09-18 12:41:33 CST; 3 months 22 days ago
     Docs: man:systemd-sysv-generator(8)

Sep 18 12:41:27 xzdcweb1 systemd[1]: Starting LSB: start and stop MySQL...
Sep 18 12:41:33 xzdcweb1 mysqld[33022]: Starting MySQL......[  OK  ]
Sep 18 12:41:33 xzdcweb1 systemd[1]: Started LSB: start and stop MySQL.
[root@xzdcweb1 ~]# ps -ef | grep mysql
root     64535 64356  0 21:10 pts/1    00:00:00 grep --color=auto mysql

以下是升级前关库前查看的服务和进程：
[root@localhost ~]# ps -ef | grep mysql
root     41766 41065  0 19:52 pts/0    00:00:00 grep --color=auto mysql
root     45742     1  0  2023 ?        00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data1/mysql/data --pid-file=/data1/mysql/data/localhost.localdomain.pid
mysql    46126 45742  0  2023 ?        04:18:50 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data1/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=localhost.localdomain.err --pid-file=/data1/mysql/data/localhost.localdomain.pid --socket=/var/lib/mysql/mysql.sock
[root@localhost ~]# systemctl status mysqld
● mysqld.service - LSB: start and stop MySQL
   Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)
   Active: active (running) since Mon 2023-09-18 11:54:00 CST; 3 months 22 days ago
     Docs: man:systemd-sysv-generator(8)
   CGroup: /system.slice/mysqld.service
           ├─45742 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data1/mysql/data --pid-file=/data1/mysql/data/localhost.localdomain.pid
           └─46126 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data1/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin -...

Sep 18 11:53:57 localhost.localdomain systemd[1]: Starting LSB: start and stop MySQL...
Sep 18 11:54:00 localhost.localdomain mysqld[45731]: Starting MySQL... SUCCESS!
Sep 18 11:54:00 localhost.localdomain systemd[1]: Started LSB: start and stop MySQL.

--问题原因
mysql8.0.13之后启库时会自动进行升级字典，需要一些时间

--解决办法
缓一会儿再启动就正常了

可查看日志，时间关系未进行查看
如果配置文件中无日志文件参数，默认在数据目录下
查看备库同步信息
root@localhost :mysql 19:24:53>show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for source to send event
                  Master_Host: 192.168.40.160
                  Master_User: replication
                  Master_Port: 2213
                Connect_Retry: 60
              Master_Log_File: mybinlog.000003
          Read_Master_Log_Pos: 157
               Relay_Log_File: mysql-relay-bin.000005
                Relay_Log_Pos: 371
        Relay_Master_Log_File: mybinlog.000003
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB: 
          Replicate_Ignore_DB: 
           Replicate_Do_Table: 
       Replicate_Ignore_Table: 
      Replicate_Wild_Do_Table: 
  Replicate_Wild_Ignore_Table: 
                   Last_Errno: 0
                   Last_Error: 
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 157
              Relay_Log_Space: 749
              Until_Condition: None
               Until_Log_File: 
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File: 
           Master_SSL_CA_Path: 
              Master_SSL_Cert: 
            Master_SSL_Cipher: 
               Master_SSL_Key: 
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error: 
               Last_SQL_Errno: 0
               Last_SQL_Error: 
  Replicate_Ignore_Server_Ids: 
             Master_Server_Id: 160
                  Master_UUID: d9eafe5f-aeaf-11ee-a9c8-000c29528229
             Master_Info_File: mysql.slave_master_info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Replica has read all relay log; waiting for more updates
           Master_Retry_Count: 86400
                  Master_Bind: 
      Last_IO_Error_Timestamp: 
     Last_SQL_Error_Timestamp: 
               Master_SSL_Crl: 
           Master_SSL_Crlpath: 
           Retrieved_Gtid_Set: 
            Executed_Gtid_Set: 
                Auto_Position: 0
         Replicate_Rewrite_DB: 
                 Channel_Name: 
           Master_TLS_Version: 
       Master_public_key_path: 
        Get_master_public_key: 1
            Network_Namespace: 
1 row in set, 1 warning (0.00 sec)

mysql从库默认启动时slave也会自动启动复制。

1.如下的两参数代表主从同步能够正常的运行网络

若是是Slave_IO_Running的参数不是YES则说明从库读取不到主库的bin-log日志

若是是Slave_SQL_Running参数不是YES，则说明从库在读取中继日志发生问题。

Slave_IO_Running: Yes

Slave_SQL_Running: Yes同步

2.查看Seconds_Behind_Master参数，若是为0的话，则表示主从复制良好

福娃筱欢
关注
  • 24
    点赞
  • 踩
  • 18
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
Mysql主从同步Last_IO_Errno:1236错误解决方法
01-21
Mysql主从同步的Last_IO_Errno:1236错误是什么原因呢，我们要如何来解决这个问题呢?下面和小编一起来看看关于此问题的记录与解决办法。 [removed]ec(2);[removed] 从服务器错误代码： Last_IO_Errno: 1236 Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Slave can not handle replication events with the checksum that master is configur
mysql主从同步出现Slave_IO_Running:NO的解决办法
热门推荐
三人行，必有我师焉。
07-04 2万+
Master Slave 主从同步错误 Slave_IO_Running:NO Slave_SQL_Running:Yes #在Slave库上查看状态 mysql> show slave status\G Slave_IO_Running: No Slave_SQL_Running: Yes #重启master库：service mysqld restart mysql> sho...
解决主从复制Slave_IO_Running=no
CY_2019
08-05 1539
解决主从复制Slave_IO_Running=no
mysql主从复制 Slave_IO_Running为No 问题解决 基于centos7
qq_52955784的博客
08-08 1644
mysql主从复制 Slave_IO_Running为No 问题解决 基于centos7
mysql配置主从复制Slave_IO_Running失败的原因
03-13 3335
最近项目中要配置mysql的主从复制，结构总是失败，Slave_IO_Running显示为NO，后来仔细查看以及从网上查资料，总结应该是两方面的原因。 一、master-log-pos参数错误 原因是配完主服务器后，有数据写入的原因导致主服务器的position参数发生变化，和从服务器对应不上，解决方案是先锁表 flush tables with read lock; ，防止数据写入，
MySQL主从架构由5.5版本升级到5.6方案
weixin_33978016的博客
08-29 189
主从架构[一主多从]升级步骤1. 首先安装最新版本的MySQL  mysql-5.6.26.tar.gz     ：每台主机分别安装目录：/usr/local/mysql-5.6yum install libaio-devel    编译参数/usr/local/cmake/bin/cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.6 \-DMYSQL...
升级mysql 主从_mysql 主从同步如何 把从数据的版本升级到指定的版本
weixin_39792475的博客
01-19 199
下载如下两个安装包MySQL-client-community-5.1.63-1.rhel5.i386.rpmMySQL-server-community-5.1.63-1.rhel5.i386.rpm2 查看系统有无安装mysql:rpm -qa mysql3 停止mysql服务：service mysqld stop4 .yum remove mysql删之前先备份：1).cd /var/...
Mysql主从复制Slave_IO_Running: No解决
01-20
问题描述： 查看 master: mysql> show master status; +------------------+----------+--------------+--------------------------+-------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | ...
C语言主从机开发_C-C++_嵌入式_主从机开发_
10-01
使用C语言开发的用于嵌入式的主从机程序，已经过验证，可以直接使用。
iic.zip_IIC 主从_MSP430 硬件IIC
09-19
iic驱动，实现MSP430的IIC的应用，包括主从程序，控制MSP430的UCA0的IIC硬件模块。
I2C.rar_I2C 主从_zsp
09-21
ZSP 500 I2C 控制器驱动，I2C 控制器的主从模式下的基本读写操作，包括测试程序。
演示在一台Windows主机上运行两个Mysql服务器（端口号3306 和 3307），安装步骤详解
Java 领域技术分享
04-24 1065
演示在一台Windows主机上运行两个Mysql服务器，安装步骤详解
深入浅出MySQL-04-【常用函数】
weixin_37799575的博客
04-24 534
【代码】深入浅出MySQL-04-【常用函数】
【MySQL 数据宝典】【磁盘结构】- 006 bin log 二进制日志的基本模式和参数设置
黄金时代的架构之路
04-23 1067
binlog是一个二进制格式的文件，用于记录语句信息，例如更改数据库表和更改内容的SQL语句都会记录到binlog里，但是不会记录SELECT和SHOW这类操作。
黑马点评项目遇到的部分问题
Suburbia的博客
04-21 1072
此时，当这个有注解的方法被调用的时候，实际上是由代理类来调用的，代理类在调用之前就会启动transaction。然而，如果这个有注解的方法是被同一个类中的其他方法调用的，那么该方法的调用并没有通过代理类，而是直接通过原来的那个bean，所以就不会启动transaction，我们看到的现象就是@Transactional注解无效。在同一个类中，一个方法调用另外一个有注解（比如@Async，@Transational）的方法，注解是不会生效的，所以我们需要创建一个代理对象，使用代理对象来调用方法。
MySQL---创建数据库与表
最新发布
2302_81055059的博客
04-27 166
【代码】MySQL---创建数据库与表。
使用 ADB 命令在 Android 设备上进行截屏
效率工具，软件测试，实用干货，资源分享，这里全是黑科技。
04-21 327
在 Android 开发和调试过程中，截取设备屏幕是一项非常有用的功能。ADB（Android Debug Bridge）是一个强大的工具，可以帮助我们与 Android 设备进行通信和调试。本文将介绍如何使用 ADB 命令在 Android 设备上进行截屏。
Public Key Retrieval is not allowed
wuyujin1997的博客
04-23 592
去登录，还是在编程语言中用 JDBC url 连接，还是用像 DBeaver 这样的 GUI 工具去连接，都需要指定那个参数。驱动属性 --> allowPublicKeyRetrieval=true --> 测试连接 --> (已连接)确定。本方案pass，因为我现在就是 root 登录不了。所讲：mysql server 从。插件做密码加密工作。不管你是在命令行通过。
AndroidStudio中虚拟机(AVD)无法启动,出现unable to locate adb错误
qq_58156721的博客
04-24 325
手机连上电脑 ——> 打开开发者模式，开启usb调试——>驱动管理类软件(360驱动大师/驱动人生/驱动精灵)检测可安装的驱动——>根据手机安装对应驱动，问题解决。首先通过File-Project Structure-Project SDK检查SDK有没有被选中。1.检查Android SDK Platform-Tools是否安装(个人是通过这个方法解决的)步骤：打开file -> settings ，搜索SDK。之后点击"-",在点击Apply进行安装。3.端口被占用(概率极小)2.可能是驱动的问题。
主从复制 Slave_IO_Running: Connecting怎么办
10-15
3. 检查主库的配置文件 my.cnf 中是否开启了二进制日志功能，并且二进制日志的格式是否正确。 4. 检查从库的配置文件 my.cnf 中是否正确配置了主库的 IP 地址、端口号、用户名和密码等信息。 5. 检查从库的防火墙...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

福娃筱欢

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值