MySQL/MariaDB Config Generator

Generateur de configuration my.cnf optimisee selon vos ressources.

Ressources systeme

Type de serveur

RAM totale du serveur

Nombre de CPUs

Type de stockage

Type d'utilisation

Connexions max attendues

Options

Serveur dedie a MySQL

Configuration replication

Role replication

Slow query log

Forcer SSL

Configuration generee

# my.cnf

Calculs

Presets par taille

Micro

1GB RAM, 1 CPU

Small

4GB RAM, 2 CPU

Medium

16GB RAM, 4 CPU

Large

64GB RAM, 16 CPU

X-Large

128GB RAM, 32 CPU

Galera Cluster

Config cluster sync

Parametres cles InnoDB

`innodb_buffer_pool_size`	Cache principal (50-80% RAM)
`innodb_log_file_size`	Taille redo log (1-2GB)
`innodb_flush_log_at_trx_commit`	1=ACID, 2=perf, 0=risque
`innodb_io_capacity`	IOPS disponibles (SSD: 2000+)
`innodb_read_io_threads`	Threads lecture async
`innodb_write_io_threads`	Threads ecriture async

Application

# Emplacement du fichier
# Debian/Ubuntu: /etc/mysql/mysql.conf.d/mysqld.cnf
# RHEL/CentOS: /etc/my.cnf ou /etc/my.cnf.d/

# Verifier la syntaxe
mysqld --validate-config

# Redemarrer
sudo systemctl restart mysql  # ou mariadb

# Verifier une valeur
mysql -e "SHOW VARIABLES LIKE 'innodb_buffer_pool_size'"