Instalación de una BBDD MariaDB en pocos pasos con una configuración mínima, segura y optimizada.
yum -y install mariadb-server
systemctl enable mariadb.service
systemctl start mariadb.service
mysqladmin -u root password P4$$W0rD
Ahora que tenemos la BBDD instalada, actualizaremos su parametrización con valores que en un entorno relativamente pequeño es funcional:
cat > /etc/my.cnf << EOF
[mysqld]
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user = mysql
symbolic-links=0
bind-address = 127.0.0.1
max-connect-errors = 1000000
max_allowed_packet = 100M
max_heap_table_size = 256M
thread_cache_size = 100
read_rnd_buffer_size = 128K
read_buffer_size = 256K
table_open_cache = 1000
tmp_table_size = 256M
local-infile=0
performance_schema = on
general_log = OFF
general_log_file = /var/log/mariadb/mariadb.log
log-error = /var/log/mariadb/mariadb_error.log
log-queries-not-using-indexes=0
log-warnings = 2
slow_query_log = 1
slow-query_log_file = /var/log/mariadb/mariadb_slow.log
long_query_time = 2
skip-networking = 1
innodb_io_capacity = 1900
innodb_file_per_table = on
innodb_buffer_pool_size = 256M
innodb_stats_on_metadata = off
innodb_log_file_size = 32M
key_buffer_size = 10M
hot_cache.key_buffer_size = 5M
cold_cache.key_buffer_size = 5M
join_buffer_size = 5M
max_connections = 300
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
EOF
Aprovecharemos y eliminaremos usuarios que no usaremos:
mysql -u root -pP4$$W0rD << EOF
DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');
DELETE FROM mysql.user WHERE User='';
DELETE FROM mysql.user WHERE Host='::1';
DELETE FROM mysql.user WHERE Host='127.0.0.1';
FLUSH PRIVILEGES;
EOF
y finalmente, aplicaremos cambios reiniciando:
systemctl restart mariadb