Mysql – run MySQL and Postgresql together on a VPS

MySQLvps

I'd like to know if anybody has any experience with this. I have a VPS server with ruby On rails, nginx and pgsql.
I'd like to use WordPress on it too, and the biggest issue seems to be running it on postgresql.

So, do you think I can run two databases on one VPS, considering the VPS is 512MB and the sites are not very much visited?

Best Answer

I have a customer server (Ubuntu 10.04, 64 Bit) with Postgres and MySQL running at the same time. It is very important that you configure both database servers accordingly to your RAM. The server I am using is equipped with 4 GB RAM, which causes Ubuntu to use the SWAP from time to time.

512 MB RAM for all your applications seems to be very low - I can only advice you to try it out and gain some field experience.

By the way, a default wordpress database only consums 2-3 MB (without the custom content, ofc).

Related Solutions

Vps – Running Ruby on Rails App on Apache + Passenger == to much memory

You can configure how many Rails processes Apache/passenger spawns. For your size (3 concurrent requests) you should be fine with 2 rails processes:

Set these in your apache config:

PassengerMaxPoolSize 2
PassengerMaxInstancesPerApp 2

The MaxPoolSize determines how many instances can be started maximally, the MaxInstancesPerApp determines how many instances each web-app can have.

You might want to play with:

PassengerPoolIdleTime

to specify how many seconds an instance must be idle before it is unloaded. Default is 300 seconds.

I run pretty high traffic web application with 3 instances without any problems.

Oh and - the Ruby Enterprise Edition helps too.

Linux – 384 MB enough for a starter VPS

That really depends on your applications. You might want to consider running a VMWare image with the same OS and amount of memory allocated, deploying your 10 or so small websites to that image, and running a stress test against the image that emulates the approximate traffic you expect.

Best Answer

Related Solutions

Vps – Running Ruby on Rails App on Apache + Passenger == to much memory

Linux – 384 MB enough for a starter VPS

Related Topic