Landing on the Cloudera manager found that a lot of the newspaper space, hand-cheap will be all deleted/tmp directory, and then restart the server and agent, found that the agent can start normally, but the server does not normally start, view log, found the error
2018-02-23 11:13:05,313 ERRORmain:com.cloudera.enterprise.dbutil.DbUtil:InnoDB engine not found. Showengines reported: [Mrg_myisam, CSV, MYISAM, MEMORY]
2018-02-23 11:13:05,313 ERRORmain:com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean:InnoDb engineisn ' t Present or enabled. SCM requires INNODB MySQL DB engine.
Log meaning is not find the MySQL InnoDB this engine, so login MySQL (mysql-u root-p), use the command show engines, the result is as follows:
+------------+---------+-----------------------------------------------------------+--------------+------+----- -------+
| Engine | Support | Comment | Transactions | XA | savepoints|
+------------+---------+-----------------------------------------------------------+--------------+------+----- -------+
| Mrg_myisam | YES | Collection of identical Myisamtables | NO | NO | NO |
| CSV | YES | CSV Storage Engine |no | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| MEMORY | YES | Hash based, stored inmemory, useful for temporary tables | NO | NO | NO |
+------------+---------+-----------------------------------------------------------+--------------+------+----- -------+
Indeed there is no innodb engine, suspicion is not normal startup, so quit MySQL, restart mysqld service (servicemysqld restart), re-enter MySQL, found that the original look
So
First of all, under MySQL's ' plugin_dir ' there are ha_innodb_plugin.so and ha_innodb.so two files
The path to query ' Plugin_dir ' can be used with the following command
Mysql> Show variables like ' Plugin_dir ';
+---------------+-------------------------+
| variable_name | Value |
+---------------+-------------------------+
| Plugin_dir |/usr/lib64/mysql/plugin |
+---------------+-------------------------+
1 row in Set (0.01 sec)
If not found, there are the following directory files in the MySQL compilation directory (built-in InnoDB and Innodb_plugin)
Storage/innobase/.libs/ha_innodb.so
Storage/innodb_plugin/.libs/ha_innodb_plugin.so
You need to copy them (ha_innodb_plugin.so and ha_innodb.so) to the MySQL plugin directory.
The next step is to install it on the MySQL command line
# MySQL
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 18
Server Version:5.1.36-log Source Distribution
Type ' help, ' or ' \h ' for help. Type ' \c ' to clear the current inputstatement.
Mysql> show engines;
The next step is to install it on the MySQL command line
# MySQL
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 18
Server Version:5.1.36-log Source Distribution
Type ' help, ' or ' \h ' for help. Type ' \c ' to clear the current inputstatement.
Mysql> show engines;
+------------+---------+-----------------------------------------------------------+--------------+------+----- -------+
| Engine | Support | Comment | Transactions | XA | savepoints |
+------------+---------+-----------------------------------------------------------+--------------+------+----- -------+
| Mrg_myisam | YES | Collection of identical Myisamtables | NO |no | NO |
| CSV | YES | CSV Storageengine | NO |no | NO |
| MEMORY | YES | Hash based,stored in memory, useful for temporary tables |no | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 withgreat Performance |no | NO | NO |
+------------+---------+-----------------------------------------------------------+--------------+------+----- -------+
4 rows in Set (0.00 sec)
mysql> INSTALL PLUGIN InnoDB soname ' ha_innodb_plugin.so ';
Query OK, 0 rows affected (0.69 sec)
Mysql> show engines;
5 rows in Set (0.00 sec)
From
4 rows in Set (0.00 sec)
mysql> INSTALL PLUGIN InnoDB soname ' ha_innodb.so ';
Query OK, 0 rows affected (0.69 sec)
Mysql> show engines;
+------------+---------+------------------------------------------------------------+--------------+------+---- --------+
| Engine | Support | Comment | Transactions | XA | savepoints|
+------------+---------+------------------------------------------------------------+--------------+------+---- --------+
| InnoDB | YES | Supports transactions,row-level locking, and foreign keys | YES | YES | YES |
| CSV | YES | CSV Storageengine | NO | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| Mrg_myisam | YES | Collection of identical Myisamtables | NO | NO | NO |
| MEMORY | YES | Hash based, stored inmemory, useful for temporary tables |no | NO | NO |
+------------+---------+------------------------------------------------------------+--------------+------+---- --------+
5 rows in Set (0.00 sec)