机器名称 IP 角色 权限
Mysql_Master1 172.16.94.5 数据库 Master 可读写、主库
Mysql_Slave1 172.16.94.6 数据库 Slave 只读、从库
Mysql_Slave2 172.16.94.10 数据库 Slave 只读、从库
Mysql_Master11 172.16.94.17 数据库 Master11 可读写、主库
Mysql_Slave11 172.16.94.18 数据库 Slave11 只读、从库
Mysql_Slave22 172.16.94.19 数据库 Slave22 只读、从库

MySQL 主从搭建 一主二从

主库配置/etc/my.cnf

  1. #bin_log 配置
  2. log_bin=mysql-bin
  3. server-id=1
  4. sync-binlog=1
  5. binlog-ignore-db=information_schema
  6. binlog-ignore-db=performance_schema
  7. binlog-ignore-db=sys
  8. #relay_log 配置
  9. relay_log=mysql-relay-bin
  10. log_slave_updates=1
  11. relay_log_purge=0

两台从库配置/etc/my.cnf

  1. #bin_log 配置
  2. log_bin=mysql-bin
  3. #服务器 ID,从库 2、3
  4. server-id=2
  5. sync-binlog=1
  6. binlog-ignore-db=information_schema
  7. binlog-ignore-db=mysql
  8. binlog-ignore-db=performance_schema
  9. #relay_log 配置
  10. relay_log=mysql-relay-bin
  11. log_slave_updates=1
  12. relay_log_purge=0
  13. read_only=1

三台分别重启服务

  1. systemctl restart mysqld

主库开启权限

  1. #进入mysql
  2. grant replication slave on *.* to 'root'@'%' identified by 'root';
  3. grant all privileges on *.* to 'root'@'%' identified by 'root';
  4. flush privileges;
  5. grant replication slave on *.* to 'mha'@'%' identified by '123123';
  6. grant all privileges on *.* to 'mha'@'%' identified by '123123';
  7. flush privileges;

两台从库建立主从关系

  1. #查看是否以前有配置信息，若有则去除掉
  2. show slave status;
  3. #stop slave;
  4. #reset slave all;
  5. #在主库查看binlog状态
  6. #show master status \G;
  7. #从库设置主库信息
  8. change master to master_host='172.16.94.5',master_port=3306,master_user='root',master_password='root',
  9. master_log_file='mysql-bin.000014',master_log_pos=154;
  10. #开启从库
  11. start slave;
  12. #再次查看从库配置信息
  13. show slave status \G;

分别复制主库和两个从库

虚拟机直接克隆

image.png

修改主库 2 配置/etc/my.cnf

  1. server-id=11

修改从库 11、22 配置/etc/my.cnf

  1. vim /etc/my.cnf
  2. server-id=12
  3. server-id=13

查找下 auto.cnf 文件的位置，全部修改

  1. find / -name "auto.cnf"
  2. vim /var/lib/mysql/auto.cnf
  3. [auto]
  4. server-uuid=356fc1ff-e339-11eb-bbea-000c29c18311

查看主库 22 的状态

  1. mysql> show master status \G;
  2. *************************** 1. row ***************************
  3.              File: mysql-bin.000015
  4.          Position: 154
  5.      Binlog_Do_DB: 
  6.  Binlog_Ignore_DB: information_schema,performance_schema,sys
  7. Executed_Gtid_Set: 
  8. 1 row in set (0.00 sec)

修改从库 22 和从库 33 的主库

  2. mysql> stop slave;
  3. Query OK, 0 rows affected (0.01 sec)
  5. mysql> reset slave all;
  6. Query OK, 0 rows affected (0.01 sec)
  8. mysql> change master to master_host='172.16.94.17',master_port=3306,master_user='root',master_password='root',
  9.     -> master_log_file='mysql-bin.000015',master_log_pos=154;
  10. Query OK, 0 rows affected, 2 warnings (0.01 sec)
  12. mysql> start slave;
  13. Query OK, 0 rows affected (0.01 sec)
  15. mysql> show slave status \G;
  16. *************************** 1. row ***************************
  17.                Slave_IO_State: Waiting for master to send event
  18.                   Master_Host: 172.16.94.17
  19.                   Master_User: root
  20.                   Master_Port: 3306
  21.                 Connect_Retry: 60
  22.               Master_Log_File: mysql-bin.000015
  23.           Read_Master_Log_Pos: 154
  24.                Relay_Log_File: mysql-relay2-bin.000002
  25.                 Relay_Log_Pos: 320
  26.         Relay_Master_Log_File: mysql-bin.000015
  27.              Slave_IO_Running: Yes
  28.             Slave_SQL_Running: Yes
  29. 1 row in set (0.00 sec)

