Server God

[inaki]

That's right! Four node master-master PostgreSQL cluster running with less than 1ms delay between the nodes. BOOYAH.

.. Tons of documentation on how I did it forthcoming later.

Comments

Cool!

[timberwuf.livejournal.com]

I understand and have set up MySQL master-slave setups. (This means that all writes are sent to the master which then sends prechewed and partially digested versions to the slaves which then apply the same changes to their data. Reads can happen anywhere, with the proviso that a slave might be behind a master depending on the number of updates and the speed of the Internet connection between them.) How do multiple masters work?

Re: Cool!

[inaki.livejournal.com]

With multiple masters, read/write can happen on any node. There's two type, sync and async. With sync, all the nodes must report in before a write is considered committed.. with async, each node commits as replication is recieved. I'm doing sync.

[its-a-trap.livejournal.com]

I don't really know what you're talking about (i'm software only), but congratulations :3

[tixen.livejournal.com]

:D :D :D

[sevencorvina.livejournal.com]

And if it wasn't for me, you'd have never even had a reason to learn Postgres. Thank you so much by the way, you've really helped move our company forward.

[inaki.livejournal.com]

This is true! <3 I'm just happy to be learning again. =D