On 08/07/2012 07:47 AM, Tyler J. Wagner wrote: > On 2012-08-07 15:07, Tobias Stroh wrote: > I do not understand why people object to MySQL for this.
I think one of the big attractions to backuppc is the ease of getting it going. > If you're going to > use a database, use a good one. I'd expect backuppc's usage to be very simple. Basically metadata -> sha512 mapings. > Sqlite is fine for small, simple apps doing > a small number of transactions. Having written and benchmarked code for doing backuppc stuff recently I wouldn't agree. Do you think that sqlite operations on metadata are likely to be a bottleneck for normal backuppc type operations? Seems like 99.9% of the use would be: select * from checksums where checksum=<checksum> Or: insert into files metadata=<metadata> insert into checksums file=<file>, checksum=<checksum> I'd be pretty surprised if anything like that where sqlite would be a limiting factor. > BackupPC is not that. MySQL is fast > (enough), reliable (enough), and well understood with tons of useful HOWTOs > and software tools (phpmyadmin, mytop, mysqldump, webmin). Right, sure. It is however very complex. So in a disaster, your important server is down... someone is yelling at you to get your files back.... Do you want to copy over a perl script that looks at sqllite and has a uber simple restore.pl command? Or do you want to first have to restore mysql contents, permissions, lock files, my.cnf, recover the root password, get it running, then try to restore? Sure, I'm all for a SQL agnostic layer, but I don't see why the default should be anything but something simple/trivial/invisible to the user like sqlite. ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ BackupPC-devel mailing list BackupPC-devel@lists.sourceforge.net List: https://lists.sourceforge.net/lists/listinfo/backuppc-devel Wiki: http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/
