Live data from Hacker News

An open-source MySQL alternative for running database on Kubernetes

github.com

31–40 of 61 posts

Re: An open-source MySQL alternative for running database on Kubernetes

#32

I had been keeping an eye on this project before, and upon checking it out recently, I've noticed many minor improvements. It's not just that one operator now supports multiple engines, but the feature experiences of several engines have also gradually become more well-rounded.

And their command line `kbcli` did impressed me, very easy to use. kbcli helps me create various clusters in several minutes. I have been working on mysql developing for more than five years, and I guess the ApeCloud team are very experienced in operating at least mysql.

Re: An open-source MySQL alternative for running database on Kubernetes

#33
post #27

The animated screenshot looks promising. I'd like to try it out. What's a good way to get SQL dumps inside the cluster? On the overview page there's a diagram for production deployment that includes a LoadBalancer for external clients. What Loadbalancer can I use that can proxy the MySQL protocol?

[dead]

Re: An open-source MySQL alternative for running database on Kubernetes

#35
post #8
post #2

This seems interesting but this passage from the readme is a red flag to me: >You do not have to learn database tuning. KubeBlocks can leverage storage and computing resources to achieve optimal database performance. No one has ever delivered on this pipe dream.

So... throw money on compute instead of just adding an index..?

This works when your data fits in L2 cache

Re: An open-source MySQL alternative for running database on Kubernetes

#37
>An open-source MySQL alternative for running database on Kubernetes

Very confusing title. It made me think it's some kind of open-source database compatible with MySQL (and kind of implies that MySQL isn't open-source).

It seems it's a tool for managing databases in Kubernetes.

Re: An open-source MySQL alternative for running database on Kubernetes

#38
post #27

The animated screenshot looks promising. I'd like to try it out. What's a good way to get SQL dumps inside the cluster? On the overview page there's a diagram for production deployment that includes a LoadBalancer for external clients. What Loadbalancer can I use that can proxy the MySQL protocol?

If you refer to backup, KubeBlocks provides ways to do backup with disk snapshot(supported from cloud provider like AWS EBS), file backup with tools such as xtrabackup for MySQL, wal-g for PostgreSQL. For SQL dump, a relative dump tool is recommended, such as mysql_dump for MySQL, you can dump it from the outside as a client, also, the built-in routine SQL dump will be supported in the near future. Anyway, KubeBlocks tries to integrate the best practices for any database product, the solution either provided by a well-known database provider or by an individual contributor, or by KubeBlocks official as you see from a fresh start. LoadBalancer is implemented with integrations of well-known cloud providers' LB controllers, it works in layer 4, so it can route any tcp traffics. When referring to MySQL proxy, KubeBlocks integrates vitess as proxy for apecloud-mysql(an addon in KubeBlocks, try 'kbcli addon list'), please try it out and enjoy yourself.

Re: An open-source MySQL alternative for running database on Kubernetes

#39
post #14

So now instead of debugging database performance issues you also have to debug the third party database orchestration middleware and the Kubernetes cluster workloads.

There is always an 'orchestration' middleware in some form, you just can't avoid it. The key is if the benefit it gives overcomes the complexity it introduces.

Re: An open-source MySQL alternative for running database on Kubernetes

#40

>An open-source MySQL alternative for running database on Kubernetes Very confusing title. It made me think it's some kind of open-source database compatible with MySQL (and kind of implies that MySQL isn't open-source). It seems it's a tool for managing databases in Kubernetes.

Yep, a DoK(Data on K8s) solution.
Post reply on HN