[mariadb] 安裝 mariadb 與 tuning

請參照：

0. 把 io scheduler 修改成 noop

• Use noop IO scheduler

https://access.redhat.com/solutions/109223

1. 安裝 mariadb 10.2.x

https://mariadb.com/kb/en/library/configuring-linux-for-mariadb/

這裡來安裝 mariadb。就這麼簡單?! 對。就這麼簡單。

2. 修改 /etc/security/limits.conf

加入一行，把 open files 放寬

* – nofile 32768

3. 這是我常用的一組 my.conf

innodb_buffer_pool_size = 16G

# innodb_log_file_size = 2G

innodb_flush_log_at_trx_commit = 0

innodb_file_per_table

default-storage-engine = innodb

# innodb_log_files_in_group = 4

# innodb_log_file_size = 16G

# innodb_log_buffer_size = 8M

large-pages

#datadir = /var/lib/mysql

#datadir = /mysql/data

 

# Networking

wait_timeout=57600

max_allowed_packet=1G

skip-name-resolve

bind=0.0.0.0

max_connections=1000

有一篇不錯的文可以看看

https://www.custompcreview.com/articles/top-five-mysql-mariadb-settings-tune-best-performance/

change db location to a new one on centos7

https://www.digitalocean.com/community/tutorials/how-to-change-a-mariadb-data-directory-to-a-new-location-on-centos-7

 

PS:

1. securing your db

https://www.digitalocean.com/community/tutorials/how-to-install-mariadb-on-centos-7

2. 記得 mariadb db & log file system 要用 LVM striping 起來

blog 有其他文可以參考

mariaDB 是一個效能不錯開源 DB, 也許改天有空研究一下她的 scaling cluster

本文摘自Simon Cheng’s 儲思盆