I have a database which requires merge replication which can be horizontally
partitioned into 25 branches.
Would this create 25 distribution databases and is there a high impact on
the performance on updating these databases?
Or is the best solution to use is dynamic horizontal partitioning?
Thanks
mm,
there is no need for more than one distribution database. Your options are
to create 25 separate publications and a distinct subscriber for each or (as
you say) you can use dynamic horizontal partitioning. I would favour the
latter as it is less administration, especially if any schema changes are
needed. To implement, you can easily add -HOSTNAME as a merge agent
parameter for each subscriber, and use this to filter.
Regards,
Paul Ibison
Monday, March 19, 2012
Dynamic horizontal partitioning
Labels:
branches,
create,
database,
databases,
distribution,
dynamic,
horizontal,
horizontallypartitioned,
merge,
microsoft,
mysql,
oracle,
partitioning,
replication,
requires,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment