Getting Started with MariaDB Xpand
MariaDB Xpand provides distributed SQL, high availability, fault tolerance, write scaling, and horizontal scale-out for transactional workloads. MariaDB Xpand can integrate with the Xpand storage engine in MariaDB Enterprise Server 10.5.
MariaDB Xpand Deployment Process
Choose a topology.
Deploy MariaDB Xpand:
On each node, connect to the MaxScale listener using MariaDB Client:
$ sudo mariadb
Use the CREATE DATABASE statement to create the database:
CREATE DATABASE IF NOT EXISTS xpand_db;
In an Xpand Storage Engine Topology, MariaDB Xpand does not synchronize databases automatically. In that topology, MariaDB Replication can synchronize databases and other objects. Without replication, the database needs to be created separately on each node.
Use the CREATE TABLE statement to create the table:
CREATE TABLE xpand_db.xpand_tab ( id INT PRIMARY KEY AUTO_INCREMENT, str VARCHAR(50) );
In an Xpand Storage Engine Topology, it is necessary to set