| View previous topic :: View next topic |
| Author |
Message |
BeerCheeze
*hick*
Joined: 14 Jun 2003
Posts: 9285
Location: At the Bar
|
 Posted: Mon, 11 Apr 2005 14:56:32 Post Subject: |
  |
|
| IceNine wrote: | | My only thought is that all the swapping that the db does could compromise the life of the backup drive. |
That is why you put the DB on the 2nd drive, and the backup on the 1st drive (with the OS).
You could even then make a 2nd backup on the 2nd hdd, and backup the system on to it. That way you have the DB backup on the OS drive, and the OS (well the config's) backed up on the DB drive.
I would also suggest a once a week download of the backups to an off site location (i.e. home PC). |
|
| Back to top |
|
 |
Little Bruin
Boo Boo
Joined: 07 Apr 2003
Posts: 667
Location: Pic-A-Nic Basket |
|
|
IceNine
*The Freshest*
Joined: 08 Sep 2003
Posts: 1459
Location: Bel Air
|
| Posted: Mon, 11 Apr 2005 15:00:44 Post Subject: |
|
|
| Dr. EvilCheeze wrote: | | I would also suggest a once a week download of the backups to an off site location (i.e. home PC). |
We maintain our backups on our main webserver (RAID Mirroring) as well as FTP it to a local box every night. It's easy and effective.
_________________
A letter to a soldier |
|
| Back to top |
|
|
BeerCheeze
*hick*
Joined: 14 Jun 2003
Posts: 9285
Location: At the Bar
|
|
| Back to top |
|
|
Doctor Feelgood
Arrrrghh!
Joined: 07 Apr 2003
Posts: 20349
Location: New Jersey
|
| Posted: Mon, 11 Apr 2005 15:10:42 Post Subject: |
|
|
In addition to the nightly backups from drive a to b, I do download the whole shebang to my PC on a regular basis, too.
You guys are too confusing (or is it confused)... 
How about this?
mySQL stays put in /var/lib on sda.
/home stays put on sdb.
a mySQL backup folder is created on sdb.
a /home backup folder is created on sda.
All files are downloaded on a regular basis. AND, if it seems economically viable to keep the existing server too, all files get backed up there weekly! |
|
| Back to top |
|
|
IceNine
*The Freshest*
Joined: 08 Sep 2003
Posts: 1459
Location: Bel Air
|
| Posted: Mon, 11 Apr 2005 15:14:29 Post Subject: |
|
|
You just do a hard link for the MySQL backup? My recommendation is to use the mysqldump utility to pipe the data into a file, then gzip it for archival. Plus, what method creates all the backups?
_________________
A letter to a soldier |
|
| Back to top |
|
|
BeerCheeze
*hick*
Joined: 14 Jun 2003
Posts: 9285
Location: At the Bar
|
|
| Back to top |
|
|
Doctor Feelgood
Arrrrghh!
Joined: 07 Apr 2003
Posts: 20349
Location: New Jersey
|
| Posted: Mon, 11 Apr 2005 15:26:26 Post Subject: |
|
|
| IceNine wrote: | | My recommendation is to use the mysqldump utility to pipe the data into a file, then gzip it for archival. Plus, what method creates all the backups? |
Yes, that is what I do, and plan to keep doing. I have CRONs setup to run that nightly.
Presently... the first CRON does a mysqldump from drive a to b everyday at 2AM. The next CRON is based on the day of the week, so I can maintain 7 recent backups... So, at 3AM this CRON gzips the mysqldump file into an archive with the day of the week in the filename. Therefore, there are 8 files in the sql bacup folder at any given time.
OK, I will put the mySQL on drive b now, and symlink it back into /var/lib on drive a.
I will then create my backups of /home and mySQL to sda.
Right?
Now... what about finding the rest of the disk space I think I should have?!? |
|
| Back to top |
|
|
Little Bruin
Boo Boo
Joined: 07 Apr 2003
Posts: 667
Location: Pic-A-Nic Basket |
|
|
IceNine
*The Freshest*
Joined: 08 Sep 2003
Posts: 1459
Location: Bel Air
|
|
| Back to top |
|
|
BeerCheeze
*hick*
Joined: 14 Jun 2003
Posts: 9285
Location: At the Bar
|
| Posted: Mon, 11 Apr 2005 15:33:14 Post Subject: |
|
|
yea, I do a mysqldump nightly I then rename the file to the date, zip it, put it in a backup dir, and burn it to a CD (speaking of... I think I need to change the CD) |
|
| Back to top |
|
|
Doctor Feelgood
Arrrrghh!
Joined: 07 Apr 2003
Posts: 20349
Location: New Jersey
|
| Posted: Mon, 11 Apr 2005 15:34:36 Post Subject: |
|
|
Thanks for all the info...
Isn't fdisk a Windows thing? |
|
| Back to top |
|
|
|
