MySQL Forums
Forum List  »  Router & Proxy

How to implement mysql consolidation strategy with multiple instances?
Posted by: William Frezno
Date: January 18, 2022 10:43AM

Here's the problem.
When my home setup started, it had several application each having it's own database. But as time goes on my needs grow and suddenly I find myself deploying dozens of sql servers. Now I want to consolidate: i.e. to move every database to a single database server to better manage backups and so on.
The consolidation strategy that I would want to implement is to deploy multiple mysql-server instances on a single server using virtualization technologies such as docker BECAUSE each database is different: e.g. one is psql GIS database. Another is mysql-5, another is mariadb10.4 and so on.
The problem is, to make it consistent I need to have one endpoint to connect to all those database instances. What approach should I use to accomplish the task.
The task is similar to reverse proxy in case of web servers.

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.