Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajkumarrai_bis
Yak Posting Veteran
78 Posts |
 Posted - 2009-02-28 : 08:26:02
|
| i am new to high availabilitywe have a sql 2005 active/passive clusteras the load is increasing, we want to upgrade to sql active/active clusterbut at the same time both the clustered sql instances need to be in sync in real time in my opinion, replication is the only solution for real time syncis it possible to setup replication between sql instances in same cluster ? i think its possible however it will sync only few tablesis there any way we can sync whole db in real time while all the connections to the db go on as normal ? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-28 : 09:25:49
|
| Won't Clustering take care of that? |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-02-28 : 15:02:02
|
| >>but at the same time both the clustered sql instances need to be in sync in real time not sure what you mean by above? Are you going to create a copy of the database on the other instance and have your app connecting to both instances and split connections? how are you going to achieve this?I think you are getting confused between the technologies here. you can setup replication between instances on a cluster but failover of the instance will cause it to fail...the real solution to your increasing load will be to identify any performance bottlenecks and fix them, re-design/architect database, add/modify some indexes, and may be add some RAM to your nodes..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
rajkumarrai_bis
Yak Posting Veteran
78 Posts |
Posted - 2009-03-01 : 09:10:22
|
| hi dinakar,yes,we are planning to create a copy of db on the other instance as well.app will be modified to split connections.you are right that whenever failover will happen replication will stop for that time but as soon as failover completes, replication will be up again.as far as hardware improvement is concerned it will not provide high availabilitymy only problem is,how to get these dbs on different instances remain in sync ?replication will only be good for few tables not for whole db.is any third party tool required here ? |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-03-01 : 12:30:19
|
| you can setup peer-peer replication between them but a failover can screw up replication and its not going to pick up when it fails back.. you should test this scenario thoroughly before finalizing on the plan. replication will work for entire db.. the only condition is that all tables should have primary keys. other than the architecture, your drives need to have pretty good throughput so your replication agents can keep up with your production load.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
active/active cluster issues