The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2025-05-01. For the latest, interactive version please visit https://mariadb.com/kb/.

Federated MariaDB Enterprise Spider Topology Operations

Contents

  1. Overview
  2. Update Character Sets and Collations
  3. Update Connection Options

Overview

Choose an operation for the Sharded MariaDB Enterprise Spider topology:

OperationDescription
Backup and RestoreHow to create a new backup or restore an existing backup.
Migrate TablesHow to update the character set or collation.
Update Character Set or CollationHow to update the character set or collation.
Update Connection OptionsHow to update the connection options for a Data Node.

Update Character Sets and Collations

The character set or collation for the Spider Table can be updated or modified using the ALTER TABLE statement.

On the Spider Node, alter the Spider Table's character set and collation:

ALTER TABLE spider_hq_sales.invoices
   DEFAULT CHARACTER SET 'utf8mb4'
   DEFAULT COLLATE 'utf8mb4_general_ci';

If the new character set and collation are not compatible with the character set and collation used by the Data Table, you must also alter the character set and collation for the Data Table on the Data Node.

Update Connection Options

In a Federated MariaDB Enterprise Spider topology, the connection options for a Data Node can be updated using the ALTER TABLE statement.

  • On the Spider Node*, alter the table's connection details: 
ALTER TABLE spider_hq_sales.invoices
   COMMENT = 'server "new_hq_server", table "invoices"'
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.