> 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
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
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.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL