Hi Tomislav, I'm a little confused by this scenario-are the databases on the same LAN? The type of replication utilized by Sequoia really only works well when all controllers and databases are on a shared network with very high availability and low latency. If the servers are in fact separated by a WAN link that has less than ideal availability, you should consider asynchronous database replication as an option. Async replication handles link failures much more robustly. If you can clarify the use case a bit more I can offer more advice.
Thanks, Robert P.s., We are working on database-neutral async replication at Continuent and will be releasing a version of it to open source in the next couple of months. On 4/27/08 10:57 AM, "Tomi N/A" <[EMAIL PROTECTED]> wrote: 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 -- Robert Hodges, CTO, Continuent, Inc. Email: [EMAIL PROTECTED] Mobile: +1-510-501-3728 Skype: hodgesrm
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
