Wụnye ma hazie MySQL na Ubuntu 22.04

Nwụnye na ntọala MySQL na Ubuntu 22.04

Nhazi MySQL database sava na Ubuntu 22.04 na nhazi nke kacha mma maka iji mmepe.

Nhazi

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

Nhazi nhazi mbụ

Nhazi MySQL site n'ịgbanwe /etc/mysql/mysql.conf.d/mysqld.cnf:

max_connections = 200
innodb_buffer_pool_size = 1G
innodb_log_file_size = 256M

Kewapụta database na onyenhọrọ

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

Nhazi

Nhazi innodb_buffer_pool_size ka 70-80% nke RAM dị̄ maka mmezi nke ọma. Mepụta nchọgharị cache maka agụụ-n'obere ọrụ.

Nhazi nchekwa

Jiri mysqldump maka logical backups mọọbụ Percona XtraBackup maka hot backups na-enweghị oge akwụsị.

Ndụmọdụ nchekwa

• Gbanye difọ́ọ̀ltụ̀ port site na 3306 gaa na port emeredịkachọrọ
• Mepee njikọ SSL/TLS
• Nhazie faịrwal ahụ ka ọ nye ikike na IPs emeredịkachọrọ
• Nhazi nke nchekwa