Take a Multi-Master Snapshot (dommrsnapshot) v6.2
For MMR only: The dommrsnapshot command performs snapshot synchronization on the specified primary node in a multi-master replication system.
-dommrsnapshot pubname
–repsvrfile pubsvrfile
-pubhostdbid dbid
[ -verboseSnapshotOutput { true | false } ]Parameters
pubname
The name of the publication for which the snapshot is to be taken.
pubsvrfile
The file containing the publication server login information.
dbid
The publication database ID of the target primary node for the snapshot replication.
-verboseSnapshotOutput
Set this option to true if you want the output from the snapshot to be displayed. Set this option to false if you do not want the snapshot output displayed. If omitted, the default is true.
Examples
In the following example snapshot replication is performed on publication emp_pub to the target primary node identified by publication database ID 9.
$ java -jar edb-repcli.jar -dommrsnapshot emp_pub \ > -pubhostdbid 9 \ > -repsvrfile ~/pubsvrfile.prop Performing snapshot... Source database connectivity info... conn =jdbc:edb://192.168.2.6:5444/edb user =pubuser password=****** Target database connectivity info... conn =jdbc:edb://192.168.2.7:5444/MMRnode user =MMRuser password=****** Connecting with source EnterpriseDB database server... Connecting with target EnterpriseDB database server... Importing enterprisedb schema edb... Table List: 'dept','emp' Loading Table Data in 8 MB batches... Disabling FK constraints & triggers on edb.dept before truncate... Truncating table dept before data load... Disabling indexes on edb.dept before data load... Loading Table: dept ... [dept] Migrated 5 rows. [dept] Table Data Load Summary: Total Time(s): 0.247 Total Rows: 5 Disabling FK constraints & triggers on edb.emp before truncate... Truncating table emp before data load... Disabling indexes on edb.emp before data load... Loading Table: emp ... [emp] Migrated 14 rows. [emp] Table Data Load Summary: Total Time(s): 0.163 Total Rows: 14 Enabling FK constraints & triggers on edb.dept... Enabling indexes on edb.dept after data load... Enabling FK constraints & triggers on edb.emp... Enabling indexes on edb.emp after data load... Performing ANALYZE on EnterpriseDB database... Data Load Summary: Total Time (sec): 0.8 Total Rows: 19 Total Size(MB): 0.0 Schema edb imported successfully. Migration process completed successfully. Migration logs have been saved to /var/log/xdb-rep/build57l ******************** Migration Summary ******************** Tables: 2 out of 2 Constraints: 4 out of 4 Total objects: 6 Successful count: 6 Failure count: 0 ************************************************************* Snapshot taken successfully.