Re: Relstorage + Oracle
Rafael Oliveira <[email protected]>
| Newsgroups | gmane.comp.web.zope.zodb |
|---|---|
| Message-ID | <CAP+kbOy1ptr8V1sB4+QpDQ_mOu3Hecehsfve8eCeSr7QKfu2Yg@mail.gmail.com> |
On Wed, Mar 8, 2017 at 9:56 AM, Jason Madden <[email protected]> wrote: > Hi, > > > On Mar 7, 2017, at 11:01, Rafael Oliveira <[email protected]> wrote: > > > > Hi, > > > > > > I'm preparing to migrate my deployment Plone to use Relstorage with > Oracle, in order to ensure better fault tolerance and scalability. > > > > > > Any advice from people who already took this road? > > As a user and maintainer of RelStorage, my suggestion would be to use > PostgreSQL 9.5+ or MySQL 5.6+ unless you have a specific need for Oracle > DBMS features (e.g., RAC) or are otherwise already committed to it. > > (...) Thank you for the advice. I'm using Oracle because it's already what other applications in my organization use. This is not a choice I made :) > > > I noted the "undo transaction" operations (via ZMI) are much slower than > Filestorage. Is this normal? > > Good question. I would hope not, but it seems possible. I suspect a lot of > RelStorage deployments operate in history-free mode because of the extra > speed that generally brings (and that's where a lot of the optimizations > have focused), but I realize that's not always an option. Maybe someone > else with experience with both can comment. If it's generally found to be > slow, and it's a common enough operation to warrant it, there might be some > optimizations that can be done, especially if there are any low-hanging > fruits. > Actually it's a lot faster. I was fiddling with the code of Relstorage in order to circumvent a bug (more related to cx_Oracle than relstorage itself) and end up disabling the DBMS_LOCK.REQUEST call in favor of a lock in the table. When I re-enabled the lock it became fast again. I made some tests and I'm quite satisfied with the results. Everything works and the setup was not that difficult. I hope the bug I found is solved in later versions of relstorage. I'm stuck in 1.6.3 because of Plone. > > Jason > (...) -- You received this message because you are subscribed to the Google Groups "zodb" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.