Add an Instance
Database Instance or simply Instance models after a single database instance which is usually accessed via a host:port address. A typical database instance could be your on-premises MySQL instance, an AWS RDS instance etc. Each Database Instance belongs to an Environment.
Currently Bytebase supports MySQL, PostgreSQL, TiDB, Snowflake, ClickHouse, MongoDB and Spanner instances.
This document describes how to add an instance in order to synchronize databases.
- Workspace Owner or Workspace DBA role
- If you don't have an existing instance on hand, you can add a local MySQL instance.
Add an instance
- Click Instances on the top bar.
- Click Add Instance.
- Select an Instance Type on the top.
- Enter Instance name, select Environment, enter Host or Socket and Port.
- Enter connection info: Username and Password, and click Test Connection.
- (Optional) Enter SSL connection info:
- Choose None to not use SSL connection.
- Choose CA Certificate to use SSL connection with CA certificate only.
- Choose CA Certificate + Client Key + Client Certificate to use a full SSL connection.
After adding an instance, click Databases on the navigation bar. You can find the table is still empty. It’s because you haven’t created any project yet. In Bytebase, only databases belong to a user project will show up on the Databases page.
Configure read-only connection
To separate from admin connection, you can configure a read-only connection used by SQL Editor once an instance is added. This separation can be configured at the database user/role access control level or replication instance level.
- Create a new role with read-only access or a read-replica instance.
- Click Create on Connection info.
- Enter read-only connection info. If this is a read-replica instance, you need to enter its host and port information.
- Click Update to finish the configuration.