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 [...]
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 than [...]
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
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 new [...]
For those just tuning in: RelStorage is an adapter for ZODB (the database behind Zope) that stores data in a relational database such as MySQL, PostgreSQL, or Oracle. It has advantages over FileStorage and ZEO, the default storage methods. Read more in the ZODB wiki.
Download this release from PyPI. As I mentioned in another post, [...]
I’ve been working on packing a 6.5GB production database based on RelStorage and MySQL 5.0. It contains 6.4 million objects, meaning “select count(1) from current_object” returns 6426879. I would call this a moderately sized database. When I first approached it, it had not been packed for at least 3 months. At first, I could not [...]
After a lot of testing and performance profiling, on Friday I released RelStorage 1.1. On Saturday, I was planning to blog about the good news and the bad news, but I was unhappy enough with the bad news that I decided to turn as much of the bad news as I could into good news. [...]
I would like to advise all users of RelStorage to run the RelStorage test suite on their staging and production servers before running any application that uses RelStorage. There are a number of ways to misconfigure the database and the tests will reveal many kinds of issues. The test suite is in very good shape [...]
I was interested in adding MySQL 5.0+ support to RelStorage, so I went ahead and did it. The code is in Subversion now.
The tests I’ve run suggest the MySQL adapter is already a lot faster than ZEO and both of the other adapters. The MySQL adapter has consistently finished the tests 40% faster [...]