TE connection and nuosql

 

{question}

When connecting to the database using nuosql, how can I force this connection to a certain TE? 

{question}

 

{answer}

In case of a multiple TEs system, a connection to the database using nuosql process will choose the current available TE randomly.

In case When you connect to the database using nuosql, the connection to the DB can be set to a specific TE, the command

/opt/nuodb/bin/nuosql {database_name} --user ${USER} --password ${PASS} --connection-property NodeKey=${NODEID}

To get the value of the TE NODEID you can use the following query:

select * from system.nodes;

 

More information can be found here

{answer}

Have more questions? Submit a request

Comments