Skip to main content
added [slow-log] to 102 questions - Shog9 (Id=1924)
Link
Tweeted twitter.com/StackDBAs/status/1208945636877492224

I am running a number mysqlof MySQL servers as slaves and masters. It is quite annoying to look for slow logs and errors in every server, so I would like to log all the errors into an external database.

    DB1    DB2    DBn ...
      \      |      /
       \     |     /          <-- error logs and slow logs
        \    |    /
[MySQL error & slow log database]

Is there some simple ofway of doing it  ? or
Or I do need to write some scripts and stuff  ?

pP.sS. I hope you appreciate my superb ASCII diagram'ing skillsdiagraming skills

I am running a number mysql servers as slaves and masters. It is quite annoying to look for slow logs and errors in every server, so I would like to log all the errors into external database.

    DB1    DB2    DBn ...
      \      |      /
       \     |     /          <-- error logs and slow logs
        \    |    /
[MySQL error & slow log database]

Is there some simple of of doing it  ? or I do need to write some scripts and stuff  ?

p.s. hope you appreciate my superb ASCII diagram'ing skills

I am running a number of MySQL servers as slaves and masters. It is quite annoying to look for slow logs and errors in every server, so I would like to log all the errors into an external database.

    DB1    DB2    DBn ...
      \      |      /
       \     |     /          <-- error logs and slow logs
        \    |    /
[MySQL error & slow log database]

Is there some simple way of doing it?
Or I do need to write some scripts and stuff?

P.S. I hope you appreciate my superb ASCII diagraming skills

Source Link
Katafalkas
  • 741
  • 1
  • 12
  • 20

Redirecting MySQL errors and slow logs into another database

I am running a number mysql servers as slaves and masters. It is quite annoying to look for slow logs and errors in every server, so I would like to log all the errors into external database.

    DB1    DB2    DBn ...
      \      |      /
       \     |     /          <-- error logs and slow logs
        \    |    /
[MySQL error & slow log database]

Is there some simple of of doing it ? or I do need to write some scripts and stuff ?

p.s. hope you appreciate my superb ASCII diagram'ing skills