April 6, 2011 at 8:05 am
Hi All,
Apologies if this is a badly described scenario but this is not really my field so here goes:
We are currently planning on implementing a clustered sql server 2008 solution with an Active / Passive set up. On the same servers we have a second instance of SQL Server running, this also is running Active / Passive but this is inverse of the first instance i.e.
Instance | Server1 / Server 2
A Active / Passive
B Passive / Active
I am not from a SQL background and am not involved in the implementation so I don't know the reasons behind this. However I have been tasked with setting up SQL Transactional Replication on the second instance to replicate some of the tables in a database in the first instance of SQL.
My questions are as follows:
1) Is this possible
2) If Instance A fails over to Server 2 will the replication continue working
3) If Instance B failes over to Server 1 will the replication continue working
4) Is there any gotcha's to plan for
5) Do I have to do anything different from setting up transactional replication on a non-clustered environment
I have previously set up transactional replication on a non-clustered environment and had no issues but the clustering is a whole new ball game for me, so any help or advice would be greatly appreciated.
Regards,
Gary
April 6, 2011 at 5:13 pm
fail.gary (4/6/2011)
Instance | Server1 / Server 2A Active / Passive
B Passive / Active
This is an Active\Active cluster as you have an instance of SQL Server active on each of the cluster nodes!
fail.gary (4/6/2011)
I am not from a SQL background and am not involved in the implementation so I don't know the reasons behind this. However I have been tasked with setting up SQL Transactional Replication on the second instance to replicate some of the tables in a database in the first instance of SQL.My questions are as follows:
1) Is this possible
2) If Instance A fails over to Server 2 will the replication continue working
3) If Instance B failes over to Server 1 will the replication continue working
4) Is there any gotcha's to plan for
5) Do I have to do anything different from setting up transactional replication on a non-clustered environment
I have previously set up transactional replication on a non-clustered environment and had no issues but the clustering is a whole new ball game for me, so any help or advice would be greatly appreciated.
Regards,
Gary
The cluster is\should be transparent to the applications and you should treat the replication the same as for non clustered. Whether clustered or non clustered they all have a unique instance name and that is all you need. Get yourself up to speed with clusters as quick as possible if you need to manage them
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2011 at 3:03 am
Hi Perry,
Thanks for the reply, fortunately I don't need to manage the clusters, that is being done by another part of our IT department. I work on our integration team hence the lack of knowledge on the server side.
If there is no difference in setting up replication in a clustered environment then I am happy.
Thanks again,
Gary
April 7, 2011 at 4:07 am
I agree with Perry. I have such configuration under my support and replication works just fine.
M&M
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply