Publish Events to MySQL

MinIO AIStor supports publishing bucket notification events to a MySQL service endpoint. MinIO AIStor supports MySQL 5.7.8 and later only.

Prerequisites

MySQL 5.7.8 and later

MinIO AIStor relies on features introduced with MySQL 5.7.8.
The MinIO AIStor mc command line tool

This procedure uses the mc command line tool for certain actions. See the mc Quickstart for installation instructions.

Add a MySQL endpoint to an AIStor Server

The following procedure adds a new MySQL service endpoint for supporting bucket notifications in an AIStor Server.

Add the MySQL endpoint to MinIO AIStor.

You can configure a new MySQL service endpoint using either environment variables or by setting runtime configuration settings.
MinIO AIStor supports specifying the MySQL service endpoint and associated configuration settings using environment variables. The minio server process applies the specified settings on its next startup.
The following example code sets all environment variables related to configuring a MySQL service endpoint. The minimum required variables are:
The full list of available environment variables is:
export MINIO_NOTIFY_MYSQL_ENABLE_<IDENTIFIER>="on" export MINIO_NOTIFY_MYSQL_DSN_STRING_<IDENTIFIER>="user:password@tcp(hostname:port)/database" export MINIO_NOTIFY_MYSQL_TABLE_<IDENTIFIER>="AIStor-events" export MINIO_NOTIFY_MYSQL_FORMAT_<IDENTIFIER>="namespace" export MINIO_NOTIFY_MYSQL_MAX_OPEN_CONNECTIONS_<IDENTIFIER>="2" export MINIO_NOTIFY_MYSQL_QUEUE_DIR_<IDENTIFIER>="/opt/minio/events" export MINIO_NOTIFY_MYSQL_QUEUE_LIMIT_<IDENTIFIER>="100000" export MINIO_NOTIFY_MYSQL_COMMENT_<IDENTIFIER>="MySQL Event Notification Logging for MinIO AIStor"
- Replace <IDENTIFIER> with a unique descriptive string for the MySQL service endpoint. Use the same <IDENTIFIER> value for all environment variables related to the new target service endpoint. The following examples assume an identifier of primary.
  
  If the specified <IDENTIFIER> matches an existing MySQL service endpoint on the AIStor Server, the new settings override any existing settings for that endpoint. Use mc admin config get notify_mysql to review the currently configured MySQL endpoints on the AIStor Server.
- Replace <ENDPOINT> with the DSN of the MySQL service endpoint. MinIO AIStor expects the following format:
  
  <user>:<password>@tcp(<host>:<port>)/<database>
  
  For example:
  
  "username:password@tcp(mysql.example.com:3306)/AIStordb"
See MySQL Service for Bucket Notifications for complete documentation on each environment variable.
MinIO AIStor supports adding or updating MySQL endpoints on a running minio server process using the mc admin config set command and the notify_mysql configuration key. MinIO AIStor applies a new or updated configuration setting immediately, with no server restart.
The following example code sets all settings related to configuring a MySQL service endpoint. The minimum required settings are:
The full list of available configuration settings is:
mc admin config set ALIAS notify_mysql:IDENTIFIER \ dsn_string="<ENDPOINT>" \ table="<string>" \ format="<string>" \ max_open_connections="<string>" \ queue_dir="<string>" \ queue_limit="<string>" \ comment="<string>"
- Replace IDENTIFIER with a unique descriptive string for the MySQL service endpoint. The following examples in this procedure assume an identifier of primary.
  
  If the specified IDENTIFIER matches an existing MySQL service endpoint on the AIStor Server, the new settings override any existing settings for that endpoint. Use mc admin config get notify_mysql to review the currently configured MySQL endpoints on the AIStor Server.
- Replace <ENDPOINT> with the DSN of the MySQL service endpoint. MinIO AIStor expects the following format:
  
  <user>:<password>@tcp(<host>:<port>)/<database>
  
  For example:
  
  "username:password@tcp(mysql.example.com:3306)/AIStordb"
See MySQL Bucket Notification Configuration Settings for complete documentation on each setting.
If you define both environment variables and configuration settings for the deployment, the settings defined by environment variables are used.
Confirm the target is registered.

MinIO AIStor applies a configuration setting change immediately.

