首页   注册   登录
V2EX = way to explore
V2EX 是一个关于分享和探索的地方
现在注册
已注册用户请  登录
wsgzao
V2EX  ›  程序员

CentOS7 平滑升级 MariaDB 5.5 到 10.x 新版本实践

  •  
  •   wsgzao · 2018-11-16 16:07:50 +08:00 · 1202 次点击
    这是一个创建于 434 天前的主题,其中的信息可能已经有所发展或是发生改变。

    前言

    自从 CentOS 7 开始,自带的数据库就变成 MariaDB 了,yum 安装之后的默认版本是 5.5,但是这个数据版本已经比较老了,无论是安装全新的 Percona 还是升级 MariaDB 第一步始终是不要忘记备份。

    CentOS7 平滑升级 MariaDB 5.5 到 10.x 新版本实践

    更新历史

    2018 年 11 月 14 日 - 初稿

    阅读原文 - https://wsgzao.github.io/post/mariadb-upgrade/

    扩展阅读

    MariaDB - https://mariadb.org/


    备份数据库

    重要的事情说三遍,备份,备份,备份

    # 备份数据库,如果升级顺利是不要实施备份还原的
    mysqldump -u root -p --all-databases > alldb.sql
    # 如果想保留自己的 my.cof 配置,则备份一下这个文件
    cp /etc/my.cnf /etc/my.cnf.bak
    # 停止数据库运行
    systemctl stop mariadb
    # 卸载 MariaDB 老版本
    yum remove mariadb mariadb-server
    
    

    添加 MariaDB Yum 库

    建议使用 MariaDB 官方推荐的 stable 稳定版,

    https://downloads.mariadb.org/mariadb/ http://yum.mariadb.org/

    # 添加 MariaDB 官方源
    vi /etc/yum.repos.d/MariaDB.repo
    
    # MariaDB 10.3 CentOS repository list
    # http://downloads.mariadb.org/mariadb/repositories/
    [mariadb]
    name = MariaDB
    baseurl = http://yum.mariadb.org/10.3/centos7-amd64
    gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    gpgcheck=1
    
    # 清除 yum 缓存
    yum clean all 
    yum makecache
    
    

    升级已有数据库

    # 安装 MariaDB 新版本
    yum install mariadb mariadb-server
    
    # 启动新版 MariaDB
    systemctl start mariadb
    
    # 升级已有数据库
    mysql_upgrade -uroot -p 
    
    [[email protected] tmp]# mysql_upgrade -uroot -p
    Enter password:
    Phase 1/7: Checking and upgrading mysql database
    Processing databases
    mysql
    mysql.columns_priv                                 OK
    mysql.db                                           OK
    mysql.event                                        OK
    mysql.func                                         OK
    mysql.help_category                                OK
    mysql.help_keyword                                 OK
    mysql.help_relation                                OK
    mysql.help_topic                                   OK
    mysql.host                                         OK
    mysql.ndb_binlog_index                             OK
    mysql.plugin                                       OK
    mysql.proc                                         OK
    mysql.procs_priv                                   OK
    mysql.proxies_priv                                 OK
    mysql.servers                                      OK
    mysql.tables_priv                                  OK
    mysql.time_zone                                    OK
    mysql.time_zone_leap_second                        OK
    mysql.time_zone_name                               OK
    mysql.time_zone_transition                         OK
    mysql.time_zone_transition_type                    OK
    mysql.user                                         OK
    Upgrading from a version before MariaDB-10.1
    Phase 2/7: Installing used storage engines
    Checking for tables with unknown storage engine
    Phase 3/7: Fixing views
    Phase 4/7: Running 'mysql_fix_privilege_tables'
    Phase 5/7: Fixing table and database names
    Phase 6/7: Checking and upgrading tables
    Processing databases
    information_schema
    performance_schema
    zabbix
    zabbix.acknowledges                                OK
    zabbix.actions                                     OK
    zabbix.alerts                                      OK
    zabbix.application_discovery                       OK
    zabbix.application_prototype                       OK
    zabbix.application_template                        OK
    zabbix.applications                                OK
    zabbix.auditlog                                    OK
    zabbix.auditlog_details                            OK
    zabbix.autoreg_host                                OK
    zabbix.conditions                                  OK
    zabbix.config                                      OK
    zabbix.corr_condition                              OK
    zabbix.corr_condition_group                        OK
    zabbix.corr_condition_tag                          OK
    zabbix.corr_condition_tagpair                      OK
    zabbix.corr_condition_tagvalue                     OK
    zabbix.corr_operation                              OK
    zabbix.correlation                                 OK
    zabbix.dashboard                                   OK
    zabbix.dashboard_user                              OK
    zabbix.dashboard_usrgrp                            OK
    zabbix.dbversion                                   OK
    zabbix.dchecks                                     OK
    zabbix.dhosts                                      OK
    zabbix.drules                                      OK
    zabbix.dservices                                   OK
    zabbix.escalations                                 OK
    zabbix.event_recovery                              OK
    zabbix.event_suppress                              OK
    zabbix.event_tag                                   OK
    zabbix.events                                      OK
    zabbix.expressions                                 OK
    zabbix.functions                                   OK
    zabbix.globalmacro                                 OK
    zabbix.globalvars                                  OK
    zabbix.graph_discovery                             OK
    zabbix.graph_theme                                 OK
    zabbix.graphs                                      OK
    zabbix.graphs_items                                OK
    zabbix.group_discovery                             OK
    zabbix.group_prototype                             OK
    zabbix.history                                     OK
    zabbix.history_log                                 OK
    zabbix.history_str                                 OK
    zabbix.history_text                                OK
    zabbix.history_uint                                OK
    zabbix.host_discovery                              OK
    zabbix.host_inventory                              OK
    zabbix.hostmacro                                   OK
    zabbix.hosts                                       OK
    zabbix.hosts_groups                                OK
    zabbix.hosts_templates                             OK
    zabbix.housekeeper                                 OK
    zabbix.hstgrp                                      OK
    zabbix.httpstep                                    OK
    zabbix.httpstep_field                              OK
    zabbix.httpstepitem                                OK
    zabbix.httptest                                    OK
    zabbix.httptest_field                              OK
    zabbix.httptestitem                                OK
    zabbix.icon_map                                    OK
    zabbix.icon_mapping                                OK
    zabbix.ids                                         OK
    zabbix.images                                      OK
    zabbix.interface                                   OK
    zabbix.interface_discovery                         OK
    zabbix.item_application_prototype                  OK
    zabbix.item_condition                              OK
    zabbix.item_discovery                              OK
    zabbix.item_preproc                                OK
    zabbix.items                                       OK
    zabbix.items_applications                          OK
    zabbix.maintenance_tag                             OK
    zabbix.maintenances                                OK
    zabbix.maintenances_groups                         OK
    zabbix.maintenances_hosts                          OK
    zabbix.maintenances_windows                        OK
    zabbix.mappings                                    OK
    zabbix.media                                       OK
    zabbix.media_type                                  OK
    zabbix.opcommand                                   OK
    zabbix.opcommand_grp                               OK
    zabbix.opcommand_hst                               OK
    zabbix.opconditions                                OK
    zabbix.operations                                  OK
    zabbix.opgroup                                     OK
    zabbix.opinventory                                 OK
    zabbix.opmessage                                   OK
    zabbix.opmessage_grp                               OK
    zabbix.opmessage_usr                               OK
    zabbix.optemplate                                  OK
    zabbix.problem                                     OK
    zabbix.problem_tag                                 OK
    zabbix.profiles                                    OK
    zabbix.proxy_autoreg_host                          OK
    zabbix.proxy_dhistory                              OK
    zabbix.proxy_history                               OK
    zabbix.regexps                                     OK
    zabbix.rights                                      OK
    zabbix.screen_user                                 OK
    zabbix.screen_usrgrp                               OK
    zabbix.screens                                     OK
    zabbix.screens_items                               OK
    zabbix.scripts                                     OK
    zabbix.service_alarms                              OK
    zabbix.services                                    OK
    zabbix.services_links                              OK
    zabbix.services_times                              OK
    zabbix.sessions                                    OK
    zabbix.slides                                      OK
    zabbix.slideshow_user                              OK
    zabbix.slideshow_usrgrp                            OK
    zabbix.slideshows                                  OK
    zabbix.sysmap_element_trigger                      OK
    zabbix.sysmap_element_url                          OK
    zabbix.sysmap_shape                                OK
    zabbix.sysmap_url                                  OK
    zabbix.sysmap_user                                 OK
    zabbix.sysmap_usrgrp                               OK
    zabbix.sysmaps                                     OK
    zabbix.sysmaps_elements                            OK
    zabbix.sysmaps_link_triggers                       OK
    zabbix.sysmaps_links                               OK
    zabbix.tag_filter                                  OK
    zabbix.task                                        OK
    zabbix.task_acknowledge                            OK
    zabbix.task_check_now                              OK
    zabbix.task_close_problem                          OK
    zabbix.task_remote_command                         OK
    zabbix.task_remote_command_result                  OK
    zabbix.timeperiods                                 OK
    zabbix.trends                                      OK
    zabbix.trends_uint                                 OK
    zabbix.trigger_depends                             OK
    zabbix.trigger_discovery                           OK
    zabbix.trigger_tag                                 OK
    zabbix.triggers                                    OK
    zabbix.users                                       OK
    zabbix.users_groups                                OK
    zabbix.usrgrp                                      OK
    zabbix.valuemaps                                   OK
    zabbix.widget                                      OK
    zabbix.widget_field                                OK
    Phase 7/7: Running 'FLUSH PRIVILEGES'
    OK
    
    # 配置服务自启动
    systemctl enable mariadb
    
    # 登录数据库验证
    mysql -uroot -p
    
    # 升级过程遇到错误记得先查看日志分析
    
    
    

    MariaDB 官方升级文档

    Upgrading from MariaDB 5.5 to MariaDB 10.0 https://mariadb.com/kb/en/library/upgrading-from-mariadb-55-to-mariadb-100/

    2 回复  |  直到 2018-11-17 07:20:58 +08:00
    DearTanker
        1
    DearTanker   2018-11-17 01:40:53 +08:00
    V2 真是废了,技术帖没人聊,无聊的东西聊的热火朝天。
    ChangHaoWei
        2
    ChangHaoWei   2018-11-17 07:20:58 +08:00
    大晚上的,,,弄完了都想睡觉了吧。友情顶一个。。
    关于   ·   FAQ   ·   API   ·   我们的愿景   ·   广告投放   ·   感谢   ·   实用小工具   ·   701 人在线   最高记录 5168   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.3 · 46ms · UTC 20:26 · PVG 04:26 · LAX 12:26 · JFK 15:26
    ♥ Do have faith in what you're doing.