List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:May 3 2004 9:53am
Subject:Re: Accessing DBMS remotely: MySQL? FireBird?
View as plain text  
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

Thread
Accessing DBMS remotely: MySQL? FireBird?The masked marvel2 May
  • Re: Accessing DBMS remotely: MySQL? FireBird?Martijn Tonies3 May
  • Re: Accessing DBMS remotely: MySQL? FireBird?David Griffiths4 May
Re: Accessing DBMS remotely: MySQL? FireBird?The masked marvel5 May
  • Re: Accessing DBMS remotely: MySQL? FireBird?Martijn Tonies5 May