Dataddo supports streaming data to MySQL data storage.
Getting your data to MySQL is an easy task to do with Dataddo.
Network setup required. Make sure to white list the following IP address to allow incoming connection from the Dataddo application to your server.
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
OR by navigating to Data Flows.
And clicking on New flow.
Add the required source by clicking on Add Source.
Select the source that you want to connect to your destination.
Now click on Add Destination, to select a destination from below.
Click on create a new destination to create a new Universal MySQL destination.
Now select Universal MySQL
Fill the configuration boxes based on your MySQL storage database, host and credentials, then click on Connection Check.
Finally, once all the information is correct, you can click on Create Flow.
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.
CREATE TRIGGER trigger_name
DELETE FROM table_name WHERE insert_date < DATE_SUB(NOW(), INTERVAL 1 DAY)