Re: Relstorage + Oracle
Jason Madden <[email protected]>
| Newsgroups | gmane.comp.web.zope.zodb |
|---|---|
| Message-ID | <[email protected]> |
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. I'm not trying to scare you away from Oracle or otherwise imply problems with it, I'm just saying that the PostgreSQL and MySQL backends are more widely used and tested than the Oracle backend, to the best of my knowledge. The Oracle backend /is/ used and it /is/ tested, but I think the community of PostgreSQL and MySQL users is probably larger and so you're probably likely to find more people that can help if you experience issues.[1] I've personally used and tested RelStorage with multiple drivers against multiple versions of MySQL and PostgreSQL, but I've only tested one version of Oracle (in a virtual machine) and haven't actually used it in production. In addition, there's only one supported driver for Oracle, cx_Oracle. This driver is not known to be compatible with gevent, and is not known to work on PyPy, if either of those things might be of interest to you.[2] > 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. Jason [1] Yes, I used a lot of qualifiers; it's entirely possible that there's a very large group of satisfied RelStorage+Oracle users that are just very quiet because everything is working so well :) [2] http://relstorage.readthedocs.io/en/latest/install.html#database-adapter -- 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.