RedDatabase DBMS 3.0 Enterprise Edition

Red Database DBMS is a Russian open-source enterprise DBMS. The Red Database DBMS kernel is built on Firebird, a popular open-source DBMS. Firebird is used in solutions of all scale: from embedded hardware systems and solutions for small companies to IT systems of major corporations with databases tens of TB in size and with tens of millions of transactions per day.

Red Database DBMS is included in the Unified Register of Russian Computer and Database Software.

Features

• Compliance with internationally accepted industry standards for quality, reliability, and security.
• Support for SQL:2008 standard.
• Support for scalable SuperServer SMP architecture.
• Synchronous and asynchronous replication.
• Fault-tolerant cluster.
• Real-time performance monitoring and event auditing.
• Full-text search.
• Autonomous transactions.
• 64-bit transaction counter.
• Incremental backup.
• Possibility to restore an increment to an existing database.
• Online database validation.
• Global temporary tables.
• Externally stored procedures, triggers, and functions.
• Window functions.
• Extended set of system functions.
• Support for Java libraries.
• Integrity control of executable files.

Functionality

• Administration tools
• Hiding stored procedure and function code.
• Task scheduler.
• Embedded architecture without a dedicated server.
• Support for all types of backups.
• Support for event notifications in the database.

Security

• Multi-factor authentication using GOST algorithms via LDAP, Active Directory, and GSSAPI.
• Support for CryptoPro.
• Role-based access control.
• Auditing changes in access rights.
• Access control to DML and DDL operations.
• Access control to services (you can assign rights to start a number of services).
• Auditing DBMS database and server events.
• Ability to use different security policies.

Certified by FSTEC of Russia. Certificate No. 2729 dated October 8, 2012 confirms that Red Database DBMS complies with the requirements of the governing documents:

• “Computer facilities. Protection against unauthorized access to information. Indicators of protection against unauthorized access to information.” — security class 5.
• “Protection against unauthorized access to information. Part 1. Information security software. Classification by the level of control of the absence of undeclared capabilities.” (FSTEC of Russia, 1999) — control level 4.

1. Get an SSH key pair to connect to a virtual machine (VM).

2. Create a VM from a public image:

   • Under Image/boot disk selection, go to the Cloud Marketplace tab and select Red Database DBMS 3.0 Enterprise edition.
   • Under Disks and file storage, add a storage disk with at least 100 GB.
   • Under Access:
     • Enter the username in the Login field.
     • Paste the contents of the public key file in the SSH key field.

   Save the public IP address and VM ID.

   Red Database DBMS runs by default and is available on port 3050.

   To connect to the DBMS, the following parameters are set:

   • Username: SYSDBA.
   • Password: VM ID.

3. Connect to the VM over SSH. To do this, use the username you set when creating the VM and the private SSH key you created earlier.

4. Partition the disk for data storage by running the command:

   sudo parted -s -a optimal -- /dev/vdb mklabel gpt mkpart primary ext4 1MiB 100%
   sudo mkfs -t ext4 /dev/vdb1
   

5. Mount the disk:

   sudo mkdir /db
   echo $(sudo blkid -o export /dev/vdb1 | grep UUID) /db ext4 defaults,nofail 1 2| sudo tee -a /etc/fstab
   sudo mount /dev/vdb1 /db
   sudo chown firebird:firebird /db
   sudo chmod 0770 /db
   

6. Add a new alias for the database:

   echo newdb=/db/newdb.fdb | sudo tee -a /opt/RedDatabase/databases.conf
   

7. Close the SSH connection:

   exit
   

8. Install the isql utility included in the Red Database DBMS distribution.

9. Connect to the DBMS:

   isql -u sysdba -p <VM_ID> <VM_public_IP_address>:employee
   

10. Change the default SYSDBA user password:

    SQL> alter user sysdba set password '<new_password>';
    SQL> exit;
    

11. Authenticate with the new password:

    isql -u sysdba -p <password>
    

12. Create a database:

    SQL> create database '<VM_public_IP_address>:<DB_name>';
    SQL> exit;
    

13. Connect to the database:

    isql -u sysdba -p <password> <VM_public_IP_address>:<DB_name>
    

• Designing, developing, and administering databases.
• Developing applications with OLTP and OLAP technologies.
• Developing hybrid applications for analytical and interactive transaction processing.
• Protecting:
  • State information systems (SIS) and trading platforms up to and including security class 1.
  • Information systems for personal data processing (ISPDP) up to and including security level 1.

RED SOFT
RED SOFT provides technical support to RED Database DBMS users:

• By phone: +7 (800) 200-48-02.
• By email: rdb@red-soft.ru.
• On the technical support portal (in Russian), which is available to users with extended support.

For extended technical support, visit the official website (in Russian).

Yandex Cloud
Yandex Cloud technical support is available 24/7 to respond to requests. The types of requests available and their response time depend on your pricing plan. You can enable paid support in the management console. Learn more about requesting technical support.

Yandex Cloud does not provide technical support for this product. If you have any issues, please refer to the developer’s information resources.