当前位置:网站首页>mysql 5.1升级到5.610
mysql 5.1升级到5.610
2022-04-23 14:06:00 【franket】
重启mysql
[root@upgrade-slave ~]# /etc/init.d/mysql stop
Shutting down MySQL (Percona Server)... [ OK ]
[root@upgrade-slave ~]# /etc/init.d/mysql start
Starting MySQL (Percona Server)........... [ OK ]
[root@upgrade-slave ~]#
检查日志
151126 21:49:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-11-26 21:49:21 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-26 21:49:21 0 [Note] /usr/sbin/mysqld (mysqld 5.6.27-75.0-log) starting as process 20186 ...
2015-11-26 21:49:21 20186 [Warning] option 'innodb-autoextend-increment': unsigned value 33554432 adjusted to 1000
2015-11-26 21:49:21 20186 [Note] Plugin 'FEDERATED' is disabled.
2015-11-26 21:49:21 7f8f2869e7e0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-11-26 21:49:21 20186 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-11-26 21:49:21 20186 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-26 21:49:21 20186 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-11-26 21:49:21 20186 [Note] InnoDB: Memory barrier is not used
2015-11-26 21:49:21 20186 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-26 21:49:21 20186 [Note] InnoDB: Using Linux native AIO
2015-11-26 21:49:21 20186 [Note] InnoDB: Using CPU crc32 instructions
2015-11-26 21:49:21 20186 [Note] InnoDB: Initializing buffer pool, size = 20.0G
2015-11-26 21:49:25 20186 [Note] InnoDB: Completed initialization of buffer pool
2015-11-26 21:49:29 20186 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-26 21:49:30 20186 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-26 21:49:30 20186 [Note] InnoDB: Waiting for purge to start
2015-11-26 21:49:30 20186 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.27-75.0 started; log sequence number 4538185053276
2015-11-26 21:49:30 20186 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2015-11-26 21:49:30 20186 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2015-11-26 21:49:30 20186 [Note] Server hostname (bind-address): '*'; port: 3306
2015-11-26 21:49:30 20186 [Note] IPv6 is available.
2015-11-26 21:49:30 20186 [Note] - '::' resolves to '::';
2015-11-26 21:49:30 20186 [Note] Server socket created on IP: '::'.
2015-11-26 21:49:30 20186 [Note] Event Scheduler: Loaded 0 events
2015-11-26 21:49:30 20186 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.27-75.0-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona Server (GPL), Release 75.0, Revision 8bb53b6
schema的结构报错已经消失了,启动正常
同步数据库
mysql> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000004 | 120 | | | |
+------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)
mysql> show slave status\G
Empty set (0.00 sec)
mysql>
mysql> CHANGE MASTER TO MASTER_HOST='192.168.100.123', MASTER_PORT=3306, MASTER_LOG_FILE='mysql-bin.000899',MASTER_LOG_POS=451678342,MASTER_USER='repl',MASTER_PASSWORD='xxxxxx';
Query OK, 0 rows affected, 2 warnings (0.33 sec)
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: 192.168.100.123
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000899
Read_Master_Log_Pos: 451678342
Relay_Log_File: relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: mysql-bin.000899
Slave_IO_Running: No
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB: mysql,feeddb,mytempdb
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: 451678342
Relay_Log_Space: 120
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: NULL
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: 0
Master_UUID:
Master_Info_File: /var/lib/mysql/master.info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State:
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
1 row in set (0.00 sec)
mysql> start slave;
Query OK, 0 rows affected (0.03 sec)
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Queueing master event to the relay log
Master_Host: 192.168.100.123
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000899
Read_Master_Log_Pos: 465602930
Relay_Log_File: relay-bin.000002
Relay_Log_Pos: 585
Relay_Master_Log_File: mysql-bin.000899
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB: mysql,feeddb,mytempdb
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: 451678658
Relay_Log_Space: 13925024
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: 82821
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: 3
Master_UUID:
Master_Info_File: /var/lib/mysql/master.info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Opening tables
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
1 row in set (0.00 sec)
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.100.123
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000900
Read_Master_Log_Pos: 745342806
Relay_Log_File: relay-bin.000002
Relay_Log_Pos: 51863048
Relay_Master_Log_File: mysql-bin.000899
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB: mysql,feeddb,mytempdb
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: 503541121
Relay_Log_Space: 1368280295
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: 77965
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: 3
Master_UUID:
Master_Info_File: /var/lib/mysql/master.info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: System lock
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
1 row in set (0.00 sec)
mysql>
版权声明
本文为[franket]所创,转载请带上原文链接,感谢
https://cloud.tencent.com/developer/article/1986105
边栏推荐
猜你喜欢
基于CM管理的CDH6.3.2集群集成Atlas2.1.0
Windos中安装labellmg教程
Subscription number development of wechat applet (message push)
帆软实现一个单选按钮,可以统一设置其他单选按钮的选择状态
logback-logger和root
Intégration de Clusters CDH Phoenix basée sur la gestion cm
微信小程序调用客服接口
sql中出现一个变态问题
PyMySQL
POI operation word template replaces data and exports word
随机推荐
不同时间类型的执行计划计算
关于密匙传递的安全性和数字签名
PyMySQL
postman批量生产body信息(实现批量修改数据)
基于CM管理的CDH集群集成Phoenix
帆软中使用if else 进行判断-使用标题条件进行判断
Use of WiFi module based on wechat applet
Promtail + Loki + Grafana 日志监控系统搭建
PySide2
什么是云迁移?云迁移的四种模式分别是?
帆软之单元格部分字体变颜色
云容灾是什么意思?云容灾和传统容灾的区别?
Understand the concepts of virtual base class, virtual function and pure virtual function (turn)
回顾2021:如何帮助客户扫清上云最后一公里的障碍?
微信小程序setInterval定时函数使用详细教程
switch使用(微信小程序)
RobotFramework 之 文件上传和下载
更改plsql工具栏的图标大小
JDBC入门
Request module