EnterpriseDB: Create Subscription
Oracle Tips by
Subscription defines the target and links the target database to the
published source. Enter the subscription name and connection
information. If the Publication Name drop down is empty, press
the Load button to refresh the list.
Associate the subscription to the publication as shown in Figure 7.11.
7.11: Link Subscription to Publisher
Create to create the subscription.
turning on synchronization, a snapshot must be taken to create the
replicated objects in the EnterpriseDB instance. The snapshot
copies all of the replicated structures, including indexes and other
reporting, you may have different index requirements than you would in
an Oracle OLTP or OLAP database. After running the snapshot, you
may drop and/or create any indexes that you feel may help performance.
Do not alter the structure of any replicated tables or you might break
any triggers that are copied and decide if they are needed in the
replicated instance. In most situations, they are not required.
get to the Taking Snapshot dialog (Figure 7.12) by right-clicking on
the subscription identified above and choosing Take Snapshot.
7.12: Take Initial Snapshot
the Take Snapshot button and examine the output window for any errors
before proceeding. You will only need to take the snapshot one
synchronization is the process of catching the target up with the
source database. Most forms of replication are to synchronize
multiple instances. You can get to the Synchronize dialog
(Figure 7.13) by right-clicking on the subscription and selecting
7.13: Force a Synchronize
synchronization process may run for several minutes depending on how
much data is being synchronized. Wait for a successful
completion before moving on to the next step.
is possible to manually synchronize your databases, doing so kind of
defeats the purpose of having an enterprise class replication tool.
probably want to schedule an automatic refresh. Depending on
your uses and needs, you may want a near, real-time refresh or a more
relaxed refresh such as daily, weekly, or monthly. You may also
schedule refreshes via crontab.
to make is that replication is never truly real-time. At best,
transactions will experience some percentage of time delay. It
takes time to enqueue captured transactions at the source, propagate
to the target and then apply them at the target.
Schedule Task Wizard (Figure 7.14) is the tool within the Replication
Console that will allow you to schedule your replication jobs.
7.14: Configure Schedule
choose a complete refresh on each run (Snapshot) or you may choose to
synchronize. For this example, I will choose Synchronize.
mentioned above, you may choose to schedule the replication
continuously (near real-time), daily, weekly, monthly or via crontab.
example, I am choosing continuously (Figure 7.15) but I will display
each of the other screens to give you an idea of the information
required to fill them out.
7.15: Continuous Synchronization
Continuous replication, you configure a refresh rate to gather and
apply changes. Remember that the more often you refresh, the
heavier the load on both the source and the target databases.
Daily replication task (Figure 7.16), you define the hour and minute
that you want to begin the synchronization.
7.16: Daily Synchronization
Weekly replication task (Figure 7.17), you define the hour and minute,
as well as the days of the week that you want to begin the
7.17: Weekly Synchronization
Monthly replication task (Figure 7.18), you define the hour and
minute, the day of the month and which months that you want to begin
7.18: Monthly Synchronization
crontab scheduling (Figure 7.19), you must define a valid crontab
expression. You must also have cron running to schedule jobs via
7.19: Cron Synchronization
successfully defining the scheduling method you require, press the
Next button to arrive at the Schedule Summary dialog (Figure 7.20).
Verify that the summary accurately reflects your choices and press the
7.20: Complete Schedule
schedule has been defined, the replication server will ensure that it
executes the data movement as scheduled. You can view the
replication log and real-time monitor by clicking to the lowest node
beneath the subscription service.
is an excerpt from the book "EnterpriseDB:
The Definitive Reference" by Rampant TechPress.