重启下这三台服务

  1. systemctl restart mysqld

初始化数据

主库分别创建 lane3、lane5 和 c_order 表

  1. ➜  ~ mysql -uroot -proot
  2. mysql> create database lane5;
  3. Query OK, 1 row affected (0.00 sec)
  4. mysql> use lane5;
  5. Database changed
  6. mysql> CREATE TABLE `c_order` (
  7.     -> `id` BIGINT ( 20 ) NOT NULL AUTO_INCREMENT,
  8.     -> `is_del` bit ( 1 ) NOT NULL DEFAULT 0 COMMENT '是否被删除',
  9.     -> `user_id` INT ( 11 ) NOT NULL COMMENT '⽤户id',
  10.     -> `company_id` INT ( 11 ) NOT NULL COMMENT '公司id',
  11.     -> `publish_user_id` INT ( 11 ) NOT NULL COMMENT 'B端⽤户id',
  12.     -> `position_id` INT ( 11 ) NOT NULL COMMENT '职位ID',
  13.     -> `resume_type` INT ( 2 ) NOT NULL DEFAULT 0 COMMENT '简历类型：0附件 1在线',
  14.     -> `status` VARCHAR ( 256 ) NOT NULL COMMENT '投递状态 投递状态 WAIT-待处理 AUTO_FILTER-⾃动过滤 PREPARE_CONTACT-待沟通 REFUSE-拒绝 ARRANGE_INTERVIEW-通知⾯试',
  15.     -> `create_time` datetime NOT NULL COMMENT '创建时间',
  16.     -> `update_time` datetime NOT NULL COMMENT '处理时间',
  17.     -> PRIMARY KEY ( `id` ),
  18.     -> KEY `index_userId_positionId` ( `user_id`, `position_id` ),
  19.     -> KEY `idx_userId_operateTime` ( `user_id`, `update_time` ) 
  20.     -> ) ENGINE = INNODB DEFAULT CHARSET = utf8mb4;
  21. Query OK, 0 rows affected (0.01 sec)
  23. mysql>

查看第二组从库是否 有 lane5 和 c_order 表

  1. ➜  ~ mysql -uroot -proot
  2. mysql> show databases;
  3. +--------------------+
  4. | Database           |
  5. +--------------------+
  6. | information_schema |
  7. | lane1              |
  8. | lane2              |
  9. | lane5              |
  10. | lanebin            |
  11. | mysql              |
  12. | performance_schema |
  13. | sys                |
  14. +--------------------+
  15. 8 rows in set (0.01 sec)
  17. mysql> use lane5
  18. mysql> show tables;
  19. +-----------------+
  20. | Tables_in_lane5 |
  21. +-----------------+
  22. | c_order         |
  23. +-----------------+
  24. 1 row in set (0.00 sec)
  26. mysql>

查看第一组从库是否 有 lane3 和 c_order 表

  2. mysql> use lane3
  3. Reading table information for completion of table and column names
  4. You can turn off this feature to get a quicker startup with -A
  6. Database changed
  7. mysql> show tables;
  8. +-----------------+
  9. | Tables_in_lane3 |
  10. +-----------------+
  11. | c_order         |
  12. +-----------------+
  13. 1 row in set (0.00 sec)
  15. mysql>

开始创建项目

创建 maven 项目 mysql-work

