This is an automated email from the ASF dual-hosted git repository.

zhangliang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git


The following commit(s) were added to refs/heads/master by this push:
     new 250ada69b8b Dynamic config use command instead of using cnf,conf file 
at IT (#19518)
250ada69b8b is described below

commit 250ada69b8bf5626d4ee482d3ebe52e869ac8b25
Author: Xinze Guo <[email protected]>
AuthorDate: Wed Jul 27 21:17:37 2022 +0800

    Dynamic config use command instead of using cnf,conf file at IT (#19518)
    
    * Use command instead of database cnf,conf file
    
    * Remove unused file
    
    * Remove useless command
    
    * Use command only for dynamic config
    
    * Change name
    
    * Upgrade codestyle
    
    * Add server-id, fix ci error
    
    * Config add max_connections
    
    * Improve PostgreSQLContainer use config correct file
---
 .../atomic/storage/StorageContainerFactory.java    |  9 ++--
 .../atomic/storage/impl/MySQLContainer.java        |  8 +++-
 .../atomic/storage/impl/OpenGaussContainer.java    | 14 +++++-
 .../atomic/storage/impl/PostgreSQLContainer.java   | 17 ++++++-
 .../env/container/atomic/util/CommandPartUtil.java | 53 ++++++++++++++++++++++
 .../env/runtime/DataSourceEnvironment.java         |  3 +-
 .../pipeline/env/IntegrationTestEnvironment.java   | 12 ++++-
 .../container/compose/DockerComposedContainer.java |  5 +-
 .../src/test/resources/env/mysql/my.cnf            |  3 ++
 .../test/resources/env/postgresql/postgresql.conf  |  1 +
 .../src/test/resources/env/mysql/my.cnf            |  3 ++
 .../test/resources/env/postgresql/postgresql.conf  |  1 +
 12 files changed, 115 insertions(+), 14 deletions(-)

diff --git 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/StorageContainerFactory.java
 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/StorageContainerFactory.java
index 14ee92e68a9..1a949ccd6c7 100644
--- 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/StorageContainerFactory.java
+++ 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/StorageContainerFactory.java
@@ -38,16 +38,17 @@ public final class StorageContainerFactory {
      * @param dockerImageName docker image name
      * @param scenario scenario
      * @param useRootUsername use root username
+     * @param commandParts command parts
      * @return created instance
      */
-    public static StorageContainer newInstance(final DatabaseType 
databaseType, final String dockerImageName, final String scenario, final 
boolean useRootUsername) {
+    public static StorageContainer newInstance(final DatabaseType 
databaseType, final String dockerImageName, final String scenario, final 
boolean useRootUsername, final String... commandParts) {
         switch (databaseType.getType()) {
             case "MySQL":
-                return new MySQLContainer(dockerImageName, scenario, 
useRootUsername);
+                return new MySQLContainer(dockerImageName, scenario, 
useRootUsername, commandParts);
             case "PostgreSQL":
-                return new PostgreSQLContainer(dockerImageName, scenario, 
useRootUsername);
+                return new PostgreSQLContainer(dockerImageName, scenario, 
useRootUsername, commandParts);
             case "openGauss":
-                return new OpenGaussContainer(dockerImageName, scenario, 
useRootUsername);
+                return new OpenGaussContainer(dockerImageName, scenario, 
useRootUsername, commandParts);
             case "H2":
                 return new H2Container(scenario);
             default:
diff --git 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/MySQLContainer.java
 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/MySQLContainer.java
index 66386399b33..ec52ecaab1d 100644
--- 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/MySQLContainer.java
+++ 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/MySQLContainer.java
@@ -29,13 +29,17 @@ import java.util.Optional;
  */
 public final class MySQLContainer extends DockerStorageContainer {
     
-    public MySQLContainer(final String dockerImageName, final String scenario, 
final boolean useRootUsername) {
+    private final String[] commandParts;
+    
+    public MySQLContainer(final String dockerImageName, final String scenario, 
final boolean useRootUsername, final String... commandParts) {
         super(DatabaseTypeFactory.getInstance("MySQL"), 
Strings.isNullOrEmpty(dockerImageName) ? "mysql/mysql-server:5.7" : 
dockerImageName, scenario, useRootUsername);
+        this.commandParts = commandParts;
     }
     
     @Override
     protected void configure() {
-        withCommand("--sql_mode=", 
"--default-authentication-plugin=mysql_native_password", 
"--lower_case_table_names=1");
+        // command config will override config at my.cnf.
+        setCommand(commandParts);
         addEnv("LANG", "C.UTF-8");
         addEnv("MYSQL_ROOT_PASSWORD", getUnifiedPassword());
         addEnv("MYSQL_ROOT_HOST", "%");
diff --git 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/OpenGaussContainer.java
 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/OpenGaussContainer.java
index 86631671296..a9edd1b01b7 100644
--- 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/OpenGaussContainer.java
+++ 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/OpenGaussContainer.java
@@ -22,6 +22,8 @@ import 
org.apache.shardingsphere.infra.database.type.DatabaseTypeFactory;
 import 
org.apache.shardingsphere.test.integration.env.container.atomic.storage.DockerStorageContainer;
 import org.testcontainers.containers.BindMode;
 
+import java.util.LinkedList;
+import java.util.List;
 import java.util.Optional;
 
 /**
@@ -29,13 +31,21 @@ import java.util.Optional;
  */
 public final class OpenGaussContainer extends DockerStorageContainer {
     
-    public OpenGaussContainer(final String dockerImageName, final String 
scenario, final boolean useRootUsername) {
+    private final String[] commandParts;
+    
+    public OpenGaussContainer(final String dockerImageName, final String 
scenario, final boolean useRootUsername, final String... commandParts) {
         super(DatabaseTypeFactory.getInstance("openGauss"), 
Strings.isNullOrEmpty(dockerImageName) ? "enmotech/opengauss:3.0.0" : 
dockerImageName, scenario, useRootUsername);
+        this.commandParts = commandParts;
     }
     
     @Override
     protected void configure() {
-        withCommand("--max_connections=600");
+        List<String> commandParts = new LinkedList<>();
+        for (String each : this.commandParts) {
+            commandParts.add("-c");
+            commandParts.add(each);
+        }
+        setCommand(commandParts.toArray(new String[0]));
         addEnv("GS_PASSWORD", getUnifiedPassword());
         withClasspathResourceMapping("/env/postgresql/postgresql.conf", 
"/usr/local/opengauss/share/postgresql/postgresql.conf.sample", 
BindMode.READ_ONLY);
         withClasspathResourceMapping("/env/opengauss/pg_hba.conf", 
"/usr/local/opengauss/share/postgresql/pg_hba.conf.sample", BindMode.READ_ONLY);
diff --git 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/PostgreSQLContainer.java
 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/PostgreSQLContainer.java
index d7bb1e0882c..25551d22d33 100644
--- 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/PostgreSQLContainer.java
+++ 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/PostgreSQLContainer.java
@@ -20,8 +20,11 @@ package 
org.apache.shardingsphere.test.integration.env.container.atomic.storage.
 import com.google.common.base.Strings;
 import org.apache.shardingsphere.infra.database.type.DatabaseTypeFactory;
 import 
org.apache.shardingsphere.test.integration.env.container.atomic.storage.DockerStorageContainer;
+import 
org.apache.shardingsphere.test.integration.env.container.atomic.util.CommandPartUtil;
 import org.testcontainers.containers.BindMode;
 
+import java.util.LinkedList;
+import java.util.List;
 import java.util.Optional;
 
 /**
@@ -29,13 +32,23 @@ import java.util.Optional;
  */
 public final class PostgreSQLContainer extends DockerStorageContainer {
     
-    public PostgreSQLContainer(final String dockerImageName, final String 
scenario, final boolean useRootUsername) {
+    private static final String[] DEFAULT_COMMAND_PARTS = new 
String[]{"config_file=/etc/postgresql/postgresql.conf"};
+    
+    private final String[] commandParts;
+    
+    public PostgreSQLContainer(final String dockerImageName, final String 
scenario, final boolean useRootUsername, final String... commandParts) {
         super(DatabaseTypeFactory.getInstance("PostgreSQL"), 
Strings.isNullOrEmpty(dockerImageName) ? "postgres:12-alpine" : 
dockerImageName, scenario, useRootUsername);
+        this.commandParts = commandParts;
     }
     
     @Override
     protected void configure() {
-        withCommand("--max_connections=600", "--wal_level=logical");
+        List<String> commandParts = new LinkedList<>();
+        for (String each : 
CommandPartUtil.mergeCommandParts(DEFAULT_COMMAND_PARTS, this.commandParts)) {
+            commandParts.add("-c");
+            commandParts.add(each);
+        }
+        setCommand(commandParts.toArray(new String[0]));
         addEnv("POSTGRES_USER", getRootUsername());
         addEnv("POSTGRES_PASSWORD", getUnifiedPassword());
         withClasspathResourceMapping("/env/postgresql/postgresql.conf", 
"/etc/postgresql/postgresql.conf", BindMode.READ_ONLY);
diff --git 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/util/CommandPartUtil.java
 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/util/CommandPartUtil.java
new file mode 100644
index 00000000000..665513b29d1
--- /dev/null
+++ 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/util/CommandPartUtil.java
@@ -0,0 +1,53 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You 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 org.apache.shardingsphere.test.integration.env.container.atomic.util;
+
+import java.util.LinkedHashMap;
+import java.util.Map;
+
+/**
+ * Command part util.
+ */
+public final class CommandPartUtil {
+    
+    /**
+     * Merge command parts.
+     *
+     * @param defaultCommandParts default command parts
+     * @param inputCommandParts input command parts, will override default 
command parts
+     * @return merged command parts
+     */
+    public static String[] mergeCommandParts(final String[] 
defaultCommandParts, final String[] inputCommandParts) {
+        if (null == defaultCommandParts || defaultCommandParts.length == 0) {
+            return inputCommandParts;
+        }
+        if (null == inputCommandParts || inputCommandParts.length == 0) {
+            return defaultCommandParts;
+        }
+        Map<String, String> defaultPartsMap = new LinkedHashMap<>();
+        for (String each : defaultCommandParts) {
+            String[] split = each.split("=");
+            defaultPartsMap.put(split[0], split[1]);
+        }
+        for (String each : inputCommandParts) {
+            String[] split = each.split("=");
+            defaultPartsMap.put(split[0], split[1]);
+        }
+        return defaultPartsMap.entrySet().stream().map(entry -> entry.getKey() 
+ "=" + entry.getValue()).toArray(String[]::new);
+    }
+}
diff --git 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/runtime/DataSourceEnvironment.java
 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/runtime/DataSourceEnvironment.java
index 19ad268f94c..7b45da302fb 100644
--- 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/runtime/DataSourceEnvironment.java
+++ 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/runtime/DataSourceEnvironment.java
@@ -90,7 +90,8 @@ public final class DataSourceEnvironment {
             case "H2":
                 return 
String.format("jdbc:h2:mem:%s;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MySQL;USER=root;PASSWORD=Root@123",
 dataSourceName);
             case "MySQL":
-                return 
String.format("jdbc:mysql://%s:%s/%s?useServerPrepStmts=true&serverTimezone=UTC&useSSL=false&useLocalSessionState=true&characterEncoding=utf-8",
 host, port, dataSourceName);
+                return 
String.format("jdbc:mysql://%s:%s/%s?useServerPrepStmts=true&serverTimezone=UTC&useSSL=false&useLocalSessionState=true&characterEncoding=utf-8&allowPublicKeyRetrieval=true",
+                        host, port, dataSourceName);
             case "PostgreSQL":
                 return String.format("jdbc:postgresql://%s:%s/%s", host, port, 
dataSourceName);
             case "SQLServer":
diff --git 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/env/IntegrationTestEnvironment.java
 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/env/IntegrationTestEnvironment.java
index f76bd59606b..6640b8fcc23 100644
--- 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/env/IntegrationTestEnvironment.java
+++ 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/env/IntegrationTestEnvironment.java
@@ -18,6 +18,7 @@
 package org.apache.shardingsphere.integration.data.pipeline.env;
 
 import lombok.Getter;
+import lombok.SneakyThrows;
 import lombok.extern.slf4j.Slf4j;
 import org.apache.commons.lang3.StringUtils;
 import org.apache.shardingsphere.infra.database.type.DatabaseType;
@@ -47,20 +48,27 @@ public final class IntegrationTestEnvironment {
     
     private final List<String> openGaussVersions;
     
+    private final String[] commandParts;
+    
     private IntegrationTestEnvironment() {
         props = loadProperties();
         itEnvType = 
ScalingITEnvTypeEnum.valueOf(StringUtils.defaultIfBlank(props.getProperty("scaling.it.env.type").toUpperCase(),
 ScalingITEnvTypeEnum.NONE.name()));
         mysqlVersions = 
Arrays.stream(props.getOrDefault("scaling.it.docker.mysql.version", 
"").toString().split(",")).filter(StringUtils::isNotBlank).collect(Collectors.toList());
         postgresVersions = 
Arrays.stream(props.getOrDefault("scaling.it.docker.postgresql.version", 
"").toString().split(",")).filter(StringUtils::isNotBlank).collect(Collectors.toList());
         openGaussVersions = 
Arrays.stream(props.getOrDefault("scaling.it.docker.opengauss.version", 
"").toString().split(",")).filter(StringUtils::isNotBlank).collect(Collectors.toList());
+        String commands = props.getOrDefault("scaling.it.database.command", 
"").toString();
+        if (StringUtils.isNotBlank(commands)) {
+            commandParts = commands.split(",");
+        } else {
+            commandParts = new String[0];
+        }
     }
     
+    @SneakyThrows(IOException.class)
     private Properties loadProperties() {
         Properties result = new Properties();
         try (InputStream inputStream = 
IntegrationTestEnvironment.class.getClassLoader().getResourceAsStream("env/it-env.properties"))
 {
             result.load(inputStream);
-        } catch (final IOException ex) {
-            throw new RuntimeException(ex);
         }
         for (String each : System.getProperties().stringPropertyNames()) {
             result.setProperty(each, System.getProperty(each));
diff --git 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/framework/container/compose/DockerComposedContainer.java
 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/framework/container/compose/DockerComposedContainer.java
index 0618151fe0d..a5d8b518453 100644
--- 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/framework/container/compose/DockerComposedContainer.java
+++ 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/framework/container/compose/DockerComposedContainer.java
@@ -19,6 +19,7 @@ package 
org.apache.shardingsphere.integration.data.pipeline.framework.container.
 
 import lombok.Getter;
 import org.apache.shardingsphere.infra.database.type.DatabaseType;
+import 
org.apache.shardingsphere.integration.data.pipeline.env.IntegrationTestEnvironment;
 import 
org.apache.shardingsphere.integration.data.pipeline.framework.container.proxy.ShardingSphereProxyDockerContainer;
 import 
org.apache.shardingsphere.test.integration.env.container.atomic.governance.GovernanceContainer;
 import 
org.apache.shardingsphere.test.integration.env.container.atomic.governance.impl.ZookeeperContainer;
@@ -31,6 +32,8 @@ import 
org.apache.shardingsphere.test.integration.env.runtime.DataSourceEnvironm
  */
 public final class DockerComposedContainer extends BaseComposedContainer {
     
+    private static final IntegrationTestEnvironment ENV = 
IntegrationTestEnvironment.getInstance();
+    
     private final DatabaseType databaseType;
     
     private final ShardingSphereProxyDockerContainer proxyContainer;
@@ -41,7 +44,7 @@ public final class DockerComposedContainer extends 
BaseComposedContainer {
     public DockerComposedContainer(final DatabaseType databaseType, final 
String dockerImageName) {
         this.databaseType = databaseType;
         GovernanceContainer governanceContainer = 
getContainers().registerContainer(new ZookeeperContainer());
-        storageContainer = 
getContainers().registerContainer((DockerStorageContainer) 
StorageContainerFactory.newInstance(databaseType, dockerImageName, "", false));
+        storageContainer = 
getContainers().registerContainer((DockerStorageContainer) 
StorageContainerFactory.newInstance(databaseType, dockerImageName, "", false, 
ENV.getCommandParts()));
         ShardingSphereProxyDockerContainer proxyContainer = new 
ShardingSphereProxyDockerContainer(databaseType);
         proxyContainer.dependsOn(governanceContainer, storageContainer);
         ShardingSphereProxyDockerContainer anotherProxyContainer = new 
ShardingSphereProxyDockerContainer(databaseType);
diff --git 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/mysql/my.cnf
 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/mysql/my.cnf
index 1a0e57d805e..552b13ae282 100644
--- 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/mysql/my.cnf
+++ 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/mysql/my.cnf
@@ -23,5 +23,8 @@ log-bin=mysql-bin
 binlog-format=row
 binlog-row-image=full
 max_connections=600
+default-authentication-plugin=mysql_native_password
+sql_mode=
+lower_case_table_names=1
 # for mysql 8.0
 secure_file_priv=/var/lib/mysql
diff --git 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/postgresql/postgresql.conf
 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/postgresql/postgresql.conf
index 15a4d3136dd..9d432a4cab4 100644
--- 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/postgresql/postgresql.conf
+++ 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/postgresql/postgresql.conf
@@ -17,6 +17,7 @@
 
 listen_addresses = '*'
 wal_level = logical
+max_connections = 600
 max_replication_slots = 10
 log_timezone = 'Asia/Shanghai'
 datestyle = 'iso, mdy'
diff --git 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/mysql/my.cnf
 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/mysql/my.cnf
index 1a0e57d805e..552b13ae282 100644
--- 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/mysql/my.cnf
+++ 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/mysql/my.cnf
@@ -23,5 +23,8 @@ log-bin=mysql-bin
 binlog-format=row
 binlog-row-image=full
 max_connections=600
+default-authentication-plugin=mysql_native_password
+sql_mode=
+lower_case_table_names=1
 # for mysql 8.0
 secure_file_priv=/var/lib/mysql
diff --git 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/postgresql/postgresql.conf
 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/postgresql/postgresql.conf
index 15a4d3136dd..9d432a4cab4 100644
--- 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/postgresql/postgresql.conf
+++ 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/postgresql/postgresql.conf
@@ -17,6 +17,7 @@
 
 listen_addresses = '*'
 wal_level = logical
+max_connections = 600
 max_replication_slots = 10
 log_timezone = 'Asia/Shanghai'
 datestyle = 'iso, mdy'

Reply via email to