Databases, Systems & Networks

MySQL database replication with LinuxDatabase replication is a technique where a given database is copied to one or more locations, ...
Lire La Suite

Sauvegarde MySQLPour sauvegarder une base de données (sans et avec compression) :# mysqldump NOM_BASE > NOM_FICHIER # mysqldump NOM_BASE | ...
Lire La Suite

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

Source: Uptime Made EasyMaster Slave MySQL Replication SummaryMaster / Slave replication in MySQL is a great way to store an ...
Lire La Suite

Sometimes we need to migrate our databases to a new MySQL server.  It is easy to move the databases, but ...
Lire La Suite

Vous avez changé votre blog WordPress de serveur et de domaine et là plus rien ne marche?Vous voulez faire le ...
Lire La Suite

You can profile a query by doing following:mysql> SET SESSION profiling = 1; mysql> USE database_name; mysql> SELECT * FROM ...
Lire La Suite

IntroductionMySQL query profiling is a useful technique when trying to analyze the overall performance of a database driven application. When ...
Lire La Suite

Tweaking MySQL is something you need to do regularly. Unlike PHP & Nginx tweaking, this is not a set & ...
Lire La Suite

IntroductionIn this tutorial, we will teach you how to scale up your WordPress MySQL database server setup using master-slave database ...
Lire La Suite

In order to log in to a MySQL server, you can run mysql command along with your login credentials and ...
Lire La Suite

Introduction ProxySQL is an open-source MySQL proxy server, meaning it serves as an intermediary between a MySQL server and the ...
Lire La Suite

Beginning with MySQL 5.1.18, it is possible to use MySQL Cluster in multi-master replication, including circular replication between a number ...
Lire La Suite

Source: nixCraft How do I use mysqldump command with Unix shell pipes? The mysqldump client is a backup program which ...
Lire La Suite

Source: nixCraft I'm a new MySQL server user. My server is running on a CentOS Linux. How can I check ...
Lire La Suite

Source: nixCraft I'm a new Ubuntu Linux user and my cloud hosting company installed MySQL server by default. I need ...
Lire La Suite