添加依赖

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0"
  3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  5.     <modelVersion>4.0.0</modelVersion>
  7.     <groupId>com.galaxy</groupId>
  8.     <artifactId>mysql-work</artifactId>
  9.     <version>1.0-SNAPSHOT</version>
  10.     <parent>
  11.         <groupId>org.springframework.boot</groupId>
  12.         <artifactId>spring-boot-starter-parent</artifactId>
  13.         <version>2.2.9.RELEASE</version>
  14.         <relativePath/> <!-- lookup parent from repository -->
  15.     </parent>
  16.     <description>Demo project for Spring Boot</description>
  17.     <properties>
  18.         <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  19.         <project.compile.sourceEncoding>UTF-8</project.compile.sourceEncoding>
  20.         <shardingsphere.version>4.1.0</shardingsphere.version>
  21.         <springboot.version>2.2.9.RELEASE</springboot.version>
  23.     </properties>
  25.         <dependencies>
  26.             <dependency>
  27.                 <groupId>org.springframework.boot</groupId>
  28.                 <artifactId>spring-boot-starter-jdbc</artifactId>
  29.                 <version>${springboot.version}</version>
  30.             </dependency>
  31.             <dependency>
  32.                 <groupId>org.springframework.boot</groupId>
  33.                 <artifactId>spring-boot-starter-data-jpa</artifactId>
  34.                 <version>${springboot.version}</version>
  35.             </dependency>
  36.             <dependency>
  37.                 <groupId>org.springframework.boot</groupId>
  38.                 <artifactId>spring-boot-starter-data-jpa</artifactId>
  39.                 <version>2.1.6.RELEASE</version>
  40.             </dependency>
  41.             <dependency>
  42.                 <groupId>org.springframework.boot</groupId>
  43.                 <artifactId>spring-boot-starter-test</artifactId>
  44.                 <version>${springboot.version}</version>
  45.                 <scope>test</scope>
  46.             </dependency>
  47.             <dependency>
  48.                 <groupId>mysql</groupId>
  49.                 <artifactId>mysql-connector-java</artifactId>
  50.                 <version>5.1.48</version>
  51.             </dependency>
  53.             <dependency>
  54.                 <groupId>org.apache.shardingsphere</groupId>
  55.                 <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
  56.                 <version>${shardingsphere.version}</version>
  57.             </dependency>
  58.             <dependency>
  59.                 <groupId>org.apache.shardingsphere</groupId>
  60.                 <artifactId>sharding-transaction-xa-core</artifactId>
  61.                 <version>${shardingsphere.version}</version>
  62.             </dependency>
  64.         </dependencies>
  66.     <build>
  67.         <plugins>
  68.             <plugin>
  69.                 <groupId>org.apache.maven.plugins</groupId>
  70.                 <artifactId>maven-compiler-plugin</artifactId>
  71.                 <version>3.8.1</version>
  72.                 <configuration>
  73.                     <source>11</source>
  74.                     <target>11</target>
  75.                     <testSource>11</testSource>
  76.                     <testTarget>11</testTarget>
  77.                 </configuration>
  78.             </plugin>
  79.         </plugins>
  80.     </build>
  82. </project>

