marceloaltmann

6 ms·

1.
What we changed to make one node serve 4.3M cached queries per second(readyset.io)
3 points by marceloaltmann 2d ago|0 comments
2.
Reverse-engineering MySQL 8.4's GTID_TAGGED_LOG_EVENT(readyset.io)
1 points by marceloaltmann 4mo ago|1 comments
3.
by marceloaltmann 4mo ago
Author here. Part 11 of a long series — if this is your first one, part 1 [1] has the setup, and part 5 [2] covers the original GTID_LOG_EVENT which is the natural thing to compare this against. Honestly, the tagged-GTID feature itself is t
4.
Replication Internals: Decoding the MySQL Binary Log – How DML Are Replicated?(readyset.io)
3 points by marceloaltmann 5mo ago|0 comments
5.
Decoding the MySQL Binary Log: Table_map_event – Table Metadata for RBR(readyset.io)
2 points by marceloaltmann 5mo ago|0 comments
6.
MySQL foreign key cascade operations finally hit the binary log(readyset.io)
35 points by marceloaltmann 7mo ago|26 comments
7.
Sorting Isn't Simple–You're Just Seeing ASCII Order, Not Real Collation(readyset.io)
4 points by marceloaltmann 1y ago|0 comments
8.
by marceloaltmann 1y ago
Readyset is an Incremental View Maintenance cache that is powered by a dataflow graph to keep caches (result-set) up-to-date as the underlining data changes on the database (MySQL/PostgreSQL). RocksDB is only used as the persistent sto
9.
450× Faster Joins with Index Condition Pushdown(readyset.io)
120 points by marceloaltmann 1y ago|57 comments
10.
by marceloaltmann 1y ago
Straddled joins were still a bottleneck in Readyset even after switching to hash joins. By integrating Index Condition Pushdown into the execution path, we eliminated the inefficiency and achieved up to 450× speedups.
11.
A Brief History of MySQL Replication(altmannmarcelo.medium.com)
4 points by marceloaltmann 1y ago|1 comments
12.
by marceloaltmann 1y ago
Replication has been one of MySQL’s most powerful and relied-upon features since the early days — long before it had things like foreign keys or even subqueries. It’s one of the foundational pillars that made MySQL suitable for large-scale,
13.
by marceloaltmann 3y ago
That is a good point on the application changes. What is appealing from Readyset is that it does not require you to change your application code. You can just change your database connection string to point to it and it will start to proxy
14.
by marceloaltmann 3y ago
On top of that, quoting @martypitt reply: > Most commonly the restrictions prevent you from launching a competing offering. In their case, you can't offer database-as-a-service using their code. Meaning the self hosted version is fr
15.
by marceloaltmann 3y ago
You can deploy on your own via their .deb packages - https://readyset.io/download The advantages is that reading from a cache will be faster than from a read replicas. The benefits increase even further if you have to perfo
16.
by marceloaltmann 3y ago
I found one case study on their blog - https://blog.readyset.io/medical-joyworks-improves-page-load... > It will be interesting to see if any of these introduce some form of write support over time Writes performed by yo
17.
by marceloaltmann 3y ago
You will add readyset between your backend and database in order to cache the data you fetch from db.
18.
by marceloaltmann 3y ago
Caches are never invalidated. Readyset uses CDC to receive updates from PostgreSQL/MySQL and update the cache entries. No invalidation required. The price you pay is eventually consistent data, which is already true if you use any asyn
19.
GDB Advanced Techniques: Expanding Functionality with Custom Function Execution(altmannmarcelo.medium.com)
1 points by marceloaltmann 3y ago|1 comments
20.
by marceloaltmann 3y ago
GDB is the go-to tool for debugging and troubleshooting low-level applications such as C++. Sometimes all you need simple break at some specific point and print a variable to inspect its value. Other times you need to go even further and lo
21.
by marceloaltmann 3y ago
ReadySet is a new caching layer for PostgreSQL and MySQL that does not rely on TTL or cache invalidation, instead, it keeps a dataflow graph with dependencies and registers itself as a replica to keep cache entries up to date.
22.
Faster Streaming Backups with FIFO parallel streams(percona.com)
2 points by marceloaltmann 3y ago|1 comments
23.
by marceloaltmann 3y ago
The new FIFO datasink has enabled XtraBackup to achieve remarkable transfer speeds exceeding 10Gbps. Our recent blog post explains the architecture behind XtraBackup streaming and how the new FIFO enables true data transfer parallelism.
24.
by marceloaltmann 4y ago
Amazon instance profiles are used to pass IAM roles to an EC2 instance. This IAM role can be queried using EC2 instance metadata to access an S3 bucket. Please check Amazon’s Official Documentation for more information. Today we are happy t
25.
Percona XtraBackup Now Supports IAM Instance Profile(percona.com)
1 points by marceloaltmann 4y ago|1 comments
26.
Making Your MySQL Backup Up to 17X Faster – Introducing Smart Memory Estimation(percona.com)
2 points by marceloaltmann 4y ago|1 comments
27.
by marceloaltmann 4y ago
We are glad to announce Percona XtraBackup Smart Memory Estimation as of the release of Percona XtraBackup 8.0.30. PXB has extended the crash recovery logic to extract the formula used to allocate memory.
28.
by marceloaltmann 4y ago
That is exactly it. The difference comes from compression ratio. ZSTD is compressing the data more, so you need to write less back to disk. Also when talking about streaming, the difference is even more as it has to go over wan to S3 (provi
29.
How to get your backup to half of its size – ZSTD support(percona.com)
72 points by marceloaltmann 4y ago|51 comments
30.
by marceloaltmann 4y ago
Today we are glad to introduce support for a new compression algorithm in Percona XtraBackup 8.0.30 – Zstandard (ZSTD). Results shows that ZSTD not only overcame LZ4 results on all tests, but it also brought backup size to half of its origi

More ›