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

  1. Choose a topology.

  2. Deploy MariaDB Xpand:

  3. On each node, connect to the MaxScale listener using MariaDB Client:

    $ sudo mariadb
    
  4. Use the CREATE DATABASE statement to create the database:

    CREATE DATABASE IF NOT EXISTS xpand_db;
    

    Note

    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.

  5. Use the CREATE TABLE statement to create the table:

    CREATE TABLE xpand_db.xpand_tab (
       id INT PRIMARY KEY AUTO_INCREMENT,
       str VARCHAR(50)
    );
    

    Note

    In an Xpand Storage Engine Topology, it is necessary to set ENGINE=Xpand.