entity

  1. package com.galaxy.entity;
  4. import javax.persistence.*;
  5. import java.util.Date;
  6. /**
  7.  * @author lane
  8.  * @date 2021年07月27日 下午7:12
  9.  */
  11. @Entity
  12. @Table(name = "c_order")
  13. public class Order {
  14.     @Id
  15.     @GeneratedValue(strategy = GenerationType.IDENTITY)
  16.     private Long id;
  18.     @Column(name = "is_del")
  19.     private Boolean del;
  21.     @Column(name = "user_id")
  22.     private Integer userId;
  24.     @Column(name = "company_id")
  25.     private Integer companyId;
  27.     @Column(name = "publish_user_id")
  28.     private Integer publishUserId;
  30.     @Column(name = "position_id")
  31.     private Integer positionId;
  33.     @Column(name = "resume_type")
  34.     private Integer resumeType;
  36.     @Column(name = "status")
  37.     private String status;
  39.     @Column(name = "create_time")
  40.     private Date createTime;
  42.     @Column(name = "update_time")
  43.     private Date updateTime;
  45.     public Long getId() {
  46.         return id;
  47.     }
  49.     public void setId(Long id) {
  50.         this.id = id;
  51.     }
  53.     public Boolean getDel() {
  54.         return del;
  55.     }
  57.     public void setDel(Boolean del) {
  58.         this.del = del;
  59.     }
  61.     public Integer getUserId() {
  62.         return userId;
  63.     }
  65.     public void setUserId(Integer userId) {
  66.         this.userId = userId;
  67.     }
  69.     public Integer getCompanyId() {
  70.         return companyId;
  71.     }
  73.     public void setCompanyId(Integer companyId) {
  74.         this.companyId = companyId;
  75.     }
  77.     public Integer getPublishUserId() {
  78.         return publishUserId;
  79.     }
  81.     public void setPublishUserId(Integer publishUserId) {
  82.         this.publishUserId = publishUserId;
  83.     }
  85.     public Integer getPositionId() {
  86.         return positionId;
  87.     }
  89.     public void setPositionId(Integer positionId) {
  90.         this.positionId = positionId;
  91.     }
  93.     public Integer getResumeType() {
  94.         return resumeType;
  95.     }
  97.     public void setResumeType(Integer resumeType) {
  98.         this.resumeType = resumeType;
  99.     }
  101.     public String getStatus() {
  102.         return status;
  103.     }
  105.     public void setStatus(String status) {
  106.         this.status = status;
  107.     }
  109.     public Date getCreateTime() {
  110.         return createTime;
  111.     }
  113.     public void setCreateTime(Date createTime) {
  114.         this.createTime = createTime;
  115.     }
  117.     public Date getUpdateTime() {
  118.         return updateTime;
  119.     }
  121.     public void setUpdateTime(Date updateTime) {
  122.         this.updateTime = updateTime;
  123.     }
  125.     @Override
  126.     public String toString() {
  127.         return "Order{" +
  128.                 "id=" + id +
  129.                 ", del=" + del +
  130.                 ", userId=" + userId +
  131.                 ", companyId=" + companyId +
  132.                 ", publishUserId=" + publishUserId +
  133.                 ", positionId=" + positionId +
  134.                 ", resumeType=" + resumeType +
  135.                 ", status='" + status + '\'' +
  136.                 ", createTime=" + createTime +
  137.                 ", updateTime=" + updateTime +
  138.                 '}';
  139.     }
  140. }

repository

  1. package com.galaxy.repository;
  3. import com.galaxy.entity.Order;
  4. import org.springframework.data.jpa.repository.JpaRepository;
  6. /**
  7.  * @author lane
  8.  * @date 2021年07月27日 下午7:14
  9.  */
  10. public interface OrderRepository extends JpaRepository<Order,Long> {
  11. }

