Why not put it in Solr or similar ?
> Am 28.11.2018 um 08:11 schrieb Jiayi Hoffman <jiayi.hoff...@gmail.com>: > > 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 >
