Mysql
Last updated
Last updated
Kubemq azure mysql target connector allows services using kubemq server to access azure mysql database services.
The following are required to run the azure mysql target connector:
kubemq cluster
azure mysql server
kubemq-targets deployment
azure mysql target connector configuration properties:
Example:
Query request metadata setting:
Query request data setting:
Example:
Query string: SELECT id,title,content,bignumber,boolvalue FROM post;
Exec request metadata setting:
Exec request data setting:
Example:
Exec string:
Transaction request metadata setting:
Transaction request data setting:
Example:
Transaction string:
Properties Key
Required
Description
Example
connection
yes
azure mysql connection string address
"username@host:password@tcp(endpoint:3306)/dbname?allowNativePasswords=true"
max_idle_connections
no
set max idle connections
"10"
max_open_connections
no
set max open connections
"100"
connection_max_lifetime_seconds
no
set max lifetime for connections in seconds
"3600"
Metadata Key
Required
Description
Possible values
method
yes
set type of request
"query"
Data Key
Required
Description
Possible values
data
yes
query string
base64 bytes array
Metadata Key
Required
Description
Possible values
method
yes
set type of request
"exec"
isolation_level
no
set isolation level for exec operation
""
"read_uncommitted"
"read_committed"
"repeatable_read"
"serializable"
Data Key
Required
Description
Possible values
data
yes
exec string
base64 bytes array
Metadata Key
Required
Description
Possible values
method
yes
set type of request
"transaction"
isolation_level
no
set isolation level for exec operation
""
"read_uncommitted"
"read_committed"
"repeatable_read"
"serializable"
Data Key
Required
Description
Possible values
data
yes
string string
base64 bytes array