Query Percona

To query Percona with Flux:

1. Import the sql package.

2. Use sql.from() and provide the following parameters:

   • driverName: mysql
   • dataSourceName: See data source name
   • query: SQL query to execute

import "sql"

sql.from(
    driverName: "mysql",
    dataSourceName: "user:password@tcp(localhost:3306)/db",
    query: "SELECT * FROM example_table",
)

Percona data source name

The mysql driver uses the following data source name (DSN) syntax (also known as a connection string):

username:password@tcp(localhost:3306)/dbname?param=value

Percona to Flux data type conversion

sql.from() converts Percona data types to Flux data types.