• MariaDB与MySQL并存


    以下是MariaDB官方文档说明,MariaDB如何安装在已经存在MySQL实例的主机上:

    https://mariadb.com/kb/en/library/installing-mariadb-alongside-mysql/
    

    但是如果是先安装了MariaDB,然后再安装MySQL,比如:

    MariaDB的二进制程序在/opt/mysql/mariadb-10.2.8-linux-x86_64/
    

    /usr/local/做了一个软链接,即

    ln -s /opt/mysql/mariadb-10.2.8-linux-x86_64/ mysql
    

    具体见《MariaDB安装》的配置是一样的。

    安装时注意

    新的MySQL实例的配置文件,比如/etc/my3308.cnf,数据等文件设置在/data/mysql/mysql3308/{data,log,tmp}下。
    做的软链接是:

    ln -s /opt/mysql/mysql-5.7.19-linux-glibc2.12-x86_64/    mysql5.7
    

    初始化MySQL时,一定要指定配置文件!!

    cd /usr/local/mysql5.7
    ./bin/mysqld --defaults-file=/etc/my3308.cnf --initialize
    

    初始化没有报错,但查看日志却发现有error和多个warning,见最后。
    其中有一个错误:

    [ERROR] Can't read from messagefile '/opt/mysql/mariadb-10.2.8-linux-x86_64/share/english/errmsg.sys'
    

    在配置文件,加一个参数即可

    [mysqld]
    language = /usr/local/mysql5.7/share/english
    

    启动

    直接使用绝对路径的mysqld来启动

    /usr/local/mysql5.7/bin/mysqld --defaults-file=/etc/my3308.cnf &
    

    关闭

    直接使用绝对路径的mysqladmin来关闭

    /usr/local/mysql5.7/bin/mysqladmin -S /data/mysql/mysql3308/tmp/mysql3308.sock -uroot -p shutdown
    

    扩展

    可以把启动/关闭/登录数据库做成shell文件

    启动

    echo '/usr/local/mysql5.7/bin/mysqld --defaults-file=/etc/my3308.cnf &' > start.sh
    chmod +x start.sh
    

    关闭

    echo '/usr/local/mysql5.7/bin/mysqladmin -S /data/mysql/mysql3308/tmp/mysql3308.sock -uroot -p1234567 shutdown' > stop.sh
    chmod +x stop.sh
    

    登录

    echo '/usr/local/mysql5.7/bin/mysql -S /data/mysql/mysql3308/tmp/mysql3308.sock -uroot -p1234567' > login.sh
    chmod +x login.sh
    

    这样就实现了MariaDB和MySQL同一个主机上并存。

    不过初始化后,错误日志记录有一些警告的信息:

    2017-10-25T10:39:08.325682Z 0 [Warning] The syntax '--language/-l' is deprecated and will be removed in a future release. Please use '--lc-messages-dir' instead.
    2017-10-25T10:39:08.325842Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2017-10-25T10:39:08.325937Z 0 [Warning] Using pre 5.5 semantics to load error messages from /usr/local/mysql5.7/share/english/.
    2017-10-25T10:39:08.325943Z 0 [Warning] If this is not intended, refer to the documentation for valid usage of --lc-messages-dir and --language parameters.
    2017-10-25T10:39:08.326404Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.326414Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.326478Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.326483Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.326547Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.326550Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.326713Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.326717Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.326784Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.326792Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.326839Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.326843Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.326895Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.326899Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.327097Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.327108Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.327175Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.327184Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.327373Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.327383Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.327432Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.327439Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.327566Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.327578Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.327673Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.327678Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.327762Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.327766Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.327820Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.327824Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.327870Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.327874Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.327968Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.327972Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.328017Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.328021Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.328082Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.328086Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.328152Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.328156Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.328216Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.328220Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.328291Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.328296Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
    2017-10-25T10:39:08.328341Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import'
    2017-10-25T10:39:08.328345Z 0 [Warning] Unknown LDML tag: 'charsets/charset/collation/rules/import/source'
     100
     100
     100
    2017-10-25T10:39:08.912076Z 0 [Warning] InnoDB: New log files created, LSN=45790
    2017-10-25T10:39:08.965834Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
    2017-10-25T10:39:09.024512Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: bb700150-b970-11e7-8e66-0050568a571f.
    2017-10-25T10:39:09.025193Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
    2017-10-25T10:39:09.026291Z 1 [Note] A temporary password is generated for root@localhost: eiq-<*>yO0k-
    
  • 相关阅读:
    微信小程序基础 | 小程序事件的绑定 | 08
    Python的驻留机制(仅对数字,字母,下划线有效)
    深浅Copy的理解
    python2/3区别
    Python的优缺点、以及解释器种类
    Python涉及的各个领域以及技术应用
    近年主流编程语言的了解
    编程语言(机器语言、汇编语言、高级语言)
    mysql常用SQL语句
    mysql数据库的优缺点
  • 原文地址:https://www.cnblogs.com/fishparadise/p/9068511.html
Copyright © 2020-2023  润新知