...
/etc/rsyslog.d/45-mysql.conf file
Code Block |
---|
template( name="mysql" type="string" string="<%PRI%>%timegenerated% %HOSTNAME% %syslogtag% %msg%" ) # MySQL general log input( type="imfile" File="/var/lib/mysql/mysql.log" Tag="db.mysql.out.productionENV.devo-eamAPP.rhel8CLON:" Facility="user" Severity="info" PersistStateInterval="1" reopenOnTruncate="on" freshStartTail="on" ruleset="mysql-rules" ) # MySQL error log input( type="imfile" File="/var/lib/mysql/mysql-error.log" Tag="db.mysql.error.productionENV.devo-eamAPP.rhel8CLON:" Facility="user" Severity="info" PersistStateInterval="1" reopenOnTruncate="on" freshStartTail="on" ruleset="mysql-rules" ) # MySQL slow log input( type="imfile" File="/var/lib/mysql/mysql-slow.log" Tag="db.mysql.slow.productionENV.devo-eamAPP.rhel8CLON:" Facility="user" Severity="info" PersistStateInterval="1" reopenOnTruncate="on" freshStartTail="on" ruleset="mysql-rules" ) ruleset(name="mysql-rules") { action( type="omfwd" template="devo" queue.type="LinkedList" queue.filename="mysqlq1" queue.saveonshutdown="on" action.resumeRetryCount="-1" TargetDEVO-RELAY="127.0.0.1" PortPORT="5140" Protocol="tcp" ) } # Send to Devo directly over TLS #ruleset(name="mysql-rules") { # action( # type="omfwd" # template="devo" # queue.type="LinkedList" # queue.filename="mysqlq1" # queue.saveonshutdown="on" # action.resumeRetryCount="-1" # TargetDEVO-RELAY="collector-us.devo.io" # PortPORT="443" # Protocol="tcp" # StreamDriver="gtls" # StreamDriverMode="1" # StreamDriverAuthMode="x509/name" # StreamDriverPermittedPeers="collector-us.devo.io" # ) #} |
...