I am studying about SQL database clustering, and to delve deeper I plan to run some practical tests with a DBMS, and I chose MariaDB for this.
So, I would like to know if it is possible to use MariaDB for clustering and what would be the version of it for this purpose?
There are a few options, but the one I know of and I've personally used (and would recommend) is MariaDB Galera Cluster , a multi-master cluster for mariadb. A multi-master cluster is where any node has authority to read / write, all are masters, different from a master-slave where only 1 master writes and the slaves only have read.
The world of database clustering is full of pineapples, if you want to give an in-depth look I recommend this technical analysis of mariadb galera . a very heavy reading, but it is not necessary to understand everything to get the general idea, and when you are choosing a database, it is better than seeing its weaknesses.
