CockroachDB
Last updated
Last updated
Kubemq Cockroach target connector allows services using kubemq server to access Cockroach database services.
The following are required to run the Cockroach target connector:
kubemq cluster
Cockroach server
kubemq-targets deployment
Cockroach target connector configuration properties:
Example:
Query request metadata setting:
Query request data setting:
Example:
Query string: SELECT id,title,content 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
Cockroach connection string address
"postgres://root:postgres@localhost:26257/Cockroach?sslmode=disable"
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