The High availability clusters are computer clusters which are implemented mainly for the purpose of improving the availability of the services. The high availability clustering detect hardware/software faults, and instantly restart the application on another system without requiring administrative intercession, this process is commonly known as a Failover process. It has functionality that provides failover from one node to another if the current node becomes unavailable, a failover cluster appears on the network as a normal application, but it has additional functionality that increases its availability in case one server fail.

The clustering software may configure the node before starting the application on it. To run the system smoothly it require appropriate filesystems to be imported and mounted and  to set-up cluster rules that enable a common set of configurations also network hardware may have to be configured, and some supporting applications may need to be running as well.

Diagram: HA Cluster network (2 node)

The purpose of HA clusters to utilize all available techniques to make the individual systems/shared infrastructure as reliable as possible. The high availability clustering should include the following;

* Build redundancy into a cluster.

* Redundant network connections so that a switchover or network interface failures do not result in network outages.

* Disk mirroring to avoid system crashes in case of failure of internal disks.

* SAN data connections.

* Redundant electrical power inputs.

The high availability  clusters usually use a critical clustering in private network connection which is used to monitor the status of each node in the cluster. Such clustering are often required for critical databases,  business applications, file sharing on a network and customer services such as e-commerce websites.

The following article explains how to access your MySQL database remotely.
1)Go to Cpanel >> MySQL® Databases >> Access Hosts: >> Add IP of the machine from which you want to access databse.
2)Click on Add host.

In order to access your MySQL database, please follow these steps:

1. Log into your machine from which you want to access database remotely.
2. Open the MySQL client program on the server in the /usr/bin directory.
cd /usr/bin

Give the command
# mysql

3.Type in the following syntax to access your database:

$ mysql -h {hostname} -u username -p {databasename}
Password: {your password}
mysql >
* hostname: the name of the MySQL server that you are assigned to, for example, domainname/servername
* databasename: The name of your MySQL database
* password: The password you use to access your MySQL database

If you want to copy existing database to another, perform the follwing steps and you will be able to copy the existing database to another database.

1)Create New database from Cpanel >> MySql >> New Database.

2)Go to WHM >> phpMyAdmin >>
3)Select the database which you want to copy it.
4)Select menu Operations from menu bar.
5)Insert name of database under “Copy database to:”
6)Select Structure and data.
7)Go.

After Completing those seven steps you will be able to copy database.

Cpanel do not provide any utility to convert .dmp file to MySql database. There are third party software which can be use to convert .dmp file to MySql database.

Excel-to-MySQL is a program to convert Microsoft Excel spreadsheets into MySQL databases. Depending on your privileges on the target MySQL server you can export MS Excel data into new database or overwrite the contents of an existing MySQL database.

Requirements

• Windows 2000/XP or Windows NT 4 with Internet Explorer 5 or later or Windows 98/ME or Windows 95 with Internet Explorer 5 or later
• At least 32 MB of available memory

VServer user’s option

If you are using Virtual Server hosting you probably have no sufficient privileges to create new databases on the target MySQL server. For this case we recommend the following approach:

1. ask your Virtual Server administrator to create blank database for you
2. run Excel-to-MySQL and select this database as the conversion target
3. click “Yes” when you will be asked if you’d like to overwrite existing MySQL database

When you complete these steps, the entire contents of the source MS Excel spreadsheet will be imported into the specified MySQL database.

MySQL dump file

Excel-to-MySQL allows users to perform deferred conversion and get more control over the process. Following this way, the program stores the contents of the data source into a local dump file instead of moving it to MySQL server directly. The resulting file contains MySQL statements to create all tables and to fill them with the data. You will be able to import this file into existing MySQL database via MySQL client as follows:

mysql.exe –host=… –user=… –password=… -vvf {MySQL database name}

Forgot the MySQL root password :

First you will have to stop the MySQL service on the server.

# service mysqld stop

Start MySQL as

# /usr/bin/safe_mysqld –skip-grant-tables &

Or

# /usr/bin/mysqld_safe –skip-grant-tables &

safe_mysqld is a script that starts mysqld and traps any forceful terminationof the MYSQL server and it privents any database corruption.

Change the password for root user as

# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD(’new_password’) WHERE user=’root’
mysql> FLUSH PRIVILEGES;
mysql> exit;

Start the MySQL service:

# service mysqld start

Hello Friends,

Following are the steps to move database from ensim server to cpanel server.

Create a file with all the mysql databases from one domain (type in
each full file name based on the files in the

/var/lib/mysql directory). If there is just one domain then you’ll only
have one domain_com_-_xx entry, if there are several,

then just keep adding the databases.

mysqldump -Q –databases domain_com_-_xx domain_com_-_yy domain_com_-_zz -u root -p –add-drop-table > dump.sql

Step 2: Create the priviliges file

mysqldump mysql > mysql.sql -u root -p

cat mysql.sql | grep domain > mysql2.sql

Step 3: Make the Tar of Files

tar -czvf dump.tar.gz dump.sql mysql2.sql

Step 4: Transfer the files

ftp new.cpanelserver

put dump.tar.gz

At cpanel server you need to do the following steps
Login to cpanel server.

step 1:Start in the directory in /home/admin
cd /home/admin

tar -zvxf dump.tar.gz

Step 2: Run the vi editor to do a search/replace on database name

vi dump.sql

:%s/ecclestoned_com_-/ecclestoned/g

Step 3: Run the vi editor to do a search/replace on the permissions to fix
some version issues.

vi mysql2.sql

:%s/ecclestoned\\\\_com\\\\_-\\\\/ecclestoned/

:%s/);/,’Y',’Y');

Step 4: Run mysql hosting to import the databases

mysql mysql -u root -f