Hi guys, I'm evaluating using Phoenix to replace MySQL for better scalability. The version I'm evaluating is 4.11-HBase-1.2, with some dependencies modified to match CDH5.9 which we are using.
The problem I'm having is the write performance to Phoenix from JDBC is too poor, only 500writes/second, while our data's throughput is almost 50,000/s. My questions are: 1. If the 500/s TPS is normal speed? How fast can you achieve in your production? 2. Whether I can write directly into HBase with mutation API, and read from Phoenix, that could be fast. But I don't see the secondary index be created automatically in this case. Regards, Hef
