Tag：Database
-
Tencent cloud database tdsql ｜ in fact, we experience such college entrance examinations every day
On June 7, 2022, at 11:30 Beijing time, with the completion of the first subject language examination of the college entrance examination, the composition questions of the college entrance examination across the country were officially “unveiled” in front of the public. The title of this year’s national college entrance examination composition in volume B is“Across, […]
-
Talking about the evolution of technical architecture (microservices, load balancing, asynchronous, message queuing, data storage, high concurrency processing, caching mechanism)
1. Not all eggs can be put in one basket — evolution from single application to microservice application Imagine that there is an owner in your upstairs who is decorating, and the improper construction has led to the leakage of a bedroom in your home. What do you do at this time? Normal people call […]
-
When PostGIS encounters gaussdb, it can also be used like this!!!
Summary:PostGIS provides spatial database analysis capabilities for PostgreSQL. It is one of the mainstream geographic databases in the industry. It provides the following spatial information service functions: spatial objects, spatial indexes, spatial operation functions and spatial operators. In gaussdb, PostGIS geographic database expansion has been supported, and has been widely used in domestic and foreign […]
-
10million TPMC for 16 servers! Challenging distributed database performance limits
Recently, Apache shardingsphere community and opengauss community cooperated again,The distributed solution of Apache shardingsphere + opengauss has broken through the performance bottleneck of a single machine. In more than one hour of testing with 16 servers, it has obtained an average result of more than 10million TPMC. Shardingsphere + opengauss, reaching 10million TPMC In this […]
-
JSP to implement shopping program
The following is the source program of the shopping cart I made with JSP and database: be careful:1. The re billing part has not been completed yet. Let’s do it ourselves!2. The next version will use session. //shop_cart.jsp <%@ page contentType=”text/html;charset=gb2312″%><%@ page session=”true” %><%@ page language=”java” import=”java.sql.*” %><jsp:useBean id=”bka” scope=”page” class=”shop.bka” /><% String product_type;String action;int […]
-
Discussion on top paging method of MSSQL access database
However, it has both advantages and disadvantages. It requires that the sorting field must form a unique record, and fields with the same name as the sorting field are not allowed in the field list after the selection.Although sql2k5 and above versions have provided rownum() for paging processing, there are still many developers using sql2k […]
-
Distributed transaction error handling for two-phase commit
1、 BackgroundThe two-stage submission method of the author and the team in Kunlun distributed database can successfully avoid the defects of the classical two-stage submission algorithm. In terms of the two-stage submission mechanism and principle of distributed transaction processing, the author and the team have enhanced their disaster tolerance and error handling capabilities, so that […]
-
Why should redis be used for caching instead of mongodb
I don’t think it’s very interesting to share an interview question. But today, let’s analyze it a little. After all, some people will always ask why 1 plus 1 equals 2. First of all, let’s think about the characteristics that must be met since it is used for caching? Basic characteristics of cache The access […]
-
Implementation of MySQL dual master synchronization
#Implementation of MySQL dual master synchronization ##Environment description “Centos7.3 version“ “192.190.10.153 installing keepalived and MySQL“ “192.190.10.154 installing keepalived and MySQL“ ##Environment deployment ### 1. deploy “—————192.190.10.153 server operation record—————“ “`linux At my Add the following content to the [mysqld] configuration area of CNF file: [[email protected] ~]# vim /opt/Spinfo/mysql/my.cnf server-id = 1 / / the MySQL […]
-
The mongodb version of Alibaba cloud database helped gibbet’s “one mind carefree” game win tens of millions of players, and its operation efficiency has doubled
A fresh and lively journey to cultivate immortality: the mongodb version of Alibaba cloud database helped gibbet’s “one mind carefree” game win tens of millions of players, and its operation efficiency doubled China’s game market has large growth space and obvious diversified demand The global game market has shown a rapid growth trend in recent […]
-
Human high quality retrieval — how to retrieve correctly and efficiently
As the beginning of meta-analysis, literature retrieval is the most critical step in constructing the whole evidence-based analysis process. Whether we can formulate a perfect retrieval strategy and collect literature comprehensively and accurately directly affects the quality of data analysis. The so-called efficient retrieval refers to the kind of literature whose subject is the research […]
-
Oracle19c installation and deployment
Environmental preparation 1. software download Official website:https://www.oracle.com/cn/database/technologies/oracle-database-software-downloads.html#19c 2.OS For system versions supported by 19C: Oracle Linux 8.1 with the Unbreakable Enterprise Kernel 6: 5.4.17-2011.0.7.el8uek.x86_64 or later Oracle Linux 8 with the Red Hat Compatible kernel: 4.18.0-80.el8.x86_64 or later Oracle Linux 7.4 with the Unbreakable Enterprise Kernel 4: 4.1.12-124.19.2.el7uek.x86_64 or later Oracle Linux 7.4 with the […]