title: Debezium Ordering of CDC Events between multiple tables
body: <p>hi i am new to debezium</p>
  <p>i am planning to do a realtime database(mysql and mongo) integration by using debezium
  from each database i need to sync the data to a destination database(mysql and mongo)
  from mysql and mongo i need only X number of tables and y number of collections respectively from each database</p>
  <p>in those x number of tabels and y number of collection i need only the specific set of data based on a condtion for each table and collection</p>
  <p>here the conditon is not straight forward i meant for example if we take the mysql database i need to take records by joining a table(the table that i want to capture cdc) with one specific table and capture the matching records only</p>
  <p>above mentioned is my requirement i have some question regarding the requirements</p>
  <ol>
  <li><p>as per the debezium documentation based on each table its creating a topic,
  for each topic if we push the cdc data into a specific partition for that topic the order is gurantateed so when working with multiple tables it will push the cdc data to each table's topic's partition in this case how can i achieve the order of events between multiple tables
  i mean i need the exact order of events that performed on mysql binlog
  is the order is guranteeed when working with multiple tables because i need to do the sync on the destination database in the same order that happened on source database's binlog??</p>
  </li>
  <li><p>if i want the data based on a mysql or mongo join condition with a table or collection how can i achieve this from debezium</p>
  </li>
  </ol>
  <p>these are my two main questions
  please help me on this</p>
  <p>Thanks</p>
  <p>Mike</p>