Hi everyone, to begin with, I'm thrilled to see what sequoia seems to offer: hat's of to the people that made it happen!
Now, I have a specific use case I'd like your opinions on... I (will) have 2 databases, one local and one on a dedicated server on the Internet. The local database is connected to the Internet with a 2Mbit undedicated symmetric link with a fixed IP address. I want to set things up so that they work as RAIDb-1 with the controller on the local db instance, propagating changes to both servers. I would load-balance read requests so that local requests never go to the Internet server. What I'm worried about is link failures and bandwith capacity. I would like to have sequoia register a link failure (via a timeout) and when the link is up again (presumably between a minute and an hour later) to have it send the missing changes to the Internet database to get it up to date. The only possibility I know of so far is manually backing up a local instance, restoring it on the Internet instance and plug the Internet instance back in. Is it the only way and can this be automated? Secondly, is using sequoia to pass low volume writes (several records/minute) over a 2Mbit link feasible? Cheers, Tomislav _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
