slb mysql

Configure mysql

mysql Specification

Type	Configuration Resource
Element Name	mysql
Element URI	/axapi/v3/slb/mysql
Element Attributes	mysql_attributes
Statistics Data URI	/axapi/v3/slb/mysql/stats
Schema	mysql schema

Operations Allowed:

Operation	Method	URI	Payload
Create Object	POST	/axapi/v3/slb/mysql	mysql attributes	example close
POST /axapi/v3/slb/mysql Payload: { "mysql": { "sampling-enable": [ { "counters1": "all" } ] } }
Get Object	GET	/axapi/v3/slb/mysql	mysql attributes	example close
GET /axapi/v3/slb/mysql Reponse: { "mysql": { "uuid": "f859cdfa-c1cf-11e8-adac-7750a01e0bd4", "sampling-enable": [ { "counters1": "all" } ], "a10-url": "/axapi/v3/slb/mysql" } }
Modify Object	POST	/axapi/v3/slb/mysql	mysql attributes
Replace Object	PUT	/axapi/v3/slb/mysql	mysql attributes	example close
PUT /axapi/v3/slb/mysql Payload: { "mysql": { "sampling-enable": [ { "counters1": "curr_proxy" } ] } }
Delete Object	DELETE	/axapi/v3/slb/mysql	mysql attributes	example close
DELETE /axapi/v3/slb/mysql Reponse: { "response": { "status": "OK" } }

mysql attributes

sampling-enable

Type: List

uuid

Description uuid of the object

Type: string

Maximum Length: 64 characters

Maximum Length: 1 characters

sampling-enable

Specification
Type	list
Block object keys

counters1

Description ‘all’: all; ‘curr_proxy’: Curr Proxy Conns; ‘total_proxy’: Total Proxy Conns; ‘curr_be_enc’: Curr BE Encryption Conns; ‘total_be_enc’: Total BE Encryption Conns; ‘curr_fe_enc’: Curr FE Encryption Conns; ‘total_fe_enc’: Total FE Encryption Conns; ‘client_fin’: Client FIN; ‘server_fin’: Server FIN; ‘session_err’: Session err; ‘queries’: DB Queries; ‘commands’: DB commands reply;

Type: string

Supported Values: all, curr_proxy, total_proxy, curr_be_enc, total_be_enc, curr_fe_enc, total_fe_enc, client_fin, server_fin, session_err, queries, commands

stats data

	Counter	Size	Description
	server_fin	2	Server FIN
	curr_be_enc	2	Curr BE Encryption Conns
	total_be_enc	2	Total BE Encryption Conns
	total_proxy	2	Total Proxy Conns
	curr_proxy	2	Curr Proxy Conns
	commands	2	DB commands reply
	client_fin	2	Client FIN
	curr_fe_enc	2	Curr FE Encryption Conns
	queries	2	DB Queries
	session_err	2	Session err
	total_fe_enc	2	Total FE Encryption Conns