News for hackers. Stuff that matters.

west0n

but when the VPS fails, you lost all your data
If you want to run a database on VPS with ssd disk, you'll need at least two replicas for data redundancy, which would cost about $10.

Show HN: WeSQL – Agile MySQL with S3-Based Storage

https://wesql.io/

WeSQL is an innovative MySQL distribution that adopts a compute-storage separation architecture, with storage backed by S3 (and S3-compatible systems). It can run on any cloud, ensuring no vendor lock-in.WeSQL has completely replaced MySQL’s traditional disk storage with S3. All MySQL data—binlogs, schemas, storage engine metadata, WAL, and data files—are entirely (not partially!) stored as...

( Read More... | no comments | 2 points | on HN )
Re:Building rqlite 9.0: Cutting disk usage by half on Tuesday August 06, 2024 @12:48AM (#41167850)
I'm curious about how rqlite's performance compares to other distributed databases developed in Go, such as CockroachDB, Vitess, and TiDB.
Re:No Abstractions: our API design principle on Thursday April 25, 2024 @09:24PM (#40164972)
If we didn't have abstractions like POSIX, applications would need to write an adaptor for every supported file system.
Re:The Arc Product-Market Fit Framework on Saturday April 13, 2024 @11:18PM (#40028362)
We have developed a control plane software that can run&manage multiple databases on K8s. I believe that in the public cloud, this business is already "Hair on Fire", as every cloud provider offers their own managed services for databases like MySQL, PostgreSQL, etc. However, in on-premise environments, this is "Hard Fact", because convincing users/customers requires acceptance of two facts:

- The future trend is to run databases on K8s. - Using a unified control plane software for all kinds of databases you use, rather than different control planes for each type of database, which would lead to a high learning curve to the Ops/SRE.

It's encouraging that we have already found some on-premise users who buy in our concept, and we hope to convince more people.

Re:Mental Health in Software Engineering on Thursday April 11, 2024 @08:54AM (#40001573)
As the founder and CEO of a two-year-old startup, seeking certainty in the direction amidst uncertainty (determining which products can bring customers and profits) should become my instinct.
Re:A MySQL compatible database engine written in pure Go on Tuesday April 09, 2024 @09:00PM (#39985925)
Interesting, another project implemented in Go that is compatible with MySQL server, alongside others like Vitess and TiDB.
Re:Distributed SQLite: Paradigm shift or hype? on Monday April 08, 2024 @09:56PM (#39975618)
See some development frameworks for local-first apps support both SQLite and PostgreSQL. The advantage of using PostgreSQL is that when you add a cloud option to your local-first app, the migration becomes much easier.
I bet that all message queues and log databases will support S3, as these types of data generally have a large volume and aren't as economically valuable (don't get me wrong, what I mean is that these databases won't be frequently read and processed).
Here is our approach: From Markdown to a Docusaurus Website via GitHub, gh Actions, and gh pages

https://baky0905.github.io/personal-website/blog/2021/04/02/...

Re:KraftCloud on Tuesday April 02, 2024 @06:44AM (#39904250)
Looks like microVM.
Re:A path out of bloat: A Linux built for VMs on Monday April 01, 2024 @09:13PM (#39901313)
Why not use containers, they even shares the kernel.
Re:AIOS: LLM Agent Operating System on Monday April 01, 2024 @09:06PM (#39901280)
Adding support for LLM Agent scheduling, context switching, and storage management within the operating system kernel.
Re:Battle of the Redis Forks? on Monday April 01, 2024 @11:19AM (#39895053)
I think the codebase of Redis is too small, which makes the cost of maintaining a Redis fork relatively low. Moreover, Redis was forked too late. This puts Redis Inc. at a disadvantage in the battle against cloud vendors.
Re:Your database skills are not 'good to have' on Monday April 01, 2024 @11:15AM (#39895018)
so I leaved Rails, lol
Re:Your database skills are not 'good to have' on Monday April 01, 2024 @11:14AM (#39894999)
this is so called "Materialized View"
In our production environment, we use XFS to run various databases, including MySQL, PostgreSQL, MongoDB, etc. It delivers performance that is either superior to or on par with ext4.

I'm interested to see if there're some ZFS users.

Re:Your database skills are not 'good to have' on Monday April 01, 2024 @10:52AM (#39894747)
lesson: DONOT join more than 3 tables in MySQL, lol

Older »