Difference between revisions of "Database"

From regify WIKI
Jump to navigation Jump to search
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
== supported database systems ==
 
== supported database systems ==
The default database for a regify-provider system is '''MySQL''' in version 5.1 or greater. Alternatively, you can use '''IBM-DB2''' database to run the regify-provider.
+
The default database for a regify-provider system is '''MariaDB'''. During installation of the regify software appliance, you are also able to select '''MySQL''' as an alternative.
  
 
== database structure ==
 
== database structure ==
  
The regify provider database consists of 14 tables, 30 indices. There are no stored procedures or views involved.
+
The regify provider database consists of 38 tables, 85 indices (incl. PRIMARY keys, status Dec 2015).
  
 
== needed space ==
 
== needed space ==
  
 +
* 1 mio regify transactions need about 185 MB storage capacity.
 +
* 1000 registered users need about 0,8 MB storage capacity.
  
== amount of selects, inserts and updates ==
+
As of those small values, a capacity of 20GB will fit for about
 +
 
 +
* 90 mio transactions
 +
* 600'000 users
 +
 
 +
This number increases massively, if you plan to offer '''regichat''' and/or '''regibox'''.
 +
 
 +
Please consider 2MB for each regibox user and 1MB for each regichat user.

Revision as of 08:53, 26 July 2019

supported database systems

The default database for a regify-provider system is MariaDB. During installation of the regify software appliance, you are also able to select MySQL as an alternative.

database structure

The regify provider database consists of 38 tables, 85 indices (incl. PRIMARY keys, status Dec 2015).

needed space

  • 1 mio regify transactions need about 185 MB storage capacity.
  • 1000 registered users need about 0,8 MB storage capacity.

As of those small values, a capacity of 20GB will fit for about

  • 90 mio transactions
  • 600'000 users

This number increases massively, if you plan to offer regichat and/or regibox.

Please consider 2MB for each regibox user and 1MB for each regichat user.