ER & CPU Sizing Question
Mark asked how few CPU VPUs (for PVU licensing) a target server needs to run one-way Enterprise Replication as an offsite DR copy of a busy primary (600+ users, 6 CPU VPs, ~12GB of logs/day). Respondents questioned using ER at all, suggesting HDR or RSS as simpler, lower-traffic options, and noted ER needs a key per table (ERKEY column in 11.50+, any unique index in 12.10). Art Kagel's guidance that a replication target should match the primary's resources was accepted; Mark explained ER was chosen because the DR copy will purge old data, and closed the thread with that answer.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Informix 11.50 or 11.70 Ultimate editions / AIX 720 platform. Client wants to implement an offsite DR site using ER one way replication. This implementation will be for DR only, no users will be allowed access to this server. The primary server has about 600+ max concurrent users, 6 cpu vps. Not quite sure on the total amount of transactions per day other than they chew thru about 12 gigs of logs daily. Assume that at some point a table here and there could get out of sync and cdr sync would need to be run. My question is what would be the MINIMUM amount of processers required for ER to function properly ? The client only wants to license the minimum amount of pvu's. Thanks, Mark
Why not use RSS? = From: "MARK JALKIEWICZ" <mark.jalkiewicz@verizon.net> = = To: ids@iiug.org, = = Date: 10/14/2013 09:51 AM = = Subject: ER & CPU Sizing Question [31701] = = Sent by: ids-bounces@iiug.org = = Informix 11.50 or 11.70 Ultimate editions / AIX 720 platform. Client wants to implement an offsite DR site using ER one way replicati= on. This implementation will be for DR only, no users will be allowed acces= s to this server. The primary server has about 600+ max concurrent users, 6 = cpu vps. Not quite sure on the total amount of transactions per day other t= han they chew thru about 12 gigs of logs daily. Assume that at some point a= table here and there could get out of sync and cdr sync would need to be run.= My question is what would be the MINIMUM amount of processers required = for ER to function properly ? The client only wants to license the minimum amo= unt of pvu's. Thanks, Mark ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
Any replication server should be equal to the primary server in its available resources. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Mon, Oct 14, 2013 at 11:49 AM, MARK JALKIEWICZ < mark.jalkiewicz@verizon.net> wrote: > Informix 11.50 or 11.70 Ultimate editions / AIX 720 platform. > > Client wants to implement an offsite DR site using ER one way replication. > This implementation will be for DR only, no users will be allowed access to > this server. The primary server has about 600+ max concurrent users, 6 cpu > vps. Not quite sure on the total amount of transactions per day other than > they chew thru about 12 gigs of logs daily. Assume that at some point a > table > here and there could get out of sync and cdr sync would need to be run. > > My question is what would be the MINIMUM amount of processers required for > ER > to function properly ? The client only wants to license the minimum amount > of > pvu's. > > Thanks, > > Mark > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e01227ca4ed218204e8b5ac3d
Mark Are they looking to ER the entire database ? If so the target server needs to be the same as the primary, but why are they no looking at HDR. Much simpler to set up and administer and no need to worry about getting out of sync, probably much less network traffic as well. I'm using ER on 15% of my tables and am running 2 CPU VPs with a similar source system, but it depends on the number of tables and volume of change. Don't forget, for ER, EVERY table you replicate needs a PK defined, may not be an issue for you (but it is for me :-( ) Keith On 14 October 2013 16:49, MARK JALKIEWICZ <mark.jalkiewicz@verizon.net>wrote: > Informix 11.50 or 11.70 Ultimate editions / AIX 720 platform. > > Client wants to implement an offsite DR site using ER one way replication. > This implementation will be for DR only, no users will be allowed access to > this server. The primary server has about 600+ max concurrent users, 6 cpu > vps. Not quite sure on the total amount of transactions per day other than > they chew thru about 12 gigs of logs daily. Assume that at some point a > table > here and there could get out of sync and cdr sync would need to be run. > > My question is what would be the MINIMUM amount of processers required for > ER > to function properly ? The client only wants to license the minimum amount > of > pvu's. > > Thanks, > > Mark > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113378d8a9c9af04e8b641c9
No PK needed in the later versions > Mark > > Are they looking to ER the entire database ? If so the target server needs > to be the same as the primary, but why are they no looking at HDR. Much > simpler to set up and administer and no need to worry about getting out > of sync, probably much less network traffic as well. > > I'm using ER on 15% of my tables and am running 2 CPU VPs with a > similar source system, but it depends on the number of tables and > volume of change. > > Don't forget, for ER, EVERY table you replicate needs a PK defined, may > not be an issue for you (but it is for me :-( ) > > Keith > > On 14 October 2013 16:49, MARK JALKIEWICZ > <mark.jalkiewicz@verizon.net>wrote: > >> Informix 11.50 or 11.70 Ultimate editions / AIX 720 platform. >> >> Client wants to implement an offsite DR site using ER one way >> replication. >> This implementation will be for DR only, no users will be allowed access >> to >> this server. The primary server has about 600+ max concurrent users, 6 >> cpu >> vps. Not quite sure on the total amount of transactions per day other >> than >> they chew thru about 12 gigs of logs daily. Assume that at some point a >> table >> here and there could get out of sync and cdr sync would need to be run. >> >> My question is what would be the MINIMUM amount of processers required >> for >> ER >> to function properly ? The client only wants to license the minimum >> amount >> of >> pvu's. >> >> Thanks, >> >> Mark >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > --001a113378d8a9c9af04e8b641c9 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com www.advancedatatools.com Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. What this country needs are more unemployed politicians
Right. In 11.50+ you can add the ERKEY column and in v12.10 you can use any unique index. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Mon, Oct 14, 2013 at 1:18 PM, Paul Watson <paul@oninit.com> wrote: > No PK needed in the later versions > > > Mark > > > > Are they looking to ER the entire database ? If so the target server > needs > > to be the same as the primary, but why are they no looking at HDR. Much > > simpler to set up and administer and no need to worry about getting out > > of sync, probably much less network traffic as well. > > > > I'm using ER on 15% of my tables and am running 2 CPU VPs with a > > similar source system, but it depends on the number of tables and > > volume of change. > > > > Don't forget, for ER, EVERY table you replicate needs a PK defined, may > > not be an issue for you (but it is for me :-( ) > > > > Keith > > > > On 14 October 2013 16:49, MARK JALKIEWICZ > > <mark.jalkiewicz@verizon.net>wrote: > > > >> Informix 11.50 or 11.70 Ultimate editions / AIX 720 platform. > >> > >> Client wants to implement an offsite DR site using ER one way > >> replication. > >> This implementation will be for DR only, no users will be allowed access > >> to > >> this server. The primary server has about 600+ max concurrent users, 6 > >> cpu > >> vps. Not quite sure on the total amount of transactions per day other > >> than > >> they chew thru about 12 gigs of logs daily. Assume that at some point a > >> table > >> here and there could get out of sync and cdr sync would need to be run. > >> > >> My question is what would be the MINIMUM amount of processers required > >> for > >> ER > >> to function properly ? The client only wants to license the minimum > >> amount > >> of > >> pvu's. > >> > >> Thanks, > >> > >> Mark > >> > >> > >> > >> > > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> > > > > --001a113378d8a9c9af04e8b641c9 > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > -- > Paul Watson > Tel: +1 913-674-0360 > Mob: +1 913-387-7529 > Web: www.oninit.com > > www.advancedatatools.com > > Failure is not as frightening as regret. > If you want to improve, be content to be thought foolish and stupid. > What this country needs are more unemployed politicians > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c352aa3d4e1604e8b71198
ERKEY upto 16M pages on the index > Right. In 11.50+ you can add the ERKEY column and in v12.10 you can use > any unique index. > > Art > > Art S. Kagel, Principal Consultant > > Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Mon, Oct 14, 2013 at 1:18 PM, Paul Watson <paul@oninit.com> wrote: > >> No PK needed in the later versions >> >> > Mark >> > >> > Are they looking to ER the entire database ? If so the target server >> needs >> > to be the same as the primary, but why are they no looking at HDR. >> Much >> > simpler to set up and administer and no need to worry about getting >> out >> > of sync, probably much less network traffic as well. >> > >> > I'm using ER on 15% of my tables and am running 2 CPU VPs with a >> > similar source system, but it depends on the number of tables and >> > volume of change. >> > >> > Don't forget, for ER, EVERY table you replicate needs a PK defined, >> may >> > not be an issue for you (but it is for me :-( ) >> > >> > Keith >> > >> > On 14 October 2013 16:49, MARK JALKIEWICZ >> > <mark.jalkiewicz@verizon.net>wrote: >> > >> >> Informix 11.50 or 11.70 Ultimate editions / AIX 720 platform. >> >> >> >> Client wants to implement an offsite DR site using ER one way >> >> replication. >> >> This implementation will be for DR only, no users will be allowed >> access >> >> to >> >> this server. The primary server has about 600+ max concurrent users, >> 6 >> >> cpu >> >> vps. Not quite sure on the total amount of transactions per day other >> >> than >> >> they chew thru about 12 gigs of logs daily. Assume that at some point >> a >> >> table >> >> here and there could get out of sync and cdr sync would need to be >> run. >> >> >> >> My question is what would be the MINIMUM amount of processers >> required >> >> for >> >> ER >> >> to function properly ? The client only wants to license the minimum >> >> amount >> >> of >> >> pvu's. >> >> >> >> Thanks, >> >> >> >> Mark >> >> >> >> >> >> >> >> >> > >> >> > ******************************************************************************* >> >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> >> >> >> > >> > --001a113378d8a9c9af04e8b641c9 >> > >> > >> > >> >> > ******************************************************************************* >> > Forum Note: Use "Reply" to post a response in the discussion forum. >> > >> >> -- >> Paul Watson >> Tel: +1 913-674-0360 >> Mob: +1 913-387-7529 >> Web: www.oninit.com >> >> www.advancedatatools.com >> >> Failure is not as frightening as regret. >> If you want to improve, be content to be thought foolish and stupid. >> What this country needs are more unemployed politicians >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > --001a11c352aa3d4e1604e8b71198 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com www.advancedatatools.com Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. What this country needs are more unemployed politicians
HDR, RSS all considered, but the client's model is that this DR server will only be used as a "temporary stop gap" until an emergency replacement server is delivered and restored via backup tapes that are stored off-site daily. Since this DR server will only serve as a temporary solution, they will be retenting old data ( to save on disk space costs on this DR ) and that retention cannot be applied back to the primary. Art's response seems to be very reasonable. Thanks to all who responded. Mark