Ikani ndikusintha MySQL pa Ubuntu 22.04

Kukhazikitsa ndi kukhazikitsa MySQL pa Ubuntu 22.04

Kukhazikitsa MySQL database server pa Ubuntu 22.04 ndi kuwongolera bwino kwa ntchito yopanga.

Kukhazikitsa

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

Kusintha Kwanthawi Yoyamba

Kusintha MySQL ndi kusintha / etc / mysql / mysql.conf.d / mysqld.cnf:

max_connections = 200
innodb_buffer_pool_size = 1G
innodb_log_file_size = 256M

Kukhazikitsa Database ndi User

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

Kuchita bwino

Kusintha innodb_buffer_pool_size kuti 70-80% ya RAM yopezeka kwa ntchito yabwino. Kukhazikitsa cache yafunso kwa zolemba zolemera.

Backup Strategy

Musanagwiritse ntchito mysqldump, muyenera kukhazikitsa Percona XtraBackup kuti mupange zosunga zobwezeretsera zotentha popanda nthawi yosagwira.

Malamulo achitetezo

• Sinthani default port kuchokera 3306 kuti makonda port
• Kukhazikitsa kugwirizana kwa SSL/TLS
• Kusintha kwa firewall kuti ilole IPs zokha
• Kusintha kwachitetezo chosasintha