From: Matt I. <mat...@bo...> - 2015-04-27 16:23:36
|
I saw a note in the Bacula documentation stating that some users were reporting database corruption problems when using SQLite. I also saw a thread on the mailing list from a couple of years ago where one user wanted to know if he would be better off using Postgresql One user stated he had great luck using SQLite and another simply said he recommended Postgres. I don't want to run a full blown database if I don't need to as my backup needs are not really complicated. I would like to use SQLite but if stability is a problem I'll have to rethink the situation and go with MySQL or Postgres. Does anyone here have experience with using SQLite? |
From: Matt I. <mat...@bo...> - 2015-04-29 13:58:49
|
-----Original Message----- From: Matt Ivie <mat...@bo...> To: bac...@li... Subject: [Bacula-users] SQLite Date: Mon, 27 Apr 2015 09:17:11 -0600 Mailer: Evolution 3.2.3-0ubuntu6+6.0trisquel1 I saw a note in the Bacula documentation stating that some users were reporting database corruption problems when using SQLite. I also saw a thread on the mailing list from a couple of years ago where one user wanted to know if he would be better off using Postgresql One user stated he had great luck using SQLite and another simply said he recommended Postgres. I don't want to run a full blown database if I don't need to as my backup needs are not really complicated. I would like to use SQLite but if stability is a problem I'll have to rethink the situation and go with MySQL or Postgres. Does anyone here have experience with using SQLite? _______________________________________________ Bacula-users mailing list Bac...@li... https://lists.sourceforge.net/lists/listinfo/bacula-users Is there anyone with any experience on this issue? For a little more background I'm going to be doing backups on machines with anywhere from 30GB to 230GB of storage used. I'm guessing that the more files that get put into the tables the more possibility for corruption? Any input on the topic is appreciated. |
From: Dimitri M. <dm...@bm...> - 2015-04-29 15:13:01
|
On 2015-04-29 08:58, Matt Ivie wrote: > Any input on the topic is appreciated. http://www.sqlite.org/howtocorrupt.html The size of the database is determined by the number of files and retention periods. IRL the most likely corruption scenario is the disk going bad, so size doesn't matter. Where it does matter is performance: with a large catalog postgres's query optimizer can make a lot of difference. Dimitri |
From: Matt I. <mat...@bo...> - 2015-04-30 14:30:51
|
-----Original Message----- From: Dimitri Maziuk <dm...@bm...> To: bac...@li... Subject: Re: [Bacula-users] SQLite Date: Wed, 29 Apr 2015 10:12:53 -0500 Mailer: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Thunderbird/31.6.0 On 2015-04-29 08:58, Matt Ivie wrote: > Any input on the topic is appreciated. http://www.sqlite.org/howtocorrupt.html The size of the database is determined by the number of files and retention periods. IRL the most likely corruption scenario is the disk going bad, so size doesn't matter. Where it does matter is performance: with a large catalog postgres's query optimizer can make a lot of difference. Dimitri ------------------------------------------------------------------------------ One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y _______________________________________________ Bacula-users mailing list Bac...@li... https://lists.sourceforge.net/lists/listinfo/bacula-users Thank you Dimitri, your explanation makes perfect sense and puts me at ease to continue using SQLite with bacula. Matt |
From: C M R. <cm...@am...> - 2015-04-29 15:35:02
|
On Wednesday, April 29, 2015 08:58:40 AM Matt Ivie wrote: > -----Original Message----- > From: Matt Ivie <mat...@bo...> > To: bac...@li... > Subject: [Bacula-users] SQLite > Date: Mon, 27 Apr 2015 09:17:11 -0600 > Mailer: Evolution 3.2.3-0ubuntu6+6.0trisquel1 > > I saw a note in the Bacula documentation stating that some users were > reporting database corruption problems when using SQLite. I also saw a > thread on the mailing list from a couple of years ago where one user > wanted to know if he would be better off using Postgresql > > One user stated he had great luck using SQLite and another simply said > he recommended Postgres. I don't want to run a full blown database if I > don't need to as my backup needs are not really complicated. I would > like to use SQLite but if stability is a problem I'll have to rethink > the situation and go with MySQL or Postgres. > > Does anyone here have experience with using SQLite? > > _______________________________________________ > Bacula-users mailing list > Bac...@li... > https://lists.sourceforge.net/lists/listinfo/bacula-users > > > Is there anyone with any experience on this issue? > > For a little more background I'm going to be doing backups on machines > with anywhere from 30GB to 230GB of storage used. I'm guessing that the > more files that get put into the tables the more possibility for > corruption? > > Any input on the topic is appreciated. Matt, I've been using SQLite for as long as I have used Bacula, perhaps fourteen or fifteen years and have had zero problems. I have a small operation with ten or twelve PC's (running Debian stable) and a couple of servers. Disk backups are run nightly and a tape backup weekly. I've read all the recommendations to run Postgres or MySQL but my philosophy has been "if it ain't broke, don't fix it!" and just keep running SQLite. It's easy to set up & manage, performance has not been a problem and it doesn't tie up a lot of system resources. Cheers! CMR -- Debian "Wheezy" Registered Linux User #241964 ---- "In the first place we should insist that if the immigrant who comes here in good faith becomes an American and assimilates himself to us, he shall be treated on an exact equality with everyone else, for it is an outrage to discriminate against any such man because of creed, or birthplace, or origin. But this is predicated upon the man's becoming in very fact an American, and nothing but an American." -- Theodore Roosevelt ------ |
From: Matt I. <mat...@bo...> - 2015-04-30 14:34:19
|
-----Original Message----- From: C M Reinehr <cm...@am...> Reply-to: bac...@li... To: bac...@li... Subject: Re: [Bacula-users] SQLite Date: Wed, 29 Apr 2015 10:04:15 -0500 Mailer: KMail/1.13.7 (Linux/3.2.0-4-amd64; KDE/4.8.4; x86_64; ; ) On Wednesday, April 29, 2015 08:58:40 AM Matt Ivie wrote: > -----Original Message----- > From: Matt Ivie <mat...@bo...> > To: bac...@li... > Subject: [Bacula-users] SQLite > Date: Mon, 27 Apr 2015 09:17:11 -0600 > Mailer: Evolution 3.2.3-0ubuntu6+6.0trisquel1 > > I saw a note in the Bacula documentation stating that some users were > reporting database corruption problems when using SQLite. I also saw a > thread on the mailing list from a couple of years ago where one user > wanted to know if he would be better off using Postgresql > > One user stated he had great luck using SQLite and another simply said > he recommended Postgres. I don't want to run a full blown database if I > don't need to as my backup needs are not really complicated. I would > like to use SQLite but if stability is a problem I'll have to rethink > the situation and go with MySQL or Postgres. > > Does anyone here have experience with using SQLite? > > _______________________________________________ > Bacula-users mailing list > Bac...@li... > https://lists.sourceforge.net/lists/listinfo/bacula-users > > > Is there anyone with any experience on this issue? > > For a little more background I'm going to be doing backups on machines > with anywhere from 30GB to 230GB of storage used. I'm guessing that the > more files that get put into the tables the more possibility for > corruption? > > Any input on the topic is appreciated. Matt, I've been using SQLite for as long as I have used Bacula, perhaps fourteen or fifteen years and have had zero problems. I have a small operation with ten or twelve PC's (running Debian stable) and a couple of servers. Disk backups are run nightly and a tape backup weekly. I've read all the recommendations to run Postgres or MySQL but my philosophy has been "if it ain't broke, don't fix it!" and just keep running SQLite. It's easy to set up & manage, performance has not been a problem and it doesn't tie up a lot of system resources. Cheers! CMR -- Debian "Wheezy" Registered Linux User #241964 ---- "In the first place we should insist that if the immigrant who comes here in good faith becomes an American and assimilates himself to us, he shall be treated on an exact equality with everyone else, for it is an outrage to discriminate against any such man because of creed, or birthplace, or origin. But this is predicated upon the man's becoming in very fact an American, and nothing but an American." -- Theodore Roosevelt ------ Thanks CMR for the information. I'm glad to hear of a real world experience like this because it really is the proof that makes all the difference. I agree with you, if it ain't broke don't fix it! Matt |