Free MySQL Monitoring With Zabbix Monitoring Software

Поділитися
Вставка
  • Опубліковано 16 жов 2024
  • To make mysql.ping work, add [mysqladmin] to .my.cnf with the same user and password.
    Use the built-in template for MySQL/MariaDB Database engine monitoring, to collect important performance data from your databases.
    ☕ In case if you want to support this content with coffee:
    ☕ www.buymeacoff...
    👋 SOCIAL MEDIA
    📹 TWITTER - @RealDeimons
    🔔 INSTAGRAM - / dmitrylambert
    📫 Sign Up For Newsletter And Don't Miss Out on Anything
    📫 tinyurl.com/4s...

КОМЕНТАРІ • 30

  • @zabbixtraining
    @zabbixtraining  3 роки тому +1

    ► Grab your Monitoring Love Merchandise - teespring.com/stores/monitoring-it

  • @zabbixtraining
    @zabbixtraining  4 роки тому +1

    Books About Zabbix
    Amazon COM
    ► Zabbix 4 Network Monitoring 3rd Edition amzn.to/2Ra7XDE
    ► Zabbix Network Monitoring 2nd Edition amzn.to/2DQLWqI
    Amazon UK
    ► Zabbix 4 Network Monitoring amzn.to/2G7BCey
    ► Mastering Zabbix - Second Edition amzn.to/306Ru86
    Amazon DE
    ► Zabbix 4 Network Monitoring amzn.to/2FYg3NU
    ► Zabbix Cookbook amzn.to/3iXuqQK

  • @ivanoviedo8853
    @ivanoviedo8853 4 роки тому +2

    First of all, thank you so much for your videos, on the other hand, it would be useful if you make the configuration in windows.

  • @ariprince7993
    @ariprince7993 5 років тому

    Struck gold, great video again, thanks.

  • @Gannicus999
    @Gannicus999 3 роки тому

    How we can monitor mysql on windows using zabbix windows agent. I have zabbix server running in container. Now how can i configure to monitor mysql on windows?

  • @rudroroy1054
    @rudroroy1054 3 роки тому

    Probably zabbix user doesnot have rights to use mysqladmin utility hence it's not fetching the ping data.
    Did you find the solution?

  • @thiagos.santos9229
    @thiagos.santos9229 5 років тому

    Thanks for the video bro. Very useful information.

  • @vineetchaturvedi1536
    @vineetchaturvedi1536 3 роки тому

    Great video ...Please help me how to monitor PostgreSQl database located remotely with my Zabbix Sever with MySQL database....

  • @mattthor5404
    @mattthor5404 5 років тому +1

    Great vid. Useful info. Please try to cut down on time. The entire first three minutes could have been replaced by "Definitely monitor everything you can - which includes your databases. Now I'm going to show you the pre-installed template."

    • @mattthor5404
      @mattthor5404 5 років тому

      Side note. It would be amazing if you could put all your cmd history and file edits into the video description.

    • @zabbixtraining
      @zabbixtraining  5 років тому +2

      Thanks for feedback. Sometimes I just cant stop talking :) And about history with commands, I am just afraid that it will lead to copy/paste without even attempt to get into the topic. Main purpose is to explain how it works rather then simply post the commands, because commands can/will differ

    • @mattthor5404
      @mattthor5404 5 років тому

      Makes sense. Keep up the videos. I love zabbix

    • @teamrampageservices7981
      @teamrampageservices7981 5 років тому

      @@zabbixtraining Completely understand about the copy/paste thing! But what would be even more helpful/useful is full path to the files you're working within the description. You (almost) always let us know what OS your working on, so if I have an idea where you find it on CentOS (for example) I can go find it on Debian/Ubuntu/etc. easier.
      You've really helped me out, I'm glad Tom Lawrence pointed out your channel because I would have taken so much longer to my setup tuned and dialed in! Thanks for all you do!

  • @syafeuq
    @syafeuq 4 роки тому +1

    Hi Sir. It all worked for 1 minute and then status changed to Not Supported like Info: MySQL version
    Host: zabbix.fimm.net
    Item: Info: MySQL version
    Key: mysql.version["localhost","3306"]
    State: Not supported
    Host: myhost
    Item: Availability: Get status variables
    Key: mysql.get_status_variables["localhost","3306"]
    State: Not supported
    Trigger name: MySQL: Service is down
    Expression: {inventory:mysql.ping["{$MYSQL.HOST}","{$MYSQL.PORT}"].last()}=0
    State: Unknown
    May i know why? Your reply is highly appreciated. Thank you.

  • @yobanamaritzaguardapuclla4286
    @yobanamaritzaguardapuclla4286 4 роки тому

    your video has helped me a lot. I thank you. you are very good

  • @gbengadara2941
    @gbengadara2941 2 роки тому

    Great lecture but I must tell you that you are very fast when moving your mouse around

  • @RaviKumar-mn8bs
    @RaviKumar-mn8bs 4 роки тому

    Hi Dmirty,nice demo could you share user parameter configuration file

    • @zabbixtraining
      @zabbixtraining  3 роки тому

      Check new native templates. they are better then this

  • @outlanderrank4241
    @outlanderrank4241 4 роки тому +1

    Hi! your course is helpful.Thanks . and I would like ask if you could do a video about zabbix on mysql replication.that will be great !! Thank you again bro.

  • @battulgabatmunkh6873
    @battulgabatmunkh6873 5 років тому

    Tnx for your tutorial

  • @biglogied5142
    @biglogied5142 2 роки тому

    " monitor your database with zero coding " LUL

  • @juanra86
    @juanra86 2 роки тому

    Don`t work on zabbix 6 and alma linux, need put in /etc/zabbix/.my.cnf a new item [mysqladmin] with the same credentials