Take a multi-master snapshot (dommrsnapshot) v7
For MMR only: The dommrsnapshot command performs snapshot synchronization on the specified primary node in a multi-master replication system.
Synopsis
-dommrsnapshot pubname –repsvrfile pubsvrfile -pubhostdbid dbid [ -verboseSnapshotOutput { true | false } ]
Parameters
pubname
The name of the publication for which to take the snapshot.
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 to display the output from the snapshot. Set this option to false if you don't want to display the snapshot output. The default is true.
Examples
This example performs snapshot replication 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.
- On this page
- Synopsis
- Parameters
- Examples