question Re: ambari server connect mysql so frequent!! in Archives of Support Questions (Read Only)

ambari server connect mysql so frequent!!

darkz1984 — Sun, 18 Aug 2019 10:11:57 GMT

I install ambari-server 2.4.2.0 and the newest hdp 2.5

after I start the ambari server, I found mysql was connect too often.

my mysql server just used for ambari ,hive,grafana.

when I stop the ambari server,the top commands show :

After I start the ambari server, the top command show :

I use show processlist in mysql,it often shows:

mysql-connector-java .... show variables where ...

I don't know why the ambari server connect to mysql so frequent..

Re: ambari server connect mysql so frequent!!

jsensharma — Mon, 27 Mar 2017 19:14:28 GMT

@darkz yu

Are to you using Ambari Database as mysql?

By any change is there any possibility that you can upgrade your mysql-connector-java driver version from 5.1.17 to 5.1.38 or later. As i remember there was some CPU utilization issue reported for the "5.1.17" version of connector.

You can drop the latest mysql-connector-java jar inside the "/usr/share/java" directory and then create a symlink "/usr/share/java/mysql-connector-java.jar"

as following to point to it. Then restart the components that are using mysql.

# ls -lan /usr/share/java/mysql-*
-rw-r--r--. 1 0 0 819803 Jun 22  2012 /usr/share/java/mysql-connector-java-5.1.17.jar
-rwxrwxrwx. 1 0 0 992808 Mar  9 08:49 /usr/share/java/mysql-connector-java-5.1.41-bin.jar
lrwxrwxrwx. 1 0 0  35 Mar  9 08:50 /usr/share/java/mysql-connector-java.jar -> mysql-connector-java-5.1.41-bin.jar

mysql-connector-java driver downlaod link: https://dev.mysql.com/downloads/connector/j/5.1.html

Re: ambari server connect mysql so frequent!!

darkz1984 — Tue, 28 Mar 2017 08:45:58 GMT

I use yum install the mysql-connector-java

Re: ambari server connect mysql so frequent!!

jsensharma — Tue, 28 Mar 2017 08:48:30 GMT

@darkz yu

Repository Jars are not upgraded frequently. Just check if you have later version of mysq-connector-java available at your OS repository? If not then better to download the Jar from previously shared link and then load it.

Re: ambari server connect mysql so frequent!!

darkz1984 — Tue, 28 Mar 2017 10:38:35 GMT

I install newer mysql-connector，and it is ok now

uninstall older connector：

rpm -e mysql-connector-java

install newer version from mysql local HDP-UTILS repo

rpm -ivh http://192.168.112.47/repo/HDP-UTILS-1.1.0.21/repos/centos6/mysql-connector-java/mysql-connector-java-5.1.37-1.noarch.rpm

then restart the ambari server：

sudo service ambari-server restart

Re: ambari server connect mysql so frequent!!

darkz1984 — Wed, 12 Jul 2017 14:01:22 GMT

@Jay SenSharma

It sees strange,I found the version of mysql-connector is mysql-connector-java-5.1.17-6.el6.noarch on mysql another cluster,but there is nothing wrong about it.

Re: ambari server connect mysql so frequent!!

orhan_incekara — Tue, 20 Feb 2018 23:08:47 GMT

This helped me 🙂

just a litte more detai for the sym link:

	rm /usr/share/java/mysql-connector-java.jar 
	ln -s /usr/share/java/mysql-connector-java-5.1.45-bin.jar /usr/share/java/mysql-connector-java.jar

Re: ambari server connect mysql so frequent!!

avikaggarwal199 — Thu, 19 Mar 2020 07:56:10 GMT

@jsensharma

Thank you for your answer.

I am facing similar issue with Ambari 2.7.0, Mysql 5.7.29.

I am unable to get into admin account even once and on click of Login it just hangs and says 'Unable to connect to Ambari Server. Confirm Ambari Server is running and you can reach Ambari Server from this machine.' after some seconds.'

I even posted details here: https://stackoverflow.com/q/60743259/7051479

Could you please help me out on this.