mattlord

6 ms·

1.
by mattlord 7mo ago
It's open source. If you really want to know these things, I would encourage you to look at the code and read the documentation. As noted in the blog post, reverse vreplication is setup when you switch. You can switch back and forth an
2.
by mattlord 7mo ago
So you don't understand how something works. That's fine. But to then say the article and/or tech are BS is... a choice. This work has been and is being used by some of the largest sites / apps in the world including Ube
3.
by mattlord 7mo ago
It's open source. If you want to understand exactly how, you certainly can! :-) https://github.com/vitessio/vitess https://vitess.io/docs/reference/vreplication/ https://
4.
by mattlord 7mo ago
It's open source. You can get as many details as you like :) https://github.com/vitessio/vitess https://vitess.io/docs/reference/vreplication/ https://vitess.io/docs
5.
by mattlord 7mo ago
You are correct about resuming. If you do an initial VDiff and then resume that same VDiff say 1 month later it would only diff rows with a higher PK value. But there's also nothing stopping you from doing a new VDiff to cover all da
6.
by mattlord 7mo ago
That particular cluster has grown significantly since the post was written, and yes there are now quite a few others that are challenging it for the "largest" claim. :-) These larger ones are fully using the PlanetScale SaaS, but
7.
by mattlord 7mo ago
Blog post author here. I'm happy to answer any related questions you may have.
8.
by mattlord 4y ago
> A relational database without relations is an oxymoron. OK. You're the only one talking to this straw man though. :-) Every Vitess user that I'm aware of has a pretty typical 2NF/3NF schema design. A small sampling of th
9.
by mattlord 4y ago
> If I were to do it in PostgreSQL 14 natively without any other third party plugins, I can get help of Table Partitioning (say root server) + Tables on Foreign Servers (say leaf servers) through FDW. Parallel scans and JOINs are allowed
10.
by mattlord 4y ago
The Expensify test was targeted at demonstrating the upper limits of SQLite itself. The hardware used: > 1TB of DDR4 RAM > 3TB of NVME SSD storage > 192 physical 2.7GHz cores (384 with hyperthreading) And a very simple read-only qu
11.
by mattlord 4y ago
It's fairly difficult to find actual details on ACUs and how it all works, the best I found after spending significant time looking was things like: https://www.jeremydaly.com/aurora-serverless-the-good-the-ba... Acco
12.
by mattlord 4y ago
I doubt that anyone would claim their billing metrics are perfect. If you find some specific workload that's actually cheaper on another serverless database offering then we'd love to hear about it (we strive for transparent, ge
13.
by mattlord 4y ago
Installing the time zone tables on a single instance is certainly not hard: https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.ht... The trickier part is orchestrating the ongoing management of th
14.
by mattlord 4y ago
This is at least the second time you've made this exact same comment on an article. So in an attempt to respond to what I will assume are arguments made in good faith... A database stores and serves requested data. Pricing is based on
15.
by mattlord 10y ago
You can see the changelog here: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-17.... The new product page here: http://www.mysql.com/products/enterprise/high_ava
16.
MySQL 5.7 GIS: An Example(mysqlserverteam.com)
2 points by mattlord 11y ago|0 comments