YIFY

Registered
Sep 5, 2011
2
0
51
cPanel Access Level
Website Owner
Hi,

I would like to know how to be able to sync up content/sql/settings between TWO different cPanels on 2 Different webhost servers. is this possible, if not what is a good solution


What i am trying to achieve is a bit of load balancing and redundancy issues if one goes down.

Please help
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
348
somewhere over the rainbow
cPanel Access Level
Root Administrator
For MySQL, do both machines have InnoDB disabled? If they do not, flat file rsycing wouldn't be supported between the servers, since it can easily result in database table corruption.
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
348
somewhere over the rainbow
cPanel Access Level
Root Administrator
Run the following command:

Code:
mysql -e 'select table_name FROM INFORMATION_SCHEMA.tables where table_type="BASE TABLE" and engine = "InnoDB"' mysql
If you get a return, InnoDB is enabled. If you do not get a return, it is not enabled.

As for syncing, while we do not support rsync, you might use the suggestions in this thread for rsyncing for redundancy purposes:

rsync backups