Ku rakib oo habayn MySQL Ubuntu 22.04

Ku rakibidda iyo qaabeynta MySQL ee Ubuntu 22.04

Ku dhis server MySQL database on Ubuntu 22.04 oo leh qaabeynta ugu fiican ee isticmaalka wax soo saarka.

Ku rakibidda

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

Asturnaanta Aasaasiga ah

Configure MySQL by edit / etc / mysql / mysql.conf.d / mysqld.cnf:

max_connections = 200
innodb_buffer_pool_size = 1G
innodb_log_file_size = 256M

abuuro database iyo user

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

Nidaamka

Isbedelka innodb_buffer_pool_size in 70-80% ee RAM ah oo la heli karo si ay u shaqeeyaan si fiican.

Qorshaha Lacag-dhimista

U isticmaal mysqldump si loo ilaaliyo xogta loo yaqaan ama Percona XtraBackup si loo ilaaliyo xogta kulul iyadoo aan la joojin.

Tallaabooyinka Amniga

• Isbedelka isha default ka 3306 in isha custom
• Ka dhig xiriirada SSL/TLS
• Configure firewall si ay u oggolaadaan oo keliya IPs gaar ah
• Isbedelada amniga ee joogtada ah