Question Multiple Database Servers?

[safemoon]

Server operating system version

Ubuntu 22.04.5 LTS

Plesk version and microupdate number

Plesk Obsidian v18.0.81_build1800260925.20 os_Ubuntu 22.04

Can i have multiple database servers running on the same plesk server?

right now i have mariadb running, but my custom php app requires mysql server. is it possible to install mysql database server and have one app/domain use that one and the other apps/domains on my server to use mariadb?

if yes, how?

 

[Nikolay Chebotarev]

Hi safemoon!

For this purpose, you can use a Docker extension and a remote database server:

https://support.plesk.com/hc/en-us/articles/12377060524439-Is-it-possible-to-have-multiple-MySQL-MariaDB-instances-on-Plesk-for-Linux

https://support.plesk.com/hc/en-us/articles/13302840458519-How-to-install-a-MySQL-database-server-in-a-Docker-container-hosted-in-Plesk

Adding and Removing Database Servers

In addition to the database server(s) hosted on the Plesk server itself, you can also register remote database servers hosted elsewhere. Once a remote database server is registered in Plesk, it can be used to host databases for any domain in Plesk.

docs.plesk.com

 

[safemoon]

if i remove the mariadb server can i enable mysql server only , without docker?

Hi safemoon!

For this purpose, you can use a Docker extension and a remote database server:

https://support.plesk.com/hc/en-us/articles/12377060524439-Is-it-possible-to-have-multiple-MySQL-MariaDB-instances-on-Plesk-for-Linux

https://support.plesk.com/hc/en-us/articles/13302840458519-How-to-install-a-MySQL-database-server-in-a-Docker-container-hosted-in-Plesk

Adding and Removing Database Servers

In addition to the database server(s) hosted on the Plesk server itself, you can also register remote database servers hosted elsewhere. Once a remote database server is registered in Plesk, it can be used to host databases for any domain in Plesk.

docs.plesk.com

 

[Nikolay Chebotarev]

if i remove the mariadb server can i enable mysql server only , without docker?

Unfortunately, no:

https://support.plesk.com/hc/en-us/articles/12377118424343-Is-it-possible-to-replace-MySQL-with-MariaDB-and-vice-versa-on-a-server-with-Plesk

As i mentioned previously, to use MySQL for your app without Docker, you can run MySQL on a separate server (a small VPS or a managed MySQL service) and add it to Plesk as an external database server: Tools & Settings → Database Servers → Add Database Server. You can then create your app's database on it from Plesk as usual, while all other sites stay on MariaDB:

https://support.plesk.com/hc/en-us/articles/12377669607703