RSS DBSERVERNAME

Good Morning, We are running Informix 11.70.FC7 on Solaris. Is there a best practice recommendation when setting up RSS on whether to use DBSERVERNAME or DBSERVERALIASES for the communication between the primary and RSS nodes? I recall at one of the IIUG Conference sessions someone mentioned that it is better to use a different listener for Primary/RSS/HDR and separate it from user connections. Should both primary and RSS use a separate listener and does it matter if it is the DBSERVERNAME or DBSERVERALIASES? Any suggestions? --Dave --001a1135e5d03b0edc050ee523c2

As always --- It depends... ;-) If you have a lot of update activity, then it might be beneficial to isolate the RSS traffic. If you don't, then it really doesn't make any= difference. From: "Informix DBA" <in4mixdba@gmail.com> To: ids@iiug.org Date: 02/12/2015 08:45 AM Subject: RSS DBSERVERNAME [34633] Sent by: ids-bounces@iiug.org Good Morning, We are running Informix 11.70.FC7 on Solaris. Is there a best practice recommendation when setting up RSS on whether to use DBSERVERNAME or DBSERVERALIASES for the communication between the primary and RSS no= des? I recall at one of the IIUG Conference sessions someone mentioned that = it is better to use a different listener for Primary/RSS/HDR and separate = it from user connections. Should both primary and RSS use a separate liste= ner and does it matter if it is the DBSERVERNAME or DBSERVERALIASES? Any suggestions? --Dave --001a1135e5d03b0edc050ee523c2 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

Yes, best practice is for the HA secondaries (ie HDR, RSS, or SDS) to use a different alias than clients. Each server should be set up with DBSERVERNAME set to the most commonly used alias whether that is shared memory, stream pipes, or TCP. The DBSERVERALIASES would include any alternative connection names for the server including the alias will be used by that instance for communication with other HA instances. Then place that alias into the HA_ALIAS parameter in the ONCONFIG file to tell the engine which alias to use for communications with other HA instances. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Feb 12, 2015 at 9:43 AM, Informix DBA <in4mixdba@gmail.com> wrote: > Good Morning, > > We are running Informix 11.70.FC7 on Solaris. Is there a best practice > recommendation when setting up RSS on whether to use DBSERVERNAME > or DBSERVERALIASES for the communication between the primary and RSS nodes? > > I recall at one of the IIUG Conference sessions someone mentioned that it > is better to use a different listener for Primary/RSS/HDR and separate it > from user connections. Should both primary and RSS use a separate listener > and does it matter if it is the DBSERVERNAME or DBSERVERALIASES? > > Any suggestions? > > --Dave > > --001a1135e5d03b0edc050ee523c2 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1135e57e019d6f050ee544f5

Thank you Madison and Art, So if I understand correctly, best practice would be to have all main user connections connecting to the DBSERVERNAME of both the Primary and RSS nodes. Then create a separate entry in DBSERVERALIASES on both the primary and RSS and use that for setting up the RSS communication when using the "onmode -d add RSS" commands? Then also add the new entry in DBSERVERALIASES to the HA_ALIAS config parameter. --Dave On Thu, Feb 12, 2015 at 9:54 AM, Art Kagel <art.kagel@gmail.com> wrote: > Yes, best practice is for the HA secondaries (ie HDR, RSS, or SDS) to use a > different alias than clients. Each server should be set up with > DBSERVERNAME set to the most commonly used alias whether that is shared > memory, stream pipes, or TCP. The DBSERVERALIASES would include any > alternative connection names for the server including the alias will be > used by that instance for communication with other HA instances. Then > place that alias into the HA_ALIAS parameter in the ONCONFIG file to tell > the engine which alias to use for communications with other HA instances. > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > > On Thu, Feb 12, 2015 at 9:43 AM, Informix DBA <in4mixdba@gmail.com> wrote: > > > Good Morning, > > > > We are running Informix 11.70.FC7 on Solaris. Is there a best practice > > recommendation when setting up RSS on whether to use DBSERVERNAME > > or DBSERVERALIASES for the communication between the primary and RSS > nodes? > > > > I recall at one of the IIUG Conference sessions someone mentioned that it > > is better to use a different listener for Primary/RSS/HDR and separate it > > from user connections. Should both primary and RSS use a separate > listener > > and does it matter if it is the DBSERVERNAME or DBSERVERALIASES? > > > > Any suggestions? > > > > --Dave > > > > --001a1135e5d03b0edc050ee523c2 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a1135e57e019d6f050ee544f5 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1135e5d0864fe6050ee5838e

Yes. Art On Feb 12, 2015 10:11 AM, "Informix DBA" <in4mixdba@gmail.com> wrote: > Thank you Madison and Art, > > So if I understand correctly, best practice would be to have all main user > connections connecting to the DBSERVERNAME of both the Primary and RSS > nodes. Then create a separate entry in DBSERVERALIASES on both the primary > and RSS and use that for setting up the RSS communication when using > the "onmode > -d add RSS" commands? Then also add the new entry in DBSERVERALIASES to > the HA_ALIAS config parameter. > > --Dave > > On Thu, Feb 12, 2015 at 9:54 AM, Art Kagel <art.kagel@gmail.com> wrote: > > > Yes, best practice is for the HA secondaries (ie HDR, RSS, or SDS) to > use a > > different alias than clients. Each server should be set up with > > DBSERVERNAME set to the most commonly used alias whether that is shared > > memory, stream pipes, or TCP. The DBSERVERALIASES would include any > > alternative connection names for the server including the alias will be > > used by that instance for communication with other HA instances. Then > > place that alias into the HA_ALIAS parameter in the ONCONFIG file to tell > > the engine which alias to use for communications with other HA instances. > > > > Art > > > > Art S. Kagel, President and Principal Consultant > > ASK Database Management > > www.askdbmgt.com > > > > Blog: http://informix-myview.blogspot.com/ > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > and do not reflect on the IIUG, nor any other organization with which I > am > > associated either explicitly, implicitly, or by inference. Neither do > > those opinions reflect those of other individuals affiliated with any > > entity with which I am affiliated nor those of the entities themselves. > > > > On Thu, Feb 12, 2015 at 9:43 AM, Informix DBA <in4mixdba@gmail.com> > wrote: > > > > > Good Morning, > > > > > > We are running Informix 11.70.FC7 on Solaris. Is there a best practice > > > recommendation when setting up RSS on whether to use DBSERVERNAME > > > or DBSERVERALIASES for the communication between the primary and RSS > > nodes? > > > > > > I recall at one of the IIUG Conference sessions someone mentioned that > it > > > is better to use a different listener for Primary/RSS/HDR and separate > it > > > from user connections. Should both primary and RSS use a separate > > listener > > > and does it matter if it is the DBSERVERNAME or DBSERVERALIASES? > > > > > > Any suggestions? > > > > > > --Dave > > > > > > --001a1135e5d03b0edc050ee523c2 > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --001a1135e57e019d6f050ee544f5 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a1135e5d0864fe6050ee5838e > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0158ba6c1bb6af050ee58f38