Dear All, Have any body worked on the configurations/optimizations needed generally for using STORM with MYSQL. Our scenario stores data in MYSQL tables, but as the data rate increases MYSQL starts responding very slow (in some cases connection refused error), resulting in DBWriterBolt to slowdown. All the Topology is bottleneck by this issue. We cannot increase the traffic at source beyond a certain level, the reason we noted is that sink (MYSQL) or the bolt adjacent to sink is performing slow.
Any suggestion on how should we proceed will be highly appreciated. Thanks.
