##// END OF EJS Templates
rhodecode-enterprise-ce
RSS
caches: use individual namespaces per user to prevent beaker caching problems....
caches: use individual namespaces per user to prevent beaker caching problems. - especially for mysql in case large number of data in caches there could be critical errors storing cache, and thus preventing users from authentication. This is caused by the fact that we used single namespace for ALL users. It means it grew as number of users grew reaching mysql single column limit. This changes the behaviour and now we use namespace per-user it means that each user-id will have it's own cache namespace fragmenting maximum column data to a single user cache. Which we should never reach.
marcink - - Load All Authors

File last commit:

r1:854a839a default
r2591:36829a17 stable
Show More
using-sqllite.rst
32 lines | 1.2 KiB | text/x-rst | RstLexer
/ docs / install / using-sqllite.rst
History | Annotation | Raw |Copy content |Copy permalink

SQLite

Important

We do not recommend using SQLite in a large development environment as it has an internal locking mechanism which can become a performance bottleneck when there are more than 5 concurrent users.

|RCM| installs SQLite as the default database if you do not specify another during installation. SQLite is suitable for small teams, projects with a low load, and evaluation purposes since it is built into |RCM| and does not require any additional database server.

Using MySQL or PostgreSQL in an large setup gives you much greater performance, and while migration tools exist to move from one database type to another, it is better to get it right first time and to immediately use MySQL or PostgreSQL when you deploy |RCM| in a production environment.

Migrating From SQLite to PostgreSQL

If you started working with SQLite and now need to migrate your database to PostgreSQL, you can contact support@rhodecode.com for some help. We have a set of scripts that enable SQLite to PostgreSQL migration. These scripts have been tested, and work with PostgreSQL 9.1+.

Note

There are no SQLite to MySQL or MariaDB scripts available.