I know using the client SCOPE will allow you to load balance session
between a clustered environment, that is if you use a database as
storage for the sessions.
I thought MySQL just introduced Stored Procedures in its new version??
Just heard about it, I'm a MSSQL kinda guy myself..
Taco
On Thursday 17 Jul 2003 09:38 am, Taco Fleur wrote:
*** Database
We have generally always used MySQL as the database for sites we develop
but considering the possible enterprise scale nature of this
application we're starting to look elsewhere. In my opinion MySQL isn't
quite there in that
Fleur [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 17, 2003 4:38 AM
To: CF-Talk
Subject: RE: Thinking about application architecture...
I know using the client SCOPE will allow you to load balance session
between a clustered environment, that is if you use a database as
storage for the sessions
hi,
Sandy Clark [EMAIL PROTECTED] Said:
Actually using J2EE Sessions with a copy of CFMX for J2EE and your own
J2EE
server will allow you to use the J2EE clustering abilities with session
variables.
Ben Forta gave a presentation here last week which came up with that exact
item. Very
:[EMAIL PROTECTED]
Sent: Thursday, July 17, 2003 4:38 AM
To: CF-Talk
Subject: RE: Thinking about application architecture...
I know using the client SCOPE will allow you to load balance session
between a clustered environment, that is if you use a database as
storage for the sessions.
I thought MySQL
Out of curiosity, what is the problem with limiting each session to the same
box on a load-balanced system? We use a web farm here and we restrict each
session to only one box with no problems. I don't really see this as much
of a constraint and it certainly makes the programming a lot easier.
Hi,
From: Hagan, Ryan Mr (Contractor ACI)
Out of curiosity, what is the problem with limiting each session to the
same
box on a load-balanced system? We use a web farm here and we restrict
each
session to only one box with no problems. I don't really see this as much
of a constraint and it
Thomas Chiverton wrote:
On Thursday 17 Jul 2003 09:38 am, Taco Fleur wrote:
We have generally always used MySQL as the database for sites we develop
but considering the possible enterprise scale nature of this
application we're starting to look elsewhere. In my opinion MySQL isn't
quite there
On Thursday 17 Jul 2003 13:46 pm, Jochem van Dieten wrote:
We used to use it, it scaled well to start with, but by the end we were
having to rebuild our indexes almost weekly, by hand.
cron + REINDEX takes care of that for BTREE indexes, but RTREE, Hash and
GIST indexes don't need
Basically that is Sticky Sessions. The only problem with this
is if you establish a session on box1, and box1 fails you
loss your session state. If you are using cluster wide
sessions, your session can just continue on another box.
Thats the main difference. This may or may not be an
- Original Message -
From: Thomas Chiverton [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, July 17, 2003 5:08 AM
Subject: Re: Thinking about application architecture...
On Thursday 17 Jul 2003 09:38 am, Taco Fleur wrote:
*** Database
We have generally always used
What kinds of things will you be needing your session state for?
- Peter
-Original Message-
From: Tim Blair [mailto:[EMAIL PROTECTED]
Sent: 17 July 2003 14:13
To: CF-Talk
Subject: RE: Thinking about application architecture...
Basically that is Sticky Sessions. The only problem
Thomas Chiverton wrote:
On Thursday 17 Jul 2003 13:46 pm, Jochem van Dieten wrote:
cron + REINDEX takes care of that for BTREE indexes, but RTREE, Hash and
GIST indexes don't need reindexing. (This was fixed for BTREE indexes in
CVS 2 months ago so once 7.4 is released it will be completely
On Thursday, Jul 17, 2003, at 01:38 US/Pacific, Taco Fleur wrote:
I know using the client SCOPE will allow you to load balance session
between a clustered environment, that is if you use a database as
storage for the sessions.
Yes, if you're using CF5 and earlier. With CFMX you'd probably want
What kinds of things will you be needing your session state for?
I would imagine (I haven't gone that deeply into it just yet) just basic
state session info -- user id, partner id, possibly affiliate id -- all
simple variable types, no structs etc ...
John Paul Ashenfelter wrote:
All that said, the memory cache built into MySQL 4 beats anything from
Oracle, MS, etc. You can set the cache size to whatever you wish and the db
handles all the caching. Huge performance increase. And what makes it even
nicer, is that MySQL *TODAY* is shipping
Cookies and cached queries spring to mind.
However, Sean's suggestion about the J2EE session variables sounds nicer.
- Peter
-Original Message-
From: Tim Blair [mailto:[EMAIL PROTECTED]
Sent: 17 July 2003 16:01
To: CF-Talk
Subject: RE: Thinking about application architecture...
What
enable J2EE session variables and take advantage of the clustering and
fail over capabilities of the underlying J2EE app server (e.g., CFMX
for J2EE on JRun gives you session replication in real-time).
Are these clustering and fail-over capabilities available if you are
using the regular
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, July 17, 2003 11:13 AM
Subject: Re: Thinking about application architecture... (db issues)
John Paul Ashenfelter wrote:
All that said, the memory cache built into MySQL 4
John Paul Ashenfelter wrote:
From: Jochem van Dieten [EMAIL PROTECTED]
John Paul Ashenfelter wrote:
All that said, the memory cache built into MySQL 4 beats anything from
Oracle, MS, etc. You can set the cache size to whatever you wish and the db
handles all the caching. Huge performance
Any other benefit to J2EE session variables on CFMX versions
other than CFMX for J2EE?
Yes, if you want to integrate your CFMX code with servlets and JSP pages on
the same machine. You can do this with the standalone CFMX Enterprise
product. You don't need CFMX for J2EE for that. You do need it
CFMX on any J2EE server that supports the replication. CFMX simply lets the
J2EE server deal with it.
-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 17, 2003 7:25 AM
To: CF-Talk
Subject: RE: Thinking about application architecture...
hi,
Sandy Clark
On Thursday, Jul 17, 2003, at 08:23 US/Pacific, Ken Wilson wrote:
enable J2EE session variables and take advantage of the clustering and
fail over capabilities of the underlying J2EE app server (e.g., CFMX
for J2EE on JRun gives you session replication in real-time).
Are these clustering and
23 matches
Mail list logo
