Issues

Select view

Select search mode

 

Lucee Clustering - Session storage over database datasource

Cannot Reproduce

Description

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 :

  1. At first I create the schema over our Mysql production database.

  1. 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)

  1. 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 --->
    }}

  1. 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!

Environment

None

Attachments

4
  • 28 Aug 2018, 11:20 am
  • 23 Aug 2018, 09:51 am
  • 23 Aug 2018, 09:49 am
  • 23 Aug 2018, 09:44 am

Details

Assignee

Reporter

Priority

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?

https://dev.lucee.org/t/shared-session-delay/5177/

Pothys - MitrahSoft26 February 2019 at 15:40

No more inputs from the reporter.

Pothys - MitrahSoft6 December 2018 at 07:37

Hi ,

Did you check above comments?

Zac Spitzer28 August 2018 at 11:34

are there any errors in your scope.log file?

Pothys - MitrahSoft28 August 2018 at 11:21

Hi ,

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.

Flag notifications