Database
16/06/2016
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 ...
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 ...
MySQL Query Profiling
You can profile a query by doing following:mysql> SET SESSION profiling = 1; mysql> USE database_name; mysql> SELECT * FROM ...
How To Use MySQL Query Profiling
IntroductionMySQL query profiling is a useful technique when trying to analyze the overall performance of a database driven application. When ...
Using MySQLTuner to Optimize MySQL
Tweaking MySQL is something you need to do regularly. Unlike PHP & Nginx tweaking, this is not a set & ...
How To Optimize WordPress Performance With MySQL Replication On Ubuntu 14.04
IntroductionIn this tutorial, we will teach you how to scale up your WordPress MySQL database server setup using master-slave database ...
How to log in to MySQL server without password
In order to log in to a MySQL server, you can run mysql command along with your login credentials and ...
How To Use ProxySQL as a Load Balancer for MySQL on Ubuntu 16.04
Introduction ProxySQL is an open-source MySQL proxy server, meaning it serves as an intermediary between a MySQL server and the ...
MySQL Cluster Replication: Multi-Master and Circular Replication
Beginning with MySQL 5.1.18, it is possible to use MySQL Cluster in multi-master replication, including circular replication between a number ...
mysqldump: Copy Database Using Shell Pipes
Source: nixCraft How do I use mysqldump command with Unix shell pipes? The mysqldump client is a backup program which ...
Check The Number Of MySQL Open Database Connections on Linux Or Unix-like Server
Source: nixCraft I'm a new MySQL server user. My server is running on a CentOS Linux. How can I check ...
Monitor your MySql replication database
You have configured your MySql replication, next step is to perform maintenance and monitor your replication. Percona Toolkit for MySQL ...
Un cluster DRBD / MySQL avec Heartbeat sur Debian 7
Source: denisrosenkranz.com Nous avons vu précédement comment mettre un place un Cluster Apache actif/passif avec DRBD et HeartBeat. Dans ce ...
Heartbeat/mysql: Bascule esclave/maitre
Nous sommes dans la situation où il faut redémarrer le serveur maitreconnection ssh sur les deux serveurs:sur le maitre #ssh ...
PHP MySQL Benchmark Tool (PMBT v. 0.2)
Source: Reasons Unbeknownst The old saying “Need is the father of innovation” (or something like that) held true this weekend. I ...
Vous avez perdu le mot de passe root de MySQL ?
Que ce soit lors de la première installation ou après la perte du mot de passe principal de MySQL, il ...
