Manage Databases with Terraform

• Part 1: Manage Environments with Terraform - Set up environments with policies
• Part 2: Manage Databases with Terraform 👈
• Part 3: Manage Projects with Terraform - Organize databases into projects
• Part 4: Manage Bytebase Settings with Terraform - Configure workspace profile and approval policies
• Part 5: Manage SQL Review Rules with Terraform - Define SQL review policies
• Part 6: Manage Users and Groups with Terraform - Configure users and groups
• Part 7: Manage Database Access Control with Terraform - Grant database permissions
• Part 8: Manage Data Masking with Terraform - Protect sensitive data

​

What You’ll Learn

​

Prerequisites

• Completed Part 1:
  • Bytebase running with built-in sample data
  • Service account created
  • Terraform initialized
  • Environments configured

​

Step 1 - Explore Built-in Instances

1. In Bytebase, click Instances on the left sidebar. You’ll see two PostgreSQL instances:
   • Test Sample Instance (port 8083)
   • Prod Sample Instance (port 8084)
2. Click +Add Instance, you may add more database instances.
3. Click Projects on the left sidebar to see the Sample Project, then click it. You’ll see:
   • hr_test database on Test instance
   • hr_prod database on Prod instance
4. Click + New DB, you may create more databases on the existing instances.

​

Step 2 - Register Instances with Terraform

# Test Sample Instance - PostgreSQL on port 8083
resource "bytebase_instance" "test" {
  depends_on  = [bytebase_setting.environments]
  resource_id = "test-sample-instance"
  environment = "environments/test"
  title       = "Test Sample Instance"
  engine      = "POSTGRES"
  # Assign instance license
  activation  = true

  # Connection settings for the built-in test database
  data_sources {
    id       = "admin data source test-sample-instance"
    type     = "ADMIN"
    host     = "/tmp"      # Unix socket for local connection
    port     = "8083"
    username = "bbsample"
    password = ""          # Empty for local auth
  }
}

# Production Sample Instance - PostgreSQL on port 8084
resource "bytebase_instance" "prod" {
  depends_on  = [bytebase_setting.environments]
  resource_id = "prod-sample-instance"
  environment = "environments/prod"
  title       = "Prod Sample Instance"
  engine      = "POSTGRES"
  activation  = true

  data_sources {
    id       = "admin data source prod-sample-instance"
    type     = "ADMIN"
    host     = "/tmp"
    port     = "8084"
    username = "bbsample"
    password = ""
  }
}

• depends_on: Ensures environments from Part 1 exist first
• resource_id: Must match the existing instance ID
• environment: Links instance to Test or Prod environment
• data_sources: Connection details for the database

​

Step 3 - Apply Configuration

terraform plan
terraform apply

​

Step 4 - Verify Setup

1. Go to Instances in Bytebase.
2. Verify both instances show:
   • Correct environment assignment
   • Y under License column (if using Enterprise)

resource "bytebase_instance" "test" {
  # ... other config ...
  title = "Development Database"  # Changed title
}

​

Summary and Next Steps