Hi, We have an application that uses MySQL to store devices and its metrics. We are thinking of migrating all data to Kafka, and using Kafka as the storage for the benefit of scaling, event souring and searchability in JSON. I am looking for some advice on the topic design for my following use case:
We currently have "device" data stored in a table. "device" has "device type", and we support hundreds of device types. Each type of device has its unique attributes. We keep “type" specific attributes as a JSON, and store the JSON in a CLOB column. The JSON schema is different for different “device types". If we store “device” data in Kafka, what is the best practice on designing the topic in this use case. We want to be able to search within the JSON. Thanks, Jiayi
