Shulou(Shulou.com)06/01 Report--

There are the following technical requirements for the deployment of upper-layer applications using Wanli open source security database software GreatDB:

Category technology requires deployment applications to be deployed separately from the database. The server of the application is deployed separately from the server of the database, and do not carry out any reuse. The communication network between the application and the database is separated from the internal network of the database cluster. The network of the application connecting the database cluster is recommended to be separated from the network between the nodes within the database cluster, and the network of the application connected to the database cluster must be separated from the data backup network of the database cluster. to avoid the huge network traffic of database backup transmission affecting the business. Long or quasi-long links are required to connect database applications to databases. The application's link to the database needs to be a long link, or a quasi-long link, for example, every minute, or every 1000 transactions. The application needs to be able to automatically relink the database cluster. The application needs to be able to relink automatically after the communication link with the database is broken. In some failure scenarios, the link applied to the database cluster may be broken, and the application needs a link pool that can automatically relink or refresh the application. The library table design table must have a primary key. The business table should have a primary key. If you can't find the primary key, you can consider adding a self-incrementing column as the primary key. If there is no special case for the character set, the table character set uses UTF8/UTF8mb4, and the application side also uses UTF8/UTF8mb4. Naming prohibits the use of Chinese or special symbols as library or table names. SQL programming avoids big transactions the columns used by SQL important SQL must be indexed such as update, where conditional columns of delete, order by, group by, distinct fields, and multi-table join fields.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.