News for hackers. Stuff that matters.
Re:Amazon RDS for PostgreSQL by jes5199 on Thursday November 14, 2013 @12:51PM (#6733908)
Some engineers I worked with went and interviewed people at various San Francisco startups about their experiences with their databases.

The MySQL startups tended to say "We love MySQL. We've gotten in the habit of taking an hour or two of downtime in the middle of the night every week to run all of our schema migrations, and we've had to build our process around that, but one we had it in place, everything's been fine."

The PostgreSQL startups said "We love PostgreSQL. We run schema migrations in real-time during the middle of our workday, and we don't have any problems."

Re:Amazon RDS for PostgreSQL by ceejayoz on Thursday November 14, 2013 @02:46PM (#6734986)
pt-online-schema-change from Percona addresses this particular point with MySQL nicely for us, incidentally. We use their Percona XtraDB Cluster fork and are quite happy.
Re:Amazon RDS for PostgreSQL by daniloassis on Thursday November 14, 2013 @05:37PM (#6736199)
I guess we are talking about RDS options though :)
Re:Amazon RDS for PostgreSQL by ceejayoz on Thursday November 14, 2013 @09:08PM (#6737246)
Entirely possible to use pt-online-schema-change on an RDS instance. It's just running a bunch of SQL commands and is very happy to do them against a remote database like an RDS instance.
Re:Amazon RDS for PostgreSQL by gtaylor on Thursday November 14, 2013 @03:36PM (#6735357)
But that's not included in mainline MySQL, correct?
Re:Amazon RDS for PostgreSQL by ceejayoz on Thursday November 14, 2013 @03:46PM (#6735431)
The Percona Toolkit works with mainline MySQL and is trivial to install.
Re:Amazon RDS for PostgreSQL by gtaylor on Thursday November 14, 2013 @04:01PM (#6735538)
I guess that means "No, it's an unofficial, third party toolkit".
Re:Amazon RDS for PostgreSQL by ceejayoz on Thursday November 14, 2013 @05:04PM (#6735993)
So's jQuery, but that hardly stops me from using it. Unsure as to the point you're trying to make.
Re:Amazon RDS for PostgreSQL by Iftheshoefits on Thursday November 14, 2013 @05:29PM (#6736146)
For starters, the requirement of a third-party library introduces at least two problems:

1. An additional potential point of failure 2. The core software (a DB, in this case) can (and probably will) evolve independently of the third-party tool--thus introducing an additional layer of maintenance problems.

I'd argue further--and this is of course just an opinion--that such a basic feature as this ought to be supported out-of-the-box by anything that claims to call itself a "database" in the sense that MySQL does.

Re:Amazon RDS for PostgreSQL by oceanplexian on Thursday November 14, 2013 @08:07PM (#6737053)
Percona and pt-online-schema-change is not just "some third-party library".

It's an industry-standard tool and one of the most respected forks of MySQL. It's not a layer of maintenance problems and they sell commercial support.

Their customers include the BBC, Yelp, and Cisco: http://www.percona.com/about-us/customers

Also, for the record, Oracle added online schema changes in 5.6.

Re:Amazon RDS for PostgreSQL by gtaylor on Friday November 15, 2013 @12:17AM (#6737878)
So you actually have to use a fork of MySQL to get online schema changes? I was thinking this was just a drop-in of some sort.
Re:Amazon RDS for PostgreSQL by gtaylor on Thursday November 14, 2013 @05:26PM (#6736128)
There is no "point". I asked a question and you didn't answer it directly.
Re:Amazon RDS for PostgreSQL by smileysteve on Thursday November 14, 2013 @01:56PM (#6734553)
Very important to note that MySQL 5.6 has ONLINE ALTER.
Re:Amazon RDS for PostgreSQL by Sanddancer on Thursday November 14, 2013 @08:41PM (#6737160)
Looking through the documentation, though, it's even worse than just saying every alter is an offline alter. There are a few, but significant, schema changes that one could want to make -- like when dealing with a table that has full text search -- that need to be done offline; you have to tread real real lightly in dealing with online alters. I'd personally argue that online alter is not ready for prime time with 5.6; there are too many other things they need to do with the database engines to make it really useful.
Re:Amazon RDS for PostgreSQL by maaku on Thursday November 14, 2013 @02:12PM (#6734680)
Is it transactional?
Re:Amazon RDS for PostgreSQL by dangrossman on Thursday November 14, 2013 @03:43PM (#6735411)
Re:Amazon RDS for PostgreSQL by nphase on Thursday November 14, 2013 @03:26PM (#6735287)
Which tools enable real-time schema migrations in Pg?
Re:Amazon RDS for PostgreSQL by gtaylor on Thursday November 14, 2013 @04:04PM (#6735566)
CREATE INDEX CONCURRENTLY, ALTER, and others. Batteries included.

This has saved our bacon a number of times. The only kind of DB-related downtime we have is when we're doing a Postgres upgrade.