Live data from Hacker News

PolarDB, yet another open source database system based on PostgreSQL

github.com

61–70 of 103 posts

Re: PolarDB, yet another open source database system based on PostgreSQL

#61

Fantastic! I was actually looking for a buggier version of postgres that won't be supported a year. That's exactly what I was looking for. > PolarDB will evolve and offer its functions and features in two major parts: Oh boy.

How do you think the next dominant Database platform will start? Is your expectation that innovation requires polish before hitting the (free open source) “marketplace”?

> How do you think the next dominant Database platform will start?

Not this way.

Re: PolarDB, yet another open source database system based on PostgreSQL

#65
post #17

Looking at their code tree, this is based on 11.2 ( https://www.postgresql.org/docs/11/release-11-2.html ): https://github.com/alibaba/PolarDB-for-PostgreSQL/blob/maste... So this is code from two years ago missing stability fixes from upstream up to 11.12, at short sight.

Are there any stability fixes you have in mind? In my recollection, there is not much instability in PG releases.

IMHO: with the latest fix -> more stable

search for "crash":

https://www.postgresql.org/docs/release/11.3/ ( 11x )

https://www.postgresql.org/docs/release/11.4/ ( 4x )

https://www.postgresql.org/docs/release/11.5/ ( 1x )

https://www.postgresql.org/docs/release/11.6/ ( 3x )

https://www.postgresql.org/docs/release/11.7/ ( 14x )

https://www.postgresql.org/docs/release/11.8/ ( 5x )

https://www.postgresql.org/docs/release/11.9/ ( 6x )

https://www.postgresql.org/docs/release/11.10/ ( 5x )

https://www.postgresql.org/docs/release/11.11/ ( 3x )

https://www.postgresql.org/docs/release/11.12/ ( 5x )

Re: PolarDB, yet another open source database system based on PostgreSQL

#67
post #40

What are people/companies using currently to make their postgres database distributed these days? Currently running my app + db on Heroku in the EU and would like to scale out since latency is abysmal for users in Australia and Asia.

I’m glancing over the Heroku Postgres docs and they seem to offer easy to set up read replicas called “followers”. Wouldn’t this work for you?

Heroku is only available in EU and US east. Latency from Australia is somewhat unavoidable. You can maybe reduce it by using Cloudflare or similar to terminate TLS as close to your users as possible.

Re: PolarDB, yet another open source database system based on PostgreSQL

#68

Earlier quoted context omitted.

There’s no need for consolidation when Postgres already exists.

Sometimes I dream about a highly available multi primary postgresql.

Do you also dream of loss of certain ACID semantics or crippling performance issues?

In the real world, it is extremely hard to provide all the same guarantees you get out of a single instance of if you turn around and spread it across the internet.

If you have super deep control over the physical & temporal environment around your system, you can cheat the rules a little bit (i.e. Google).

Re: PolarDB, yet another open source database system based on PostgreSQL

#69
post #50

Earlier quoted context omitted.

HA isn't really about 100% availability. Any single system that promises such is extremely likely to be misleading you somehow. Your in-flight query is going to get interrupted no matter how fancy your clustering is, and I struggle to even come up with hypothetical use cases where this is something you can't afford to have happen, ever. All you need is that in the event of a failure the clustered system can still rec…

> I struggle to even come up with hypothetical use cases where this is something you can't afford to have happen, ever. a rocket is using this query to adjust their trusters ;)

Such a rocket would likely have two or more independent systems that would each have to agree on the adjustment, so one of them temporarily failing would not pose a problem. Though I doubt there are any rockets using database queries as part of their control system.

In those kinds of systems I suspect the approach is to enumerate every possible scenario and prove that the system behaves correctly in all of them, and if you can't do that, the system may be too complex and you need to redesign it to be simpler so that you can guarantee that it does not fail.

Re: PolarDB, yet another open source database system based on PostgreSQL

#70
post #15

Oh, what's going on here? > OceanBase, the database of Alibaba's fintech company Ant Group, will be open-source soon, possibly as early as June 1, according to Sina Tech. https://cntechpost.com/2021/05/27/ant-groups-in-house-databa... Also the team published many papers about PolarDB. https://scholar.google.com/scholar?hl=en&as_sdt=0%2C48&q=%22...

Alibaba is huge and different teams have different goals.

That one is for fintech.

Post reply on HN