MySQL Utilities 1.4 Manual  /  MySQL Fabric  /  Backing Store

8.5. Backing Store

The backing store feature requires a MySQL instance. This server should be the same version as your other servers and MySQL version 5.6.10 or later. This section explains how to set up the backing store and provides information about some of the tables created.

To set up the backing store, use the mysqlfabric command. The --param options specify the user and password we created in Section, “Create a MySQL User” so that the utility can connect to the backing store and create the database and tables. We show the resulting tables in the new fabric database below.

shell> mysqlfabric manage setup --param=storage.user=fabric --param=storage.password=secret
[INFO] 1379444563.457977 - MainThread - Initializing persister:
user (fabric), server (localhost:3306), database (fabric).
shell> mysqlshow -ufabric -psecret fabric
|      Tables       |
| checkpoints       |
| error_log         |
| group_replication |
| groups            |
| permissions       |
| role_permissions  |
| roles             |
| servers           |
| shard_maps        |
| shard_ranges      |
| shard_tables      |
| shards            |
| user_roles        |
| users             |

The tables described here are subject to change in future versions of Fabric.

Download this Manual
PDF (US Ltr) - 1.1Mb
PDF (A4) - 1.1Mb
EPUB - 292.9Kb
HTML Download (TGZ) - 224.3Kb
HTML Download (Zip) - 236.0Kb
User Comments
Sign Up Login You must be logged in to post a comment.