Other flavours of mySQL

[shade]

Hello,

Can OPSI handle other "flavours" of mySQL ?

We use Percona Server for our 2 other SQL servers and are happy with it, and if it possible I would like to have the OPSI server to also run that version to only have one version. Is this possible with OPSI ?

Regards

[dkoch]

Its been reported that some people here use MariaDB instead of Mysql which is another fork.
Percona should be fine if they didnt change anything that breaks the compatibility to mysql.

I am also maintaining a postgres backend which is not supported by uib https://github.com/kochd/opsi-postgres but compatible.

[n.wenselowski]

Hello,

Its been reported that some people here use MariaDB instead of Mysql which is another fork.
Percona should be if they didnt change anything that breaks the compatibility to mysql.

I am also maintaining a postgres backend which is not supported by uib https://github.com/kochd/opsi-postgres but compatible.

Great answer.

Officially we only support MySQL but as long as they are compatible to MySQL you should be fine. One small tripwire could be that we use MySQLdb to connect to the database and your server must work with that too.


With kind regards

Niko

[denmarknian]

Hi Dkoch, We used your postgres DB and it's working fine. It's just that the server had a high memory utilization after we converted but I think it's Ok we can just upgrade to a higher memory. Do you have suggested hardware requirements for the postgres DB? Thank you.

[dkoch]

Hi denmarknian,

Is that memory cosumed by a opsi process or by a postgresql process ?

If its opsi and still present after restarting the services and running some time there might be a memory leak.
I know about a memory leak in opsi-package-manager which i have not attend to yet. But that is not related to the postgres backend.
If its postgres that might be because databases usually cache a lot. Also there is a difference between used memory, buffer and cache. Don't know how familiar you are with linux. http://www.linuxatemyram.com/
You can tune postgres and its memory usage a lot. For assistance in that have a look at pgtune and the postgres wiki

[denmarknian]

Thanks a lot dkoch. I have to check thiat with our administrators. Btw, it usually happened every morning when clients boots up and tred to connect to the server. After all clients boots up then the utilzation goes down.

[dkoch]

Well that’s meant to be

[SisterOfMercy]

Its been reported that some people here use MariaDB instead of Mysql which is another fork.

I'm one of them, but am only using it to store certain things, because I don't have a license for the MySQL backend. So, YMMV.
If I'm correct, Red Hat has MariaDB as standard since RHEL7.0

[rmtevesjr]

Anyone tested postgres or mariadb in 4.0.6?

[n.wenselowski]

Hi,

Anyone tested postgres or mariadb in 4.0.6?

mariadb works.
Also in 4.0.7.
Until now I haven't seen incompatibility that required special MySQL drivers.


Kind regards

Niko