This tutorial explains how you can manage multiple MySQL servers from one phpMyAdmin installation. For security reasons, communication between phpMyAdmin and any remote MySQL server is using SSL encryption (this is not necessary for a local MySQL server since communication between phpMyAdmin and MySQL is not leaving the server).

To solve MySQL problems or to optimize MySQL server you need to use special tool called mytop. It is a UNIX top command clone for MySQL server. It updates every few seconds, so you can get a reasonable look at your SQL performance. It is capable of displaying a huge amount of information.

At the end of day, there was two server running simultaneously on the using different ports for connections. Here are the steps, I took to install and configure multiple MySQL servers:

Today I will tell you how to set up a new Ubuntu 10.04 server which runs VMware server 2.0.2-x and the VMware Remote Console Plug-in. With VMware Server you can create and run guest operating systems ("virtual machines") such as Linux, Windows, FreeBSD, etc. under a host operating system.

Regardless of whether you're running a single MySQL server or a cluster of multiple servers, one thing you are always interested in is squeezing the maximum performance out of your system. MySQL's developers were well aware of this, and so they provided a fairly comprehensive list of performance variables that you can monitor in real time to check the health and performance of your MySQL server.

You might know that beginning with MySQL 5.1.24, support for the NDBCLUSTER storage engine was removed from the standard MySQL server binaries built by MySQL. Therefore, here I'm using MySQL Cluster edition instead of MySQL Community edition.

Sometimes in large deployments, there are cases when MySQL server, setup by you long time back which has been in use by multiple teams in your organization, needs some change or update or intrupption in its service and you are in need to know how many clients are there which connects to this server.

File Transfer Protocol (FTP) is a popular and time-honored method of transferring files to and from a remote network site. FTP is built on a client-server architecture and uses separate control and data connections between the client and server applications. The FTP client connects to the FTP server, and enables the user to send and retrieves files from that server.

MySQL is a relational database management system. It provides a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL is the most popular open source database, and is the database component of the LAMP software stack. LAMP consists of the Apache web server, MySQL and PHP, the essential building blocks to run a general purpose web server.