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.


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



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.


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

Copyright© 2018 HCL Technologies Limited