Solved

Mirror a PHP/MySQL site

Posted on 2006-10-31
3
246 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
  • 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 150 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

746 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now