com.github.tomitakussaari.mysqlcluscon.galera.GaleraClusterConnectionChecker Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of myslcluscon-driver Show documentation

The newest version!

package com.github.tomitakussaari.mysqlcluscon.galera;

import com.github.tomitakussaari.mysqlcluscon.ConnectionChecker;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class GaleraClusterConnectionChecker implements ConnectionChecker{

    @Override
    public boolean connectionOk(final Connection conn) throws SQLException {
        if(! conn.isValid(1)) {
           return false;
        }
        try (Statement stmt = conn.createStatement()) {
            ResultSet rs = stmt.executeQuery("SHOW STATUS like 'wsrep_ready'");
            if(rs.next()) {
                return "ON".equalsIgnoreCase(rs.getString("Value"));
            }
        }
        return true;
    }
}