Skip to content

Synchronized database

Full Size

This pattern has many similarities with the Shared database pattern.

Problem/Context

Solution

Set up a new database and use synchronization mechanisms to move data between the existing and new database. The pattern assumes that data in the new database will be migrated back to the existing database. A variation of this pattern only replicates from existing data to new: Replicated database. The synchronized database pattern can be used to synchronize all or just some data between databases.

Strengths

  • reduced MDE
  • new features early
  • partial replacement possible
  • new database can be on a different platform and have a different structure than existing db.
  • less need for migration

Weaknesses

  • can be brittle
  • corrupt data
  • testing

Examples