Detailed explanation of how to use amoeba to implement read-write separation of MySQL database

 `<property name="port">3306</property>　
       #Set the port of the mysql database that Amoeba wants to connect to. The default is 3306
  <property name="schema">testdb</property>　
      #Set the default database. When connecting to amoeba, the operation table must explicitly specify the database name, that is, use the dbname.tablename method. Use dbname to specify the default database is not supported because the operation will be dispatched to each backend dbserver
  <property name="user">test1</property>　
        #Set the account and password for amoeba to connect to the backend database server. Therefore, you need to create this user on all backend databases and authorize the amoeba server to connect <property name="password">111111</property>

  <property name="maxActive">500</property> #Maximum number of connections, default 500
  <property name="maxIdle">500</property> #Maximum number of idle connections<property name="minIdle">1</property> #Latest number of idle connections<dbServer name="writedb" parent="abstractServer"> #Set up a backend writable database, defined here as writedb. This name can be named arbitrarily and will be used later<property name="ipAddress">172.22.10.237</property> #Set the ip of the backend writable dbserver

  <dbServer name="slave01" parent="abstractServer"> #Set the backend readable database <property name="ipAddress">10.4.66.58</property>

   <dbServer name="myslave" virtual="true"> #Set up a virtual dbserver, which is actually equivalent to a dbserver group. Here, all readable database IPs are put into a group and the group name is named myslave
      <property name="loadbalance">1</property> #Select the scheduling algorithm. 1 means replication balance, 2 means weight, and 3 means HA. Select 1 here.
      <property name="poolNames">slave01</property> #myslave group member`

<property name="port">8066</property>　
       #Set the port that amoeba listens on, the default is 8066
    <property name="ipAddress">127.0.0.1</property> 
        #Configure the listening interface. If not set, all IP addresses will be listened by default.
        # Provide the account set here for the client to connect to amoeba (the account and password here have nothing to do with the password used by amoeba to connect to the backend database server)
      <property name="user">root</property>　
      <property name="password">123456</property>

    <property name="defaultPool">myslave</property>　
         #Set the default pool for amoeba, here set it to writedb
    <property name="writePool">master</property>　
         #These two options are deregistered by default and need to be uncommented. They are used here to specify the two read-write pools defined earlier <property name="readPool">slave01</property>

 #Start the script, you need to configure the jdk environment variables;
    # Add the following line after the comment:
    JAVA_HOME=/usr/local/java/jdk1.8.0_131

  #Memory usage profile# The -Xss parameter has a minimum value requirement, which must be greater than 228 to start the JVM
    #Revise:
      JVM_OPTIONS="-server -Xms1024m -Xmx1024m -Xss256k -XX:PermSize=16m -XX:MaxPermSize=96m"