| Groups | Blog | Home |
sql server clustering : Connecting SQL Clustering from 2 different sites
in-line
[quoted text, click to view] <subscrib3@gmail.com> wrote in message news:1187258221.606896.189050@z24g2000prh.googlegroups.com... > Hi all.. hope someone can help me on this.. I'm a beginner and have > limited knowledge on clustering. > > I managed to setup 2 set active/passive cluster with SQL clustering on > 2 different site which is connected through lease line. > > Plant 1: > Cluster IP : 192.168.128.150 > SQL Cluster IP: 192.168.128.200 (VIRTUSQLS1) > Node1: 192.168.128.10 > Node2: 192.168.128.11 > > Plant 2: > Cluster IP: 192.168.128.2.150 > SQL Cluster IP: 192.168.2.200 (VIRTUALSQLS2) > Node1: 192.168.2.10 > Node2: 192.168.2.11 > > A few questions here: > > 1. Why all nodes in Plant 2 can ping all the nodes/cluster/sqlcluster > in Plant 1 but Plant 2 can ping all nodes in Plant 1 except the > cluster/sqlcluster? There are 3 NIC in each node where there are > Gateways set in 2 of the NIC except for the heartbeat connection. Is > there anything to do with routing? your cluster IP in plant 2 is on the same subnet as your cluster IP in plant 1, are you sure you are tunneling/vlanning this subnet accross ? also you made a typo above, please send us the correct settings. Furthermore, check if your private network in plant 2, you might be mistakingly routing packets there (do not use a Default GW on your private NIC's, you should only have 1 NIC with a default GW), as well as check subnetting of your private NIC's. [quoted text, click to view] > > 2. We have a software where we need to transfer data from SQL in Plant > 2 to Plant 1 or vice versa. How do we define the Host? By the IP ( I > don't know how I can make the server in Plant 1 to recognise the name > VIRTUALSQLS2)? SQL2005 supports logshipping, various forms of replication, as well as database mirroring.... would that do what your want ? If not give us more info on your requirements, or the package/software you are planning of using HTH, Edwin.
They are on two different subnets. Plant 1 is on the 192.168.128 subnet and
Plant 2 is on the 192.168.2 subnet. -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "Edwin vMierlo [MVP]" <EdwinvMierlo@discussions.microsoft.com> wrote in message news:unCXSN$3HHA.948@TK2MSFTNGP06.phx.gbl... in-line [quoted text, click to view] <subscrib3@gmail.com> wrote in message news:1187258221.606896.189050@z24g2000prh.googlegroups.com... > Hi all.. hope someone can help me on this.. I'm a beginner and have > limited knowledge on clustering. > > I managed to setup 2 set active/passive cluster with SQL clustering on > 2 different site which is connected through lease line. > > Plant 1: > Cluster IP : 192.168.128.150 > SQL Cluster IP: 192.168.128.200 (VIRTUSQLS1) > Node1: 192.168.128.10 > Node2: 192.168.128.11 > > Plant 2: > Cluster IP: 192.168.128.2.150 > SQL Cluster IP: 192.168.2.200 (VIRTUALSQLS2) > Node1: 192.168.2.10 > Node2: 192.168.2.11 > > A few questions here: > > 1. Why all nodes in Plant 2 can ping all the nodes/cluster/sqlcluster > in Plant 1 but Plant 2 can ping all nodes in Plant 1 except the > cluster/sqlcluster? There are 3 NIC in each node where there are > Gateways set in 2 of the NIC except for the heartbeat connection. Is > there anything to do with routing? your cluster IP in plant 2 is on the same subnet as your cluster IP in plant 1, are you sure you are tunneling/vlanning this subnet accross ? also you made a typo above, please send us the correct settings. Furthermore, check if your private network in plant 2, you might be mistakingly routing packets there (do not use a Default GW on your private NIC's, you should only have 1 NIC with a default GW), as well as check subnetting of your private NIC's. [quoted text, click to view] > > 2. We have a software where we need to transfer data from SQL in Plant > 2 to Plant 1 or vice versa. How do we define the Host? By the IP ( I > don't know how I can make the server in Plant 1 to recognise the name > VIRTUALSQLS2)? SQL2005 supports logshipping, various forms of replication, as well as database mirroring.... would that do what your want ? If not give us more info on your requirements, or the package/software you are planning of using HTH, Edwin.
In that case, I suspect that packets are mis-routed due to 2 NIC's having
Default GW's configured. [quoted text, click to view] "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message news:O5Fkqb$3HHA.4476@TK2MSFTNGP06.phx.gbl... > They are on two different subnets. Plant 1 is on the 192.168.128 subnet and > Plant 2 is on the 192.168.2 subnet. > > -- > Tom > > ---------------------------------------------------- > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS > SQL Server MVP > Toronto, ON Canada > https://mvp.support.microsoft.com/profile/Tom.Moreau > > > "Edwin vMierlo [MVP]" <EdwinvMierlo@discussions.microsoft.com> wrote in > message news:unCXSN$3HHA.948@TK2MSFTNGP06.phx.gbl... > in-line > > <subscrib3@gmail.com> wrote in message > news:1187258221.606896.189050@z24g2000prh.googlegroups.com... > > Hi all.. hope someone can help me on this.. I'm a beginner and have > > limited knowledge on clustering. > > > > I managed to setup 2 set active/passive cluster with SQL clustering on > > 2 different site which is connected through lease line. > > > > Plant 1: > > Cluster IP : 192.168.128.150 > > SQL Cluster IP: 192.168.128.200 (VIRTUSQLS1) > > Node1: 192.168.128.10 > > Node2: 192.168.128.11 > > > > Plant 2: > > Cluster IP: 192.168.128.2.150 > > SQL Cluster IP: 192.168.2.200 (VIRTUALSQLS2) > > Node1: 192.168.2.10 > > Node2: 192.168.2.11 > > > > A few questions here: > > > > 1. Why all nodes in Plant 2 can ping all the nodes/cluster/sqlcluster > > in Plant 1 but Plant 2 can ping all nodes in Plant 1 except the > > cluster/sqlcluster? There are 3 NIC in each node where there are > > Gateways set in 2 of the NIC except for the heartbeat connection. Is > > there anything to do with routing? > > your cluster IP in plant 2 is on the same subnet as your cluster IP in plant > 1, are you sure you are tunneling/vlanning this subnet accross ? also you > made a typo above, please send us the correct settings. Furthermore, check > if your private network in plant 2, you might be mistakingly routing packets > there (do not use a Default GW on your private NIC's, you should only have 1 > NIC with a default GW), as well as check subnetting of your private NIC's. > > > > > 2. We have a software where we need to transfer data from SQL in Plant > > 2 to Plant 1 or vice versa. How do we define the Host? By the IP ( I > > don't know how I can make the server in Plant 1 to recognise the name > > VIRTUALSQLS2)? > > SQL2005 supports logshipping, various forms of replication, as well as > database mirroring.... would that do what your want ? > If not give us more info on your requirements, or the package/software you > are planning of using > > HTH, > Edwin. > >
Hi all.. hope someone can help me on this.. I'm a beginner and have
limited knowledge on clustering. I managed to setup 2 set active/passive cluster with SQL clustering on 2 different site which is connected through lease line. Plant 1: Cluster IP : 192.168.128.150 SQL Cluster IP: 192.168.128.200 (VIRTUSQLS1) Node1: 192.168.128.10 Node2: 192.168.128.11 Plant 2: Cluster IP: 192.168.128.2.150 SQL Cluster IP: 192.168.2.200 (VIRTUALSQLS2) Node1: 192.168.2.10 Node2: 192.168.2.11 A few questions here: 1. Why all nodes in Plant 2 can ping all the nodes/cluster/sqlcluster in Plant 1 but Plant 2 can ping all nodes in Plant 1 except the cluster/sqlcluster? There are 3 NIC in each node where there are Gateways set in 2 of the NIC except for the heartbeat connection. Is there anything to do with routing? 2. We have a software where we need to transfer data from SQL in Plant 2 to Plant 1 or vice versa. How do we define the Host? By the IP ( I don't know how I can make the server in Plant 1 to recognise the name VIRTUALSQLS2)? Your help is very much appreaciated. Thanks sw.yin
Sorry, it was a typo. The correct one should be:
Plant 1: Cluster IP : 192.168.128.150 SQL Cluster IP: 192.168.128.200 (VIRTUSQLS1) Node1: 192.168.128.10 Node2: 192.168.128.11 Plant 2: Cluster IP: 192.168.2.150 SQL Cluster IP: 192.168.2.200 (VIRTUALSQLS2) Node1: 192.168.2.10 Node2: 192.168.2.11 No, there is no Default Gateway set on the Private network only the public network. I will double-check again on the subnetting. 2. I have our own customised software where it will do some processing and transfer some data over from Plant 1 to Plant 2. In the software, we definately need to define the Host or the SQL Server in Plant 2 in order for me to access it. Do I connect it by IP or what must I do in Plant 1 for it to recognize the name VIRTUALSQLS2? Thanks all for the answer. I will do further checking and update later. -- sw.yin On Aug 16, 6:50 pm, "Edwin vMierlo [MVP]" [quoted text, click to view] <EdwinvMie...@discussions.microsoft.com> wrote: > in-line > > <subscr...@gmail.com> wrote in message > > news:1187258221.606896.189050@z24g2000prh.googlegroups.com... > > > > > > > Hi all.. hope someone can help me on this.. I'm a beginner and have > > limited knowledge on clustering. > > > I managed to setup 2 set active/passive cluster with SQL clustering on > > 2 different site which is connected through lease line. > > > Plant 1: > > Cluster IP : 192.168.128.150 > > SQL Cluster IP: 192.168.128.200 (VIRTUSQLS1) > > Node1: 192.168.128.10 > > Node2: 192.168.128.11 > > > Plant 2: > > Cluster IP: 192.168.128.2.150 > > SQL Cluster IP: 192.168.2.200 (VIRTUALSQLS2) > > Node1: 192.168.2.10 > > Node2: 192.168.2.11 > > > A few questions here: > > > 1. Why all nodes in Plant 2 can ping all the nodes/cluster/sqlcluster > > in Plant 1 but Plant 2 can ping all nodes in Plant 1 except the > > cluster/sqlcluster? There are 3 NIC in each node where there are > > Gateways set in 2 of the NIC except for the heartbeat connection. Is > > there anything to do with routing? > > your cluster IP in plant 2 is on the same subnet as your cluster IP in plant > 1, are you sure you are tunneling/vlanning this subnet accross ? also you > made a typo above, please send us the correct settings. Furthermore, check > if your private network in plant 2, you might be mistakingly routing packets > there (do not use a Default GW on your private NIC's, you should only have 1 > NIC with a default GW), as well as check subnetting of your private NIC's. > > > > > 2. We have a software where we need to transfer data from SQL in Plant > > 2 to Plant 1 or vice versa. How do we define the Host? By the IP ( I > > don't know how I can make the server in Plant 1 to recognise the name > > VIRTUALSQLS2)? > > SQL2005 supports logshipping, various forms of replication, as well as > database mirroring.... would that do what your want ? > If not give us more info on your requirements, or the package/software you > are planning of using > > HTH, > Edwin.- Hide quoted text - > > - Show quoted text -
BTW, each node have 3 NICs. 1 NIC for the heartbeat connect with the
IP of 10.x.x.x. No Default GW defined here. The other 2 NIC is public NIC with Default Gateway defined for both of it. -- sw.yin On Aug 16, 8:16 pm, "Edwin vMierlo [MVP]" [quoted text, click to view] <EdwinvMie...@discussions.microsoft.com> wrote: > In that case, I suspect that packets are mis-routed due to 2 NIC's having > Default GW's configured. > > "Tom Moreau" <t...@dont.spam.me.cips.ca> wrote in message > > news:O5Fkqb$3HHA.4476@TK2MSFTNGP06.phx.gbl... > > > > > They are on two different subnets. Plant 1 is on the 192.168.128 subnet > and > > Plant 2 is on the 192.168.2 subnet. > > > -- > > Tom > > > ---------------------------------------------------- > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS > > SQL Server MVP > > Toronto, ON Canada > >https://mvp.support.microsoft.com/profile/Tom.Moreau > > > "Edwin vMierlo [MVP]" <EdwinvMie...@discussions.microsoft.com> wrote in > > messagenews:unCXSN$3HHA.948@TK2MSFTNGP06.phx.gbl... > > in-line > > > <subscr...@gmail.com> wrote in message > >news:1187258221.606896.189050@z24g2000prh.googlegroups.com... > > > Hi all.. hope someone can help me on this.. I'm a beginner and have > > > limited knowledge on clustering. > > > > I managed to setup 2 set active/passive cluster with SQL clustering on > > > 2 different site which is connected through lease line. > > > > Plant 1: > > > Cluster IP : 192.168.128.150 > > > SQL Cluster IP: 192.168.128.200 (VIRTUSQLS1) > > > Node1: 192.168.128.10 > > > Node2: 192.168.128.11 > > > > Plant 2: > > > Cluster IP: 192.168.128.2.150 > > > SQL Cluster IP: 192.168.2.200 (VIRTUALSQLS2) > > > Node1: 192.168.2.10 > > > Node2: 192.168.2.11 > > > > A few questions here: > > > > 1. Why all nodes in Plant 2 can ping all the nodes/cluster/sqlcluster > > > in Plant 1 but Plant 2 can ping all nodes in Plant 1 except the > > > cluster/sqlcluster? There are 3 NIC in each node where there are > > > Gateways set in 2 of the NIC except for the heartbeat connection. Is > > > there anything to do with routing? > > > your cluster IP in plant 2 is on the same subnet as your cluster IP in > plant > > 1, are you sure you are tunneling/vlanning this subnet accross ? also you > > made a typo above, please send us the correct settings. Furthermore, check > > if your private network in plant 2, you might be mistakingly routing > packets > > there (do not use a Default GW on your private NIC's, you should only have > 1 > > NIC with a default GW), as well as check subnetting of your private NIC's. > > > > 2. We have a software where we need to transfer data from SQL in Plant > > > 2 to Plant 1 or vice versa. How do we define the Host? By the IP ( I > > > don't know how I can make the server in Plant 1 to recognise the name > > > VIRTUALSQLS2)? > > > SQL2005 supports logshipping, various forms of replication, as well as > > database mirroring.... would that do what your want ? > > If not give us more info on your requirements, or the package/software you > > are planning of using > > > HTH, > > Edwin.- Hide quoted text - > > - Show quoted text -
Even though you have two public NICs on each server, we see only one IP per
node and per virtual SQL Server. How is the second NIC configured? -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau [quoted text, click to view] "sw.yin" <subscrib3@gmail.com> wrote in message Sorry, it was a typo. The correct one should be:news:1187266752.154718.149560@g12g2000prg.googlegroups.com... Plant 1: Cluster IP : 192.168.128.150 SQL Cluster IP: 192.168.128.200 (VIRTUSQLS1) Node1: 192.168.128.10 Node2: 192.168.128.11 Plant 2: Cluster IP: 192.168.2.150 SQL Cluster IP: 192.168.2.200 (VIRTUALSQLS2) Node1: 192.168.2.10 Node2: 192.168.2.11 No, there is no Default Gateway set on the Private network only the public network. I will double-check again on the subnetting. 2. I have our own customised software where it will do some processing and transfer some data over from Plant 1 to Plant 2. In the software, we definately need to define the Host or the SQL Server in Plant 2 in order for me to access it. Do I connect it by IP or what must I do in Plant 1 for it to recognize the name VIRTUALSQLS2? Thanks all for the answer. I will do further checking and update later. -- sw.yin On Aug 16, 6:50 pm, "Edwin vMierlo [MVP]" [quoted text, click to view] <EdwinvMie...@discussions.microsoft.com> wrote: > in-line > > <subscr...@gmail.com> wrote in message > > news:1187258221.606896.189050@z24g2000prh.googlegroups.com... > > > > > > > Hi all.. hope someone can help me on this.. I'm a beginner and have > > limited knowledge on clustering. > > > I managed to setup 2 set active/passive cluster with SQL clustering on > > 2 different site which is connected through lease line. > > > Plant 1: > > Cluster IP : 192.168.128.150 > > SQL Cluster IP: 192.168.128.200 (VIRTUSQLS1) > > Node1: 192.168.128.10 > > Node2: 192.168.128.11 > > > Plant 2: > > Cluster IP: 192.168.128.2.150 > > SQL Cluster IP: 192.168.2.200 (VIRTUALSQLS2) > > Node1: 192.168.2.10 > > Node2: 192.168.2.11 > > > A few questions here: > > > 1. Why all nodes in Plant 2 can ping all the nodes/cluster/sqlcluster > > in Plant 1 but Plant 2 can ping all nodes in Plant 1 except the > > cluster/sqlcluster? There are 3 NIC in each node where there are > > Gateways set in 2 of the NIC except for the heartbeat connection. Is > > there anything to do with routing? > > your cluster IP in plant 2 is on the same subnet as your cluster IP in > plant > 1, are you sure you are tunneling/vlanning this subnet accross ? also you > made a typo above, please send us the correct settings. Furthermore, check > if your private network in plant 2, you might be mistakingly routing > packets > there (do not use a Default GW on your private NIC's, you should only have > 1 > NIC with a default GW), as well as check subnetting of your private NIC's. > > > > > 2. We have a software where we need to transfer data from SQL in Plant > > 2 to Plant 1 or vice versa. How do we define the Host? By the IP ( I > > don't know how I can make the server in Plant 1 to recognise the name > > VIRTUALSQLS2)? > > SQL2005 supports logshipping, various forms of replication, as well as > database mirroring.... would that do what your want ? > If not give us more info on your requirements, or the package/software you > are planning of using > > HTH, > Edwin.- Hide quoted text - > > - Show quoted text -
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |