Redundancy

SeLLeRoNe

SeLLeRoNe

Super Moderator
Joined
Oct 9, 2004
Messages
6,632
Location
A Coruña, Spain
Hi guys,

ive to build a redundant server for a customer so im here to ask for your suggest.

That customer dont wanna spend much money (strange!?!?!?) so no load balancing (as i proposed).

I was thinkin about make backup everyday and upload everynight (from Server A to Server B) and i wanna know if that would work or not...

And, if that is going to be the customer choise, so, how i can setup DA to delete an user and import the backup just get via ftp?

I would make a script (of course) for make all automatic during the night with cronjobs so, if someone got some suggestion or already did something like that i would appreciate some help.

Thanks in advance

Regards
 
Why would you delete the user? What you need to do is an admin-based reseller backup, and then move the backup. And on the new machine restore the backup.

The only part of that I'm not sure of is how to automate the restore. I don't know if there are commands for it in the API or not. If not, there should be :).

However if any of the sites use MySQL to allow user updates, none of those updates will be on the second machine until the next night's backups. Same with orders, etc.

And how do you intend to change DNS?

Jeff
 
Yes i know about mysql and i told to the customer about this issue.

Maybe the restore can be started via shell as for the backup.

I was thinkin about delete the user cause i thot that the restore machine would say "user already exist" or something like that if the username or the domain is already been restored the night before.

For the DNS i would put ns1 on server a and ns2 on server b without dns redundancy between those server, so, when server a is up the dns pass form he and are his own ip, on server b ill setup domains with the machine ip (ofc both machine have different ips) so, when ns1 doesnt work ns2 reply to requet using his own ip and the backup on of the night before.

If im not wrong dns lookup always at ns1 then if no reply go to ns2 right?

I was thinkin about rsync ftp aswell and backup every hour the dbs (easy to make a script that drop all table on a db and import a new one) but i dunno if should work correctly and how make rsync work.

Do you think should work?

Regards
 
SeLLeRoNe said:
If im not wrong dns lookup always at ns1 then if no reply go to ns2 right?
Click to expand...
Wrong. The user's resolver looks to it's upstream nameservers (usually the user's ISP), and accepts the first reply it gets. If none of those nameservers have an answer, they'll get it from your nameservers and accept the first reply they get.

The first nameserver to respond to your user's machine... that's the IP# that gets used.
I was thinkin about rsync ftp aswell and backup every hour the dbs (easy to make a script that drop all table on a db and import a new one) but i dunno if should work correctly and how make rsync work.
Click to expand...
Hourly isn't enough to keep MySQL updated. You need to keep it updated in real time.

Jeff
 
damn so ive no idea about how to do, for mysql i should use a 3rd box for mysql but customer wanna use just two servers.. and.. if ns doesnt work as i thot.. i dunno how to solve this...

do you have any idea or suggestion for me about this sort of problem?
 
yes i already read that post days ago, but, that 3d dont tell "how replicate mysql on 2 server" is just a suggestion about what happen on a website with a backup system. am i wrong? o.O Maybe i missed something?
 
My point in the thread is to point out that it's not simple to do what you and/or your client want. I don't do replication, so I'm not going to pretend I know enough to tell you how. Perhaps someone else, who does, will respond.

Jeff
 
Which was the problem in my other thread.

I don't know. I don't think so.

Jeff
 
ehehe ok ill get informed about this "problem", for the "ftp side" do yuu know how to configure rsync?

thanks for your support
 
The last time I tried to configure rsync I managed to delete some important files. So I don't feel comfortable teaching someone else. Perhaps someone else will respond. The rsync manual should be available on your server:
Code: 
$ man rsync
Jeff
 
You must log in or register to reply here.
Back
Top