Hi,
We have an architecture such that we have 2 instances of Apache Tomcat 6
sitting under the Amazon ELB. We are having difficulties in session stickyness
over HTTPS such that that requests are not being directed to the same Tomcat
instance, therefore creating a new session when the request is directed to a
different instance. One possible solution was to use the Tomcat JDBCStore
Persistent Mananger so that session information is held centrally in a database.
This did not seem to work as intended as the minimum time to write session
details to the database was 10 seconds. This clearly did not solve the problem
as the users interaction with the application would be less than 10 seconds.
I am wating to know if there is a way to speed up the write process?
I have used the FileStore and this also has the same problems. Can someone
please advise in how to get this to work?
The configuration in context.xml I am using is :
<Manager className="org.apache.catalina.session.PersistentManager"
distributable="true"
checkInterval="1"
saveOnRestart="false"
maxActiveSessions="-1"
minIdleSwap="-1"
maxIdleSwap="0"
maxIdleBackup="0">
<Store className="org.apache.catalina.session.JDBCStore"
connectionURL="<connection url>"
driverName="com.mysql.jdbc.Driver"
connectionName="<name>"
connectionPassword="<password>"
sessionAppCol="app_name"
sessionDataCol="session_data"
sessionIdCol="session_id"
sessionLastAccessedCol="last_access"
sessionMaxInactiveCol="max_inactive"
sessionTable="sessions"
sessionValidCol="valid_session"/>
</Manager>
Thanks,
Taj
