Which Database Are You Using?

[CarlosinFL]

I was wondering how many different RC users are using specific databases and if you've tried anything else. I started RC using MySQL and quickly realized the perforamance gain by moving to PostgreSQL. I have over 500 users and each of them have their personal address books and other data. The switch was amazing and couldn't be happier getting away from MySQL. Post what you're using and any issues you've had.

Thanks!

[CarlosinFL]

I'm actually very surprised at how many people use MySQL. I'm only assuming that most don't really care about the database and just install MySQL since they're only familiar with it and or just set it and forget it. I switched to PostgreSQL and the performance difference was night / day!

[SKaero]

PostgreSQL is also installed on less servers.

[CarlosinFL]

PostgreSQL is also installed on less servers.

How do you figure?

[SKaero]

MySQL is more common, a lot of the open source don't have support PostgreSQL and from my research only 1 out 3 web hosts offer PostgreSQL. I can't find any hard numbers but I see a lot more scripts and host that offer/support MySQL then PostgreSQL.

[ABerglund]

Is there a script or process available to migrate from MySQL to PostgreSQL? I've got a bit more than 2000 users, making them all restart from scratch now in a new DB would be politically inconvenient.

[CarlosinFL]

Is there a script or process available to migrate from MySQL to PostgreSQL? I've got a bit more than 2000 users, making them all restart from scratch now in a new DB would be politically inconvenient.

I've got 4 reasonable small databases in my office that run the conference room scheduler (MRBS), webmail (RoundCube), and Wiki (MediaWiki) that I need to convert to PostreSQL. I'm interested in doing the same!

[SKaero]

Good list of conversion methods here: http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL