blog.zhuohua.store - Powered by Discuz! Board

标题: CentOS8_lnmp1.7_升级MySQL/MariaDB [打印本页]

作者: admin 时间: 2021-7-20 23:18 标题: CentOS8_lnmp1.7_升级MySQL/MariaDB

笺注：这是在 CentOS8_lnmp1.7_LAMP 的基础上进行的。默认自带的MariaDB软件包：（安装以下版本的MariaDB就无需连接公网了）图片1.png

MySQL升级到MariaDB：图片2.png

要输入当前数据库用户root@localhost的密码：图片4.png

输入MariaDB的版本号： You can get version number from https://downloads.mariadb.org/ 图片5.png

备注：如果连接公网安装成功，自动下载下来的软件包也会放在 /root/lnmp1.7-full/src 启用InnoDB Storage Engine，输入 y 再按回车键：图片6.png

开始或取消：

下面是全自动安装的^_^ ^_^ MySQL升级到MariaDB成功：图片8.png

笺注：数据库升级到MariaDB10.1.45后，Discuz!7.2运行正常。 MariaDB10.1.45的主配置文件： [root@centos8 ~]# cat /etc/my.cnf |grep -v "^$" [client] #password = your_password port = 3306 socket = /tmp/mysql.sock [mysqld] port = 3306 socket = /tmp/mysql.sock user = mariadb basedir = /usr/local/mariadb datadir = /usr/local/mariadb/var log_error = /usr/local/mariadb/var/mariadb.err pid-file = /usr/local/mariadb/var/mariadb.pid skip-external-locking key_buffer_size = 32M max_allowed_packet = 1M table_open_cache = 128 sort_buffer_size = 768K net_buffer_length = 8K read_buffer_size = 768K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M thread_cache_size = 16 query_cache_size = 16M tmp_table_size = 32M #skip-networking max_connections = 500 max_connect_errors = 100 open_files_limit = 65535 log-bin=mysql-bin binlog_format=mixed server-id = 1 expire_logs_days = 10 default_storage_engine = InnoDB innodb_file_per_table = 1 innodb_data_home_dir = /usr/local/mariadb/var innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mariadb/var innodb_buffer_pool_size = 128M innodb_log_file_size = 32M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 32M sort_buffer_size = 768K read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout ########### 升级MariaDB的版本：图片9.png

要输入当前数据库用户root@localhost的密码：图片11.png

输入MariaDB的新版本号：图片12.png

启用InnoDB Storage Engine，输入 y 再按回车键：图片13.png

开始或取消：

下面是全自动安装的^_^ ^_^ 升级MariaDB成功：图片15.png

笺注：数据库升级到MariaDB10.2.32后，Discuz!7.2运行正常。 MariaDB10.2.32的主配置文件： [root@centos8 ~]# cat /etc/my.cnf |grep -v "^$" [client] #password = your_password port = 3306 socket = /tmp/mysql.sock [mysqld] port = 3306 socket = /tmp/mysql.sock user = mariadb basedir = /usr/local/mariadb datadir = /usr/local/mariadb/var log_error = /usr/local/mariadb/var/mariadb.err pid-file = /usr/local/mariadb/var/mariadb.pid skip-external-locking key_buffer_size = 32M max_allowed_packet = 1M table_open_cache = 128 sort_buffer_size = 768K net_buffer_length = 8K read_buffer_size = 768K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M thread_cache_size = 16 query_cache_size = 16M tmp_table_size = 32M #skip-networking max_connections = 500 max_connect_errors = 100 open_files_limit = 65535 log-bin=mysql-bin binlog_format=mixed server-id = 1 expire_logs_days = 10 default_storage_engine = InnoDB innodb_file_per_table = 1 innodb_data_home_dir = /usr/local/mariadb/var innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mariadb/var innodb_buffer_pool_size = 128M innodb_log_file_size = 32M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 32M sort_buffer_size = 768K read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout 相关文章： CentOS8_lnmp1.7_单独安装数据库（MariaDB）

