Feature #7617
open
Replicating a redmine instance geographically across continents
Added by Dave Täht almost 14 years ago.
Updated almost 14 years ago.
Description
On the bufferbloat.net project there will be developers spread across a minimum of three continents - Europe, the USA, and Australia. The latencies for accessing a site based only in the USA are already quite high.
I am curious what it would take to make redmine more of a "read-mostly" system, where the primary database connection could be served locally (updates streamed from the main postgres database), and edit operations only served from the main site?
If postgres can replicate data in read-write fashion, you can have one instance of the DB and of redmine on each continent as long as the redmine config (DB, cookie secret, …) is the same everywhere, you'd only have to make sure to replicate the files
directory across all instances on your own.
Dave Täht wrote:
Many readers, one writer unless you've gone through great pains in redmine to use uniqueness properties like sha1 hashes. AND can do all write transactions through a separate connection to the main db.
Nope to the hashes, and nope to the "write through a second connection". That might be doable, maybe there are plugins for that, but Redmine can't do it OOTB. You might have better performance with one instance per continent all connecting to a shared DB, but that's all that I can think of right now.
Also available in: Atom
PDF