4 ms·
Does Postgres have reliable, tolerably-easy-to-install-and-configure master/slave replication yet? That's the only thing that kept us off postgres last time we
by Calamitous 16y ago
Does Postgres have reliable, tolerably-easy-to-install-and-configure master/slave replication yet? That's the only thing that kept us off postgres last time we were looking, we definitely need a fast, reliable, read-only slave.
- stephen 16y agoI think what you're looking for is the marque feature of 9.0: http://developer.postgresql.org/pgdocs/postgres/release-9-0.html http://developer.postgresql.org/pgdocs/postgres/release-9-0....
- Calamitous 16y agoOh, man, sweet. :) Now to get the Ops guys on board...
- mmt 16y agoAny "Ops guys" who don't find something like Slony tolerably easy to install might not be suited to your environment. I've found the "feature" that MySQL replication is integrated[1] to a huge problem, especially when faced with messes made by those who installed/implemented it because understanding something more complex (like the realities of database replication) would have been too high a barrier to entry. It also, of course, meant that competing solutions were rare, something that, in the case of MySQL, I do consider a benefit. [1] I hesitate to use the term "built in," since there's a giant piece missing: initial synchronization. They want me to do what?! A full dump and restore, before I even turn on the replication? That, as well as the "tip" of just copying files over always struck me as amazingly manual.
- chrisbolt 16y agoThe way we do initial synchronization with MyISAM: * Everything is on LVM * Run FLUSH TABLES WITH READ LOCK * Take an LVM snapshot then record binary log filename and position * Run UNLOCK TABLES * Mount snapshot, rsync to new server and bring up replication with recorded file and position Very fast and only locks tables for a short time.
- LiveTheDream 16y agoBeware of FLUSH TABLES WITH READ LOCK potentially causing an exclusive lock. The percona guys give an explanation: http://www.mysqlperformanceblog.com/2010/04/24/how-fast-is-flush-tables-with-read-lock/ http://www.mysqlperformanceblog.com/2010/04/24/how-fast-is-f...
- mmt 16y agoEverything is on LVM An excellent idea, which I, too, have advocated. It is, of course, external and not integrated with MySQL.
- sandGorgon 16y agoWith a live snapshot, doesnt MySQL performance take a massive hit ? I have seen benchmark numbers from the MySQL Performance Blog people.
- donw 16y agoI'm an Ops guy by trade, and I would sacrifice non-redundant organs to have worked for more companies that used Postgres. Of course, my startup does.
- deleted 16y ago[deleted]
- prodigal_erik 16y agoMore than once, our DBAs have come to us asking how to handle discrepancies between masters' and slaves' copies of the same rows. That this is even possible says all you need to know about how reliable MySQL's replication design is. The solution to this problem (2PC) is older than I am.
- jasonlotito 16y agoThat was the big feature missing when I explored using PostgreSQL. At the time, many many years ago, it was black and white. Went with MySQL, and never had any issues. I was happy to see they are finally getting solid replication in 9. About time. =)