• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

Question mariaDB and postgreSQL on one server

S

S8669n1m2gb

New Pleskian
Server operating system version
latest
Plesk version and microupdate number
latest
Hi,

I currently have MariaDB database server version 5.5.68 installed. The latest version of Joomla 4, however, needs the latest version of mariaDB. I do not want to update it on my server to the latest version because it may turn out that suddenly many pages on the old version of joomla will stop working.



Can I have several database servers with different versions on one plesk server? I can theoretically add a new server, e.g. postgreSQL (which I would use for Joomla 4) but I don't know what to enter in hostname (localhost is already taken) to make it work well with current databases.
 
Are you sure your OS version is latest? Because 5.5.68 is from a rather old MariaDB series. That particular version's release was two years ago, and the 5.5 series is EOL.
The 10.0.x series came out 8 years ago, and current is 10.7.3.
 
@mow Indeed CentOS delivers version 5.5 of MariaDB by default. It is well possible that S8669n1m2gb is using their default.

@S8669n1m2gb You should upgrade to 10.6 following this guide (replace the 10.1 version with 10.6) https://support.plesk.com/hc/en-us/...w-to-upgrade-MariaDB-10-0-to-10-1-on-CentOS-7 . Here are two settings you may need to adapt in your my.cnf configuration file afterwards:
- Always: The bind-statement should either be set to :: or 127.0.0.1 but only one of these two with no further additions.
- Occasionally necessary: If you experience issues with the Plesk database or other databases after complete upgrade, try to add "sql_mode= ''" to my.cnf, too. But only if there are issues with some tables.

The new version of MariaDB will work fine with your old Joomla as well as your new Joomla.
 
I have CentOS Linux 7.9.2009 with maria 5.5.68. I'm afraid to update maria db because I have many Joomla installation on server. If update will be not successful....

Maybe it will be safer to use postgreSQL for new Joomla installations (and it will be possible to migrate old one to postgreSQL step by step).

It is possible to have two different sql servers on working in one plesk?
 
You must log in or register to reply here.

Similar threads

Azurel
Question MariaDB Warning for "Could not increase number of max_open_files to more than 32768 (request: 80555)"
Replies
2
Views
334
Kaspar
K
B
Issue "Allow local MariaDB/MySQL server to accept external connections" unchecked after every MariaDB update
Replies
7
Views
920
Bitpalast
Bitpalast
S
Issue MariaDB 10.5 to 10.11 upgrade failure on AlmaLinux 9.5
Replies
3
Views
2K
sder
S
davidds64
Question How to upgrade MariaDB to latest version with Plesk Obsidian on Alma Linux 9
Replies
5
Views
3K
davidds64
davidds64
R
Resolved Upgrading MariaDB on New AlmaLinux Server
Replies
7
Views
2K
Robin McDermott
R
Back
Top