Database administration [Документация VAS Experts]

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
en:dpi:dpi_components:platform:dpi_admin:admin_db:start [2020/01/22 09:06] edrudichgmailcomen:dpi:dpi_components:platform:dpi_admin:admin_db:start [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
Line 1: Line 1:
-====== 2 Database administration ====== 
-{{indexmenu_n>2}} 
- 
-UDR (built-in database, user data repository) is used for permanent storage of data on services and policing settings for the subscribers. 
- 
-**List of database tables** 
- 
-^ Table ^ Purpose ^ 
-|bindings| login and address binding| 
-|bindings_multi| login and address binding for multu-subscribers (with several IPs)| 
-|policing| Subscriber policing setting| 
-|profile_names| Names of profiles| 
-|profiles| Profiles of services and policing| 
-|services| Subscriber services setting| 
-|vchannel_policing| Channel policing setting| 
-|ip_props| BRAS subscriber properties| 
- 
-==== Activating the built-in database ==== 
- 
-<note important>UDR activation is required to support dynamic IPs and subscribers with several IPs.</note> 
- 
-UDR is activated by the configuration parameter in ///etc/dpi/fastdpi.conf// file. 
- 
-<code>udr=1</code> 
- 
-The created database is located in the ///var/db/dpi// directory 
- 
-<note important>You can make a copy of the database without stopping the DPI with a backup command 
-<code>mdb_copy/var/db/dpi./DB</code> 
-and handle further manipulations in the copied database.</note> 
- 
-==== Enlarging the DB ==== 
- 
-By default, the database size is limited to 1GB. If you have more than 1 million policing profiles, you will need to increase the default size: 
-<code>udr_size=2147483648</code> 
-will set the DB size of 2GB. 
- 
-<note>The built-in database does not require administration and is fault tolerant. However, in rare cases, damage to the embedded database occurred. In this case, one of the following options is possible.</note> 
-