application.properties

  1. spring.shardingsphere.datasource.names=master-0,slave-1,slave-2,master-1,slave-3,slave-4
  2. spring.shardingsphere.props.sql.show=true
  4. spring.shardingsphere.datasource.master-0.type=com.zaxxer.hikari.HikariDataSource
  5. spring.shardingsphere.datasource.master-0.driver-class-name=com.mysql.jdbc.Driver
  6. spring.shardingsphere.datasource.master-0.jdbc-url=jdbc:mysql://172.16.94.5:3306/lane3?useUnicode=true&useSSL=false
  7. spring.shardingsphere.datasource.master-0.username=root
  8. spring.shardingsphere.datasource.master-0.password=root
  10. spring.shardingsphere.datasource.slave-1.type=com.zaxxer.hikari.HikariDataSource
  11. spring.shardingsphere.datasource.slave-1.driver-class-name=com.mysql.jdbc.Driver
  12. spring.shardingsphere.datasource.slave-1.jdbc-url=jdbc:mysql://172.16.94.6:3306/lane3?useUnicode=true&useSSL=false
  13. spring.shardingsphere.datasource.slave-1.username=root
  14. spring.shardingsphere.datasource.slave-1.password=root
  16. spring.shardingsphere.datasource.slave-2.type=com.zaxxer.hikari.HikariDataSource
  17. spring.shardingsphere.datasource.slave-2.driver-class-name=com.mysql.jdbc.Driver
  18. spring.shardingsphere.datasource.slave-2.jdbc-url=jdbc:mysql://172.16.94.10:3306/lane3?useUnicode=true&useSSL=false
  19. spring.shardingsphere.datasource.slave-2.username=root
  20. spring.shardingsphere.datasource.slave-2.password=root
  22. spring.shardingsphere.datasource.master-1.type=com.zaxxer.hikari.HikariDataSource
  23. spring.shardingsphere.datasource.master-1.driver-class-name=com.mysql.jdbc.Driver
  24. spring.shardingsphere.datasource.master-1.jdbc-url=jdbc:mysql://172.16.94.17:3306/lane5?useUnicode=true&useSSL=false
  25. spring.shardingsphere.datasource.master-1.username=root
  26. spring.shardingsphere.datasource.master-1.password=root
  28. spring.shardingsphere.datasource.slave-3.type=com.zaxxer.hikari.HikariDataSource
  29. spring.shardingsphere.datasource.slave-3.driver-class-name=com.mysql.jdbc.Driver
  30. spring.shardingsphere.datasource.slave-3.jdbc-url=jdbc:mysql://172.16.94.18:3306/lane5?useUnicode=true&useSSL=false
  31. spring.shardingsphere.datasource.slave-3.username=root
  32. spring.shardingsphere.datasource.slave-3.password=root
  34. spring.shardingsphere.datasource.slave-4.type=com.zaxxer.hikari.HikariDataSource
  35. spring.shardingsphere.datasource.slave-4.driver-class-name=com.mysql.jdbc.Driver
  36. spring.shardingsphere.datasource.slave-4.jdbc-url=jdbc:mysql://172.16.94.19:3306/lane5?useUnicode=true&useSSL=false
  37. spring.shardingsphere.datasource.slave-4.username=root
  38. spring.shardingsphere.datasource.slave-4.password=root
  40. spring.shardingsphere.sharding.tables.c_order.database-strategy.inline.sharding-column=user_id
  41. spring.shardingsphere.sharding.tables.c_order.database-strategy.inline.algorithm-expression=master-$->{user_id % 2}
  42. spring.shardingsphere.sharding.tables.c_order.actual-data-nodes=master-$->{0..1}.c_order
  44. spring.shardingsphere.sharding.tables.c_order.key-generator.column=id
  45. spring.shardingsphere.sharding.tables.c_order.key-generator.type=SNOWFLAKE
  47. spring.shardingsphere.sharding.master-slave-rules.master-0.master-data-source-name=master-0
  48. spring.shardingsphere.sharding.master-slave-rules.master-0.slave-data-source-names=slave-1,slave-2
  49. #spring.shardingsphere.masterslave.load-balance-algorithm-type=ROUND_ROBIN
  50. spring.shardingsphere.sharding.master-slave-rules.master-1.master-data-source-name=master-1
  51. spring.shardingsphere.sharding.master-slave-rules.master-1.slave-data-source-names=slave-3,slave-4

test

  2. /**
  3.  * @author lane
  4.  * @date 2021年07月27日 下午7:16
  5.  */
  6. @RunWith(SpringRunner.class)
  7. @SpringBootTest(classes = ShardingBootRunApplication.class)
  8. public class ShardingTest {
  10.     @Autowired
  11.     private OrderRepository orderRepository;
  13.     @org.junit.Test
  14.     public void test(){
  15.         for (int idx = 0; idx < 4; ++idx) {
  16.             Order order = new Order();
  17.             order.setCompanyId(1);
  19.             order.setCreateTime(new Date());
  20.             order.setDel(false);
  21.             order.setPositionId(1);
  23.             order.setStatus("WAITING");
  24.             order.setPublishUserId(1);
  25.             order.setResumeType(1);
  27.             order.setUpdateTime(new Date());
  28.             order.setUserId(idx);
  30.             orderRepository.save(order);
  31.         }
  34.     }
  36.     @Test
  37.     public void testSlave(){
  38.         List<Order> all = orderRepository.findAll();
  40.         System.out.println(all);
  41.     }
  42. }

测试分库分表和主从同步结果

通过 Master1 和 Master11 的查询结果可以看出分库成功

通过 Slave1 和 Slave11 可以看到主从同步 OK

master1

  1. mysql> select * from c_order \G;
  2. *************************** 1. row ***************************
  3.              id: 626865956605394944
  4.          is_del:  
  5.         user_id: 0
  6.      company_id: 1
  7. publish_user_id: 1
  8.     position_id: 1
  9.     resume_type: 1
  10.          status: WAITING
  11.     create_time: 2021-07-27 19:41:30
  12.     update_time: 2021-07-27 19:41:30
  13. *************************** 2. row ***************************
  14.              id: 626865957251317760
  15.          is_del:  
  16.         user_id: 2
  17.      company_id: 1
  18. publish_user_id: 1
  19.     position_id: 1
  20.     resume_type: 1
  21.          status: WAITING
  22.     create_time: 2021-07-27 19:41:31
  23.     update_time: 2021-07-27 19:41:31
  24. 2 rows in set (0.00 sec)

