RHEL 7 中将不再包含 MySQL 数据库,而是用 MariaDB 替代之。而我们对MariaDB 不了解,今天就先学安装吧。
一,下载MariaDB
最新版本
mariadb-5.5.31.tar.gz
下载cmake
-
wget http://www.cmake.org/files/v2.8/cmake-2.8.5.tar.gz
二,安装
1) 安装cmake
-
[root@zabbix_server opt]# tar xzvf mariadb-5.5.31.tar.gz
-
[root@zabbix_server cmake-2.8.5]# cd cmake-2.8.5
-
[root@zabbix_server cmake-2.8.5]# ./bootstrap
-
[root@zabbix_server cmake-2.8.5]# make
-
[root@zabbix_server cmake-2.8.5]# make install
2) 安装MariaDB
-
yum install libaio-devel -y
-
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mariamysql -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_DEBUG=0 -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DWITH_EMBEDDED_SERVER=OFF
-
cp support-files/my-innodb-heavy-4G.cnf /etc/my.cnf
-
/usr/local/mariamysql/scripts/mysql_install_db --basedir=/usr/local/mariamysql/ --datadir=/usr/local/mariamysql/data/ --user=mysql
-
/usr/local/mariamysql/bin/mysqld_safe --user=mysql &
-
yum install libaio-devel -y
-
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mariamysql -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_DEBUG=0 -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DWITH_EMBEDDED_SERVER=OFF
-
cp support-files/my-innodb-heavy-4G.cnf /etc/my.cnf
-
/usr/local/mariamysql/scripts/mysql_install_db --basedir=/usr/local/mariamysql/ --datadir=/usr/local/mariamysql/data/ --user=mysql
-
/usr/local/mariamysql/bin/mysqld_safe --user=mysql &
三,查看
-
[root@zabbix_server mariadb-5.5.31]# ps -ef | grep mysql
-
root 9010 17846 0 16:08 pts/0 00:00:00 /bin/sh /usr/local/mariamysql/bin/mysqld_safe --user=mysql
-
mysql 9459 9010 0 16:08 pts/0 00:00:01 /usr/local/mariamysql/bin/mysqld --basedir=/usr/local/mariamysql --datadir=/data/database --plugin-dir=/usr/local/mariamysql/lib/plugin --user=mysql --log-error=/data/database/zabbix_server.err --open-files-limit=40960 --pid-file=zabbix_server.pid --socket=/data/database/mysql.sock --port=3306
-
root 10391 17846 0 16:16 pts/0 00:00:00 grep mysql
-
-
[root@zabbix_server mariadb-5.5.31]# mysql
-
Welcome to the MySQL monitor. Commands end with ; or \g.
-
Your MySQL connection id is 41
-
Server version: 5.5.31-MariaDB-log MariaDB Server
-
-
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
-
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
-
and you are welcome to modify and redistribute it under the GPL v2 license
-
-
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
-
-
root@zabbix ((none)) > show databases;
-
+--------------------+
-
| Database |
-
+--------------------+
-
| information_schema |
-
| mysql |
-
| zabbix |
-
+--------------------+
-
3 rows in set (0.00 sec)
-
-
root@zabbix ((none)) >
感觉和mysql一样
阅读(2027) | 评论(0) | 转发(0) |