MySQL

Documentation Index

Fetch the complete documentation index at: https://docs.mantrixflow.com/llms.txt

Use this file to discover all available pages before exploring further.

​

Current connection form

• Connection Name
• Host
• Port
• Database
• Username
• Password
• SSL Mode
• Port defaults to 3306.
• SSL Mode options are available in the connection form.
• Use the builder to set the final destination Schema and Table.

​

Good first use cases

• operational reporting tables
• internal tool read models
• application-facing SQL tables fed by a pipeline

​

Before you connect

• Create a dedicated write user for the target MySQL database.
• Decide which schema and table name you want to use in the destination panel.
• Validate one destination table manually before broadening the rollout.

​

Step by step

1. Open Connections and click + New Connection.
2. Set the role to Destination and choose MySQL.
3. Fill the form with real values, for example:
   • Connection Name: MySQL Reporting
   • Host: reporting.cluster-abcdefghijkl.us-east-1.rds.amazonaws.com
   • Port: 3306
   • Database: reporting
   • Username: mf_writer
   • SSL Mode: require
4. Click Test Connection and save the connection after the test succeeds.
5. In the builder’s Destination panel, configure:
   • Connection: MySQL Reporting
   • Schema: analytics
   • Table: orders_live
   • Write mode: Upsert
6. Save the pipeline and run one manual sync before enabling a schedule.

​

Real-world example

​

Troubleshooting

• If the test fails, confirm the database host, SSL mode, and write user credentials.
• If destination validation fails, make sure the target schema and table names are correct for the environment.
• Keep the first rollout on Upsert and validate the rows with SQL before adding a schedule.