This page is about the SQL databases on the Mageia infrastructure servers.
Postgresql is the database server that is used for software that support it, MySQL is used if there is no other choice.
We are running postgresql 9.0 from Mageia 1 at the moment. The configuration can be found in svn, in the postgresql module ( http://svnweb.mageia.org/adm/puppet/modules/postgresql/ ).
The module use various specific trick to let use do server orchestration using puppet exported ressources. For a manifests writer, the only thing to know is that adding postgresql::remote_db_and_user will create the user, the database, add it to the list of database along wiht autorized ip and may run a callback to fill the db on next puppet run ( see mediawiki module for example ).
The Database Servers currently installed
- postgresql on alamut
- mysql on krampouezh
Main services using SQL databases
- blog: mysql (krampouezh)
- bugzilla: postgresql (alamut)
- epoll: postgresql (alamut)
- mga::mirror: postgresql (alamut)
- sympa: postgresql (alamut)
- transifex: postgresql (alamut)
- puppet: sqlite (valstar)
- phpbb: postgresql (alamut)
- mediawiki: postgresql (alamut)
For a more up to date list, see the puppet manifests, and grep for postgresql::remote_database and postgresql::remote_db_and_user, since they are the type used to remotely create the database on installation.
