TiDB and Golang · · · · · · · · · · · · · · · · · 145 4.3.2 Build a TiDB Application Using Spring Boot · · · · · · · · · · · · · · · · · · · · · · 163 4.3.3 Build a Simple CRUD App with TiDB and Java go-sql-driver/mysql Expected Output 4.3.2 Build a TiDB Application Using Spring Boot This tutorial shows you how to build a Spring Boot web application using TiDB. The Spring Data JPA module is used as the framework from GitHub. This is a sample application for building a RESTful API, which shows a generic Spring Boot backend service using TiDB as the database. The following process was designed to recreate a real-world

· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 106 4.3.2 使用 Spring Boot 构建 TiDB 应用程序 · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 122 Spring Boot 构建 TiDB 应用程序 本教程向你展示如何使用 TiDB 构建 Spring Boot Web 应用程序。使用 Spring Data JPA 模块作为数据访问能力的框 架。此示例应用程序的代码仓库可在 Github 下载。 这是一个较为完整的构建 Restful API 的示例应用程序，展示了一个使用 TiDB 作为数据库的通用 Spring Boot 后端 服务。设计了以下过程，用于还原一个现实场景： goods。且每个玩家都拥有一个字 段 id，作为玩家的唯一标识。玩家在金币数和货物数充足的情况下，可以自由的交易。 你可以以此示例为基础，构建自己的应用程序。 建议： 在云原生开发环境中尝试 Spring Boot 构建 TiDB 应用程序。预配置完成的环境，自动启动 TiDB 集群，获取和运行代码，只需要一个链接。 现在就试试 4.3.2.1 第 1 步：启动你的 TiDB 集群 本节将介绍 TiDB

200 万商家用户。 业务挑战 PayPay 采用亚马逊 AWS 作为 IT 基础架构, 并在此基础之上搭建了微服务应用架构。业务应用架构由大约 80 个组件构成, 使用 Java、 Spring Boot 等基础技术及Amazon Aurora 作为核心数据库,所有的支付交易 都传输到 Payment 组件进行管理。 随着业务迅速增长, 当 Aurora 数据库遇到许多写入请求时, Binlog

4 Connect to TiDB with Spring Boot TiDB is a MySQL-compatible database, and Spring is a popular open-source container framework for Java. This document uses Spring Boot as the way to use Spring. In this their official documentation: • The documentation of Spring Framework • The documentation of Spring Boot • The documentation of Spring Data JPA • The documentation of Hibernate • Learn the best practices Spring Data JPA or Hibernate to build a TiDB application by Spring, see Build a TiDB app using Spring Boot. In addition, you need to specify the TiDB dialect in your Hibernate configuration file: org.hibernate

lsblk -f NAME FSTYPE LABEL UUID MOUNTPOINT sda ￿─ sda1 ext4 237b634b-a565-477b-8371-6dff0c41f5ab /boot ￿─ sda2 swap f414c5c0-f823-4bb1-8fdf-e531173a72ed ￿─ sda3 ext4 547909c1-398d-4696-94c6-03e43e317b60 --default-kernel /boot/vmlinuz-3.10.0-957.el7.x86_64 2. Execute grubby --update-kernel to modify the kernel configuration: grubby --args="transparent_hugepage=never" --update-kernel / �→ boot/vmlinuz-3.10 default kernel configuration: grubby --info /boot/vmlinuz-3.10.0-957.el7.x86_64 Note: --info is followed by the actual default kernel version. index=0 kernel=/boot/vmlinuz-3.10.0-957.el7.x86_64 args="ro crashkernel=auto

4 Connect to TiDB with Spring Boot TiDB is a MySQL-compatible database, and Spring is a popular open-source container framework for Java. This document uses Spring Boot as the way to use Spring. In this their official documentation: • The documentation of Spring Framework • The documentation of Spring Boot • The documentation of Spring Data JPA • The documentation of Hibernate • Learn the best practices Spring Data JPA or Hibernate to build a TiDB application by Spring, see Build a TiDB app using Spring Boot. In addition, you need to specify the TiDB dialect in your Hibernate configuration file: org.hibernate

4 Connect to TiDB with Spring Boot TiDB is a MySQL-compatible database, and Spring is a popular open-source container framework for Java. This document uses Spring Boot as the way to use Spring. In this their official documentation: • The documentation of Spring Framework • The documentation of Spring Boot • The documentation of Spring Data JPA • The documentation of Hibernate • Learn the best practices Spring Data JPA or Hibernate to build a TiDB application by Spring, see Build a TiDB app using Spring Boot. In addition, you need to specify the TiDB dialect in your Hibernate configuration file: org.hibernate

4 Connect to TiDB with Spring Boot TiDB is a MySQL-compatible database, and Spring is a popular open-source container framework for Java. This document uses Spring Boot as the way to use Spring. In this their official documentation: • The documentation of Spring Framework • The documentation of Spring Boot • The documentation of Spring Data JPA • The documentation of Hibernate • Learn the best practices Spring Data JPA or Hibernate to build a TiDB application by Spring, see Build a TiDB app using Spring Boot. In addition, you need to specify the TiDB dialect in your Hibernate configuration file: org.hibernate

lsblk -f NAME FSTYPE LABEL UUID MOUNTPOINT sda ￿─ sda1 ext4 237b634b-a565-477b-8371-6dff0c41f5ab /boot ￿─ sda2 swap f414c5c0-f823-4bb1-8fdf-e531173a72ed ￿─ sda3 ext4 547909c1-398d-4696-94c6-03e43e317b60 --default-kernel /boot/vmlinuz-3.10.0-957.el7.x86_64 2. Execute grubby --update-kernel to modify the kernel configuration: grubby --args="transparent_hugepage=never" --update-kernel / �→ boot/vmlinuz-3.10 default kernel configuration: grubby --info /boot/vmlinuz-3.10.0-957.el7.x86_64 Note: --info is followed by the actual default kernel version. index=0 kernel=/boot/vmlinuz-3.10.0-957.el7.x86_64 args="ro crashkernel=auto

4 Connect to TiDB with Spring Boot TiDB is a MySQL-compatible database, and Spring is a popular open-source container framework for Java. This document uses Spring Boot as the way to use Spring. In this their official documentation: • The documentation of Spring Framework • The documentation of Spring Boot • The documentation of Spring Data JPA • The documentation of Hibernate • Learn the best practices Spring Data JPA or Hibernate to build a TiDB application by Spring, see Build a TiDB app using Spring Boot. In addition, you need to specify the TiDB dialect in your Hibernate configuration file: org.hibernate