slave1

  2. mysql> use lane3
  3. mysql> select * from c_order \G；
  4. *************************** 1. row ***************************
  5.              id: 626865956605394944
  6.          is_del:  
  7.         user_id: 0
  8.      company_id: 1
  9. publish_user_id: 1
  10.     position_id: 1
  11.     resume_type: 1
  12.          status: WAITING
  13.     create_time: 2021-07-27 19:41:30
  14.     update_time: 2021-07-27 19:41:30
  15. *************************** 2. row ***************************
  16.              id: 626865957251317760
  17.          is_del:  
  18.         user_id: 2
  19.      company_id: 1
  20. publish_user_id: 1
  21.     position_id: 1
  22.     resume_type: 1
  23.          status: WAITING
  24.     create_time: 2021-07-27 19:41:31
  25.     update_time: 2021-07-27 19:41:31
  26. 2 rows in set (0.00 sec)

master11

  1. mysql> select * from c_order \G;
  2. *************************** 1. row ***************************
  3.              id: 626865957129682945
  4.          is_del:  
  5.         user_id: 1
  6.      company_id: 1
  7. publish_user_id: 1
  8.     position_id: 1
  9.     resume_type: 1
  10.          status: WAITING
  11.     create_time: 2021-07-27 19:41:31
  12.     update_time: 2021-07-27 19:41:31
  13. *************************** 2. row ***************************
  14.              id: 626865957284872193
  15.          is_del:  
  16.         user_id: 3
  17.      company_id: 1
  18. publish_user_id: 1
  19.     position_id: 1
  20.     resume_type: 1
  21.          status: WAITING
  22.     create_time: 2021-07-27 19:41:31
  23.     update_time: 2021-07-27 19:41:31
  24. 2 rows in set (0.00 sec)

slave11

  2. mysql> use lane5;
  3. mysql> select * from c_order\G;
  4. *************************** 1. row ***************************
  5.              id: 626865957129682945
  6.          is_del:  
  7.         user_id: 1
  8.      company_id: 1
  9. publish_user_id: 1
  10.     position_id: 1
  11.     resume_type: 1
  12.          status: WAITING
  13.     create_time: 2021-07-27 19:41:31
  14.     update_time: 2021-07-27 19:41:31
  15. *************************** 2. row ***************************
  16.              id: 626865957284872193
  17.          is_del:  
  18.         user_id: 3
  19.      company_id: 1
  20. publish_user_id: 1
  21.     position_id: 1
  22.     resume_type: 1
  23.          status: WAITING
  24.     create_time: 2021-07-27 19:41:31
  25.     update_time: 2021-07-27 19:41:31
  26. 2 rows in set (0.00 sec)

测试读写分离结果

分别修改下 slave1 和 slave11 中 c_order 表的数据

  1. #slave1
  2. update c_order set status ='slave1';
  3. #slave11
  4. update c_order set status ='slave11';

查看读取的数据，可以看到读取到的是从库中 c_order 的数据，成功实现读写分离

  1. [Order{id=626865956605394944, del=false, userId=0, companyId=1, publishUserId=1, positionId=1, resumeType=1, status='slave1', 
  2. createTime=2021-07-27 19:41:30.0, updateTime=2021-07-27 19:41:30.0}, 
  3. Order{id=626865957251317760, del=false, userId=2, companyId=1, publishUserId=1, positionId=1, resumeType=1, status='slave1',
  4.  createTime=2021-07-27 19:41:31.0, updateTime=2021-07-27 19:41:31.0}, 
  5. Order{id=626865957129682945, del=false, userId=1, companyId=1, publishUserId=1, positionId=1, resumeType=1, status='slave11', 
  6. createTime=2021-07-27 19:41:31.0, updateTime=2021-07-27 19:41:31.0}, 
  7. Order{id=626865957284872193, del=false, userId=3, companyId=1, publishUserId=1, positionId=1, resumeType=1, status='slave11', 
  8. createTime=2021-07-27 19:41:31.0, updateTime=2021-07-27 19:41:31.0}]
  9. 2