Faka futhi Lungiselela i-MySQL ku-Ubuntu 22.04

Ukufakela nokuhlela iMySQL ku-Ubuntu 22.04

Sebenzisa isisebenzisi sedatha yeMySQL ku-Ubuntu 22.04 ngesimo esifanele sokusetshenziswa kokukhiqizwa.

Ukufakela

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

Ukumiswa kokuqala

Misa iMySQL ngokuhlela /etc/mysql/mysql.conf.d/mysqld.cnf:

max_connections = 200
innodb_buffer_pool_size = 1G
innodb_log_file_size = 256M

Dala i-database nomsebenzisi

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

Ukuthuthukiswa kwemisebenzi

Linganisa innodb_buffer_pool_size ku 70-80% ye RAM ekhona ukuze usebenze kahle. Vumela umbuzo wendawo yokugcina efihlakeleyo ukuze ufunde ubunzima bomsebenzi.

Uhlelo lokulondoloza

Sebenzisa i-mysqldump nge-backup efanele noma i-Percona XtraBackup nge-backup eshushu ngaphandle kwesikhathi sokuphuma.

Izincomo zokuphepha

• Guqula isibuko esijwayelekile kusuka ku-3306 kuya kusiphoko esijwayelekile
• Vumela ukuxhumana kwe-SSL/TLS
• Misa i-firewall ukuze ivumele kuphela IPs ezicacisiwe
• Ukuhlaziywa kokuphepha okujwayelekile