图片附件: 图片1.png (2021-7-20 23:09, 137.14 KB) / 下载次数 91
http://blog.zhuohua.store/attachment.php?aid=18582&k=59c1d4ca2296656e147d95bbd13fb3ff&t=1714338220&sid=qVNoKV

图片附件: 图片2.png (2021-7-20 23:09, 97.68 KB) / 下载次数 99
http://blog.zhuohua.store/attachment.php?aid=18583&k=eae31ebb4e400f5a43684fb5b2ed2b34&t=1714338220&sid=qVNoKV

图片附件: 图片3.png (2021-7-20 23:10, 85.37 KB) / 下载次数 90
http://blog.zhuohua.store/attachment.php?aid=18584&k=ecb71ee80a509c21765e232d6dfb9bae&t=1714338220&sid=qVNoKV

图片附件: 图片4.png (2021-7-20 23:10, 45.42 KB) / 下载次数 89
http://blog.zhuohua.store/attachment.php?aid=18585&k=d9a991b5c3155316033116195a591dc2&t=1714338220&sid=qVNoKV

图片附件: 图片5.png (2021-7-20 23:10, 73.91 KB) / 下载次数 99
http://blog.zhuohua.store/attachment.php?aid=18586&k=0973295302579600b8b2e163d15b29dc&t=1714338220&sid=qVNoKV

图片附件: 图片6.png (2021-7-20 23:11, 55.37 KB) / 下载次数 94
http://blog.zhuohua.store/attachment.php?aid=18587&k=abb0fdbbdf75e57b82f4652e7d100627&t=1714338220&sid=qVNoKV

图片附件: 图片7.png (2021-7-20 23:11, 35.7 KB) / 下载次数 91
http://blog.zhuohua.store/attachment.php?aid=18588&k=7fb70d15a639cb0828b17519b83aac4e&t=1714338220&sid=qVNoKV

图片附件: 图片8.png (2021-7-20 23:11, 66.35 KB) / 下载次数 108
http://blog.zhuohua.store/attachment.php?aid=18589&k=a5747ba8379f529df9d553068f1046a1&t=1714338220&sid=qVNoKV

图片附件: 图片9.png (2021-7-20 23:12, 97.68 KB) / 下载次数 106
http://blog.zhuohua.store/attachment.php?aid=18590&k=28e6eabca9595ee16fc56d83a2be7144&t=1714338220&sid=qVNoKV

图片附件: 图片10.png (2021-7-20 23:13, 85.36 KB) / 下载次数 117
http://blog.zhuohua.store/attachment.php?aid=18591&k=e80d4e04fa378e9ccd0f27fcd7215287&t=1714338220&sid=qVNoKV

图片附件: 图片11.png (2021-7-20 23:13, 45.6 KB) / 下载次数 88
http://blog.zhuohua.store/attachment.php?aid=18592&k=41661a64c8578e362c9497e57e6efb2e&t=1714338220&sid=qVNoKV

图片附件: 图片12.png (2021-7-20 23:13, 106.14 KB) / 下载次数 102
http://blog.zhuohua.store/attachment.php?aid=18593&k=784f596896eb80d4278fc4b5aeb86cd7&t=1714338220&sid=qVNoKV

图片附件: 图片13.png (2021-7-20 23:13, 55.05 KB) / 下载次数 112
http://blog.zhuohua.store/attachment.php?aid=18594&k=670fb16eb356424a0579505945646f6f&t=1714338220&sid=qVNoKV

图片附件: 图片14.png (2021-7-20 23:14, 33.12 KB) / 下载次数 113
http://blog.zhuohua.store/attachment.php?aid=18595&k=52994df1f1c252b7295c3501fecc9754&t=1714338220&sid=qVNoKV

图片附件: 图片15.png (2021-7-20 23:14, 63.46 KB) / 下载次数 105
http://blog.zhuohua.store/attachment.php?aid=18596&k=94d252aa6d7eb24f9ff59878555dfe42&t=1714338220&sid=qVNoKV

欢迎光临 blog.zhuohua.store (http://blog.zhuohua.store/)