I also faced many stability problems with Phoenix..it's very complicated to tune the tables in order to have decent performance for all kind of queries. Since we need to be performant for every type of query (analytics and exploration) we use Elasticsearch + Join plugin (i.e. Siren platform [1])
Best, Flavio [1] https://siren.io/welcome-siren-platform/ On Mon, Jun 24, 2019 at 8:02 AM 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". >
