Andrew Webb

Hi Shan, Please refer to Symmetric DS User Guide MySQL section: https://symmetricds.sourceforge.net/doc/3.16/html/user-guide.html#_mysql. You will want to use the instructions and grants outlined there and in the MariaDB section as well.

Hi Dwi, If you don't have any foreign keys across tables you could move them into separate channels and queues to achieve parallel processing. You could move all the tables with foreign keys into a channel and queue as well. Here's a related article: https://medium.com/data-weekly/channel-ing-your-symmetricds-configuration-706b6c19cb.

Hi Andrew K., Here's a link to the open source documentation section that explains these things. https://symmetricds.sourceforge.net/doc/3.16/html/user-guide.html#_node_properties_file Here's also a link to a video that explains setup. https://www.jumpmind.com/video-webinar/symmetricds-setup-overview/ It's worth noting, the PRO version has a much cleaner and simpler setup that may help. Thanks, Andy W.

Hi Shivhar, This is an open issue. You can run: symadmin -e [engine name] sync-triggers, to manually sync the triggers on demand, say after a ddl change is executed on your database. You may want to run this on both nodes. We will also accept a PR for the fix as well. Thanks, Andy

Hi Wayne, Did Symmetric create the triggers initially? If so, Symmetric should be able to drop as well. Thanks, Andy

Hi Calvin, Could you provide more details? For instance, check if your purge job is running efficiently. Do you have outgoing batches stuck lingering around? Have you investigated if running optimize tables on your DB? Thanks, Andy

Hi Davide, Could you try setting the INITIAL_LOAD_ENABLED=0 for NODE_ID ='target01' in the sym_node_security table. If that does not work, try: sync.use.ready.queues=false. Thanks, Andy

Looks like you are missing a required dependency. You'll need the dependency for Avro. java.lang.RuntimeException: java.lang.NoClassDefFoundError: org/apache/avro/generic/GenericRecord