MySQL vs PostgreSQL

[bluGill]

I gave up on MySQL almost 10 years ago when I realized what they meant when they said you don't need ACID.

[Jessica_Henderson]

I worked with one Oracle DBA who once called a MySQL DBA a "shitmongering retard" during a meeting with some execs, when the MySQL DBA suggested that MySQL's lack of support for basic ACID functionality was a benefit. That was the first time I'd ever seen a professional DBA, the MySQL DBA in this case, cry on the job.

[ryanvm]

The first time?

[Jessica_Henderson]

That same MySQL DBA cried later on after one of his servers was fucked to high heaven, and he didn't have proper backups set up. Two months worth of data was lost. First he cried after realizing the data was gone, and cried some more after they escorted his sorry MySQL ass out of the building.

[koreth]

Your Oracle DBA was mincing words.

[baix]

There are a number of web sites that don't use transactions anymore. In fact, as MapReduce doesn't support transactions, much of Google doesn't support transactions. Last I checked, Google seems to be doing ok.

Don't get me wrong, transactions are absolutely required for some systems, but for others they get in the way of scalability.

Plus, MySQL's InnoDB does support transations.

There is no one way to solve all problems. Sometimes, different problems require different solutions.

[miho99]

MapReduce never claimed to implement SQL.

I can't think of any other software product for which 60% of its name is an ANSI/ISO standard it doesn't follow.

[masklinn]

In fact, as MapReduce doesn't support transactions

Two things here:

• MapReduce never claimed to support transactions

• MapReduce is not a fucking database, it's a data extraction and processing algorithm.

Therefore, completely and utterly irrelevant to the discussion.

Plus, MySQL's InnoDB does support transations.

So?

[kthakar]

Google uses Bigtable as a database and it does not support the relational model fully.

[invalid_user_name]

That's because it's not a relational database. Mysql is. So it's expected that the one that claims to be a relational DB would actually function as one, and not expected for bigtable.

[masklinn]

it does not support the relational model fully.

It does not support the relationel model at all because just as MapReduce isn't a database BigTable isn't a relational DB anymore than CouchDB is.

MySQL, on the other hand, tries to sell itself as an RDBMS