Multi-instance MySQL database startup problem

Source: Internet
Author: User
Environment:

Operating system: CentOS release 6.5
Database 1:
Version: mysql5.6.37
basedir:/usr/local/mysql5637
Configuration file Location:/data/mysql5637/my.cnf
Database 2:
Version: mysql5.7.19
basedir:/usr/local/mysql5719
Configuration file Location:/data/mysql5719/my.cnf

Question Summary

Today the 5.7.19 database to shutdown, and then use Mysqld_safe--defaults-file=/data/mysql5719/my.cnf start the database started not up, error message:

2018-02-27 11:05:32 47490 [ERROR] Plugin ' InnoDB ' init function returned ERROR.
2018-02-27 11:05:32 47490 [ERROR] Plugin ' InnoDB ' registration as a STORAGE ENGINE failed.
2018-02-27 11:05:32 47490 [ERROR] unknown/unsupported storage Engine:innodb
2018-02-27 11:05:32 47490 [ERROR] Aborting

Cause of error

The Mysqld_safe is the Mysqld_safe tool under the MySQL5.6.37 version
Using MySQL5.7.19 's Mysqld_safe tool is OK.


The direct use of Mysqld_safe is called the Mysqld_safe in the 5637 directory and cannot be started

Error log

Specify the full directory of Mysqld_safe to start MySQL is ok

Summarize

Multi-instance or write a startup script ~ ~ Wait till I learn how to write and put it up again

Multi-instance MySQL database startup problem

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.