Databases

Related information: http://iweb.com/dedicated-server/cluster

Database Servers (Linux MySQL Server)
Single Linux Database Server
Your database server is configured with a base configuration. The private IP of the server should be used in your applications as the host for your databases instead of "localhost".

Master-Slave Replication

Your database servers are configured with a MASTER-SLAVE replication. You can use the SLAVE server for backup purpose and/or if your application supports it, you can send the SELECT transaction to this server to reduce the load on the MASTER server.

Databases
DRBD Servers
About your database servers, you have a pair of MySQL servers, which are being replicated using DRBD. Only one of the two servers is active at a time. The active server has a mounted DRBD partition in '/data', a shared virtual IP address and the MySQL service started. The secondary server (passive) must never have any of these properties so it is critical to be attentive during any operation on these servers.
To determine which server is active, you may use the following command:

drbdadm state r0

The command will return either "Primary/Secondary" which means the current server is Primary/Active or "Secondary/Primary" which means the opposite, that the current server is Secondary/Passive. In the eventuality that one of the DB servers becomes unavailable, we will receive alerts and we will
work on it until we are able to restore both servers in their respective roles. If you need to modify the MySQL configuration (my.cnf), you must apply the modifications on both servers but you must only restart the MySQL service on the Primary/Active node since MySQL should never run on a  Secondary/Passive node.

Note: The shared virtual IP is the IP address to use in your web applications. This IP will be used by the active server so if there is an outage, the transfer to the second server will be done in a transparent manner.

PHPMyAdmin

PHPMyAdmin is installed on each of the web servers. In the event that this is not the case, please contact us and we will do the installation. You are also free to proceed with the installation yourself if you feel comfortable with it. You must specify the IP address of the database server in the
configuration file.

Database Servers (Microsoft SQL Server)
Single Windows Database Server
Your database server is configured with a base configuration. The private IP of the server should be used in your applications as the host for your databases instead of "localhost".
SQL Mirroring (Automated Failover)
Your database servers are configured with SQL mirroring (automatic fail-over). The private IP of both servers should be used in your applications as the host for your databases instead of localhost. Your application must be .mirroring aware. and configured to use the primary database at all times
except when it's down, then it should use the secondary server. Let us know when your databases will be installed in the server DB1 (primary server) and we will take care of the mirroring on DB2 (secondary server).



Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk