Skip to main content

MySQL

This guide contains information required in setting up an MySQL Sink in Vanus Connect.

Introduction​

MySQL is a popular open-source relational database management system used to store, organize, and retrieve data for websites, applications, and other software.

Vanus Connect's MySQL sink connector simplifies the process of transferring data/events from various sources to a MySQL database/table, with configurable filters and upsert/insert modes.

Prerequisites​

Before forwarding events to MySQL, you must have:

Perform the following step to configure your MySQL Sink.

Step 1: Create a Connection​

Enter all the following information in Vanus Connect.

  • Choose the action to execute①
  • Host② - The IP address of your MySQL Server.
  • Port③ - The Port of your MySQL Server: 3306.
  • Username④ - A Username with the following permissions INSERT, UPDATE, DELETE.
  • Password⑤ - The user password.
  • Database⑥ - The database name.
  • Table⑦ - The table name.

mysql-sink-1.webp

Step 2: Personalize Event Structure​

note

This is a general instruction on how to personalize your event structure. You can structure your events to suit your specific requirements and create connections for different scenarios.

  1. Click on Display sample events① for reference and click on Add More② to add events.

mysql-sink-2.webp

  1. Input key③ and search for the corresponding value④ for the event you want.

mysql-sink-3.webp

  1. You can fill in as many key-value pairs⑤ as you wish to receive.

mysql-sink-4.webp

  1. Click Submit⑥ to finish the configuration process.

mysql-sink-5.webp

Custom Connection​

The event data must be in JSON format and created following the structure of your database, here's an example:

{
  "title": "value",
  "date": "value",
  "ect...": "value"
}