[CentOS] s3 as mysql directory

2012-10-01 Thread Tim Dunphy
Hello list, I am soliciting opinion here as opposed technical help with an idea I 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 use postgres or sqlite if you chose). Since I've started doing this I

Re: [CentOS] s3 as mysql directory

2012-10-01 Thread Nux!
On 01.10.2012 19:24, Tim Dunphy wrote: Hello list, I am soliciting opinion here as opposed technical help with an idea I 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 use postgres or

Re: [CentOS] s3 as mysql directory

2012-10-01 Thread Tim Dunphy
What a wild idea! :-) I don't think it will work; S3 is not really a filesystem afaik. Hey, well thanks for the compliment! Thing is once you mount your s3 bucket to your local file system via fuse and the s3fs app, your S3 bucket will ACT like a local filesystem in every way. If you read the

Re: [CentOS] s3 as mysql directory

2012-10-01 Thread joel billy
Hi, 700 GB is quite large. What was the amount of data you would have backed up till this point ? Could be that the catalog data is building up, have you looked at http://www.bacula.org/5.0.x-manuals/en/main/main/Catalog_Maintenance.html While your setup in theory should work, have you tested

Re: [CentOS] s3 as mysql directory

2012-10-01 Thread John R Pierce
On 10/01/12 11:24 AM, Tim Dunphy wrote: 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? In other words mount your s3 bucket on /var/lib/mysql databases need fast reliable commited random small block

Re: [CentOS] s3 as mysql directory

2012-10-01 Thread Leon Fauster
Am 01.10.2012 um 20:24 schrieb Tim Dunphy: Hello list, I am soliciting opinion here as opposed technical help with an idea I 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 use postgres or sqlite

Re: [CentOS] s3 as mysql directory

2012-10-01 Thread Craig White
On Oct 1, 2012, at 11:24 AM, Tim Dunphy wrote: Hello list, I am soliciting opinion here as opposed technical help with an idea I 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 use postgres or

Re: [CentOS] s3 as mysql directory

2012-10-01 Thread Paul Heinlein
On Mon, 1 Oct 2012, Craig White wrote: On Oct 1, 2012, at 11:24 AM, Tim Dunphy wrote: I am soliciting opinion here as opposed technical help with an idea I 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