MariaDB 10.1.21

yum -y install cmake.x86_64 ncurses* krb5-devel

 

wget -P /root/src/ https://downloads.mariadb.org/interstitial/mariadb-10.1.21/source/mariadb-10.1.21.tar.gz

cd /root/src; tar xvzf mariadb-10.1.21.tar.gz; cd mariadb-10.1.21

 

cmake -DCMAKE_INSTALL_PREFIX=/opt/mysql -DMYSQL_DATADIR=/opt/mysql/var -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DENABLED_LOCAL_INFILE=ON -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_JEMALLOC=no -DWITH_ARIA_STORAGE_ENGINE=ON -DUSE_ARIA_FOR_TMP_TABLES=ON -DWITH_PARTITION_STORAGE_ENGINE=ON -DWITH_PERFSCHEMA_STORAGE_ENGINE=ON -DWITH_QUERY_CACHE_INFO=ON -DWITH_QUERY_RESPONSE_TIME=ON -DWITH_SAFEMALLOC=AUTO -DWITH_XTRADB_STORAGE_ENGINE=ON -DWITH_LOCALES=ON -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all

 

make -j `grep processor /proc/cpuinfo | wc -l`; make install

 

useradd -M -s /bin/false mysql

 

vi /etc/my.cnf

[mysqld]

init_connect=SET collation_connection=utf8_general_ci

init_connect=SET NAMES utf8

character-set-server=utf8

collation-server=utf8_general_ci

table_open_cache=1024

max_connections=2048

max_user_connections=500

max_connect_errors=10000

wait_timeout=300

query_cache_type=1

query_cache_size=128M

query_cache_limit=5M

slow_query_log

long_query_time=3

max_allowed_packet=16M

sort_buffer_size=2M

skip-name-resolve

symbolic-links=0

 

[mysql]

default-character-set=utf8

 

/opt/mysql/scripts/mysql_install_db --basedir=/opt/mysql --datadir=/opt/mysql/var

 

chown -R mysql.mysql /opt/mysql/