Determine which database server is being used by SafeSync for Enterprise and how administrator can access it.
SafeSync for Enterprise uses MySQL as its database. MySQL is configured during SSFE server installation. Below are the several databases created in MySQL for SSFE:
- osdp – main database that stores everything that is not in shard_1 or data
- shard_1 – objects and permissions reference database
- data – contains the data table
- mogilefs – MogileFS’ own database managed independently by the MogileFS system
- gearman – stores the gearman queue
- auth – contains persistent logins and SSO information
- tmsb_db – Shared Protection Extension configuration and keys
- au – update configuration and component versions
Administrators can locally manage the database or make database queries using the following options:
Option 1: Third-party MySQL access tools
Third-party tools such as MySQL Workbench and Navicat for MySQL can be used to connect to MySQL. When using a third-party tool, make sure to set up the connection via SSH tunnel. This is necessary because, by default, MySQL is configured to prohibit remote connections to the database. Only local access is allowed.
Option 2: MySQL command line tool
To work directly with the database:
- Log in to SSFE server command line interface.
- Run the following command:
mysql -uroot -p
- Type the password when prompted.