MariaDB 10.4.10

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

 

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

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

 

cmake -DCMAKE_INSTALL_PREFIX=/home/mariadb -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DMYSQL_DATADIR=/home/mariadb/var -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_FEDERATEDX_STORAGE_ENGINE=1 -DWITH_ARIA_STORAGE_ENGINE=1 -DWITH_XTRADB_STORAGE_ENGINE=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DENABLED_LOCAL_INFILE=1 -DWITH_EXTRA_CHARSETS=all -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system

 

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/