added tests for mysql consumer