Subscribing to audit publications
You can create either push or named pull subscriptions for an audit log database. When you create the subscription, you should always accept the default options unless specified otherwise in the following instructions (notice that there are no conflicts to resolve in this type of iBase database).
About this task
- Start a new subscription, either a push subscription or a named pull
Option Description Publication The database that contains the iBase entity and link data at the Publisher. Subscription database The existing entity and link database at the Subscriber.Select the following options for the subscription:
- The Subscriber does not have the schema and data and should therefore be initialized.
- The Merge Agent should continuously check for updates.
- Use the Publisher as a proxy for the Subscriber when resolving conflicts (described as First to Publisher Wins).
- The subscription is a client subscription type
- Depending on the subscription type, set the Merge Agent to initialize the subscription immediately.
- Verify that the snapshot is applied by checking that a rowguid column exists in the _ AuditLog table. If this column is missing, check that the snapshot is applied.
- Set the Merge Agent for the Subscriber to run at the required frequency, for example a polling interval of 1 second.
- Test that replication is working correctly for the new subscription. Use one of the
- At the Publisher, in the _ AuditLog table, change one of the user names.
- After the change is replicated, check the corresponding table at the Subscriber.
- At the Subscriber, change the column back to its original value.
- After the change is replicated, check the table at the Publisher. If the Subscriber is supposed to be read-only, and the change is merged at the Publisher, check the setting of the Merge Agent.
- If the Subscriber is read-only, change the data at the Publisher back to its initial value.
- Restrict access to the tables in the SQL Server database. See the Administration Center document Managing Access Control, for details. The information in this document applies to all types of iBase database.
- Back up the databases.
- Tell the iBase administrator that the security data at the Subscriber is configured for replication.