rhodecode-enterprise-ce Files · docs/install/database-string.rst

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:

r144:e4b1972a default


                r2591:36829a17

stable

Download file

             database-string.rst
        
                    38 lines
            
             | 1.3 KiB
            
                | text/x-rst
            
             |
                RstLexer
            
             / docs / install / database-string.rst
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

        marcink
    
project: added all source files and assets

              r1
            
      .. _config-database:

      Make Database Changes

      ---------------------

      .. important::

        marcink
    
docs: updated some installation instructions

              r144
            
         If you do change the |repo| database that |RCEE| uses, then you will need to

        marcink
    
project: added all source files and assets

              r1
            
         upgrade the database, and also remap and rescan the |repos|. More detailed

         information is available in the

         :ref:`Alternative upgrade documentation <control:install-port>`.

        marcink
    
docs: updated some installation instructions

              r144
            
      If you need to change database connection details for a |RCEE| instance,

        marcink
    
project: added all source files and assets

              r1
            
      use the following steps:

      1. Open the :file:`rhodecode.ini` file for the instance you wish to edit. The

         default location is

         :file:`home/{user}/.rccontrol/{instance-id}/rhodecode.ini`

      2. When you open the file, find the database configuration section,

         and use the below example to change the

         connection details:

      .. code-block:: ini

          #########################################################

          ### DB CONFIGS - EACH DB WILL HAVE IT'S OWN CONFIG    ###

          #########################################################

          # Default SQLite config

          sqlalchemy.db1.url = sqlite:////home/brian/.rccontrol/enterprise-1/rhodecode.db

          # Use this example for a PostgreSQL

          sqlalchemy.db1.url = postgresql://postgres:qwe@localhost/rhodecode

          # see sqlalchemy docs for other advanced settings

          sqlalchemy.db1.echo = false

          sqlalchemy.db1.pool_recycle = 3600

          sqlalchemy.db1.convert_unicode = true

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

marcink project: added all source files and assets	r1	.. _config-database:

		Make Database Changes
		---------------------

		.. important::

marcink docs: updated some installation instructions	r144	If you do change the \|repo\| database that \|RCEE\| uses, then you will need to
marcink project: added all source files and assets	r1	upgrade the database, and also remap and rescan the \|repos\|. More detailed
		information is available in the
		:ref:`Alternative upgrade documentation <control:install-port>`.

marcink docs: updated some installation instructions	r144	If you need to change database connection details for a \|RCEE\| instance,
marcink project: added all source files and assets	r1	use the following steps:

		1. Open the :file:`rhodecode.ini` file for the instance you wish to edit. The
		default location is
		:file:`home/{user}/.rccontrol/{instance-id}/rhodecode.ini`
		2. When you open the file, find the database configuration section,
		and use the below example to change the
		connection details:

		.. code-block:: ini

		#########################################################
		### DB CONFIGS - EACH DB WILL HAVE IT'S OWN CONFIG ###
		#########################################################

		# Default SQLite config
		sqlalchemy.db1.url = sqlite:////home/brian/.rccontrol/enterprise-1/rhodecode.db

		# Use this example for a PostgreSQL
		sqlalchemy.db1.url = postgresql://postgres:qwe@localhost/rhodecode

		# see sqlalchemy docs for other advanced settings
		sqlalchemy.db1.echo = false
		sqlalchemy.db1.pool_recycle = 3600
		sqlalchemy.db1.convert_unicode = true