Strange logical question: (applies to all versions and I can't provide any logs 🙂)
Has anyone experienced a scenario when the service provider had two MySQL servers and both are offered on localhost?
From what I know port is ignored as localhost uses no TCP/IP but how can I tell to use the other server? (Database name doesn't seem to be enough. Trying to run with the provider but they hidden so far behind bureaucracy so I am trying my chances here...)
They have to have some way of differentiating the database servers. Please ask your host how to point to a specific database server.
Thanks, I did but I was hoping to figure out without them. I see that is not an option then...
We are not the host so we have no idea how they have it set up. You can’t run two database servers on the same hostname and port. Unless that one connection is a load balancer or something like ProxySQL that routes traffic based on certain criteria.
Thank you, it is not for sure, as then it would find the server based on user name/database name. 🙂
note: I was hoping someone less from the osticket side with similar experience... 😉
This is not a common/typical setup so I doubt anyone here has had a similar experience but you never know! We'll just have to wait and see.
well, time is money. 😃 Thank you anyways...
Two mySQL servers cannot run on the same server and both listen to the same port.
They would have to listen on different ports.
Exactly, the question was the HOW...
Again, you’ll have to ask your host as this is not a typical setup at all.
You would setup database A to listen on port X
Start the db server.
Configure datbase B to listen on port Y.
start that db server.