...
The full tag must have at least three six levels. The first two are fixed asas db.mysql
. The The third level identifies the log type/format and currently must be one of error
,out
, or slow
.
The fourth, fifth and sixth levels are required and should identify the environment type, server name, and node/node group respectively.
environment
- Describes the environment in when the event occurred. For example, development, testing, or production.application
- The name of the MySQL database server.clon
- The name or ID of the node/node group that generated the event
The values of these levels should be guided by the structure we propose because they will be saved in the events when saved in Devo. When you open the resulting data table, these will appear in the environment, application, and clon columns.
These are the valid tags and corresponding data tables that will receive the parsers' data:
Product / Service | Tags | Data tables |
---|---|---|
MySQL |
|
|
|
| |
|
|
For more information, read more about Devo tags.
MySQL logs
Make sure that your MySQL Server is configured to generate the log events that you want to send to Devo. For example, both the general and slow query logs are disabled by default. Additionally, the error log and the slow query log can be configured to log different kinds of events. You should review the configuration of these logs before setting up the forwarding of events to Devo.
For full details about the MySQL Server logs and configuration options, see the vendor documentation.
Sending to Devo via files
Unix environments
You can read more about using rsyslog to monitor and send files to a Devo endpoint in the Sending data to Devo section of our documentation. Here we offer a sample rsyslog configuration file that is set up to monitor the error, general query and slow query logs, and forward them to a Devo Relay.
/etc/rsyslog.d/45-mysql.conf file
|
Note the following placeholder values in the sample file above:
Replace ENV.APP.CLON with the values that represent the source environment, server name, and node reference.
Replace DEVO-RELAY and PORT with the IP address and port of your Devo Relay.
You can uncomment the SSL section of the file to send the events directly to the Devo Cloud. In this case, you should replace DEVO-RELAY and PORT with the hostname of your Devo domain and port 443.
Make sure that the file you are sending and the directory where resides can be read by the user running rsyslog. If not, you can assign the necessary permissions by changing the file group to syslog:
|
To configure file rotation, you can use the logrotate utility. The following in an example of a mysql.conf might be set up.
/etc/logrotate.d/mysql file
|
When you have made all the configuration changes necessary, don't forget to restart the rsyslog process:
Code Block |
---|
/etc/init.d/rsyslog restart |
Windows environments
You can use a MySQL Server system variable to write the error events to the Windows event log. See the vendor documentation for the version of MySQL Server you are running.
You can use the rsyslog to tag the logs and send them to Devo. The following configuration file is a sample that needs to be customized to use the complete tag, correct paths to the security certificates (if forwarding to the DevoCloud directly), and the DEVO-RELAY and PORT of the destination.
/etc/rsyslog.d/46-mysql-local.conf
|
Table structure
These are the fields displayed in these tables:
...