当前位置：网站首页>Upgrade MySQL 5.1 to 5.610
Upgrade MySQL 5.1 to 5.610
2022-04-23 15:54:00 【franket】
restart 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 ~]# Check the log
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 8bb53b6schema The structure of error reporting has disappeared , Start up normal
Synchronize database
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://yzsam.com/2022/04/202204231406039190.html
边栏推荐
- Go语言数组，指针，结构体
- PHP function
- PS为图片添加纹理
- Calculate the number of occurrences of a character
- Read the meaning of serial port and various level signals
- Redis master-slave replication process
- 一刷313-剑指 Offer 06. 从尾到头打印链表（e）
- utils. Deprecated in35 may be cancelled due to upgrade. What should I do
- Application of Bloom filter in 100 million flow e-commerce system
- R语言中绘制ROC曲线方法二：pROC包
猜你喜欢
Implement default page
MySQL集群模式与应用场景
Large factory technology implementation | industry solution series tutorials
时序模型：门控循环单元网络（GRU）
MetaLife与ESTV建立战略合作伙伴关系并任命其首席执行官Eric Yoon为顾问
大厂技术实现 | 行业解决方案系列教程
多级缓存使用
Import address table analysis (calculated according to the library file name: number of imported functions, function serial number and function name)
Single architecture system re architecture
一文读懂串口及各种电平信号含义
随机推荐
幂等性的处理
Tencent offer has been taken. Don't miss the 99 algorithm high-frequency interview questions. 80% of them are lost in the algorithm
Upgrade MySQL 5.1 to 5.69
【自娱自乐】构造笔记 week 2
Extract non duplicate integers
WPS品牌再升级专注国内，另两款国产软件低调出国门，却遭禁令
一文掌握vscode远程gdb调试
大厂技术实现 | 行业解决方案系列教程
[split of recursive number] n points K, split of limited range
Fastjon2他来了，性能显著提升，还能再战十年
时序模型：长短期记忆网络（LSTM）
How do you think the fund is REITs? Is it safe to buy the fund through the bank
VIM specifies the line comment and reconciliation comment
Go language, condition, loop, function
Upgrade MySQL 5.1 to 5.611
s16. One click installation of containerd script based on image warehouse
js正則判斷域名或者IP的端口路徑是否正確
Use bitnami PostgreSQL docker image to quickly set up stream replication clusters
Configuration of multi spanning tree MSTP
R语言中实现作图对象排列的函数总结