Expert Advice

Expert Advice

Dear Professional,

I would like to ask couple of question in terms of Load Balancing, 
Replication, Database Mirroring.

1. Our organization has two production servers, one is on Toronto and other 
one is on New York. In New York I have five databases and Toronto I have 
nine databases.

Now the requirement is I have to create two instance in New York box and top 
of that we have to install F5 BIG IP so that we can use Load Balancing as 
well as have to create Merge Replication so that both the instance would 
work as Active Active...

Question, is there any other way we can use Active Active or the above 
solution is the best one?

2. Now the requirment is if any thing update on New York Box then it has to 
replicate on Toronto. I think Transaction Replication is the best solution? 
Am I right? Is it possible if user want to retrive any data it calls the 
data from Toronto box and if the user want to update the data the 
application point to New York box and replicate the data to Toronto 
automatically through Transaction Replication, is it possible?

3. A part from Merge Replication and Transaction Replication, I have to 
create Data Mirroing for Disaster Recovery, Is is possible I can use same 
database for Merge Replication and Database Mirroring ?

I would appreciate if anyone help me out?

Thanks

date: Sun, 15 Jun 2008 21:12:03 -0400 author: Noor

RE: Expert Advice

1. Whether merge replication and active/active' configuration you described 
make sense depends on your business requirements. For many apps that must 
maintain a single copy of truth (e.g. your bank account), this would not make 
sense. 

2. Transactional replication should work for the scenario you described.

3. You can't use a database mirror for transactional/merge replication. 

Linchi

"Noor" wrote:

> Dear Professional,
> 
> I would like to ask couple of question in terms of Load Balancing, 
> Replication, Database Mirroring.
> 
> 1. Our organization has two production servers, one is on Toronto and other 
> one is on New York. In New York I have five databases and Toronto I have 
> nine databases.
> 
> Now the requirement is I have to create two instance in New York box and top 
> of that we have to install F5 BIG IP so that we can use Load Balancing as 
> well as have to create Merge Replication so that both the instance would 
> work as Active Active...
> 
> Question, is there any other way we can use Active Active or the above 
> solution is the best one?
> 
> 2. Now the requirment is if any thing update on New York Box then it has to 
> replicate on Toronto. I think Transaction Replication is the best solution? 
> Am I right? Is it possible if user want to retrive any data it calls the 
> data from Toronto box and if the user want to update the data the 
> application point to New York box and replicate the data to Toronto 
> automatically through Transaction Replication, is it possible?
> 
> 3. A part from Merge Replication and Transaction Replication, I have to 
> create Data Mirroing for Disaster Recovery, Is is possible I can use same 
> database for Merge Replication and Database Mirroring ?
> 
> I would appreciate if anyone help me out?
> 
> Thanks
> 
> 
> 
>

date: Sun, 15 Jun 2008 22:44:01 -0700 author: Linchi Shea

RE: Expert Advice

thanks for your reply Linchi, let say I have db1 on server1 and it has merge 
replication on db2 on server2 and transaction replication on db3 on server3, 
now i want to create database mirroring on db1 from server1 and that has 
mirror to db1 on server4? is it possible.

thanks


"Linchi Shea" wrote:

> 1. Whether merge replication and active/active' configuration you described 
> make sense depends on your business requirements. For many apps that must 
> maintain a single copy of truth (e.g. your bank account), this would not make 
> sense. 
> 
> 2. Transactional replication should work for the scenario you described.
> 
> 3. You can't use a database mirror for transactional/merge replication. 
> 
> Linchi
> 
> "Noor" wrote:
> 
> > Dear Professional,
> > 
> > I would like to ask couple of question in terms of Load Balancing, 
> > Replication, Database Mirroring.
> > 
> > 1. Our organization has two production servers, one is on Toronto and other 
> > one is on New York. In New York I have five databases and Toronto I have 
> > nine databases.
> > 
> > Now the requirement is I have to create two instance in New York box and top 
> > of that we have to install F5 BIG IP so that we can use Load Balancing as 
> > well as have to create Merge Replication so that both the instance would 
> > work as Active Active...
> > 
> > Question, is there any other way we can use Active Active or the above 
> > solution is the best one?
> > 
> > 2. Now the requirment is if any thing update on New York Box then it has to 
> > replicate on Toronto. I think Transaction Replication is the best solution? 
> > Am I right? Is it possible if user want to retrive any data it calls the 
> > data from Toronto box and if the user want to update the data the 
> > application point to New York box and replicate the data to Toronto 
> > automatically through Transaction Replication, is it possible?
> > 
> > 3. A part from Merge Replication and Transaction Replication, I have to 
> > create Data Mirroing for Disaster Recovery, Is is possible I can use same 
> > database for Merge Replication and Database Mirroring ?
> > 
> > I would appreciate if anyone help me out?
> > 
> > Thanks
> > 
> > 
> > 
> >

date: Fri, 4 Jul 2008 20:09:01 -0700 author: Rogers