[wp-hackers] Allow Wordpress to use a Slave Database

[howard chen]

On Tue, Jun 3, 2008 at 11:54 PM, Otto <otto at ottodestruct.com> wrote:
> On Tue, Jun 3, 2008 at 9:38 AM, howard chen <howachen at gmail.com> wrote:
>>> Once again, I wish MySQL was capable of bi-directional replication.
>>
>> Just need to make sure auto increment ID will not conflict with other
>> node, then master-to-master replication is easy to setup, right now.
>
> Well, yeah, but then that's sort of the problem, isn't it? It works
> fine if you don't mind dealing with setting auto_increment_increment
> and auto_increment_offset everywhere and then dealing with big gaps in
> your auto-increment table. Auto-increment columns are pretty much
> everywhere, having them look all strange by using offsets and such
> just strikes me as a strange and somewhat annoying way to go.
>

Sure, master-to-master setup is only for realtime, write hungry applications.

Personally, if I really hit that limit, I would think about reduce the
number of write or update per request.

E.g. Use of memcached for temp storage and write to DB in a batch.

Howard.