News for hackers. Stuff that matters.
Re:Alibaba is leading a $27M investment in MariaDB by autotune on Friday September 29, 2017 @12:12PM (#15366558)
Probably because they don't use it: http://techstacks.io/alibaba
Re:Alibaba is leading a $27M investment in MariaDB by zerr on Friday September 29, 2017 @12:16PM (#15366591)
What's the reason nowadays to use MySQL/MariaDB instead of PostgreSQL?
Re:Alibaba is leading a $27M investment in MariaDB by icelancer on Friday September 29, 2017 @12:36PM (#15366771)
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/

Re:Alibaba is leading a $27M investment in MariaDB by j_s on Friday September 29, 2017 @01:02PM (#15366999)
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

Re:Alibaba is leading a $27M investment in MariaDB by dx034 on Saturday September 30, 2017 @06:53AM (#15372247)
I never understood which table caused these issues at Uber. They use an example with birthday changes for users. That's no real world example. Apparently issues were caused by a small table updated 500+ times a second and used in a lot of joins. That could be the driver table but why would they update it so much? Personal information rarely changes and live information about the driver (trip status, position, online/offline) should be stored separate from that? And you wouldn't need transactions around those updates?

Did they ever clarify what data actually caused the issues?

Re:Alibaba is leading a $27M investment in MariaDB by merb on Saturday September 30, 2017 @05:48PM (#15375155)
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 by technion on Monday October 02, 2017 @03:38AM (#15382244)
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 by merb on Saturday September 30, 2017 @05:51PM (#15375162)
> 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 by netcraft on Friday September 29, 2017 @12:52PM (#15366905)
can you elaborate on the in-memory capabilities you mention? My google searches aren't yielding anything.
Re:Alibaba is leading a $27M investment in MariaDB by netcraft on Friday September 29, 2017 @02:23PM (#15367741)
I'm aware of the memory capabilities of mysql in general, but the insinuation was that mysql had more capabilities of in-memory processing than postgres - I dont see anything in those links that are things that postgres cant do - although they may be implemented differently.
Re:Alibaba is leading a $27M investment in MariaDB by haimez on Friday September 29, 2017 @08:41PM (#15370453)
The honest answer is that you can get the desired result with Postgres, even if it might require a custom foreign data wrapper implementation. Carpenters pick their favorite saws, and they like MySQL.

To be fair, uber did get burned by a Postgres replication failure- but they also had a NOC team promote 3 bad replicas to primary before stepping back to reconsider their approach. Carpenters do hate losing their fingers in circular saws.

Re:Alibaba is leading a $27M investment in MariaDB by riku_iki on Saturday September 30, 2017 @12:46PM (#15373701)
It is simple, MySql has in-memory storage, and PSQL doesn't: all updates for your table are forced to be synced to the disk, which kills performance.
Re:Alibaba is leading a $27M investment in MariaDB by Thaxll on Friday September 29, 2017 @01:37PM (#15367350)
MySQL is faster. There are people that will argue against it but they probably don't understand how the vacuum works. Also if you only read HN yeah you're bias on Postgres vs MySQL. On the end Postgres is "better" but MySQL is already pretty good, it's not like you're comparing a good product to a bad one, both of them are good.
Re:Alibaba is leading a $27M investment in MariaDB by qaq on Friday September 29, 2017 @02:23PM (#15367734)
InnoDB is MVCC too
Re:Alibaba is leading a $27M investment in MariaDB by richardknop on Friday September 29, 2017 @12:23PM (#15366656)
That question could be asked in a reversed fashion too. PostgreSQL is the favorite database here on HN (I prefer it too) but for a generic company out there MySQL/PostgreSQL are interchangeable. Won't really matter which one you choose and I think it's easier to hire people with MySQL experience.
Re:Alibaba is leading a $27M investment in MariaDB by mdnormy on Friday September 29, 2017 @12:27PM (#15366697)
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

Re:Alibaba is leading a $27M investment in MariaDB by takeda on Friday September 29, 2017 @04:23PM (#15368804)
I actually had databases class which used MySQL for exercises and essentially it was like this:

* you can configure triggers for a table, but you can't use them in MySQL unless you make sure the table is InnoDB (this was a while ago before defaults changed)

* MySQL doesn't support aborting INSERT/UPDATE/DELETE from trigger, but you can emulate it by throwing an exception

* a table can have a CHECK constraint, but you can't use it because it is not available in MySQL

Makes one wonder MySQL was picked for that class. I get that it was because it was very popular at the time, but it felt like a toy compared to a functionality that any other database had.

Re:Alibaba is leading a $27M investment in MariaDB by jstarfish on Friday September 29, 2017 @12:30PM (#15366727)
Also the default database on most shared hosting, so anybody who got a start in web dev likely cut their teeth on MySQL.
Re:Alibaba is leading a $27M investment in MariaDB by type0 on Saturday September 30, 2017 @07:44AM (#15372401)
Yeah, LAMP stacks are to blame for it's popularity.
Re:Alibaba is leading a $27M investment in MariaDB by technion on Monday October 02, 2017 @03:42AM (#15382261)
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).