7.5.10.6 MySQL REST Service Functions

MySQL REST Service provides the functions shown in the next table. More detailed information about each function is provided in the list following the table.

These functions cannot be invoked from a stored function, trigger, or other server substatement.

Table 7.14 MySQL REST Service Functions

Name	Description
mysql_rest_service_restart()	Restarts the REST Service backend, asynchronously.
mysql_rest_service_start()	Starts the REST Service backend, asynchronously.
mysql_rest_service_stop()	Stops the REST Service backend, synchronously.

You can monitor lifecycle operations triggered by these functons with SHOW GLOBAL STATUS LIKE 'mysql_rest_service.state';.

• mysql_rest_service_restart()

  Retarts the MySQL REST Service backend, asynchronously. Returns 0 if the immediate operation succeeds. Failures raise an error. A return value of 0 from restart means that restart was accepted, it does not mean that the state reached READY.

• mysql_rest_service_start()

  Starts the MySQL REST Service backend, asynchronously. Returns 0 if the immediate operation succeeds. Failures raise an error. A return value of 0 from start means that startup was accepted, it does not mean that the state reached READY.

• mysql_rest_service_stop()

  Stops the MySQL REST Service backend, synchronously. Returns 0 if the immediate operation succeeds. Failures raise an error. A return value of 0 from stop means that stop was accepted, it does not mean that the state reached STOPPED.