Thread: ocs-setup with mysql versus postgres

I am using Red Hat HPC Solution 5.3

contents of /etc/kusu-release are:
Kusu "Platform OCS" 5 (build 1991)

I tried a fresh install of RHHPC Solution 5.3 on top of a fresh install of RHEL 5.3. I set KUSU_DB_ENGINE to "mysql" in /opt/bin/kusuenv.sh, because I had previously used Red Hat HPC Solution 5.2 which used mysql by default, and I wanted to set it up the same way. (default for HPC solution 5.3 now seems to be postgres).

But there were numerous problems running /opt/kusu/sbin/ocs-setup with KUSU_DB_ENGINE set to "mysql".

I managed to hack the ocs-setup script to make it work, and now the installation is successful using mysql.

But I am wondering whether use of mysql is being phased out or if this is still supported in the kusu release.

Can anyone tell me whether it is OK to continue to use mysql for new installations? Or is the preferred database now postgres and is it better to use postgres?

Hi

It would be better to stick with postgres as Kusu has now been moved to postgres database.

-Liming

Thanks very much for the info. I have installed using the default postgres setup and everything is fine.

Why was this changed?
We prefer to use mysql.
Can it be made an install option?

Hi,

This certainly can be considered in the future.

Thanks for your feedback.

-Liming