How to connect MySQL

Dataddo supports streaming data to MySQL data storage.

Getting your data to MySQL is an easy task to do with Dataddo.

First, you need to create a Data Flow. You can do this either by navigating to Sources, picking the Source that you want to use and clicking on Add to flow

flow_sourceOR by navigating to Data Flows.

dataflow-pngAnd clicking on New flow.

New Data Flows-pngAdd the required source by clicking on Add Source.

New Source Flow-png

Select the source that you want to connect to your destination. 

5. Choosing Source for flow

Now click on Add Destination, to select a destination from below.6. Selecting Destination

Click on create a new destination to create a new Universal MySQL destination.

7. Creating New DestinationNow select Universal MySQL

1. Selecting Universal MySQL

Make sure to allow the connection to your server from the IP address.2. Configuring IP address

Fill the configuration boxes based on your MySQL storage database, host and credentials, then click on Connection Check.

3. Filling MySQL InfoFinally, once all the information is correct, you can click on Create Flow. 

4. Creating flow for MySQL

Free consultation available!
Feel free to contact us if you encounter a problem during configuration. We're happy to help you configure your integrations with your dashboarding app of choice!
 Delivering data to storage

Append-only

When data delivery is scheduled, Dataddo gets the actual contents of the data source and perform a set of INSERT operations (one or multiple) against your storage. Neither DELETE nor UPDATE operation is performed, therefore the data are inserted in append-only mode.

Deleting historic rows

In certain cases, the append-only solution might have drawbacks due to the growing size of the database. To cope with this, the best solution is to define an AFTER INSERT trigger that deletes the historic data. In the example below, the trigger deletes all the rows meeting the insert_date < DATE_SUB(NOW(), INTERVAL 1 DAY) condition. Dataddo connectors allow to extract various date information, so the retention period can be flexibly set.

DELIMITER $$

CREATE TRIGGER trigger_name
AFTER INSERT
ON table_name
BEGIN
DELETE FROM table_name WHERE insert_date < DATE_SUB(NOW(), INTERVAL 1 DAY)
END$$

DELIMITER ;