MYSQL InnoDB Cluster Connect String parameters
I have setup MySQL InnoDB Cluster latest release (8.0.27) with three nodes with single primary. And I have a VB script and connection string for it.
Current connection string is like :
load-balancing
ERROR 2013 (HY000): Lost connection to MySQL server at ‘reading authorization packet’, system error: 0
I am getting the following error
What is the best way to handle sessions for a PHP site on multiple hosts?
PHP stores its session information on the file system of the host of the server establishing that session. In a multiple-host PHP environment, where load is unintelligently distributed amongst each host, PHP session variables are not available to each request (unless by chance the request is assigned to the same host — assume we have … Read more
PHP sessions in a load balancing cluster – how?
OK, so I’ve got this totally rare an unique scenario of a load balanced PHP website. The bummer is – it didn’t used to be load balanced. Now we’re starting to get issues…
How to force node.js/express.js to HTTPS when it is running behind an AWS load balancer
I’m running a node/express service on AWS and have deployed an ELB in front of it. When I spin up an ELB instance with SSL enabled, it works for the first page I hit, but then switches over to HTTP for every server access after that.
Proxying WebSockets with TCP load balancer without sticky sessions
I want to proxy WebSocket connections to multiple node.js servers using Amazon Elastic Load Balancer. Since Amazon ELB does not provide actual WebSocket support, I would need to use its vanilla TCP messaging. However, I’m trying to understand how this would work without some sort of sticky session functionality.
Amazon Elastic load balancer is not populating x-forwarded-proto header
I am trying to force all http requests to https requests and I am facing the problem as elastic load balancer not populating x-forwarded-proto header in the request.
How to associate properties to socket.io object in Redis Store?
I am working on a complex game with Nodejs and Socket.io, where I need to store socket.io objects in the memory and also assign properties to the socket object ( say a name , a counter of some action from the socket , etc )
Scaling with sticky sessions and websockets
Initially we have two AWS EC2 instances with node.js running behind a load balancer with sticky sessions. As the load increases more instances are added.
CSRF Token Mismatch with Laravel API using Digital Ocean Load Balancer with Sticky Session
I am working on a project in Laravel 8 which I am now testing the deployment on production servers. I have set up 2 Digital Ocean Droplets that are behind a load balancer with Sticky Sessions enabled. I am attempting to login via a SPA app with a separate Laravel API so the middleware is configured for the api routes to be stateful API and perform CSRF validation. This works perfectly fine when I just hit a single droplet and bypass the load balancer but as soon as the load balancer is in use, I always receive a 419 CSRF Token mismatch.