[CentOS] s3 as mysql directory
nux at li.nux.ro
Mon Oct 1 14:39:06 EDT 2012
On 01.10.2012 19:24, Tim Dunphy wrote:
> Hello list,
> I am soliciting opinion here as opposed technical help with an idea
> have. I've setup a bacula backup system on an AWS volume. Bacula
> stores a
> LOT of information in it's mysql database (in my setup, you can also
> postgres or sqlite if you chose). Since I've started doing this I
> that the mysql data directory has swelled to over 700GB! That's quite
> a lot
> and its' easting up valuable disk space.
> So I had an idea. What about uses the fuse based s3fs to mount an S3
> bucket on the local filesystem and use that as your mysql data dir?
> other words mount your s3 bucket on /var/lib/mysql
> I used this article to setup the s3fs file system
> And everything went as planned. So my question to you dear listers is
> if I
> do start using a locally mounted s3 bucket as my mysqld data dir,
> performance of the database be acceptable? If so, why? If not are
> there any
> other reasons why it would NOT be a good idea to do this?
> The steps I have in mind are basically this:
> 1) mysqldump --all-databases > alldb.sql
> 2) stop mysql
> 3) rm -rf /var/lib/mysql/*
> 4) mount the s3 bucket on /var/lib/mysql
> 5) start mysql
> 6) restore the alldb.sql dump
> Thanks for your opinions on this!
What a wild idea! :-)
I don't think it will work; S3 is not really a filesystem afaik.
Sent from the Delta quadrant using Borg technology!
More information about the CentOS