dotcommakers Posted February 2, 2010 Share Posted February 2, 2010 Hi I have a weird question. I would like to use two databases for my whmcs. one on current server and another on different server. I want to update both databases at a time. Aim to keep things like this, is only to avoid any downtime of the server. How can i achieve this? I am not programmer, I am just designer, I check dbconnect.php files but its encoded not open source so how can I achieve this? regards 0 Quote Link to comment Share on other sites More sharing options...
tomdchi Posted February 3, 2010 Share Posted February 3, 2010 I don't think that would be possible from within WHMCS. I think you should look into replication if you are looking for failover. 0 Quote Link to comment Share on other sites More sharing options...
dotcommakers Posted February 3, 2010 Author Share Posted February 3, 2010 What do u mean by replication? regards 0 Quote Link to comment Share on other sites More sharing options...
vchosting Posted February 3, 2010 Share Posted February 3, 2010 You could use the database backup facility which is done daily automatically and ftp to a different server of send to an email account on a different server. Access is via Setup >> Database Backups from within your WHMCS admin. This way you would always have a backup that is less than 24 hours old 0 Quote Link to comment Share on other sites More sharing options...
dotcommakers Posted February 3, 2010 Author Share Posted February 3, 2010 I know that.. backup is not solution i am looking for because I dont want to update second server database with this backup all the time.. its not the best solution.. regards 0 Quote Link to comment Share on other sites More sharing options...
vchosting Posted February 3, 2010 Share Posted February 3, 2010 Then I dont thin there is any way of doing this with WHMCS that I can think of. 0 Quote Link to comment Share on other sites More sharing options...
LicenseChef Posted February 3, 2010 Share Posted February 3, 2010 You can configure your mysql servers to mirror each other. 0 Quote Link to comment Share on other sites More sharing options...
tomdchi Posted February 3, 2010 Share Posted February 3, 2010 (edited) http://dev.mysql.com/doc/refman/5.0/en/replication.html Or set up a cluster- http://dev.mysql.com/tech-resources/articles/mysql-cluster-for-two-servers.html If you are looking for high availablility/failover then whatever you do needs to be done from within mysql not whmcs. Edited February 3, 2010 by tomdchi 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.