ha set idxauto argument: Replicate indexes to secondary servers (SQL administration API)

Use the ha set idxauto argument with the admin() or task() function to control whether indexes are automatically replicated to secondary servers.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--+-"ha set idxauto off"-+----->
                     '-task--'     '-"ha set idxauto on"--'   

>--)--;--------------------------------------------------------><

Usage

Run this function on an established primary server to enable or disable automatic index replication to secondary servers.

You can run this function on any type of primary server.

This function is equivalent to the onmode -d idxauto command.

Example

The following example enables automatic index replication:
EXECUTE FUNCTION task("ha set idxauto on");

Copyright© 2019 HCL Technologies Limited