Manage Users via RDBMS
By default, Syncrify does not require any database. It stores everything in local files, most of them are in XML format. Often, companies (particularly service providers) have thousands of users and they want to maintain the users in Syncrify programatically.
Consider This Scenario
Most ISPs have their own website where they offer other services besides remote backup. By storing the user information in a database, information can be modified in realtime without using Syncrify's web interface.
Here are some pros and cons of using a relational database.
Advantages
- External management - you can add/view/modify users from another program, such as your website.
- Highly scaleable
Disadvantages
- Additional dependency - if your database goes down, Syncrify goes down.
- Additional configuration
Prerequisites
At this time, Syncrify supports two database Vendor:
- MySQL
- MS SQL Server (with TCP/IP for the protocol and SQL Server Authentication model for security enabled.)
You must have one of the above RDBMS installed either on the same machine or a different machine. You will need a valid user account on the back-end with the following permissions:
- CREATE TABLE
- SELECT
- UPDATE
- DELETE
Syncrify stores user records in just one table called synusers. If this table does not exist, it will be created when you enable RDBMS in Syncrify.
Configuration
Follow the steps below to configure database.
- Log in as admin using the web interface.
- Click on the Configuration link on the left hand side
- Click on More Configuration Options on the top right, then click on Configure RDBMS.
- Select the type of database vendor.
- Syncrify will download necessary files for establishing connection from Synametrics' main website
- Once the files are downloaded, it will prompt you for connection parameters such as host name, TCP/IP port, user name and password.
- A new table called synusers will be created if it does not exist
- You can also import existing user accounts to the newly created table if desired.