Caravan Business Server>Help>Database>Replicate records at real time |
Syntax
|
<CARAVAN>connection object(_location)=" server1,server2…."</CARAVAN> <CARAVAN>connection object(_priority)=" priority"</CARAVAN>
Where server is a location defined in the hosts file and priority is any numeric value. Higher the number, higher will be the priority. Records replicated with higher priority will get replicated first.
|
Text
|
Caravan Database server provides record based replication as well. You can also set a priority for database replication. Records with higher priority will get replicated first the records will a lower priority. You can use this feature to replicate a record as and when a record is inserted follow this method. This method also can be used to take backup of the database on the standby server at real time.
|
Sample
|
Replication to a single destination <CARAVAN> company(CompanyName)="Niti Telecom" company(Address)="D-83/MIG Colony" company(City)="Mumbai" company(StateorProvince)="Maharashtra" company(Country)="India" company(Website)="http://www.nititelecom.com" //replicate the new company added in another location company(_location)="Florida" //set a priority for replication company(_lpriorityocation)="1" // insert the record company(insert) </CARAVAN>
Replication to multiple destination <CARAVAN> //replicate the new company added to multiple locations //set delimiter to insert multiple values company(delim)="," company(_location)="Florida,Georgia" //set a priority for replication company(_priority)="1" //insert the record company(insert) </CARAVAN>
|
Back
|