Forum GLPI-Project

hakimjamali

Member

Registered: 2013-07-22

Posts: 8

recommended GLPI Architecture

Hi all,

I had few questions erlated to GLPI if some one can help :

Which all DB are supported, what is the recommended DB architecture. Is clustered DB, multiple node servers supported.

can we use clstered database like percona DB/mysql cluster & will it help increasing the performance. Has any one used & can recommend the best architecture and cluster to be used.

We have GLPI running in our production. & system is too slow. Its been found that the database queries are really slow. We have around 500 connection at a time.
Currently around 500users are using GLPI & now we have to make it live for all of our organization for 5000 users.
Please suggest a suitable cluster & architecture for better performance.

ddurieux

Plugins Dev

From: Propières, France

Registered: 2005-06-17

Posts: 7,521

Re: recommended GLPI Architecture

GLPI use MySAM engine

For better performances, you can have a master MySQL and many slaves (1, 2, 3...)

After, use mysqlproxy to direct UPDATE and INSERT to the master, and all SELECT to the slaves.

if your DB is not too big, you can have a slave with data all in memory (like use of ramfs). But require more than space use by the DB (I have made tests and have very nice performances)