I am trying to enable the row based replication for mysql connection in clover by calling "SET SESSION binlog_format = 'ROW';" in phase 0 of a graph.
I was thinking that different nodes using the same db connection will be using the same session of mysql, but apparently I was wrong.
My question is how I can enable clover to have the same mysql session for different db connection nodes in the same graph?
For example, I have two DBExecute nodes in my graph and I want them to have the same mysql session when being executed, rather than two different sessions.
Thanks in advance
I was thinking that different nodes using the same db connection will be using the same session of mysql, but apparently I was wrong.
My question is how I can enable clover to have the same mysql session for different db connection nodes in the same graph?
For example, I have two DBExecute nodes in my graph and I want them to have the same mysql session when being executed, rather than two different sessions.
Thanks in advance
-
Just set threadSafeConnection attribute to false. Then all graph elements, that use the connection, use the same session (see Database Connections).
Please sign in to leave a comment.
Comments 1