RelStorage
I just released RelStorage 1.4.0b1. New features: More documentation. Support for history-free storage on PostgreSQL, MySQL, and Oracle. This reduces the need to pack and makes RelStorage more appropriate for session storage. Speed. New tests prompted several optimizations that reduced the effect of network latency in both read and write operations. Memcached support is now [...]
I’ve been racking my brains to find something to present at PyCon 2010. I have been trying to find something good to present since PyCon 2003, when I last presented at PyCon. (I talked about Ape, the Adaptable Persistence Engine for Zope.) I really liked the experience of presenting and it led to a lot [...]
Continue reading about PyCon 2010: I Want to Present Something
I have just released two versions of RelStorage. Version 1.3.0b1 adds full support for ZODB blobs stored on the filesystem. Version 1.2.0 is currently the better choice if you’re upgrading a production system and don’t need blob support. People have been asking for blob support for months. I am glad to finally get it done, [...]
Continue reading about RelStorage 1.3.0b1, Now With Blob Support
This release works with unpatched versions of ZODB 3.9! A big thank-you to Jim Fulton for including support for RelStorage in ZODB. This release also continues to support patched versions of ZODB 3.7 and 3.8. I have been doing a lot of testing, and I have found MySQL 5.1.34 to be a lot more stable [...]
These step by step instructions describe how to install Plone on Ubuntu with RelStorage connected to MySQL as the main database. Familiarity with Linux systems administration is expected. Update: These instructions were revised in August 2009 for Plone 3.2.3 and RelStorage 1.2.0.
Continue reading about How to Install Plone with RelStorage and MySQL
I’ve been working on a document explaining how to install Plone with RelStorage, starting from a basic Linux server. As always, the basic procedure is simple, but there are all sorts of interesting little complications. One detail that bugged me today is the need for a shared session database. Session storage is a little different [...]
I have been planning to compare mod_wsgi with paste.httpserver, which Zope 3 uses by default. I guessed the improvement would be small since parsing HTTP isn’t exactly computationally intensive. Today I finally had a good chance to perform the test on a new linode virtual host. The difference blew me away. I couldn’t believe it [...]
Last time I ran the RelStorage performance tests, the write speed to a MySQL database appeared to be slow and getting slower. I suspected, however, that all I needed to do was tune the database. Today I changed some InnoDB configuration parameters from the defaults. The simple changes solved the MySQL performance problem completely. The [...]
I am more than happy to support RelStorage as best I can by email. Every time I do, however, I always get a nagging feeling that I could help RelStorage users a lot better if we set up a short term support contract. I would very much appreciate a chance to optimize their system by [...]
This release has two new useful features, one for performance, one for safety. The performance feature is that if you use both the cache-servers and poll-interval options, RelStorage will use the cache to distribute basic change notifications. That means we get to lighten the load on the database using the poll-interval, yet changes should still [...]