-
Notifications
You must be signed in to change notification settings - Fork 41
/
AuroraMysqlDialect.java
68 lines (60 loc) · 2.45 KB
/
AuroraMysqlDialect.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
/*
* Copyright Amazon.com, Inc. or its affiliates. All Rights Reserved.
*
* Licensed under the Apache License, Version 2.0 (the "License").
* You may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package software.amazon.jdbc.dialect;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Collections;
import java.util.List;
import software.amazon.jdbc.hostlistprovider.AuroraHostListProvider;
public class AuroraMysqlDialect extends MysqlDialect {
private static final String TOPOLOGY_QUERY =
"SELECT SERVER_ID, CASE WHEN SESSION_ID = 'MASTER_SESSION_ID' THEN TRUE ELSE FALSE END, "
+ "CPU, REPLICA_LAG_IN_MILLISECONDS, LAST_UPDATE_TIMESTAMP "
+ "FROM information_schema.replica_host_status "
// filter out nodes that haven't been updated in the last 5 minutes
+ "WHERE time_to_sec(timediff(now(), LAST_UPDATE_TIMESTAMP)) <= 300 OR SESSION_ID = 'MASTER_SESSION_ID' ";
private static final String NODE_ID_QUERY = "SELECT @@aurora_server_id";
private static final String IS_READER_QUERY = "SELECT @@innodb_read_only";
@Override
public boolean isDialect(final Connection connection) {
try (final Statement stmt = connection.createStatement();
final ResultSet rs = stmt.executeQuery("SHOW VARIABLES LIKE 'aurora_version'")) {
if (rs.next()) {
// If variable with such name is presented then it means it's an Aurora cluster
return true;
}
} catch (final SQLException ex) {
// ignore
}
return false;
}
@Override
public List</* dialect code */ String> getDialectUpdateCandidates() {
return Collections.singletonList(DialectCodes.RDS_MULTI_AZ_MYSQL_CLUSTER);
}
@Override
public HostListProviderSupplier getHostListProvider() {
return (properties, initialUrl, hostListProviderService) -> new AuroraHostListProvider(
properties,
initialUrl,
hostListProviderService,
TOPOLOGY_QUERY,
NODE_ID_QUERY,
IS_READER_QUERY);
}
}