MariaDB

# MariaDB 10.0 CentOS repository list - created 2015-06-10 04:26 UTC
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.2/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
sudo yum install MariaDB-server MariaDB-client
sudo service mysql start
sudo mysql_secure_installation
GRANT ALL PRIVILEGES ON devdb.* TO devuser@localhost
IDENTIFIED BY 'devpass' WITH GRANT OPTION;

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?