Sharded MariaDB Enterprise Spider Topology Operations
Overview
Choose an operation for the Sharded MariaDB Enterprise Spider topology:
| Operation | Description |
|---|---|
| Add a Shard | How to add a new shard to a Spider Table. |
| Backup and Restore | How to create a new backup or restore an existing backup. |
| Update Character Set or Collation | How to update the character set or collation for a Spider Table. |
| Update Connection Options | How 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_sharded_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 Sharded 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 partition's connection details:
ALTER TABLE spider_sharded_sales.invoices
REORGANIZE PARTITION hq_partition INTO (
PARTITION hq_partition VALUES IN (1) COMMENT = 'server "new_hq_server", table "invoices"'
);
-
Sharded MariaDB Enterprise Spider Topology Add a Shard
Overview In a Sharded MariaDB Enterprise Spider topology, new shards can b... -
Sharded MariaDB Enterprise Spider Topology Backup and Restore
Overview When using Spider in the Sharded MariaDB Enterprise Spider topolo...
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.
