Do you have a question? Post it now! No Registration Necessary. Now with pictures!
July 11, 2005, 7:06 am
rate this thread
can become master at any time (by human decision). The two servers are
placed at geographically different sites. The servers contain à number
of databases which are all replicated both ways.
When we have full usage of one master ~500 inserts/updates per second,
the bandwidth between our sites becomes a significant bottle-neck. This
we can accept at database level not on server level, ie
- if database A on site B has a lag of 30min because of important
activity on database A on site A, it is acceptable.
- if database B on site B has a lag of 30min because of important
activity on database A on site A, it is not acceptable.
Is there a work-around? We never have updates concerning 2 databases in
the same query.
Creating multiple mysql servers at each site could be one, but that
means some 10-50 servers on every physical computer. What side-effects
does that create?
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum