I've done a quick scan of the archives about "synchronizing databases", but there seem to have been few posts on it since <URL:https://groups.google.com/d/msg/web2py/myTf5eedMc8/6xLmScVVH48J> in 2011. And that post, referencing <URL:http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#CSV-and-remote-database-synchronization> seems to be more concerned about occasional synchronization than continuous synchronization.
Has anybody done the latter? On StackOverflow, there's mentions of SymmetricDS and MySQL master-master synchronization <URL:http://www.symmetricds.org/about/overview> By using database triggers, SymmetricDS guarantees that data changes are > captured and atomicity is preserved. Support for database vendors is > provided through a Database Dialect layer, with implementations for MySQL, > Oracle, SQL Server, SQL Server Azure, PostgreSQL, DB2, Informix, Interbase, > Firebird, HSQLDB, H2, Apache Derby, Greenplum, and SQLite included. > and SymmetricDS is developed and maintained by JumpMind, Inc, a commercial open > source company. JumpMind sponsors the open source project and dedicates its > software developers to lead the development. The software is made available > as both open source and the commercial SymmetricDS Pro product. > and more info on MySQL M2M is at <URL:https://www.howtoforge.com/mysql_master_master_replication> There's a hint here in W2P-Users that PostGRES also has replication or synchronization. I see this as being primarily a fail-over need or supporting multiple deployments (think in terms of a company with worksites in multiple cities, and a local server for each), but while I'd like to synchronize properly, honesty requires me to admit that in my own current usage I'm only talking about tens of updates per week, so I'm sort of shopping for a 3/4 ton pickup truck to make sure I can carry a couple of bags of groceries and the occasional bag of catfood. That said, anyone here have experience in such synchronization? What's a realistic expectation for the propagation delay? Is this subject to loads, such that a flurry of activity would adversely impact synchronization? Is this all hidden in the database plumbing, or does it have an effect on controllers for W2P apps? Thanks for your thoughts and experiences. /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
