Faka kwaye ulungiselele i-MySQL kwi-Ubuntu 22.04

Ukufaka nokumiselwa kweMySQL kwi-Ubuntu 22.04

Misela iseva ye-MySQL database kwi-Ubuntu 22.04 ngokumiselwa kwenkqubo efanelekileyo yokusetyenziswa komveliso.

Ufakelo

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

Uqwalaselo Lokuqala

Misela inkqubo ye-MySQL ngokuhlela i-/etc/mysql/mysql.conf.d/mysqld.cnf:

max_connections = 200
innodb_buffer_pool_size = 1G
innodb_log_file_size = 256M

Yenza isiseko sedata kunye nomsebenzisi

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

Ulawulo lwe Performance

Ilungisa i-innodb_buffer_pool_size ukuya kwi-70-80% ye-RAM efumanekayo ukuphucula ukusebenza. Yenza ukuba umbuzo ugcinwe kwindawo yokugcina efihlakeleyo ufunde ubunzima bomsebenzi.

Inkqubo yovimba weefayili

Sebenzisa i mysqldump kwi backups ezi logical okanye i Percona XtraBackup kwi backups ezishushu ngaphandle kwexesha lokuphuma.

Iingcebiso zokhuseleko

• Tshintsha isiqhagamshelanisi esimiselweyo ukusuka kwi 3306 ukuya kwisiqhagamshelanisi esimiselweyo
• Yenza uxhulumaniso lwe-SSL/TLS
• Qwalasela i-firewall ukuze ivumele kuphela ii-IP ezikhankanyiweyo
• Uhlaziyo lokhuseleko oluqhelekileyo