Syncing two linux boxes
Greetings from Denmark! The weather is getting a little warmer over here. Here's my question: I run a little webdesign shop - one man band. I have three computers on a LAN connected to the net via a router + adsl connection. One computer has SuSE 9.0 installed. I use it as an apache, mysql, sendmail server. Another computer on the Lan is also a SuSE 9.0 box. It is sightly used as a workstation, mainly for surfing the net and emailing. I would like to use this computer as a backup of my server just in case something should happen. What is the easiest way to sync the two machines? What I am interesting in syching: 1. htdocs /srv/www/htdocs 2. the mysql database 3. My Apache configuration file at /etc/httpd/httpd.conf I'm a newbie so I'll need pretty detailed instructions. I would like the two machine to sync nightly. Do apache, mysql on the server have to shut down in other to sync or can they sync "on the fly"? Any suggestions? Thanks in advance. Regards, Dan
I'm a newbie so I'll need pretty detailed instructions. I would like the two machine to sync nightly. Do apache, mysql on the server have to shut down in other to sync or can
Dan, they sync "on the fly"?
Any suggestions? Thanks in advance.
I'd suuggest using rsync for most of that stuff. There should be extensive HOWTO articles online on rsync; I remember one in Linux Magazine, for example. For MySQL, I'm not sure. I believe that MySQL still lacks a open source hot backup tool, meaning that you would either have to pay $$ for a commercial tool, or shutdown MySQL and rsync the files. However, I'm not terribly up to date on MySQL ... we use Postgres here. -- -Josh Berkus Aglio Database Solutions San Francisco
Thanks for your quick reply. I have a ? about MySQL. See below.
Dan,
I'm a newbie so I'll need pretty detailed instructions. I would like the two machine to sync nightly. Do apache, mysql on the server have to shut down in other to sync or can they sync "on the fly"?
Any suggestions? Thanks in advance.
I'd suuggest using rsync for most of that stuff. There should be extensive HOWTO articles online on rsync; I remember one in Linux Magazine, for example.
For MySQL, I'm not sure. I believe that MySQL still lacks a open source hot backup tool, meaning that you would either have to pay $$ for a commercial tool, or shutdown MySQL and rsync the files.
Embarrassing question, eh, but where are the data files for MySQL stored? What files do I need to backup?
However, I'm not terribly up to date on MySQL ... we use Postgres here.
-- -Josh Berkus Aglio Database Solutions San Francisco
-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com
On Tuesday 13 April 2004 17:02, Josh Berkus wrote:
Dan,
I'm a newbie so I'll need pretty detailed instructions. I would like the
two machine to sync nightly.
Do apache, mysql on the server have to shut down in other to sync or can
they sync "on the fly"?
Any suggestions? Thanks in advance.
I'd suuggest using rsync for most of that stuff. There should be extensive HOWTO articles online on rsync; I remember one in Linux Magazine, for example.
For MySQL, I'm not sure. I believe that MySQL still lacks a open source hot backup tool, meaning that you would either have to pay $$ for a commercial tool, or shutdown MySQL and rsync the files.
However, I'm not terribly up to date on MySQL ... we use Postgres here.
Sorry, I am a little behind on email here. rsync would definitely be the way to go with your web server. MySQL has replication capability built-in. I haven't used it but I saw an article about it in a magazine a few months back (don't remember which one). I thought that I might give it a try, but haven't had time. I use PostgreSQL for most things as I started using it before MySQL even existed. The MySQL replication is strictly master/slave replication (no two way stuff). Hope this helps. -- Kelly L. Fulks Home Account near Huntsville, AL
participants (3)
-
Dan Eskildsen -
Josh Berkus -
Kelly Fulks