Output MySQL event adapter helps to dump the output events to a MySQL database. It is used as an output event adapter.
| Table of Contents | ||
|---|---|---|
|
| Excerpt | ||||
|---|---|---|---|---|
| ||||
NOTE TO WRITERS: Add the TOC here.
|
Prerequisites
Follow the steps below to set up the prerequisites before starting the configuration.
- Download MySQL JDBC connector for Java, and add it to
<PRODUCT_HOME>/repository/components/lib/directory. Create a datasource, as the MySQL event adapter uses Carbon datasources.
Excerpt hidden true NOTE TO WRITERS: Link the word "datasource" above to the page named " Managing Datasources".
Configuring output MySQL event Adapter
You can configure the output MySQL event adapter using the management console or using a configuration file.
| Anchor | ||||
|---|---|---|---|---|
|
The steps below explain how to configure output MySQL event adapter using the management console. This deploys the event adapter in the <PRODUCT_HOME>/repository/deployment/server/outputeventadaptors/ directory.
- Log in to product's management console, and click Configure.
- Click Output Event Adaptors in the Event Processor Configs menu, and then click Add Output Event Adaptor.
Enter
mysql_adapterfor Event Adaptor Name, selectmysqlfor Event Adaptor Type, and enter the name of the created datasource
as shown in the below example.
- Click Add Event Adaptor.
| Anchor | ||||
|---|---|---|---|---|
|
Follow the instructions below to configure output MySQL event adapter using a configuration file.
...
| Info |
|---|
After an adapter is successfully added, it gets added to the list of adapters displayed under Event Processor Configs in the Configure menu of the product's management console. Click Edit to change its configuration and redeploy it. This opens an XML-based editor allowing you to edit the event adapter configurations from the UI. Do your modifications and click Update. You can also delete it, enable/disable statistics or enable/disable tracing on it using the provided options in the UI. |
Configuring output MySQL event adapter message properties
The configured output event adapters are used in event formatters. With output event adapter message properties, event formatters are able to extract data from event streams and format the output events. Following are the output MySQL event adapter-specific message properties.
...