Converting a Table's Engine to ReplicatedMergeTree

Adding replication support to a table

To support replication, you can convert a table’s engine from MergeTree to ReplicatedMergeTree. (A table with a MergeTree engine can’t be replicated.)

To get started, click the EXPLORE button in the Clusters view:

The EXPLORE button

Figure 1 – The EXPLORE button

In the Explorer view, switch to the Schema tab:

The Schema tab

Figure 2 – The Schema tab

Click the vertical dots icon next to the table whose engine you want to change and select Convert to ReplicatedMergeTree:

The Convert to ReplicatedMergeTree menu

Figure 3 – The Convert to ReplicatedMergeTree menu item

As you would expect, this menu item is only available if a table’s engine is MergeTree.

When you click the menu item, you’ll see a confirmation message:

The Convert to ReplicatedMergeTree confirmation dialog

Figure 4 - ReplicatedMergeTree conversion confirmation dialog

Click OK to start the conversion.