Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Firebird database replication

I have reached the point where I've decided to replace my custom-built replication system with a system that has been built by someone else, mainly for reliability purposes. Can anyone recommend any replication system that is worth it? Is FiBRE any good?

What I need might be a little away from a generic system, though. I have five departments with each having it's own copy of the database, and the master in a remote location. The departments all have sporadic internet connection, the master is always online. The data has to flow back and forth from the master, meaning that all departments need to be equal to the master (when internet connection is available), and to upload changes made during network outage that are later distributed to other departments by the master.

like image 392
Rytis Avatar asked Sep 15 '08 06:09

Rytis


People also ask

Is Firebird a good database?

Firebird is an open source and relational database that provides excellent performance and scales impressively by use of embedded and single user model that provides many SQL and ANSI features.

What is Firebird database used for?

Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers.

What type of database is Firebird?

Firebird is an open-source SQL relational database management system that support Linux, Microsoft Windows, macOS and other Unix platforms. The database forked from Borland's open source edition of InterBase in 2000 but the code has been largely rewritten since Firebird 1.5.


1 Answers

I have used CopyCat to create a replication project. It allows you create your own replication client/server configuration using CodeGear Delphi. This allows you complete flexibilty as to how you want your replication to work.

If you don't use Delphi, or need a prefabricated solution, CopyTiger does the same thing already configured.

like image 196
Rick Long Avatar answered Nov 15 '22 07:11

Rick Long