?
Solved

Mirror a PHP/MySQL site

Posted on 2006-10-31
3
Medium Priority
?
253 Views
Last Modified: 2010-04-20
I have a nice reliable (underused) server at Rackspace.  I offered to host a site there for someone, because it's a site I use a lot, and it tends to go down regularly (bad hosting).  It's a PHP/MySQL site, and he'd rather that I mirror it rather than just host it.  Sounds fine to me, but how do you go about setting that up?  Also, is there a way to make his DNS point to my server if his goes down?
0
Comment
Question by:aaroncampbell
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 5

Expert Comment

by:flashwebhost
ID: 17853933
To mirror MySQL, you need special setup, can only done if both servers are dedicated with root access. For web part, you can add one more A record for the domain  and point that to your servers IP. Also edit the DNS Record of the domain and reduce the TTL.

You need to move the DNS of the domain to a different server or use thrid party DNS service like www.ZoneEdit.com

0
 

Author Comment

by:aaroncampbell
ID: 17861433
Both servers are dedicated, with root access.
0
 
LVL 5

Accepted Solution

by:
flashwebhost earned 600 total points
ID: 17873513
You can see how to cluster MySQL database at

http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-quick.html

This is not easy to do, you need to spend some time and need resources to get this  done.

It will be better to use a dedicated server for MySQL that way server load can be shared.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month10 days, 19 hours left to enroll

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question