SIsignal18
ClusterActions

Switch the tables of one storage engine to another

Changed on

Plans (confirm false) or runs (confirm true) ALTER TABLE ... ENGINE=engineTo on the master for every user table on engineFrom, optionally of one schema; binlog on, the replicas follow. Tables of any other engine (Aria, MEMORY, MyISAM...) are not touched; a table engineTo cannot hold (a foreign key, only InnoDB enforces them) is skipped with its reason. engineTo must be available on the master. Runs in the background, one table at a time, stopping at the first error: progress CINF0015, stop WARN0240. Needs db-optimize.

post/api/clusters/{clusterName}/actions/alter-engine

Request

  • The document declares no server URL.
  • Auth
    none declared. Required headers: Authorization

Path parameters

clusterNamestring required

Cluster Name

Headers

Authorizationstring required

Insert your access token

Request body

confirmboolean
engineFromstring
engineTostring
schemastring

optional: one schema only

Response

The plan (confirm false)

clusterstring
engineFromstring
engineTostring
notesstring[]
schemastring
serverstring
totalBytesinteger

Changes