MariaDB数据库安装笔记

mariadb 安装文档

需要下载 以下东西：
cmake-2.8.11.2.tar.gz
mariadb-5.5.33a.tar.gz
并将上面两个东西 传到你的linux 机器下面，我本人的系统环境是centos6.3 ,传到 /tmp 下面 然后解压一下.

以下我们正式开始，mariadb 我之前没用过，也没装过，应该和mysql5.5的安装步骤差不多。下面正式开始：

1.系统环境装一些东西：
yum -y install gcc gcc-c++ make automake autoconf kernel-devel ncurses-devel libxml2-devel openssl-devel curl-devel libjpeg-devel libpng-devel pcre-devel libtool-libs freetype-devel gd zlib-devel file bison patch mlocate flex diffutils
readline-devel glibc-devel glib2-devel bzip2-devel gettext-devel libcap-devel libmcrypt-devel

2.安装cmake 要等到上面的东西装完
解压 cmake-2.8.11.2.tar.gz

tar zxvf cmake-2.8.8.tar.gz
mkdir /usr/local/cmake
cd cmake-2.8.4
./configure --prefix=/usr/local/cmake
make&&make install

3.创建 相关目录 和mysql 用户
mkdir -p /usr/local/mariadb/data

groupadd mariadb
useradd -g mariadb -s /sbin/nologin mariadb

4.
/usr/local/cmake/bin/cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mariadb \
-DMYSQL_UNIX_ADDR=/tmp/mariadb.sock \
-DMYSQL_DATADIR=/usr/local/mariadb/data \
-DSYSCOnFDIR=/etc \
-DMYSQL_USER=mariadb \
-DMYSQL_TCP_PORT=3308 \
-DWITH_XTRADB_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_EXTRA_CHARSETS=1 \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all \
-DWITH_BIG_TABLES=1 \
-DWITH_DEBUG=0

make &&make install

5.目录权限设置
chown mariadb -R /usr/local/mariadb

chgrp mariadb -R /usr/local/mariadb

chmod -R go-rwx data

chmod -R 755 /usr/local/mariadb/bin

6.启动文件 和参数文件的设置
启动文件和参数文件 没有 需要拷贝一个 到init.d 下面
进入 support-files
cp my-huge.cnf /etc/my.cnf

cp mysql.server /etc/init.d/mysqld

 
[mysqld]
basedir = /usr/local/mariadb
datadir = /data/mariadb
pid-file = /data/mariadb/mariadb.pid
character-set-server = utf8
collation-server = utf8_general_ci
user = mysql
port = 3306
default_storage_engine = InnoDB
innodb_file_per_table = 1
server_id = 1
log_bin = mysql-bin
binlog_format = mixed
expire_logs_days = 7
bind-address = 0.0.0.0

# name-resolve
skip-name-resolve
skip-host-cache

#lower_case_table_names = 1
ft_min_word_len = 1
query_cache_size = 64M
query_cache_type = 1

skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

# LOG
log_error = /data/mariadb/mariadb-error.log
long_query_time = 1
slow_query_log
slow_query_log_file = /data/mariadb/mariadb-slow.log

# Oher
#max_cOnnections= 1000
open_files_limit = 65535

[client]
port = 3306

7.
./mysql_install_db --basedir=/usr/local/mariadb --datadir=/usr/local/mariadb/data --user=mariadb
echo "/usr/local/mariadb/lib/mysql" >> /etc/ld.so.conf

vim /etc/profile

MARIADB_PATH="/usr/local/mariadb/bin"
export MARIADB_PATH
chkconfig mysqld on