MySQL

This article contains sections on:

Creating a MySQL source
Creating a stream query

CREATING A MYSQL SOURCE

1. In the Data Manager window, click Sources +.
2. In the Source Types window, click START on the  tile. The MySQL dialog box is displayed.
   
3. Enter your Server location.
4. Either enter your MySQL port number or leave the default port number [3306] as-is.
5. [Optional] Enter a user name.
6. [Optional] enter a user password.
7. Enable / disable Use SSL. The default is Use SSL enabled.
8. Enable Verify Server Certificate.
9. Click LIST DATABASES to display the databases available on the server and user data specified.
10. Choose a Database.
11. Click Continue to open the Stream Query window.

CREATING A STREAM QUERY

If you have just created a MySQL data source, skip to step 3.

1.  In the Data Manager Sources+ panel, choose the MySQL source for which you want to create a stream query. 
   Note The streams associated to that source are displayed. If the Streams panel is empty, no stream queries exist for that source.
2. Click Stream+ to display the Stream Query window.
3. Open the Choose Table/View drop-down menu.
4. Choose the Table Data for your query.
   Note To preview the Table, click the Preview icon.
5. To edit the query  data, click the Pen icon in the Measures & Dimensions panel.
   
6. To add either a measure or a dimension drag the item from the Available fields column to the relevant column. If the item is not displayed, Search for it.
7. To add a Date, drag or search for a relevant field from the Available fields column.
8. To edit the Schedule Records Collections, click the panel Pen icon. 
   
9. In Query every, choose a query interval [Day/Hour]. The default is Day.
10. In Records Time Zone, choose a time zone according to which the records will be processed. The default is UTC.
11. In Historical Time Span, choose a time span of records to query while initializing the stream. The default is based on the interval choose in step 9: 
    Hour = Last week
    Day = Last month
12. In Records Delay (Minutes), set a recording delay. The default is "0".
    Note To minimize partial query results, set the delay according to the delay your internal process takes to prepare the data records.
13. In Query Backfill Policy, set the backfill missing data records policy after stream initialization. The default is 100. 
    Examples
    0 = Query only last day/hour 
    1 = Query previous and last day/hour
    50 = Query previous 50 last days\hours
14. Click X to apply the scheduling settings.
15. Click NEXT. The Stream Table is displayed.
    

    SEE 
    Whitelisting Anodot Servers
    Using Data Collectors
    Data Manager
    Stream Tables
    Viewing Stream Summaries