We are using Process instance modification api to submit asynch batches to process the Bulk data in camunda. The challenge is that when users submit heavy count of batches back to back the DB CPU Utilization shoots to peak and remains the same until all the batches are processed. Hence we plan to go for Sharding at DB level.
Currently we are using MySQL DB on aws to process the data. Could you please suggest as to how the sharding can be done in MySQL from Camunda perspective as camunda guide recommends to use DB in Active Active with RC mode. Any documentation or guidance would be of great help