Iṣeto olupin

Fi sori ẹrọ ati tunto MySQL lori Ubuntu 22.04

Itọsọna pipe si fifi olupin data MySQL sori Ubuntu 22.04 pẹlu iṣeto ti o ṣetan fun iṣelọpọ.

December 20, 2025 13426 awọn iwo

Fi sori ẹrọ ati Iṣeto MySQL lori Ubuntu 22.04

Fí àwọn ààtòjọ-ẹ̀yàn MySQL pamọ́ lórí Ubuntu 22.04 láti fi àwọn ìṣàmúlò-ètò tí o dara jù láti lò nípa ìṣàmúlò-ètò.

Àtòjọ-ẹ̀yàn

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

Àtòjọ-ẹ̀yàn Ìṣàmúlò-ètò

Àtòjọ-ẹ̀yàn MySQL láti fi àtòjọ-ẹ̀yàn /etc/mysql/mysql.conf.d/mysqld.cnf pamọ́:

max_connections = 200
innodb_buffer_pool_size = 1G
innodb_log_file_size = 256M

Ṣẹ̀dá àtòjọ-ẹ̀yàn àti Òǹlò

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

Àwọn Ìṣàmúlò-ètò

Fi innodb_buffer_pool_size pamọ́ sí 70-80% tí RAM náà bá jẹ́ fún ìṣàfarawé iṣẹ́. Ló àwọn ààtò àìṣàfilọ́lẹ̀ ìtàn ìtàn fún àwọn ààtò iṣẹ́ àìkànṣe.

Àwọn Ìṣàmúlò-ètò Àìtò

Use mysqldump for logical backups or Percona XtraBackup for hot backups without downtime.

Àwọn Àṣẹ Àìdá

Ṣàfikún ìpàtó ìpéwọ̀n láti inú 3306 sí ìpàtó àwọn ìṣàmúlò-ètò
Fún àwọn ìpàpọ̀ SSL/TLS lágbára iṣẹ́
Àtòjọ-ẹ̀yàn ààyè-iṣẹ́ fún ìgbàjójú IPs kan
Àwọn ìṣàmúlò-ètò ìdàjọ́ ìdàjọ́

Ṣe ìdíyelé sí Àpilẹ̀kọ Yìí

★★★★★

Ń fi pamọ́...

Ṣe àwárí Àwọn Ìwé

Iṣeto olupin

Wo gbogbo àwọn àpilẹ̀kọ

Fi sori ẹrọ ati tunto MySQL lori Ubuntu 22.04

Fi sori ẹrọ ati Iṣeto MySQL lori Ubuntu 22.04

Àtòjọ-ẹ̀yàn

Àtòjọ-ẹ̀yàn Ìṣàmúlò-ètò

Ṣẹ̀dá àtòjọ-ẹ̀yàn àti Òǹlò

Àwọn Ìṣàmúlò-ètò

Àwọn Ìṣàmúlò-ètò Àìtò

Àwọn Àṣẹ Àìdá

Ṣe ìdíyelé sí Àpilẹ̀kọ Yìí

Àwọn Àpilẹ̀kọ Tó Jọra

Fi PostgreSQL pamọ́ lórí Ubuntu 22.04

Ṣe àwárí Àwọn Ìwé

Iṣeto olupin