MariaDB

# MariaDB 10.4 CentOS repository list
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.4/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
sudo yum install MariaDB-server MariaDB-client
sudo systemctl start mariadb
sudo mariadb-secure-installation

Create Database Schema And DB User

GRANT ALL PRIVILEGES ON devdb.* TO devuser@localhost IDENTIFIED BY 'devpass' WITH GRANT OPTION;
create user 'devuser'@'localhost' identified by 'devpass';
grant all on devdb.* to 'devuser'@'localhost';
GRANT SELECT, SHOW VIEW ON devdb.* TO devuser2@localhost IDENTIFIED BY 'devpass';

DB backup

mysqldump -h localhost -u devuser -p devpass devdb > okdevdb-20180724.sql
# low CPU
mysqldump -h localhost -u devuser -p devpass --single-transaction --quick --lock-tables=false $DBNAME > okdevdb-20180724.sql

Timezone

sudo cp /usr/share/zoneinfo/Asia/Seoul /etc/localtime
sudo service mysql restart

all process

show processlist;

Table stats

select TABLE_NAME, TABLE_ROWS
from information_schema.tables
order by 2 desc;

MariaDB on ubuntu

MariaDB + node.js

What Else?