Lmst

#distributedSQL

MySQL Ndb Cluster is a variant of MySQL and as such supports the MySQL JSON functions, the MySQL JSON type and related functionalities. These mechanisms give the database visibility into stored JSON documents, enabling more efficient storage and processing without tightly constrained schemas.

JSON columns can be stored, retrieved, and queried from MySQL Ndb Cluster in a structured way via SQL or other APIs (MySQL X API, Document store, REST server implementations etc).

JSON data can be selectively indexed using stored generated columns, allowing efficient access or the use of relational constraints.

https://dev.mysql.com/doc/refman/8.4/en/json.html

https://dev.mysql.com/doc/refman/8.4/en/json-functions.html

#mysql #distributedsql #ndbcluster #opensource

MySQL Ndb Cluster is often described as an in-memory or main memory database but this is not the whole story.

Tables in Ndb always support :
- Transactions, parallel query, indexes, FKs etc
- Sync replication between nodes in a cluster
- HA with automatic failover and recovery
- Consistent backup
- Async replication via MySQLD

By default Tables in Ndb also have automatic transactional durability via parallel checkpoints and logs, supporting full system recovery from storage. However, this can be disabled for individual tables if desired for highest performance with lowest resource usage. In the event of a full system recovery from storage, these tables will be empty.

By default, all columns of a table are kept in memory at all times, limiting system capacity to full cluster system memory size. However unindexed columns can be marked for disk storage. Values for these columns are stored in pages of a tablespace, and only cached in memory like most other RDBMS. This allows far more data to be stored while retaining predictable fast access via purely in memory indexes.

#MySQL #ndbcluster #DistributedSQL

MySQL Ndb Cluster 8.4 specific security features include :
- Encrypted backups
- Encrypted storage (Checkpoints, redo logs, undo logs + tablespaces) (TDE)
- mTLS on all internal connections for authentication and encryption (Ndb TLS)

All open source, implemented using industry standard optimised and reviewed OpenSSL libraries.

These features are in addition to the standard MySQL Server Security features ([m]TLS, TDE, Binlog encryption, PAM etc)

https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-security.html
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup-using-management-client.html
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tde.html
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tls.html

https://dev.mysql.com/blog-archive/mysql-cluster-8031-transparent-data-encryption/
https://blogs.oracle.com/mysql/introducing-ndb-tls
https://messagepassing.blogspot.com/2020/11/mysql-cluster-backup-and-restore.html

https://dev.mysql.com/doc/refman/8.4/en/security.html

#DistributedSQL #MySQL #NdbCluster #OpenSource

MySQL Ndb Cluster quarterly releases are now available :
9.6.0 https://dev.mysql.com/doc/relnotes/mysql-cluster/9.6/en/
8.4.8 LTS https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-8.html
8.0.45 https://dev.mysql.com/doc/relnotes/mysql-cluster/8.0/en/news-8-0-45.html
7.6.37 https://dev.mysql.com/doc/relnotes/mysql-cluster/7.6/en/news-7-6-37.html

#mysql #ndbcluster #distributedSQL

Good to see that RonDB has a slot in the 2026 FOSDEM databases devroom.

They are doing interesting work extending NDB to cover new and trending use cases that you may have heard of.

https://fosdem.org/2026/schedule/event/real-time_ai_powered_by_rondb/

#DistributedSQL #ndbcluster #fork #opensource

Friends, I'm looking for contracts in HealthCare IT (20+ yrs in this domain, 40+ yrs in IT). Done two #FOSS clinical data repository. Now on federated clinical data analytics. Expert in #openEHR, #FHIR, #SNOMED-CT, PACS, MPI, #Kotlin, #Java, #python, DB: #SQL (#PostgreSQL!), #jOOQ, #distributedSQL, #KnowledgeGraph, APIs, #docker, #linux, #Unix... Very keen on medical projects benefiting rural and/or developing communities. Also looking for tutoring, compliance, security and SOPs. TIA!

MySQL Ndb Cluster quarterly releases are out.
9.0 Innovation : 9.4.4 https://dev.mysql.com/doc/relnotes/mysql-cluster/9.4/en/news-9-4-0.html
8.4 LTS : 8.4.6 https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-6.html
8.0 : 8.0.43 https://dev.mysql.com/doc/relnotes/mysql-cluster/8.0/en/news-8-0-43.html
7.6 : 7.6.35 https://dev.mysql.com/doc/relnotes/mysql-cluster/7.6/en/news-7-6-35.html

#mysql #NdbCluster #DistributedSQL

History : Ericsson Review article about #NdbCluster development at Ericsson. Starts at page 167 (pdf page 179) 1997 volume 4
#MySQL #DistributedSQL

https://www.ericsson.com/4ac5c3/assets/local/about-ericsson/ericsson-history/lme-review/documents/da2011-35598-ericsson_review_vol_74_1997.pdf

