May 27, 2011 at 5:50 pm
Are there any third party real-time replication products available for SQL server that will synchronize 2 or more identical SQL server instances to allow horizontal scaling of the database across multiple database servers?
I understand the limitations of SQL Server clustering and this seems to be one area where Oracle is still in the lead even though the Oracle RAC requires that the database still be accessed through a central database all the servers in the cluster can share the database processing load.
With the third party solutions or SharePlex and Tungsten it sounds like they provide true synchronization (real-time bidirectional replication )between identical databases and even allow one of the database nodes to be offsite at another location (great for disaster recovery).
I'm hoping something like this is available for SQL server too but if it is then I'm not Googling the right words...
May 28, 2011 at 1:15 am
Create Active/Active cluster installation of SQL Server,its mean multiple instances on more than 1 node and then create merge replcation between these instances and then use network load balancing NLB server infront of cluster IP
It will cover HA
It will give Load Balancing also
Similar to RAC
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
May 31, 2011 at 6:27 am
no merge replication does not load balance.
You can load balance sql server ( don't need clusters ) by using peer to peer replication.
Your clients need load balancing to share the connections to your replicated databases.
peer to peer works both ways. ( this assumes you have more readers than writers of course )
I've tested peer to peer in this manner and I've seen microsoft folks do it ( with sql 2005 ) no client of mine has yet had the courage ( or the correct database design ) to implement it though.
Federated servers can distribute processing, I've also tested this extensively, but never implemented into production. ( but it's not true load balancing )
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
May 31, 2011 at 9:21 am
In this scenerio of cluster and requirement Merge Replication can balance the load you will have 2 SQL Server resource IPs in the cluster then you will configure the NLB(MS Network Load Balance) Server infront of both
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply