Designing and preparing databases for synchronization
After you install solidDB® on each machine, you are ready to prepare and design your databases for synchronization. This requires the following tasks:
▪Define master and replica databases.
▪Create your database schema according to advanced replication guidelines.
▪Create catalogs if you have a multi-master environment or you are using different schema names in your master and replica database.
▪Define concurrency conflict handling in synchronized tables, i.e. determine if the tables should use optimistic or pessimistic concurrency control.
▪Provide user access required for synchronization.
▪Set up backups of the master database and large replicas.
▪Design application(s) for data synchronization.
See also