Have you considered : CockRoach DB? It is similar to Google Spanner but with soft clock mechanism.
On Sun, Jun 23, 2019, 11:02 PM Hengesbach, Martin < martin.hengesb...@fiz-karlsruhe.de> wrote: > Hi, > > > > we are using Phoenix in production since more than 2 years. We are quite > unhappy with the reliability of Phoenix. We migrated from Oracle because of > the performance (we have tables with up to 200M records, each record up to > 30 MB in size, up to 10 selective columns). Phoenix is really much faster > than Oracle (20 nodes cluster). > > > > But we have problems with > > · Phoenix totally hanging, only restart helps (We were able to > reduce this from daily to monthly) > > · incorrect indices, need rebuild > > · select statements not producing the expected (specified) results > > · Upserts sporadically not working without error message > > · Some not reproducible errors > > · … > > > > We are thinking about switching to another database, but the question is: > what is better (reliable and performant)? > > > > Conclusion: With the current status of Phoenix, I would never use it again. > > > > Regards > > Martin > > > > > > > > *Von:* jesse [mailto:chat2je...@gmail.com] > *Gesendet:* Samstag, 22. Juni 2019 20:04 > *An:* user@phoenix.apache.org > *Betreff:* is Apache phoenix reliable enough? > > > > I stumbled on this post: > > > https://medium.com/@vkrava4/fighting-with-apache-phoenix-secondary-indexes-163495bcb361 > > > and the bug: > > https://issues.apache.org/jira/browse/PHOENIX-5287 > > > I had a similar very frustrating experience with Phoenix, In addition to > various performance issues, you can found one of my posts about the > reliability issue on the mail-list. > > > > > https://lists.apache.org/thread.html/231b175fce8811d474cceb1fe270a3dd6b30c9eff2150ac42ddef0dc@%3Cuser.phoenix.apache.org%3E > > > > just wondering others experience if you could share > > > > > > > > > > > ------------------------------ > > FIZ Karlsruhe - Leibniz-Institut für Informationsinfrastruktur GmbH. > Sitz der Gesellschaft: Eggenstein-Leopoldshafen, Amtsgericht Mannheim HRB > 101892. > Geschäftsführerin: Sabine Brünger-Weilandt. > Vorsitzende des Aufsichtsrats: MinDirig'in Dr. Angelika Willms-Herget. > FIZ Karlsruhe ist zertifiziert mit dem Siegel "audit berufundfamilie". >