Erick,
While Yugabyte & ScyllaDB are great options they both come with their own inherit limitations. If I had to chose between the two, I'd go with Scylla. However, I'd highly consider taking a look at Aerospike, as it really shines where those other two options fall short.
Aerospike, is the global leader in next generation real-time NoSQL data solutions. We power instant payment transactions for The European Central Bank, transaction fraud for PayPal and Barclays, identity resolution for LexisNexis Risk Solutions, and pre-trade risk mitigation at Charles Schwab.
Our ability to deliver superior performance on significantly less hardware combined with our multi model approach is why you should consider taking a look. Don't take my word for it. Here is a list of user talks and benchmarks that should paint a pretty clear picture.
https://view.highspot.com/viewer/649b2c8bc795a41d640c5e07
Also more than happy to connect over zoo to dive deeper at your leisure. https://info.aerospike.com/c/Lance_Wyatt#/select-time