Hello Everybody,
could you please tell me the Best way to monitor Database Server based on OS Linux and Microsoft
Thaaaanks
could you please tell me the Best way to monitor Database Server based on OS Linux and Microsoft
Thaaaanks
-
-
Please clarify what is in your interest scope?
Would you like to monitor database server by itself in "operating system" level? Then you can proceed with templates like "Template OS Windows" or "Template OS Linux"
If you have running MySQL under linux you can advance from built-in "Template DB MySQL".
Regards,
Aigars -
Hello Mohammadjuve,
Here is workflow how to gather metrics form Zabbixs servers own database 'zabbix'. The most important part is put the database username and passowrd in '.my.cnf' file on 'zabbix' users HOME directory so the agent knows how to access the database.
Assign 'Template DB MySQL' to host 'Zabbix server'Code:[root@z347 ~]# getenforce #check SELinux status Enforcing [root@z347 ~]# setenforce 0 #trun off SELinux [root@z347 ~]# getenforce #check SELinux status Permissive [root@z347 ~]# grep zabbix /etc/passwd #note the home dir for user 'zabbix' zabbix:x:997:994:Zabbix Monitoring System:/var/lib/zabbix:/sbin/nologin [root@z347 ~]# grep "^Hostname=" /etc/zabbix/zabbix_agentd.conf #note hostname if plan to use active checks Hostname=Zabbix server [root@z347 ~]# grep "^Include" /etc/zabbix/zabbix_agentd.conf #make sure 'zabbix_agentd.d' direcotry is enabled Include=/etc/zabbix/zabbix_agentd.d/*.conf [root@z347 ~]# grep -v "^$\|^#" /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf #output active content of MySQL metric query. note the HOME dir UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/var/lib/zabbix mysql -N | awk '{print $$2}' UserParameter=mysql.size[*],bash -c 'echo "select sum($(case "$3" in both|"") echo "data_length+index_length";; data|index) echo "$3_length";; free) echo "data_free";; esac)) from information_schema.tables$([[ "$1" = "all" || ! "$1" ]] || echo " where table_schema=\"$1\"")$([[ "$2" = "all" || ! "$2" ]] || echo "and table_name=\"$2\"");" | HOME=/var/lib/zabbix mysql -N' UserParameter=mysql.ping,HOME=/var/lib/zabbix mysqladmin ping | grep -c alive UserParameter=mysql.version,mysql -V [root@z347 ~]# ls -la /var/lib/zabbix/.my.cnf #necessary permissions and owner -rw-------. 1 zabbix zabbix 47 May 8 02:18 /var/lib/zabbix/.my.cnf [root@z347 ~]# cat /var/lib/zabbix/.my.cnf #direct content [client] user=zabbix password=TaL2gPU5U9FcCU2u [root@z347 ~]# sudo -H -u zabbix bash -c 'zabbix_agentd -t mysql.status[Uptime]' #test key from 'zabbix' user. in this way we ensure zabbix agent can reach the credentials to access DB mysql.status[Uptime] [t|3477] [root@z347 ~]# systemctl restart zabbix-agent #restart agent
Regards,Comment
-
Hello Aigars,
That was really Super.
i works perfectly with MYSQL.
have idea about MS SQL Server ?
Regards,Comment
-
Hi, Mohammadjuve,
What kind of Windows version and MS SQL version you have?
Please try out
or
Let us know how it goes and share the struggles you have.
Regards,
Comment
-
Hello Aigars,
How are you doing?
Thank you for your Reply, I've tried the Template "App MSSQL 2008-2016" , the Scripts run perfectly, also the Discovery rules.
the Issue occurred with Perf counter, I muss pass the parameters with $:
for Example:
perf_counter["\MSSQL$TestSQL
atabases(master)\Active Transactions"]
receive the message "Cannot obtain performance information from collector".I Think the problem related to $.
I tried another perf_counter without $ and I got normal result.
Regards,
Comment
-
Hi aigars, do you have any tutorial with PostgreSQL ?Hello Mohammadjuve,
Here is workflow how to gather metrics form Zabbixs servers own database 'zabbix'. The most important part is put the database username and passowrd in '.my.cnf' file on 'zabbix' users HOME directory so the agent knows how to access the database.
Assign 'Template DB MySQL' to host 'Zabbix server'Code:[root@z347 ~]# getenforce #check SELinux status Enforcing [root@z347 ~]# setenforce 0 #trun off SELinux [root@z347 ~]# getenforce #check SELinux status Permissive [root@z347 ~]# grep zabbix /etc/passwd #note the home dir for user 'zabbix' zabbix:x:997:994:Zabbix Monitoring System:/var/lib/zabbix:/sbin/nologin [root@z347 ~]# grep "^Hostname=" /etc/zabbix/zabbix_agentd.conf #note hostname if plan to use active checks Hostname=Zabbix server [root@z347 ~]# grep "^Include" /etc/zabbix/zabbix_agentd.conf #make sure 'zabbix_agentd.d' direcotry is enabled Include=/etc/zabbix/zabbix_agentd.d/*.conf [root@z347 ~]# grep -v "^$\|^#" /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf #output active content of MySQL metric query. note the HOME dir UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/var/lib/zabbix mysql -N | awk '{print $$2}' UserParameter=mysql.size[*],bash -c 'echo "select sum($(case "$3" in both|"") echo "data_length+index_length";; data|index) echo "$3_length";; free) echo "data_free";; esac)) from information_schema.tables$([[ "$1" = "all" || ! "$1" ]] || echo " where table_schema=\"$1\"")$([[ "$2" = "all" || ! "$2" ]] || echo "and table_name=\"$2\"");" | HOME=/var/lib/zabbix mysql -N' UserParameter=mysql.ping,HOME=/var/lib/zabbix mysqladmin ping | grep -c alive UserParameter=mysql.version,mysql -V [root@z347 ~]# ls -la /var/lib/zabbix/.my.cnf #necessary permissions and owner -rw-------. 1 zabbix zabbix 47 May 8 02:18 /var/lib/zabbix/.my.cnf [root@z347 ~]# cat /var/lib/zabbix/.my.cnf #direct content [client] user=zabbix password=TaL2gPU5U9FcCU2u [root@z347 ~]# sudo -H -u zabbix bash -c 'zabbix_agentd -t mysql.status[Uptime]' #test key from 'zabbix' user. in this way we ensure zabbix agent can reach the credentials to access DB mysql.status[Uptime] [t|3477] [root@z347 ~]# systemctl restart zabbix-agent #restart agent
Regards,
Thank youComment
-
I added the Template DB MySQL to the zabbix server host. What do you think of these values below?
Queries per second: 54.11 qps
Slow queries: 873Comment
Comment