Alibaba is leading a $27M investment in MariaDB • Hacker News Board

Re: Alibaba is leading a $27M investment in MariaDB

#101

Post by merb » Sat, Sep 30, 2017, 9:48 PM UTC

j_s wrote: post #20

icelancer wrote: post #14

Earlier quoted context omitted.

In-memory capability, hiring pool of MySQL/MariaDB developers tends to be larger/wider, Galera cluster (M-M functionality), if the queries trend towards simplicity then MySQL/MariaDB tends to be more performant, Postgres can have issues with write amplification, etc. Uber (I know, I know) switched to MySQL, here are some reasons why: https://eng.uber.com/mysql-migration/

Why Uber Engineering Switched from Postgres to MySQL | https://news.ycombinator.com/item?id=12166585 Re: Why Uber Engineering Switched from Postgres to MySQL | https://news.ycombinator.com/item?id=12179222 Why we lost Uber as a user | https://news.ycombinator.com/item?id=12201353 > naming / pronunciation diversion: https://news.ycombinator.com/item?id=12201672

please don't use uber as an example. they made just so many mistakes with postgresql (mistakes that would probably blow up a ton of databases including mysql)

Re: Alibaba is leading a $27M investment in MariaDB

#102

Post by merb » Sat, Sep 30, 2017, 9:51 PM UTC

icelancer wrote: post #14

zerr wrote: post #6

Earlier quoted context omitted.

What's the reason nowadays to use MySQL/MariaDB instead of PostgreSQL?

In-memory capability, hiring pool of MySQL/MariaDB developers tends to be larger/wider, Galera cluster (M-M functionality), if the queries trend towards simplicity then MySQL/MariaDB tends to be more performant, Postgres can have issues with write amplification, etc. Uber (I know, I know) switched to MySQL, here are some reasons why: https://eng.uber.com/mysql-migration/

> Galera cluster (M-M functionality)

not sure if galera cluster is a good thing.. we've started out with galera and it was a pain. we now run on postgres, but even if we would've stayed with mysql we wouldn't use galera anymore. network split was a pita, even if you had major quorum.

Re: Alibaba is leading a $27M investment in MariaDB

#103

Post by frik » Sun, Oct 01, 2017, 6:19 AM UTC

unixhero wrote: post #2

Strange, why not go for postgres

Postgres has toxic fanboys. Instead of going for closed source competition like Oracle, DB2, MSSQL where Postgres is a valuable competitor, these really stupid fanboys go for friendly open source databases. Unfortunately toxic Postgres fanboys do this for 15+ years. How about try to convert the "hard part" (enterprise), not the friendly minded ones.

Re: Alibaba is leading a $27M investment in MariaDB

#104

Post by technion » Mon, Oct 02, 2017, 7:38 AM UTC

merb wrote: post #101

j_s wrote: post #20

Earlier quoted context omitted.

Why Uber Engineering Switched from Postgres to MySQL | https://news.ycombinator.com/item?id=12166585 Re: Why Uber Engineering Switched from Postgres to MySQL | https://news.ycombinator.com/item?id=12179222 Why we lost Uber as a user | https://news.ycombinator.com/item?id=12201353 > naming / pronunciation diversion: https://news.ycombinator.com/item?id=12201672

please don't use uber as an example. they made just so many mistakes with postgresql (mistakes that would probably blow up a ton of databases including mysql)

The fact is there are decision makers - often non-technical ones - who do look at Uber as an example.

It's something we should at least consider an issue, even if it doesn't feel like a valid technical issue.

Re: Alibaba is leading a $27M investment in MariaDB

#105

Post by technion » Mon, Oct 02, 2017, 7:42 AM UTC

mdnormy wrote: post #12

zerr wrote: post #6

Earlier quoted context omitted.

What's the reason nowadays to use MySQL/MariaDB instead of PostgreSQL?

Familiarity? MySQL/MariaDB is pretty much the "standard" database that most programmer started with. At least in university. So there is no point on using PosgreSQL if MariaDB fits the bill for them. Less learning curve, easy to hire for etc

University?

I'm interested in what people's experiences here are. I spent the entire of my degree deep in Oracle, persistently being warned a database without object-relational queries were absolutely never used in the real world (how ironic).