phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jesse <chat2je...@gmail.com>
Subject Re: is Apache phoenix reliable enough?
Date Tue, 25 Jun 2019 04:39:51 GMT
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.Hengesbach@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:chat2jesse@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".
>

Mime
View raw message