First page of article describing Ndb Cluster

CockroachDB 25.2 tackles enterprise AI's biggest data challenges. Achieve 41% efficiency, a new distributed vector index for billions, and boosted security. Crucial for agentic AI workloads & operational big data at scale.
#DistributedSQL #VectorDB #CockroachDB

CockroachDB 25.2 Solves AI's Data Overload with Distributed Power.

MySQL Ndb Cluster 8.4 security features include :
- Encrypted data in motion : mTLS for all distributed communication https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tls.html
- Encrypted data at rest :
- Transparent Data Encryption for Ndb checkpoints, Redo logs, tablespaces, Undo logs https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster.html
- Encrypted Backups https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup-using-management-client.html

Plus all the usual MySQL Server security features :
- Pluggable authentication, roles, policies
- [m]TLS
- TDE for InnoDB tablespaces, logs
- Encrypted Binlogs
- Audit plugin
...

#MySQL #NdbCluster #DistributedSQL

The distributed core of MySQL [Ndb] Cluster was originally developed at Ericsson, and inherits their expertise in high performance reliable software development.

Ndb stands for 'Network DataBase', where 'network' is a telecoms core network such as 2G, 3G, 4G, 5G cores.

After the 2001 telecoms crash, Ericsson spun the project out as an independent company called Alzato.

Alzato was purchased by the startup MySQL AB, where it was integrated with MySQL Server and marketed as 'MySQL Cluster', first released in MySQL 4.1.3 in June 2004.

Since then the product has been continuously improved, scaled, optimised and extended.

Over that time the value of distributed scale-out, NoSQL + SQL, built-in HA, online upgrades, online schema changes etc has been recognised, with well marketed NoSQL + distributed SQL startups finding customers and success in this area.

June 2024 marked 20 years of MySQL [Ndb] Cluster being freely available open source, providing HA, high throughput, low latency, distributed SQL to everyone.

https://en.wikipedia.org/wiki/MySQL_Cluster

#DistributedSQL #NdbCluster #MySQL

MySQL Ndb Cluster quarterly releases are out.
9.0 Innovation : 9.4.3 https://dev.mysql.com/doc/relnotes/mysql-cluster/9.3/en/
8.4 LTS : 8.4.5 https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-5.html
8.0 : 8.0.42 https://dev.mysql.com/doc/relnotes/mysql-cluster/8.0/en/news-8-0-42.html
7.6 : 7.6.34 https://dev.mysql.com/doc/relnotes/mysql-cluster/7.6/en/news-7-6-34.html

#MySQL #DistributedSQL #NdbCluster

Join Predee Kajonpai's session "Growth Across Dimensions with Distributed SQL" at #FOSSASIASummit2025 to explore how Distributed SQL enables scalability, resilience, and performance for modern applications.

🔗 Click here https://youtu.be/NWyPYBX5MUw?si=N39OWfrHeddE0J3A to watch on the FOSSASIA YouTube channel

#DistributedSQL #Database #OpenSource #FOSSASIA

Nice writeup of Raft vs Quorum consensus vs 'Reconfiguration' based systems from Alex Miller.

https://transactional.blog/talk/enough-with-all-the-raft

This covers ground he previously discussed here :
https://transactional.blog/blog/2024-data-replication-design-spectrum

For DML and query processing, #MySQL Ndb Cluster is a 'Reconfiguration' design, with properties as described in his blogs and similar to CRAQ.

When node failures are detected Ndb uses a built-in quorum mechanism to ensure safety and consensus for Reconfiguration, rather than relying on a separate system like etcd.

#DistributedSQL #Ndb

The best time to start blogging is to not stop blogging in the first place. The next best time is today.

Here's a syndication of a post from the ComplyAdvantage Technology Blog to kicks things off.

https://mark.allanson.org/blog/dss-2024-ca-lessons/

#Yugabyte #YugabyteDB #DistributedSQL #ComplyAdvantage

Even though I am not attending AWS reInvent this year, I am still following the product announcements. This one is pretty cool. I have been ramping up on my distributed SQL skills over the past year with both CockroachDB and YugabyteDB. I will need to free up some time to try this one out. #AWS #AWSreInvent #Aurora #CockroachDB #YugabyteDB #DistributedSQL #DSQL
https://aws.amazon.com/blogs/database/introducing-amazon-aurora-dsql/

I’ll be stepping way out of my comfort zone and presenting at the #DistributedSQL Summit on November 12 on behalf of my employer - #ComplyAdvantage, organised by our key partner, #YugabyteDB.

Data is central to our solutions at ComplyAdvantage and in the session I’ll share some of the lessons we’ve learned while harnessing distributed database technology to address the critical challenges of anti-money laundering and fraud detection.

#FraudDetection #WorkPost