On 2012-08-07 16:35, Les Mikesell wrote: > On Tue, Aug 7, 2012 at 10:20 AM, Tyler J. Wagner <ty...@tolaris.com> wrote: >>> >> Network overhead via local socket is tiny. Compared to loading and >> unloading sqlite databases, MySQL is a a huge gain. > > Loading? Why would you stop/start backuppc any more often than your > mysql daemon?
Sorry, I misunderstood. I thought the design called for multiple small sqlite databases, not just one that's kept open. If that's the case, it makes more sense. Except then you have the problem of when that DB is written out, and how to dump it for backup or moving. As you later said, you get easy redundancy with MySQL. > Another thing to consider is the difficulty of moving your > installation from one machine to another (probably with a different or > upgraded OS, possibly with a different CPU type) without losing > history, Or making duplicate copies for offsite storage. Having to > deal with a separate daemon and a separately-changing data format adds > complications for not-much benefit unless it also lets you scale up or > gives you redundancy. That's not a problem for anyone who has ever moved a website. You move files independently from the database. For a simple move or backup, it's easy to script mysqldump+rsync+mysql. Apropos (or perhaps ironic) to this discussion, all of my servers running MySQL run webmin, and so have MySQL backups made daily. This gets grabbed by BackupPC daily, so I have a reasonably stable DB state in BackupPC. Regards, Tyler -- "Copyright is a bargain, not property. We agreed not to copy because they agreed it would only be for a short period of time. They have broken their end of the bargain; we are now breaking ours." -- Russell Nelson ------------------------------------------------------------------------------ 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/
