Conversation

Notices

1. nixCraft 🐧 (nixcraft@mastodon.social)'s status on Saturday, 22-Jun-2024 23:31:21 JST nixCraft 🐧

   Is it possible to install two database engines, mysql and PostgreSQL, on the same #linux or #unix server?

   • krolden (krolden@mastodon.social)'s status on Saturday, 22-Jun-2024 23:32:34 JST krolden

     in reply to

     @nixCraft just run them on different ports.

   • gibeath (gibeath@mastodon.social)'s status on Saturday, 22-Jun-2024 23:33:47 JST gibeath

     in reply to

     @nixCraft You could run as many database instances as you want, but for any serious workloads... use a dedicated machine.

   • 4Xsample :mastodon: (4xsample@mastodon.social)'s status on Saturday, 22-Jun-2024 23:34:13 JST 4Xsample :mastodon:

     in reply to

     @nixCraft Yup.
     I have several in different docker containers.
     But provably, you can do it even without it.

   • Osfast (osfast@mastodon.social)'s status on Saturday, 22-Jun-2024 23:36:40 JST Osfast

     in reply to

     @nixCraft yes, easiest would be using docker

   • Stephen McNamara (noflcl@mastodon.social)'s status on Saturday, 22-Jun-2024 23:38:10 JST Stephen McNamara

     in reply to

     @nixCraft

     perfectly fine. You may bottleneck your I/O depending on how fast your storage array is.

     I run mariadb, postgres, and InodeDB all on the same box. No issues.

     My databases are on solid state storage arrays backed by zfs. Years running 👌

   • hansvschoot (hansvschoot@mastodon.social)'s status on Saturday, 22-Jun-2024 23:41:27 JST hansvschoot

     in reply to

     @nixCraft sure, you can even run multiple versions of Mysql side by side if you really have to. Just bind them to different ports. However, to prevent yourself a lot of dependency hell in your package manager, it is certainly advisable to put each database server in its own container. Docker, LXC, LXC, or whatever container system you prefer.

   • eno2001 (georgelenzer@mastodon.social)'s status on Sunday, 23-Jun-2024 00:12:32 JST eno2001

     in reply to

     @nixCraft Yes. It can be done. There is NOTHING wrong with doing it as long as your system has the resources to support the DBs with decent performance. One instance of MySQL and one instance of Postgres will not conflict with each other network wise using default ports. MySQL 3306. Postgres 5432. Of course you can select custom ports and run as many instances as you want then. The biggest issues will be storage I/O contention if you don't have separate storage for each DB engine...

   • Barry Rowlingson (geospacedman@mastodon.social)'s status on Sunday, 23-Jun-2024 00:29:28 JST Barry Rowlingson

     in reply to

     @nixCraft Dolphins and elephants living together!? On the same server!? Its against nature man!

   • Alonely0 🦀 (alonely0@mastodon.social)'s status on Sunday, 23-Jun-2024 01:50:25 JST Alonely0 🦀

     in reply to

     @nixCraft I'd use docker

   • theM0ntarCann0n (montar@mastodon.social)'s status on Sunday, 23-Jun-2024 03:53:58 JST theM0ntarCann0n

     in reply to

     @nixCraft FreeBSD has firejails, for what i know about them they should do it.

   • Ins0mniak (ins0miak@mastodon.social)'s status on Sunday, 23-Jun-2024 04:42:45 JST Ins0mniak

     in reply to

     @nixCraft is it possible to chew gum and walk at the same time?