Fa'apipi'i ma Fa'atulaga le MySQL i le Ubuntu 22.04

Faʻapipiʻiina ma le Faʻatonuina o MySQL i luga o Ubuntu 22.04

Faʻatulaga le MySQL database server i luga o le Ubuntu 22.04 ma le faʻatulagaina lelei mo le faʻaaogaina o le gaosiga.

Faʻapipiʻi

sudo apt update
sudo apt install mysql-server -y
sudo mysql_secure_installation

Faʻatulagaina o le amataga

Faʻatulagaina MySQL e ala i le toe faʻaleleia /etc/mysql/mysql.conf.d/mysqld.cnf:

max_connections = 200
innodb_buffer_pool_size = 1G
innodb_log_file_size = 256M

Faʻatonu le faʻafanua

sudo mysql
CREATE DATABASE myapp;
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON myapp.* TO 'myuser'@'localhost';
FLUSH PRIVILEGES;

Faʻatonuina o le aʻoaʻoga

Faʻatonu le innodb_buffer_pool_size i le 70-80% o le RAM e maua ai mo le lelei o le faʻatinoina. Faʻatagaina le cache fesili mo le faitauina o le mamafa o le galuega.

Faʻatulagaga o le backup

Faʻaaoga mysqldump mo faʻataga logical poʻo Percona XtraBackup mo faʻataga vevela e aunoa ma le taimi leiloa.

Fautuaga mo le saogalemu

• Change default port from 3306 to a custom port
• Faʻatagaina fesoʻotaʻiga SSL/TLS
• Faʻatulagaina o le firewall e faʻatagaina ai IP faapitoa
• Faʻafouga saogalemu masani