0

I have a Windows 7 machine running MySQL database and I have a Linux machine running PostgreSQL database.

Preferably I would like to have only 1 machine housing both database as currently they are co-located in a datacenter which counts the electricty power and space used.

Would it be favorable to run 2 different database (MySQL and PostgreSQL) or convert the MySQL to a PostgreSQL?

closed as primarily opinion-based by mustaccio, McNets, Marco, LowlyDBA, Colin 't Hart Jan 7 at 10:47

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise. If this question can be reworded to fit the rules in the help center, please edit the question.

  • What does the usage look like? CPU, Memory and Disk I/O? If you have resources to spare then you can certainly run both engines on the same machine (apparently not server class). But if you are running just two databases then I don't think you would have any issues running them on one. – Jonathan Fite Jan 2 at 13:03
  • Don't forget it's going to cost you time and money to convert from MySQL to Postgres. Personally, I would like to host all my apps on Postgres. You could run a single cluster with multiple databases. But like I said this will take time for someone to do. And time is money. – Colin 't Hart Jan 7 at 10:46
1

Following up on @JonathanFite's comment, current and future resource usage is critical to answer this question, specifically memory capacity and I/O write performance.

Rule of thumb: if both databases can fit in RAM with room to spare, run both engines. If memory is limited, consider migrating the smaller database of the two, to the engine running the larger one.

Because you're most concerned about hosting costs, it will probably work out cheaper to consolidate, but you may have to increase your memory down the line.

Not the answer you're looking for? Browse other questions tagged or ask your own question.