Enable row based replication in clover

CloverDX Platform
1

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

2

Just set threadSafeConnection attribute to false. Then all graph elements, that use the connection, use the same session (see Database Connections).