I'm trying to setup db sessions in Lucee without enabling

sessionCluster

(because I read it causes a db read on every request vs temp memory store). If I turn off

sessionCluster

, sessions only seem to last a few minutes before expiring, even though the session is still active in the DB, it's like it gets clear from the local memory and Lucee doesn't check the DB, it just assumes the session is empty or something. Can anyone clarify the bnhavuour here? There isn't much information out there on the internals of how all this works. I'm on Lucee 5.3.12.1 and here's my session config. Thanks!

this.sessionManagement = true;
	this.sessionCluster = false;
	this.sessionTimeout = createTimespan(7,0,0,0);
	this.sessionStorage = 'rsessions';
    this.datasources={
		'rsessions' = {
			type: 'mysql',
			host: 'mariadb',
			database: 'rsessions',
			port: '3306',
			username: 'root',
			password: 'pass',
			connectionLimit: -1,
			blob: false,
			clob: true,
			storage: true,
			timezone: 'GMT',
			custom: { useUnicode:true, characterEncoding:'UTF-8' }
		}
	}

Cluster is required if you have more than one server.

Yeah, it's a single server which is why this behavior is so weird. I can't imagine I would be the first to have this issue if that were the case though.

Does it works if you enable session cluster

Yeah, it works with SessionCluster enabled but the site gets high traffic, so within 8 or so hours we have 30,000 sessions and things slow down. I could move the session storage from Mysql to Redis. I'm using the following Docker image:

ortussolutions/commandbox:lucee5-alpine-3.7.12

- I'm guessing it doesn't have the Lucee Redis plugin built in. Is there a good guide for adding it? I also don't have access to the admin and prefer to configure everything programmatically and avoid the GUI.

I can't say I've ever used DB based sessions in production

Okay, I didn't have to install anything, turns out the Redis extension was already installed in the box image. Took 2 hours to figure out how to configure it in the application.cfc:

this.cache.connections["redis"] = {
		class: 'lucee.extension.io.cache.redis.simple.RedisCache',
		storage: true,
		custom: {
			host: 'redis',
			port: 6379,
			timeout: 2000,
			password: 'pass'
		}
	};
	this.cache.defaultConnection = "redis";
	this.sessionStorage = 'redis';

Now I am seeing sessions flowing into the redis db which is great but now if I also want to use it as a cache store I guess I have to mix both session data and cache data in one db as I haven't seen an option to specific the db index in the settings yet.

Redis wasn't already in the image

Correct

it came from the mounted volume to the deploy directory with the lex I had added

Lol, how would you have gone through all that trouble and forgot you did it?

it removes the lex file so on the next start it crashes due to the missing value.

I have no idea what that means. Missing value??

I'm not sure where to find the guid identifier for the extension

Depends on which Redis extension you want. Lucee has their GUIDs on this page https://download.lucee.org/#60772C12-F179-D555-8E2CD2B4F7428718 Ortus has our own supported extension, here https://forgebox.io/view/5C558CC6-1E67-4776-96A60F9726D580F1

Lol, multitasking, then thought I forgot to drop the lex file in but turned out Lucee deleted it. Anyway, all good now. Now thinking about how I can implement pub/sub simple messaging into my app with Redis, more wondering how fleshed out this extension is.

The Lucee one isn't very fleshed out. One of the reasons we created ours

Redis allows for multiple DB’s in the config. Mine is set to 10 or something

Ahh, ok. A little confusing since you were talking about actual DB storage at the start of this thread. Like JDBC DB

Yeah, I followed :)

👍