Database is the most crucial component of IT systems. In order to achieve high availability of applications using it replication mechanisms have been developed.
Replication in EuroDB provides the capability to distribute physical copies of databases between different instances, data centres, and even continents. In addition, replication on the logical layer allows to use different data sources to create complex database structures.
EuroDB supports the majority of popular replication methods. Two of these methods are recommended by EuroDB for their capabilities and usefulness.
In cases of increased architecture complexity, EuroDB offers a more sophisticated mechanism – logical replication:
- Grid replication – multiple master servers, multiple slave servers
- Replication with granularity to a single table
- Replication of specific DML types (or combinations thereof)
- No DDL replication – protection of data structure in replicas
- No automatic replication of newly created objects – higher level of security
- Replication of individual databases within a cluster
- Replicas in read/write mode – different conflict resolution mechanisms
- Ability to modify the replication scope
- Ability to use logical replication to update between major versions of EuroDB (rolling upgrade)
- Logic replication is not based on trigger functions.