To query Percona with Flux:
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
mysql driver uses the following data source name (DSN) syntax (also known as a connection string):
Percona to Flux data type conversion
sql.from() converts Percona data types to Flux data types.
|Percona data type||Flux data type|
|INT, BIGINT, SMALLINT, TINYINT||int|
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for Flux and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.