NEC Storage ReplicationControl SQL Option, User Manual

Page: 19 / 104

Chapter 2 Overview of NEC Storage ReplicationControl SQL Option
13
2
2
2
.
.
.
4
4
4
.
.
.
3
3
3
P
P
P
a
a
a
r
r
r
a
a
a
l
l
l
l
l
l
e
e
e
l
l
l
P
P
P
r
r
r
o
o
o
c
c
c
e
e
e
s
s
s
s
s
s
i
i
i
n
n
n
g
g
g
o
o
o
f
f
f
O
O
O
p
p
p
e
e
e
r
r
r
a
a
a
t
t
t
i
i
i
o
o
o
n
n
n
s
s
s
A
A
A
c
c
c
c
c
c
o
o
o
m
m
m
p
p
p
a
a
a
n
n
n
i
i
i
e
e
e
d
d
d
b
b
b
y
y
y
U
U
U
p
p
p
d
d
d
a
a
a
t
t
t
e
e
e
By creating and separating an RV of the business operation database, the database can be used by other
servers. This is used for constructing test environments.
When constructing an environment, replications of the database can be made without suspending
operations using the Microsoft SQL Server 2000. When the business operations load is lower, the MV
and the RV are synchronized and separated.
Figure 2-5 Parallel processing of Operations Accompanied by Update
(a) During the daytime, keep the MV and the RV separate.
(b) During the nighttime, stop parallel operation, synchronize and separate the MV and the RV.
(c) Execute the operation DB and the replication DB in parallel. (RV being the data of the previous
day)
Reflecting the
updated part
Nighttime
Data from previous day
Update
work
Connect
Daytime
Search
work
Master
Volume
(MV)
Replication
Volume
(RV)
Business
Volume
(MV)
Master
database
Master
database
Separate
Replication
Volume
(RV)