We are currently in the process of load testing various yugabyte tables with different schemas and were wondering if yugabyte has a recommended tool for applying load to the system. Our current approach is a java client that would be inserting/retrieving rows from the database with different values. Any guidance would be helpful
A standard approach to load test databases is YCSB. You can also use your own client code.
Usually you have to make sure you have client nodes separated from server ones and be sure the client is not the bottleneck (multiple threads, or multiple machines).
Or you can also explain your use case, with a set of queries sorted by most frequently run and we can suggest the best schema. Or explain your schemas with queries and can comment on them.