#1649 PGPool (because django is too dumb to know how to do it)
Closed: Fixed None Opened 14 years ago by mmcgrath.

= phenomenon =

Transifex is running out of db connections because people are actually using it.

= background analysis =

django was designed in such a way that not many people should use it.

= implementation recommendation =

Deploy pgpool everywhere transifex is deployed and point it at the transifex db, point transifex at it, this will need to be tested and puppetized.


http://www.djangobook.com/en/2.0/chapter12/

Note, we will want to do this for mirrormanager as well. SQLObject doesn't allow limiting the number of connections either and mirrormanager has been one of the reasons we run out of connections.

mmcgrath has pgpool transparently sitting in front of postgres in the staging environment. Testing shows that it increases our throughput for all queries to all dbs.

If I remember correctly, this was disabled near a release after we ran into some problems - do we still need to look into this?

Yeah, we need to get it setup until we're happy with it. The way it was was buggy in a weird way.

With the plans to move to tx.net, won't be much of a priority anymore, closing for now.

Login to comment on this ticket.

Metadata