Need help configuring Epicor 9.05 VM's in a Load Balanced Pool (

Out of sheer curiousity, how many users do you need to support?

On Tue, Mar 8, 2011 at 6:29 PM, pcivantage <vantagegroup@...>wrote:

>
>
> Thanks Pim;
> I did also look into the Load Balancing of Name Servers in OpenEdge, but
> that seems to be just for the NameServer services.
>
> I see that there are many features for clustering in the OpenEdge side of
> things, but no real documentation from Epicor that i have seen. It would be
> intersting to try, though. Let me know when you get it working in your test
> environment. ;)
>
> We seem to have enough trouble just getting the production stuff to work so
> we can play in the sandbox with these scenarios. I hope we get time to try
> this as well.
>
> George Hicks
> PCI
>
>
> --- In vantage@yahoogroups.com, Pim Zandbergen <P.Zandbergen@...> wrote:
> >
> > Sorry to go slightly off-topic, but doesn't anyone use the load balancing
> > feature that comes with Progress OpenEdge? Even more because Epicor
> provides
> > each of their customers with the necessary license.
> >
> > From theory, it should be easy; just install multiple appserver servers
> and
> > have them register at the same Progress nameserver. Then use
> > AppServer://nameserver-host/ServiceName in all your clients rather than
> > AppServerDC://appserver-host:port
> >
> > The System Agent form supports constructing these AppServer: URI's
> > internally
> > by just entering service name and nameserver name, and blanking the URI.
> > .MfgSys files will need to be edited.
> >
> > This should work in both virtual as well ass physical setups, but again,
> > this is theory, I never tried this in a lab.
> >
> > Pim
> >
> > On 22-2-2011 7:19, pcivantage wrote:
> > > I have an Epicor 9.05 (Progress) VM currently running fine.
> > > I have purchased a Barracuda Load Balancer and want to clone my Epicor
> VM Server and create two more to use in a cluster or pool with the Load
> Balancer.
> > >
> > > I have read the Epicor documents on Virtual and Load Balancing, and the
> VMWare Best Practices documents but none of them talk about load balancing
> Progress and how to seperate the DB from the cluster. Their example shows a
> SQL Server for the DB.
> > >
> > > Q. Since there can only be one machine with the Progress Database on
> it, what do I need to do to the copies to make them point to the one VM with
> the database on it? I want the cluster for AppServer performance, but the
> Load Balancer will switch between VM's depending upon load and I am sure if
> I had all three VM's with the DB on them, there would be issues.
> > >
> > > Q. When using the NLB and the single VM for Epicor 9, I am using the
> TCP Proxy configuration with Port 9401 for the client connection. Problem is
> when working in the software, if I am idle for more than 30 seconds, it
> drops the connection. Are there other ports that the client needs to use to
> keep the connection alive? Perhaps the port for the SystemMonitor?
> > >
> > > Any help is appreciated, as e intend to go LIVE on the 28th if I can
> get this worked out...
> > >
> > > Regards,
> > >
> > > George Hicks
> > > PCI
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> > > (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> > > (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> > > (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > >
> > >
> > >
> >
>
>
>


[Non-text portions of this message have been removed]
I have an Epicor 9.05 (Progress) VM currently running fine.
I have purchased a Barracuda Load Balancer and want to clone my Epicor VM Server and create two more to use in a cluster or pool with the Load Balancer.

I have read the Epicor documents on Virtual and Load Balancing, and the VMWare Best Practices documents but none of them talk about load balancing Progress and how to seperate the DB from the cluster. Their example shows a SQL Server for the DB.

Q. Since there can only be one machine with the Progress Database on it, what do I need to do to the copies to make them point to the one VM with the database on it? I want the cluster for AppServer performance, but the Load Balancer will switch between VM's depending upon load and I am sure if I had all three VM's with the DB on them, there would be issues.

Q. When using the NLB and the single VM for Epicor 9, I am using the TCP Proxy configuration with Port 9401 for the client connection. Problem is when working in the software, if I am idle for more than 30 seconds, it drops the connection. Are there other ports that the client needs to use to keep the connection alive? Perhaps the port for the SystemMonitor?

Any help is appreciated, as e intend to go LIVE on the 28th if I can get this worked out...

Regards,

George Hicks
PCI
Update Regarding second question: Barracuda Load Balancer has a setting for the connection timeout, which defaults to 60 Seconds. Enter 0 for no timeout and all works as expected with only Port 9401 used on the TCP Proxy Service to the "Real Server"

Still need help on first question...

George Hicks


--- In vantage@yahoogroups.com, "pcivantage" <vantagegroup@...> wrote:
>
> I have an Epicor 9.05 (Progress) VM currently running fine.
> I have purchased a Barracuda Load Balancer and want to clone my Epicor VM Server and create two more to use in a cluster or pool with the Load Balancer.
>
> I have read the Epicor documents on Virtual and Load Balancing, and the VMWare Best Practices documents but none of them talk about load balancing Progress and how to seperate the DB from the cluster. Their example shows a SQL Server for the DB.
>
> Q. Since there can only be one machine with the Progress Database on it, what do I need to do to the copies to make them point to the one VM with the database on it? I want the cluster for AppServer performance, but the Load Balancer will switch between VM's depending upon load and I am sure if I had all three VM's with the DB on them, there would be issues.
>
> Q. When using the NLB and the single VM for Epicor 9, I am using the TCP Proxy configuration with Port 9401 for the client connection. Problem is when working in the software, if I am idle for more than 30 seconds, it drops the connection. Are there other ports that the client needs to use to keep the connection alive? Perhaps the port for the SystemMonitor?
>
> Any help is appreciated, as e intend to go LIVE on the 28th if I can get this worked out...
>
> Regards,
>
> George Hicks
> PCI
>
Your best bet would be to setup the AppServers on the second server without
the DB on it to connect to the DB by changing a line in the .pf file.

You will be making a .pf change similar to the change made in the .PF files
to run Admin Tools and Schema changes on a 64-bit server.

Change this line in the .pf:

-db "D:\Epicor\Epicor905\db\mfgsys"

to this line:

-db mfgsys -H EpicorServerName -S 9400

Where -H is the host name of the server, and -S is the Pot number of the DB;
Both need to be capital letters.


Ned
Alternative Technology Partners


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
pcivantage
Sent: Tuesday, February 22, 2011 7:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Need help configuring Epicor 9.05 VM's in a Load
Balanced Pool (Progress)

Update Regarding second question: Barracuda Load Balancer has a setting for
the connection timeout, which defaults to 60 Seconds. Enter 0 for no timeout
and all works as expected with only Port 9401 used on the TCP Proxy Service
to the "Real Server"

Still need help on first question...

George Hicks


--- In vantage@yahoogroups.com, "pcivantage" <vantagegroup@...> wrote:
>
> I have an Epicor 9.05 (Progress) VM currently running fine.
> I have purchased a Barracuda Load Balancer and want to clone my Epicor VM
Server and create two more to use in a cluster or pool with the Load
Balancer.
>
> I have read the Epicor documents on Virtual and Load Balancing, and the
VMWare Best Practices documents but none of them talk about load balancing
Progress and how to seperate the DB from the cluster. Their example shows a
SQL Server for the DB.
>
> Q. Since there can only be one machine with the Progress Database on it,
what do I need to do to the copies to make them point to the one VM with the
database on it? I want the cluster for AppServer performance, but the Load
Balancer will switch between VM's depending upon load and I am sure if I had
all three VM's with the DB on them, there would be issues.
>
> Q. When using the NLB and the single VM for Epicor 9, I am using the TCP
Proxy configuration with Port 9401 for the client connection. Problem is
when working in the software, if I am idle for more than 30 seconds, it
drops the connection. Are there other ports that the client needs to use to
keep the connection alive? Perhaps the port for the SystemMonitor?
>
> Any help is appreciated, as e intend to go LIVE on the 28th if I can get
this worked out...
>
> Regards,
>
> George Hicks
> PCI
>




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
Thanks Ned;

So if I read you right...
The VM called, say "DB01" with both Epicor 9.05 and the Progress DB on it, will remain as-is on it's own. Client requests will not hit it because it is on a differnet IP and is not in the cluster that the clients point to.

Then I can create a clone of it as a seperate VM call it say "APP01" and then delete the database off of it, leave the AppServers and change the .pf file to point to the main "DBO1" machine to process DB functions.

I can create a copy of that new "APP01" called "APP02" etc. and place those in the Cluster or pool on the load balancer.

Client requests will come into the NLB and be directed to one of the "APP0x" machines which will then point to the DB Machine via the .pf file changes.

I don't need to do anything else than that?
I did some reading on OpenEdge Name Server Load Balancing, but that seems to be a failover for a stiuation where the NameServer component fails on the server. I don't think this is required at this point, nor related to what I want to do with the load balancing.

Sounds logical to me. Let me know if my interpretation makes sense.

Regards,
George hicks
PCI

--- In vantage@yahoogroups.com, "Ned" <TechnoBabbly@...> wrote:
>
> Your best bet would be to setup the AppServers on the second server without
> the DB on it to connect to the DB by changing a line in the .pf file.
>
> You will be making a .pf change similar to the change made in the .PF files
> to run Admin Tools and Schema changes on a 64-bit server.
>
> Change this line in the .pf:
>
> -db "D:\Epicor\Epicor905\db\mfgsys"
>
> to this line:
>
> -db mfgsys -H EpicorServerName -S 9400
>
> Where -H is the host name of the server, and -S is the Pot number of the DB;
> Both need to be capital letters.
>
>
> Ned
> Alternative Technology Partners
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> pcivantage
> Sent: Tuesday, February 22, 2011 7:27 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Need help configuring Epicor 9.05 VM's in a Load
> Balanced Pool (Progress)
>
> Update Regarding second question: Barracuda Load Balancer has a setting for
> the connection timeout, which defaults to 60 Seconds. Enter 0 for no timeout
> and all works as expected with only Port 9401 used on the TCP Proxy Service
> to the "Real Server"
>
> Still need help on first question...
>
> George Hicks
>
>
> --- In vantage@yahoogroups.com, "pcivantage" <vantagegroup@> wrote:
> >
> > I have an Epicor 9.05 (Progress) VM currently running fine.
> > I have purchased a Barracuda Load Balancer and want to clone my Epicor VM
> Server and create two more to use in a cluster or pool with the Load
> Balancer.
> >
> > I have read the Epicor documents on Virtual and Load Balancing, and the
> VMWare Best Practices documents but none of them talk about load balancing
> Progress and how to seperate the DB from the cluster. Their example shows a
> SQL Server for the DB.
> >
> > Q. Since there can only be one machine with the Progress Database on it,
> what do I need to do to the copies to make them point to the one VM with the
> database on it? I want the cluster for AppServer performance, but the Load
> Balancer will switch between VM's depending upon load and I am sure if I had
> all three VM's with the DB on them, there would be issues.
> >
> > Q. When using the NLB and the single VM for Epicor 9, I am using the TCP
> Proxy configuration with Port 9401 for the client connection. Problem is
> when working in the software, if I am idle for more than 30 seconds, it
> drops the connection. Are there other ports that the client needs to use to
> keep the connection alive? Perhaps the port for the SystemMonitor?
> >
> > Any help is appreciated, as e intend to go LIVE on the 28th if I can get
> this worked out...
> >
> > Regards,
> >
> > George Hicks
> > PCI
> >
>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
Sorry to go slightly off-topic, but doesn't anyone use the load balancing
feature that comes with Progress OpenEdge? Even more because Epicor provides
each of their customers with the necessary license.

From theory, it should be easy; just install multiple appserver servers and
have them register at the same Progress nameserver. Then use
AppServer://nameserver-host/ServiceName in all your clients rather than
AppServerDC://appserver-host:port

The System Agent form supports constructing these AppServer: URI's
internally
by just entering service name and nameserver name, and blanking the URI.
.MfgSys files will need to be edited.

This should work in both virtual as well ass physical setups, but again,
this is theory, I never tried this in a lab.

Pim

On 22-2-2011 7:19, pcivantage wrote:
> I have an Epicor 9.05 (Progress) VM currently running fine.
> I have purchased a Barracuda Load Balancer and want to clone my Epicor VM Server and create two more to use in a cluster or pool with the Load Balancer.
>
> I have read the Epicor documents on Virtual and Load Balancing, and the VMWare Best Practices documents but none of them talk about load balancing Progress and how to seperate the DB from the cluster. Their example shows a SQL Server for the DB.
>
> Q. Since there can only be one machine with the Progress Database on it, what do I need to do to the copies to make them point to the one VM with the database on it? I want the cluster for AppServer performance, but the Load Balancer will switch between VM's depending upon load and I am sure if I had all three VM's with the DB on them, there would be issues.
>
> Q. When using the NLB and the single VM for Epicor 9, I am using the TCP Proxy configuration with Port 9401 for the client connection. Problem is when working in the software, if I am idle for more than 30 seconds, it drops the connection. Are there other ports that the client needs to use to keep the connection alive? Perhaps the port for the SystemMonitor?
>
> Any help is appreciated, as e intend to go LIVE on the 28th if I can get this worked out...
>
> Regards,
>
> George Hicks
> PCI
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
Thanks Pim;
I did also look into the Load Balancing of Name Servers in OpenEdge, but that seems to be just for the NameServer services.

I see that there are many features for clustering in the OpenEdge side of things, but no real documentation from Epicor that i have seen. It would be intersting to try, though. Let me know when you get it working in your test environment. ;)

We seem to have enough trouble just getting the production stuff to work so we can play in the sandbox with these scenarios. I hope we get time to try this as well.

George Hicks
PCI

--- In vantage@yahoogroups.com, Pim Zandbergen <P.Zandbergen@...> wrote:
>
> Sorry to go slightly off-topic, but doesn't anyone use the load balancing
> feature that comes with Progress OpenEdge? Even more because Epicor provides
> each of their customers with the necessary license.
>
> From theory, it should be easy; just install multiple appserver servers and
> have them register at the same Progress nameserver. Then use
> AppServer://nameserver-host/ServiceName in all your clients rather than
> AppServerDC://appserver-host:port
>
> The System Agent form supports constructing these AppServer: URI's
> internally
> by just entering service name and nameserver name, and blanking the URI.
> .MfgSys files will need to be edited.
>
> This should work in both virtual as well ass physical setups, but again,
> this is theory, I never tried this in a lab.
>
> Pim
>
> On 22-2-2011 7:19, pcivantage wrote:
> > I have an Epicor 9.05 (Progress) VM currently running fine.
> > I have purchased a Barracuda Load Balancer and want to clone my Epicor VM Server and create two more to use in a cluster or pool with the Load Balancer.
> >
> > I have read the Epicor documents on Virtual and Load Balancing, and the VMWare Best Practices documents but none of them talk about load balancing Progress and how to seperate the DB from the cluster. Their example shows a SQL Server for the DB.
> >
> > Q. Since there can only be one machine with the Progress Database on it, what do I need to do to the copies to make them point to the one VM with the database on it? I want the cluster for AppServer performance, but the Load Balancer will switch between VM's depending upon load and I am sure if I had all three VM's with the DB on them, there would be issues.
> >
> > Q. When using the NLB and the single VM for Epicor 9, I am using the TCP Proxy configuration with Port 9401 for the client connection. Problem is when working in the software, if I am idle for more than 30 seconds, it drops the connection. Are there other ports that the client needs to use to keep the connection alive? Perhaps the port for the SystemMonitor?
> >
> > Any help is appreciated, as e intend to go LIVE on the 28th if I can get this worked out...
> >
> > Regards,
> >
> > George Hicks
> > PCI
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> >
> >
>