Database
16/06/2016
5 Steps to Setup MySQL Master Master Replication on Ubuntu 16.04
Source: linoxide.com The Master-Slave replication in MySQL databases provides load balancing for the databases. But it does not provide any ...
Lire La Suite
Lire La Suite
How to Setup MySQL Master Master Replication
MySQL master master replication, also known as “mysql chained replication”, “multi master replication or “mysql daisy chaining replication” is an ...
Lire La Suite
Lire La Suite
ERROR 1040…again
A pretty common topic in Support tickets is the rather infamous error: ERROR 1040: Too many connections. The issue is ...
Lire La Suite
Lire La Suite
MySQL Circular Replication
Source: icicimov Setting the MySQL in Master-Master mode means in case of an instance failure the other one will transparently ...
Lire La Suite
Lire La Suite
Initialize MySQL Master-Slave replication with a script
Source: Nico's Blog MySQL Master-Slave replication is natively supported by MySQL. However its configuration is not so simple. For each ...
Lire La Suite
Lire La Suite
When the Replication stops working: analysis and resync of MySQL Replication
Source: ryadel.com We already had the opportunity to talk about Replication between MySQL Database in a previous article, where we ...
Lire La Suite
Lire La Suite
Optimiser les performances de MySQL
Source: Optimiser les performances de MySQL (Quentin Busuttil) Les bases de données SQL et plus particulièrement MySQL restent une des ...
Lire La Suite
Lire La Suite
Pure-FTPd et MySQL
Le logiciel pure-ftpd est l’un des serveurs FTP les plus simple à installer et configurer c’est pourquoi si vous cherchez ...
Lire La Suite
Lire La Suite
MySQL: Setting Account Resource Limits
One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a ...
Lire La Suite
Lire La Suite
MySQL database replication with Linux
MySQL database replication with LinuxDatabase replication is a technique where a given database is copied to one or more locations, ...
Lire La Suite
Lire La Suite
Sauvegarde MySQL
Sauvegarde MySQLPour sauvegarder une base de données (sans et avec compression) :# mysqldump NOM_BASE > NOM_FICHIER # mysqldump NOM_BASE | ...
Lire La Suite
Lire La Suite
MySQL – Gestion des binlogs
Par défaut, MySQL stocke chaque requête en écriture dans des fichiers appelés binlogs.Configuration des binlogsPar défaut les binlogs sont conservés ...
Lire La Suite
Lire La Suite
MySQL Master / Slave Replication
Source: Uptime Made EasyMaster Slave MySQL Replication SummaryMaster / Slave replication in MySQL is a great way to store an ...
Lire La Suite
Lire La Suite
MySQL – Migrate Users from Server to Server
Sometimes we need to migrate our databases to a new MySQL server. It is easy to move the databases, but ...
Lire La Suite
Lire La Suite
Des requêtes SQL pour vous sauver la vie avec WordPress
Vous avez changé votre blog WordPress de serveur et de domaine et là plus rien ne marche?Vous voulez faire le ...
Lire La Suite
Lire La Suite
MySQL Query Profiling
You can profile a query by doing following:mysql> SET SESSION profiling = 1; mysql> USE database_name; mysql> SELECT * FROM ...
Lire La Suite
Lire La Suite