If you configured this endpoint with environment variables, those values take precedence and mc admin config set has no effect on it. Update the environment variables on every node, then restart the deployment with the mc admin service restart command:
```
mc admin service restart ALIAS
```
Replace ALIAS with the alias of the deployment.

List the notification targets with mc event target list:
```
mc event target list ALIAS
```
The MySQL target appears with an ARN similar to the following:
```
arn:minio:sqs::primary:mysql
```
You must specify the ARN resource when configuring bucket notifications with the associated MySQL deployment as a target.
Configure bucket notifications using the MySQL endpoint as a target.

Use the mc event add command to add a new bucket notification event with the configured MySQL service as a target:
```
mc event add ALIAS/BUCKET arn:minio:sqs::primary:mysql \
  --event EVENTS
```
- Replace ALIAS with the alias of an AIStor Server.
- Replace BUCKET with the name of the bucket in which to configure the event.
- Replace EVENTS with a comma-separated list of events for which MinIO AIStor triggers notifications.
Use mc event ls to view all configured bucket events for a given notification target:
```
mc event ls ALIAS/BUCKET arn:minio:sqs::primary:mysql
```
Validate the configured events.

Perform an action on the bucket for which you configured the new event and check the MySQL service for the notification data. The action required depends on which events were specified when configuring the bucket notification.

For example, if the bucket notification configuration includes the s3:ObjectCreated:Put event, you can use the mc cp command to create a new object in the bucket and trigger a notification.
```
mc cp ~/data/new-object.txt ALIAS/BUCKET
```

Update a MySQL endpoint in an AIStor Server

The following procedure updates an existing MySQL service endpoint for supporting bucket notifications in a MinIO AIStor deployment.

List configured MySQL endpoints in the deployment.

Use the mc admin config get command to list the currently configured MySQL service endpoints in the deployment:
```
mc admin config get ALIAS notify_mysql
```
Replace ALIAS with the alias of the AIStor Server.

The command output resembles the following:
```
notify_mysql:primary format="namespace" table="aistor_images" dsn_string="user:pass@tcp(mysql.example.com:3306)/AIStordb"
notify_mysql:secondary format="namespace" table="aistor_images" dsn_string="user:pass@tcp(mysql.example.com:3306)/AIStordb"
```
- notify_mysql is the top-level configuration key for MySQL notification settings.
- dsn_string specifies the MySQL service endpoint for the given notify_mysql key.
- The notify_mysql:<IDENTIFIER> suffix describes the unique identifier for that MySQL service endpoint.
Note the identifier for the MySQL service endpoint you want to update for the next step.
Update the MySQL endpoint.

Use the mc admin config set command to set the new configuration for the MySQL service endpoint:
```
mc admin config set ALIAS notify_mysql:IDENTIFIER \
   dsn_string="<ENDPOINT>" \
   table="<string>" \
   format="<string>" \
   max_open_connections="<string>" \
   queue_dir="<string>" \
   queue_limit="<string>" \
   comment="<string>"
```
The following configuration settings are the minimum required for a MySQL service endpoint:
All other configuration settings are optional. See MySQL Notification Settings for a complete list of MySQL configuration settings.
Confirm the target is registered.

MinIO AIStor applies a configuration setting change immediately.

If you configured this endpoint with environment variables, those values take precedence and mc admin config set has no effect on it. Update the environment variables on every node, then restart the deployment with the mc admin service restart command:
```
mc admin service restart ALIAS
```
Replace ALIAS with the alias of the deployment.

List the notification targets with mc event target list:
```
mc event target list ALIAS
```
The MySQL target appears with an ARN similar to the following:
```
arn:minio:sqs::primary:mysql
```
Validate the changes.

Perform an action on a bucket which has an event configuration using the updated MySQL service endpoint and check the MySQL service for the notification data. The action required depends on which events were specified when configuring the bucket notification.

For example, if the bucket notification configuration includes the s3:ObjectCreated:Put event, you can use the mc cp command to create a new object in the bucket and trigger a notification.
```
mc cp ~/data/new-object.txt ALIAS/BUCKET
```

Publish Events to MySQL

Prerequisites

Add a MySQL endpoint to an AIStor Server

Update a MySQL endpoint in an AIStor Server

On this page