Programming VIP

There are some general optimization steps for the optimization of SQL query statements. This section introduces the general optimization steps. How is a query executed First, if we want to understand the process of a query statement, then we can optimize the process. Refer to a MySQL infrastructure diagram I drew earlier: The life cycle of a q ...

MySQL Master-Slave Architecture 11.1 mysql replication In production environments, if data is read and written in the same database. It is completely impossible to meet the actual needs in terms of security, high availability, or high concurrency. Therefore, data synchronization is usually done by master-slave replication to ensure data secur ...

Code Address Sharding_ Sphere_ Demo: Getting started with shardingJDBC Introduction to ShardingSphere ShardingSphere is an application framework that originated within Dangdang. Born in Dandang in 2015, it was originally called ShardingJDBC. In 2016, Zhang Liang, one of the main developers, brought to Jingdong Department of Mathematics, and ...

Article catalogue I Create a spring project using IDEA II Establish project structure III Create database IV Import pom dependencies V Writing pojo entity classes Vi Write dao layer VII Write service layer VIII Write controller layer IX Write usermapper XML Mapping File X Write yml configuration information Xi Write front page XII ...

day27 SQL enhancement and Practice Course objective: to practice the design of common SQL statements and table structures. Course overview: SQL hardeningTable structure design (blog system) 1. SQL enhancement Create database & table structure and input data according to the above figure (you can create data by yourself) create dat ...

Detailed explanation of Mysql index What is an index? 1. Index An index is the directory of a table. You can find the index position in the directory before finding the content, so as to quickly locate the query data. For indexes, they are saved in additional files. **2. * * index is a data structure specially used to help users query data ...

1, Introduction to Tidb 1. What is TiDB TiDB is an open-source distributed relational database independently designed and developed by PingCAP company. It is an integrated distributed database product that supports both online transaction processing and online analytical processing (HTAP). It has horizontal expansion or reduction, financi ...

There are two ways to realize read-write separation and data segmentation Method 1: middle tier agent (mycat) System application ----- > intermediate agent ----- > Database Method 2: the client mode (sharding JDBC) only needs to introduce the jar package of the client Difference: mycat is the server agent and sharding JDBC is the c ...

day28 Today's content Basic concepts of JDBCquick get startA detailed explanation of interfaces and classes in JDBC JDBC Concept: Java Database Connectivity (JDBC) is an application program interface in the Java language used to standardize how client programs access the database, and provides methods such as querying and updating data in t ...

prefaceFor mysql8 0.28 installation tutorial I even spent a day in the official MySQL documentation. So far, I'm dedicated to trying to get started with MySQL 8 0 beginners. With the latest version of MySQL 8 0.28 is an example for detailed explanation of installation and preliminary use, and a detailed tutorial for beginners. Whether it is ins ...