Menu
Is there a specific method in Java that checks whether a MySQL server is alive?
564
mysql. jdbc. ConnectionImpl. pingInternal() to send a simple ping packet to the DB and returns true as long as a valid response is returned.
Step 3: Connect to a Local MySQL ServerEnter mysql.exe -uroot -p , and MySQL will launch using the root user. MySQL will prompt you for your password. Enter the password from the user account you specified with the –u tag, and you'll connect to the MySQL server.
Press Win+R. Type services. msc. Find MySQL service in the list, it is usually named as MySQL [version number], for example, MySQL 80.
If you can use SSH to access the machine remotely you can do: ps -ef | grep mysqld to see if mysql is up and running.
The standard MySQL JDBC connector, ConnectorJ, has a lightweight ping. From the docs:
MySQL Connector/J has the ability to execute a lightweight ping against a server, in order to validate the connection. In the case of load-balanced connections, this is performed against all active pooled internal connections that are retained. This is beneficial to Java applications using connection pools, as the pool can use this feature to validate connections.
Basically, ensure that your "ping" query starts with exactly the text /* ping */. Details in the linked docs above. This lets you take advantage of the pinging mechanism rather than doing a (slightly) heavier weight operation.
So basically, doing the query:
/* ping */ SELECT 1
...will trigger the ping mechanism rather than actually doing the "work" of a SELECT 1.
Mind you, if you're talking about checking a MySQL server that you're not currently connected to, just the act of connecting to it verifies that it's there and responding. The above is mostly about checking that an existing connection is still valid.
61
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
