News for hackers. Stuff that matters.

A comment on Alibaba is leading a $27M investment in MariaDB. Parent comment

Re:Alibaba is leading a $27M investment in MariaDB by baybal2 on Saturday September 30, 2017 @04:58AM (#15371941)
The reason is that Alibaba is stuck with mysql and complex queries being put very very deep inside their architecture.

And yes, things like top level transaction databases are like hand maintained clusters of 20 servers for the whole Alibaba with query caching servers in front of them to prevent OOMs

They tried to get rid of it many times as written in their tech blogs, but this probably indicates that they finally gave up on such endeavour, choosing to own Mysql instead

[ Parent | on HN ]
Re:Alibaba is leading a $27M investment in MariaDB by baybal2 on Saturday September 30, 2017 @06:23AM (#15372171)
Their most sisyphean issue is the transaction locking. Imagine, 20 people trying to buy 19 trinkets, and you try to resolve transactions in a distributed DB, and two guys manage to buy the same thing in the exactly same nanosecond. The task is hard to tackle.

If you time-atomize the transaction, you get increase in minimal latency.

If you simply use a single server with very fast DB, you get reliability concerns.

With token ring locking, you get both.

And so on, so on, and on

[ Parent | on HN ]