httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Richard Peacock" <richard.peac...@minorplanet.com>
Subject RE: [users@httpd] Re: backup & restore apache & mysql
Date Tue, 11 Aug 2009 11:42:20 GMT
Hello

I just wanted to provide an update to the list of my implemented backup
procedure (it may help with other people in the same position!)

1.	Apache - rsync the file httpd.conf and the conf.d folder over to
another machine which is configured with the same Apache version (2.2
IIRC) - it acts as a "mirror" to the main server now (for want of a
better description).

2. MySQL - Currently looking at Zmanda on a virtual machine and not
having much luck (although a small disaster with an un-related LVM issue
this weekend took priority!).  For now, a simple EXPORT from the WebGUI
to a plain SQL file which can be imported in at will to the "mirror"
will have to suffice.

In the event of the main webserver failing, the rsync will be no more
than 1 hour old and the MySQL no more than 1 day old - all I need to do
is change my firewall's port forwarding to the IP address of the
failover machine (I can't change the Ip on the machine because there are
other services running on it (samba)).  Yes, I know, I should get DNS
working so I can change the IP at will but I can't be bothered, ok ;) I
have two kids and a demanding wife who insists I spend time with her
instead of the computers lol!!

Anyway, Sheryl, your help is very much appreciated and your suggestions
very good.

Have a nice day everyone!
Rich




-----Original Message-----
From: Sheryl [mailto:gubydala@his.com] 
Sent: 07 August 2009 16:30
To: users@httpd.apache.org
Subject: RE: [users@httpd] Re: backup & restore apache & mysql

> Sheryl
> Many thanks for the comprehensive reply and information; I'll look at
> zmanda now (I have looked at using the Amanda backup stuff once
already
> and thought it was very good).
>
> Would making a copy of the httpd.conf and conf.d folders be sufficient
> for a good easily "restorable" Apache backup?
>
> Rich
>

Rich,

Any time.  And yes, I've heard very good things about amanda
(now zmanda) although I've never used the main backup package
on the job.

Apache is going to be considerably more forgiving than mysql.
As long as you don't change minor numbers (like 2.0 to 2.2) the
httpd.conf should work on any hardware/OS you restore to as should
the html.  However, you need to make sure you get all of the bits
and pieces.  Better to back up too much than too little.  And I also
like to put configuration files under version control in subversion
as well as back them up.

In the past at our site, we had apache, php and mysql software
installed in /opt, supporting small programs in /usr/local,
perl modules in /usr/lib/perl5, cron jobs in /var/spool/cron,
etc and sometimes had to scramble to reassemble them on a recovery
machine.  More recently we have been taking the hit on disk space and
including everything the site needs in one tree.  If we have a
disaster we restore the whole tree to a clean install.  If we need a
development version we restore the whole tree to a clean install and
just
change a few lines in httpd.conf to get it to come up under the new
name/IP.  Of course we already compiled our own apache and php
rather than using RPMs and we have a  mysql support contract so we
had to use mysql.com binaries  instead of what came with RedHat
(and wanted to use more current copies anyway).

Regards,

Sheryl


---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server
Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org



**********************************************************************
Privileged/Confidential Information may be contained in this 
message. If you are not the addressee indicated in this 
message (or responsible for delivery of the message to such 
person), you must not copy, distribute or take any action in 
reliance to it.
In such case, you should destroy this message and kindly 
notify the sender by reply email. Please advise immediately 
if you or your employer do not consent to Internet email for 
messages of this kind. Opinions, conclusions and other 
information in this message that do not relate to the official 
business of Minorplanet Systems plc shall be understood as 
neither given nor endorsed by it. Minorplanet Systems plc, Registration no: 3372097
Minorplanet Limited, Registration no: 4072786
Greenwich House, 223 North Street, Leeds, LS7 2AA
VAT #: 698 1438 86
********************************************************************** 
 

---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Mime
View raw message