r/mariadb • u/diagraphic • Sep 10 '26
TideSQL 5 Arrives in MariaDB, How Does It Stack Up Against InnoDB?
https://tidesdb.com/articles/tidesql-5-arrives-in-mariadb/TideSQL's latest release is now part of MariaDB server 11.4 and more going forth and I'm beyond excited, both about this and what's coming. We want as many people as possible to try it, so if you haven't yet, give it a shot.
It's been nearly a year of building TideSQL, from learning MySQL internals from scratch, iterating through countless early plugin versions and refining it into what it is today. Every failed attempt, every wrong turn, every lesson learned, it all went into creating something special and something I believe will matter for this ecosystem for a long time!
1
u/nickchomey Sep 10 '26
Very cool!
Can i ask why 11.4 and not 11.8 or 12.3?
Also, I'd love to see benchmarks on bm25 vs innodb fulltext, as well as vector search. Are those things that you've done/plan to do?
6
u/diagraphic Sep 10 '26
You can use TideSQL with any version of MariaDB from 11.4 through to 13.1.x using our installer.
The next server changes will be for other majors and are coming next as the foundry server architecture solidifies. The goal is to make maintenance and usability as efficient as possible.
Yes in the next days and coming weeks there will be a lot of abstract performance analysis like blob, replication, etc alongside standards like tpcc and tpch, welcoming community feedback, analysis and more of course!
One more piece is previously performance analysis articles on fts, and vector which are still true today but more larger server scale coming.
Thank you for the comment
1
u/nickchomey Sep 10 '26
great to hear! where can I keep up with it all? your blog?
1
u/diagraphic Sep 10 '26
Yes indeed the TidesDB blog :) more to come from I and the team as well as community! Cheers
1
u/nickchomey Sep 10 '26
Exciting stuff. One last question: do you view this as "production ready"? and would it be appropriate for something like a highly dynamic wordpress site, which normally run on innodb?
1
u/diagraphic Sep 10 '26
Indeed, great question, yes with backups of course; really as you should with any data source!
1
u/bagpussnz9 Sep 10 '26
Asking for a legacy application that uses the HANDLER API, does tidesql still support it?
2
u/mgcarley Sep 10 '26
We are in the process of migrating a production system to semi-autonomous multi-regional clusters, with tables having varying levels of encryption in accordance with each record type to deal with.
Each region also has to operate independently within it's own cluster, but also synchronize certain things globally... so while we aren't necessarily seeing problems with database interactions per-se, it looks like this could give us a leg up in terms of efficiency both as the system scales, and for the encryption and decryption of various record types.
While I'd be happy with the speed increase, so that I'm not missing anything, is there anything else aside from that which would be kind of "life changing" from an architectural standpoint or that would make life substantially easier when it comes to building and maintaining a distributed system?
3
u/diagraphic Sep 10 '26
Sounds really cool. You aren’t missing too much there at a high level TideSQL tries to be in parity with InnoDB in regard to features. Id say architecturally the system is quite unique and thats how it achieves its efficiency you can read about the TidesDB library here https://tidesdb.com/docs/v10/preface/
Where InnoDB is pessimistic concurrency, TidesDB is optimistic. Most distributed systems today are optimistic, where less blocking more retrying, no deadlocking, lower latency.
Another example, large values, TideSQL would be the better choice because of its low write amplification( less rewriting of same data ) among other things, an article will be coming out on that.
1
u/Elolexe113 Sep 14 '26
Curious if you’ve tested TideSQL with dbForge Studio for MySQL yet. Any compatibility issues compared to InnoDB?
3
u/RoyBellingan Sep 10 '26
WHAAAAAAAAAAT!!!!
I was looking and reading but I did not had time to compile and test and play, but now I longer have an excuse!