Hi Fred, > > Some of our customers have remote offices. I was wondering if it'd be safe > to have a DBMS running at their central office, and have our client > application running on hosts in the branches connect to it through a VPN > via the Net?
If the connection is reasonably stable, and you cache often used static data, you sure can. > What happens if the connection goes south while a branch office was making > changes? Does the DBMS just rollbacks changes automatically after a time-out? For Firebird, I am sure about this: yes. it will do a Rollback. For MySQL, I expect it to do the same. > Should we set up some kind of replication instead? > > Also, are there compeling reasons to go for Firebird instead of MySQL? I > don't know enough about the capabilities of each DBMS today to make an > educated choice. That depends - Firebird has quite some features that MySQL doesn't have. On the other hand, MySQL has built in replication, which Firebird doesn't have. However, if you need to do some more server-processing, Firebird has stored procedures, triggers, views and check constraints, all of which MySQL doesn't have. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
