mariadb(mariadb和mysql的区别)

本文目录：

• 1、Centos7安装 mariadb启动错误解决
• 2、mariadb表最大数据量
• 3、mariadb配置文件执行顺序

Centos7安装 mariadb启动错误解决

本人遇到mariadb 启动错误的故障解决过程分享。

故障现象 ：

Centos7 使用 yum -y install mariadb mariadb-server  安装完成mariadb后启动错误。

错误信息：

[root@iZ882mt6umfZ ~] systemctl status mariadb.service

[0m mariadb.service – MariaDB database server

Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)

Active: failed (Result: exit-code) since Fri 2019-03-01 09:25:54 CST; 9s ago

Process: 309 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE)

Process: 308 ExecStart=/usr/bin/mysqld_safe –basedir=/usr (code=exited, status=0/SUCCESS)

Process: 32745 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)

Main PID: 308 (code=exited, status=0/SUCCESS)

Mar 01 09:25:53 iZ882mt6umfZ systemd[1]: Starting MariaDB database server…

Mar 01 09:25:53 iZ882mt6umfZ mariadb-prepare-db-dir[32745]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.

Mar 01 09:25:53 iZ882mt6umfZ mariadb-prepare-db-dir[32745]: If this is not the case, make sure the /var/lib/mysql is empty before running mariad…db-dir.

Mar 01 09:25:53 iZ882mt6umfZ mysqld_safe[308]: 190301 09:25:53 mysqld_safe Logging to ‘/var/log/mariadb/mariadb.log’.

Mar 01 09:25:53 iZ882mt6umfZ mysqld_safe[308]: 190301 09:25:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

Mar 01 09:25:54 iZ882mt6umfZ systemd[1]: mariadb.service: control process exited, code=exited status=1

Mar 01 09:25:54 iZ882mt6umfZ systemd[1]: Failed to start MariaDB database server.

Mar 01 09:25:54 iZ882mt6umfZ systemd[1]: Unit mariadb.service entered failed state.

Mar 01 09:25:54 iZ882mt6umfZ systemd[1]: mariadb.service failed.

解决方案：

yum install mariadb*

chown -R mysql:mysql /var/lib/mysql/

启动正常：

root@iZ882mt6umfZ ~] systemctl start mariadb

[root@iZ882mt6umfZ ~] systemctl status mariadb

[0m mariadb.service – MariaDB database server

Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)

Active: active (running) since Fri 2019-03-01 09:38:58 CST; 13s ago

Process: 1875 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)

Process: 1843 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)

Main PID: 1874 (mysqld_safe)

mariadb表最大数据量

151MDB。mariadb表是一种博客表，表单的最大数据量只有151MDB，用户可以对最大的数据量存储进行相应的改写，选择变成自己喜欢的储存量。

mariadb配置文件执行顺序

mariadb配置文件执行顺序是

1、创建/data目录mkdir/data，chmod777/data(要给这个目录至少要附加读写权限)。

2、把mariadb服务停掉：systemctlstopmariadb.service。

3、把/var/lib/mysql整个目录复制到/data，cp-r/var/lib/mysql//data/这样就把MySQL的数据文档复制到了/data下。

4、编辑mariadb的配置文档/etc/my.cnf。

5、chown-Rmysql:mysql/data/mysql。

6、重新启动mariadb服务systemctlstartmariadb.service。

本文来源：https://www.yuntue.com/post/76775.html | 云服务器网，转载请注明出处！