当前位置:网站首页>Upgrade MySQL 5.1 to 5.67
Upgrade MySQL 5.1 to 5.67
2022-04-23 15:38:00 【franket】
Upgrade the new version mysql
In fact, replacing with a new version of the software
Because there are dependencies, use --nodeps
To ignore dependencies
[root@upgrade-slave src]# rpm -e Percona-Server-client-51-5.1.73-rel14.12.624.rhel6.x86_64 Percona-Server-server-51-5.1.73-rel14.12.624.rhel6.x86_64 Percona-Server-shared-51-5.1.73-rel14.12.624.rhel6.x86_64
error: Failed dependencies:
libmysqlclient.so.16()(64bit) is needed by (installed) postfix-2:2.6.6-6.el6_5.x86_64
libmysqlclient.so.16()(64bit) is needed by (installed) perl-DBD-MySQL-4.013-3.el6.x86_64
libmysqlclient.so.16()(64bit) is needed by (installed) php-mysql-5.3.3-46.el6_6.x86_64
libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by (installed) postfix-2:2.6.6-6.el6_5.x86_64
libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by (installed) perl-DBD-MySQL-4.013-3.el6.x86_64
libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by (installed) php-mysql-5.3.3-46.el6_6.x86_64
libmysqlclient_r.so.16()(64bit) is needed by (installed) sysbench-0.5-6.el6.x86_64
libmysqlclient_r.so.16(libmysqlclient_16)(64bit) is needed by (installed) sysbench-0.5-6.el6.x86_64
mysql-libs is needed by (installed) postfix-2:2.6.6-6.el6_5.x86_64
[root@upgrade-slave src]# rpm -e Percona-Server-client-51-5.1.73-rel14.12.624.rhel6.x86_64 Percona-Server-server-51-5.1.73-rel14.12.624.rhel6.x86_64 Percona-Server-shared-51-5.1.73-rel14.12.624.rhel6.x86_64 --nodeps
[root@upgrade-slave src]# ll | grep 56
-rw-r--r--. 1 root root 6726712 Nov 3 19:31 Percona-Server-client-56-5.6.27-rel75.0.el6.x86_64.rpm
-rw-r--r--. 1 root root 6566688 Jul 31 2014 Percona-Server-devel-51-5.1.73-rel14.12.624.rhel6.x86_64.rpm
-rw-r--r--. 1 root root 1032200 Nov 3 19:31 Percona-Server-devel-56-5.6.27-rel75.0.el6.x86_64.rpm
-rw-r--r--. 1 root root 20480132 Nov 3 19:31 Percona-Server-server-56-5.6.27-rel75.0.el6.x86_64.rpm
-rw-r--r--. 1 root root 742712 Nov 3 19:31 Percona-Server-shared-56-5.6.27-rel75.0.el6.x86_64.rpm
[root@upgrade-slave src]# rpm -ivh Percona-Server-client-56-5.6.27-rel75.0.el6.x86_64.rpm Percona-Server-server-56-5.6.27-rel75.0.el6.x86_64.rpm Percona-Server-shared-56-5.6.27-rel75.0.el6.x86_64.rpm
Preparing... ########################################### [100%]
1:Percona-Server-shared-5########################################### [ 33%]
2:Percona-Server-client-5########################################### [ 67%]
3:Percona-Server-server-5########################################### [100%]
Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
See http://www.percona.com/doc/percona-server/5.6/management/udf_percona_toolkit.html for more details
[root@upgrade-slave src]# echo $?
0
[root@upgrade-slave src]#
Try to start the database
[root@upgrade-slave mysql]# /etc/init.d/mysql start
Starting MySQL (Percona Server)............The server quit [FAILED]updating PID file (/var/lib/mysql/upgrade-slave.pid).
[root@upgrade-slave mysql]#
/var/lib/mysql/upgrade-slave.err Log error
151126 21:27:16 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-11-26 21:27:16 0 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2015-11-26 21:27:16 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:27:16 0 [Note] /usr/sbin/mysqld (mysqld 5.6.27-75.0-log) starting as process 12493 ...
2015-11-26 21:27:16 12493 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2015-11-26 21:27:16 12493 [Warning] option 'innodb-autoextend-increment': unsigned value 33554432 adjusted to 1000
2015-11-26 21:27:16 12493 [Note] Plugin 'FEDERATED' is disabled.
2015-11-26 21:27:16 7f6ec219f7e0 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:27:16 12493 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-11-26 21:27:16 12493 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-26 21:27:16 12493 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-11-26 21:27:16 12493 [Note] InnoDB: Memory barrier is not used
2015-11-26 21:27:16 12493 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-26 21:27:16 12493 [Note] InnoDB: Using Linux native AIO
2015-11-26 21:27:16 12493 [Note] InnoDB: Using CPU crc32 instructions
2015-11-26 21:27:16 12493 [Note] InnoDB: Initializing buffer pool, size = 20.0G
2015-11-26 21:27:21 12493 [Note] InnoDB: Completed initialization of buffer pool
2015-11-26 21:27:22 12493 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-26 21:27:24 12493 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-26 21:27:24 12493 [Note] InnoDB: Creating tablespace and datafile system tables.
2015-11-26 21:27:24 12493 [Note] InnoDB: Tablespace and datafile system tables created.
2015-11-26 21:27:24 12493 [Note] InnoDB: Waiting for purge to start
2015-11-26 21:27:24 12493 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.27-75.0 started; log sequence number 4538181520918
2015-11-26 21:27:24 12493 [ERROR] /usr/sbin/mysqld: unknown variable 'table_cache=2048'
2015-11-26 21:27:24 12493 [ERROR] Aborting
2015-11-26 21:27:24 12493 [Note] Binlog end
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'partition'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'ARCHIVE'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'BLACKHOLE'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_METRICS'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_CMP'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'INNODB_TRX'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'XTRADB_RSEG'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
2015-11-26 21:27:24 12493 [Note] Shutting down plugin 'InnoDB'
2015-11-26 21:27:24 12493 [Note] InnoDB: FTS optimize thread exiting.
2015-11-26 21:27:24 12493 [Note] InnoDB: Starting shutdown...
2015-11-26 21:27:27 12493 [Note] InnoDB: Shutdown completed; log sequence number 4538183224168
2015-11-26 21:27:27 12493 [Note] Shutting down plugin 'CSV'
2015-11-26 21:27:27 12493 [Note] Shutting down plugin 'MyISAM'
2015-11-26 21:27:27 12493 [Note] Shutting down plugin 'MRG_MYISAM'
2015-11-26 21:27:27 12493 [Note] Shutting down plugin 'MEMORY'
2015-11-26 21:27:27 12493 [Note] Shutting down plugin 'sha256_password'
2015-11-26 21:27:27 12493 [Note] Shutting down plugin 'mysql_old_password'
2015-11-26 21:27:27 12493 [Note] Shutting down plugin 'mysql_native_password'
2015-11-26 21:27:27 12493 [Note] Shutting down plugin 'binlog'
2015-11-26 21:27:27 12493 [Note] /usr/sbin/mysqld: Shutdown complete
151126 21:27:27 mysqld_safe mysqld from pid file /var/lib/mysql/upgrade-slave.pid ended
The reason is that some parameters are no longer supported in the new version , Or will it be abandoned , Or it has been changed to a new name , The solution is to consult the documentation , Modify the configuration file
版权声明
本文为[franket]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/04/202204231406039313.html
边栏推荐
- 自主作业智慧农场创新论坛
- Use of common pod controller of kubernetes
- 字节面试 transformer相关问题 整理复盘
- Detailed explanation of kubernetes (XI) -- label and label selector
- Summary of interfaces for JDBC and servlet to write CRUD
- CVPR 2022 优质论文分享
- MySQL InnoDB transaction
- Pytorch中named_parameters、named_children、named_modules函数
- Grep was unable to redirect to the file
- APISIX jwt-auth 插件存在错误响应中泄露信息的风险公告(CVE-2022-29266)
猜你喜欢
电脑怎么重装系统后显示器没有信号了
Multitimer V2 reconstruction version | an infinitely scalable software timer
携号转网最大赢家是中国电信,为何人们嫌弃中国移动和中国联通?
重定向和请求转发详解
Kubernetes详解(九)——资源配置清单创建Pod实战
CVPR 2022 优质论文分享
The wechat applet optimizes the native request through the promise of ES6
推荐搜索 常用评价指标
Functions (Part I)
Recommended search common evaluation indicators
随机推荐
控制结构(二)
一刷312-简单重复set-剑指 Offer 03. 数组中重复的数字(e)
Go语言数组,指针,结构体
提取不重复的整数
The wechat applet optimizes the native request through the promise of ES6
Node. JS ODBC connection PostgreSQL
Common types of automated testing framework ▏ automated testing is handed over to software evaluation institutions
php函数
Explanation 2 of redis database (redis high availability, persistence and performance management)
字符串排序
Kubernetes详解(十一)——标签与标签选择器
Introduction to dynamic programming of leetcode learning plan day3 (198213740)
Leetcode学习计划之动态规划入门day3(198,213,740)
Cookie&Session
What exactly does the distributed core principle analysis that fascinates Alibaba P8? I was surprised after reading it
[backtrader source code analysis 18] Yahoo Py code comments and analysis (boring, interested in the code, you can refer to)
Mysql database explanation (IX)
regular expression
c语言---指针进阶
Sword finger offer (1) -- for Huawei