Hm, that's an interesting case that I don't quite follow. But you could definitely use Bedrock on 2 nodes, and Bedrock would handle realtime replication from one to the other. This would provide an instant offsite backup. Granted, if there were only 2 nodes, you couldn't take one offline, as the other one wouldn't have quorum. If your goal is to not just have a backup, but also copy that backup to tape, I actually recommend a 3 node deployment. This way you can take one node offline and the remaining two still have quorum.
Now, another crazy idea would be to have a 2 node cluster, where one of the nodes is a "permaslave". Permaslaves don't participate in quorum, so taking it offline wouldn't affect the master -- which would go forward exactly as if it were alone (because from a quorum perspective, it is, and thus it always represents its own quorum). This *might* "just work" out of the box, I haven't tried it. But it's an interesting case! -david On Wed, Oct 19, 2016 at 6:17 AM, Stephen Chrzanowski <pontia...@gmail.com> wrote: > So am I to understand you just "server-ized" SQLite with Bedrock? > > Looks rather interesting. I was just talking to my IT manager about how I > can take something like a SQLite backup and put it somewhere else so it'll > eventually get to tape, but, if I run a node on my local machine, run one > on the 'primary' and another on the 'backup' of the primary, it'd satisfy > quorum, and I'd be thinking less of backups. (But its still a thought) > > Is there a way to disable the check for quorum and either let the split > brain happen, or at least make the executive decision to which is the > primary data source at all times? In the tool I'll be writing, it COULD > happen that only one node would be available. We typically run our servers > here at work in primary/secondary fashion, no tertiary, so if the primary > goes away, and its only the secondary, then my software would go down, > which is something I obviously want to avoid. We also do typically one-way > replication. > > Is there a mechanism that will allow me to run the Backup API to dump the > database on a particular node? > > > On Tue, Oct 18, 2016 at 8:45 PM, David Barrett <dbarr...@expensify.com> > wrote: > > > Love SQLite? Wish you could use it to power your enterprise SaaS or web > > service? Now you can! Check out Expensify Bedrock, our distributed > > transaction layer built atop SQLite, powering Expensify's millions of > > users. More information is here: > > > > http://bedrockdb.com > > > > > > Keep all the power and simplicity of SQLite, but wrapped in a package > that > > provides network accessibility, WAN-optimized replication, and > distributed > > ACID transactions. Under continuous development and operation for the > past > > 8 years, now it's open sourced and ready for your production use. > > > > Thank you to the SQLite team for not only producing such an incredible > > database, but helping with our countless questions and demanding > > requirements. I'm ecstatic to share this with you, and I hope you enjoy > it > > too! > > > > -david > > Founder and CEO of Expensify > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users