Issues
- Lucee Clustering - Session storage over database datasourceLDEV-1966Resolved issue: LDEV-1966Pothys - MitrahSoft
- Load balanced clustered sessions not working correctlyLDEV-1318Resolved issue: LDEV-1318Pothys - MitrahSoft
- this.sessioncluster=true breaks sessionsLDEV-1207Resolved issue: LDEV-1207Michael Offner
- In the admin there is no setting for default clientcluster or sessionclusterLDEV-481Michael Offner
4 of 4
Lucee Clustering - Session storage over database datasource
Cannot Reproduce
Description
Environment
None
Attachments
4
Details
Assignee
Pothys - MitrahSoftPothys - MitrahSoftReporter
Sergio BelliSergio BelliPriority
MajorNew Issue warning screen
Before you create a new Issue, please post to the mailing list first https://dev.lucee.org
Once the issue has been verified, one of the Lucee team will ask you to file an issue
Affects versions
Details
Details
Assignee
Pothys - MitrahSoft
Pothys - MitrahSoftReporter
Sergio Belli
Sergio BelliPriority
New Issue warning screen
Before you create a new Issue, please post to the mailing list first https://dev.lucee.org
Once the issue has been verified, one of the Lucee team will ask you to file an issue
Affects versions
Created 23 August 2018 at 10:01
Updated 26 February 2019 at 16:02
Resolved 26 February 2019 at 15:40
Activity
Show:
Zac Spitzer26 February 2019 at 16:02
seems related, there are performance problems with j2ee session storage in a database?
Pothys - MitrahSoft26 February 2019 at 15:40
No more inputs from the reporter.
Pothys - MitrahSoft6 December 2018 at 07:37
Hi @Sergio Belli,
Did you check above comments?
Zac Spitzer28 August 2018 at 11:34
@Sergio Belli are there any errors in your scope.log file?
Pothys - MitrahSoft28 August 2018 at 11:21
Hi @Sergio Belli,
I've tested with session cluster working fine for me. Session values were stored in DB also working as expected.
I attached my
Zip file run this code on multiple instance and check once again. I hope that it helps you lot.
Hi everybody.
I'm writing a ticket in order to obtain assistance to perform the right configuration of Lucee clustering over database.
At the moment we have some Lucee instances in production environment for our customers.
For an important customer we want to achieve the goal of getting a cluster in production environment, so I search over the internet for possibile solution to our needs.
I found this document : https://rorylaitila.gitbooks.io/lucee/content/clustering.html
Then I started to follow the instructions :
At first I create the schema over our Mysql production database.
Then I configure in Lucee console the datasource, following the instructions I achieve the goal of having a datasource usable for Session Storage (see lucee-datasources.png)
So I go to my Application.cfc and wrote the configuration of the datasource, something like this
{{<!--- clustering - start --->
<cfset THIS.datasources["lucee_sessions"] = {
class: 'org.gjt.mm.mysql.Driver'
, connectionString: 'jdbc:mysql://something:3306/lucee_sessions?useUnicode=true&characterEncoding=UTF-8&useLegacyDatetimeCode=true'
, username: 'username'
, password: "pwd"
, storage:true
} />
<cfset THIS.sessionStorage = "lucee_sessions" />
<cfset THIS.sessionCluster = true />
<cfset THIS.sessionType = "cfml" />
<!--- clustering - end --->
}}
At last I go to "Scope management" on lucee console and I have enabled session storage over database (see lucee-scope-sessionstorage.png)
Let me remark that I leave session type at JEE value (see lucee-scope-sessiontype.png)
In order to get session replicated over cluster nodes by means of a database that's all!
Then I go to home page of my production site and I expect to see created the table named cf_session_data over my database schema lucee_sessions ...
Nothing!
The table is not present!
What I have to do in order to perform this configuration?
There are other documents online that describe the process?
Thanks in advance for every kind of help!