Kenya le ho Lokisa MySQL ho Ubuntu 22.04

Ho kenya le ho hlophisa MySQL ho Ubuntu 22.04

Sebetsa MySQL database server ka Ubuntu 22.04 le ho hlophisa ho nepahetseng bakeng sa ho sebelisa tlhahiso.

Ho kenya

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

Qt:: Configuration

MySQL e hlophisoa ka ho fetola /etc/mysql/mysql.conf.d/mysqld.cnf:

max_connections = 200
innodb_buffer_pool_size = 1G
innodb_log_file_size = 256M

E-ba le tsebo ea ho kenya

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

Ho kenya tšebetsong

Ho fetola innodb_buffer_pool_size ho 70-80% ea RAM e fumanehang bakeng sa ho sebetsa ka ho nepahetseng. Ho etsa hore cache ea potso e be teng bakeng sa ho bala-boholo ho sebetsa.

Litsela tsa ho boloka

Senya mysqldump bakeng sa li-backup tsa logical kapa Percona XtraBackup bakeng sa li-backup tse futhumetseng ntle le nako e setseng.

Litlhahiso tsa Tšireletso

• Tlosa port e tloaelehileng ho tloha ho 3306 ho ea ho port e hlophisitsoeng
• Ho lumella ho kopanya SSL/TLS
• Qwalasela firewall ho lumella IP tse itseng feela
• Lintlafatso tsa polokeho