MySQL

Supports:

• ✅ Models
• ✅ Model sync destination
• ✅ Bulk sync source
• ✅ Bulk sync destination

Connection

Configuration

ssh

When ssh is true

Example

1
{
2
  "name": "MySQL connection",
3
  "type": "mysql",
4
  "configuration": {
5
    "account": "admin",
6
    "change_detection": false,
7
    "dbname": "mydb",
8
    "hostname": "database.example.com",
9
    "passwd": "password",
10
    "port": 3306,
11
    "ssh": false,
12
    "ssl": false
13
  }
14
}

Model Sync

Source

Configuration

Example

1
{
2
  ...
3
  "configuration": {
4
    "query": "SELECT * from users",
5
    "table": "users",
6
    "view": "active_users"
7
  }
8
}

Target

MySQL connections may be used as the destination in a model sync.

All targets

Configuration

Example

1
{
2
  ...
3
  "target": {
4
      "configuration": {
5
        "created_column": "",
6
        "preserve_table_on_resync": false,
7
        "updated_column": "",
8
        "write_null_values": false,
9
        "write_record_timestamps": false
10
    }
11
  }
12
}

Target creation

MySQL connections may be used to create a new target for a model sync. The following parameters are required to create a new target:

Bulk Sync

Source

MySQL connections may be used as a bulk sync source. No additional configuration options are required.

Destination

MySQL connections may be used as a bulk sync destination. No additional configuration options are required.

Type handling

Destination types

Source types