From: Johan De Meersman Date: September 13 2010 10:03am Subject: Re: Unique ID's across multiple databases List-Archive: http://lists.mysql.com/mysql/222960 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=002215046ae318801c04902135b8 --002215046ae318801c04902135b8 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On Sun, Sep 12, 2010 at 9:45 PM, Kiss D=E1niel wrote: > offset + increment thingy is good if you know in advance that you'll have= a > limited number of servers. But if you have no idea that you will have 2, > 20, > or 200 servers in your array in the future, you just can't pick an optima= l > What benefit do you think you will reap from that many masters ? Don't forget that every write still has to be done on every server, so you're not actually distributing that load; while for reads you only need simple slaves. --=20 Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --002215046ae318801c04902135b8--