MySQL installation and setting up WINDOWS service
Set up Windows services for MySQL
MySQL creates and authorizes users
The notes are based on the teaching course "baldness saves the earth" in station B. Course link: 7-day MySQL devil training camp (beginner to expert)_ Beep beep b ...
Posted by brotherhewd on Tue, 01 Mar 2022 02:43:21 +0100
Barman is an open-source excellent PG database backup tool based on Python, which integrates backup and recovery. It can make remote / local backup for single / multiple PG databases to enhance the security of business data and provide reliable help for DBA s to recover databases.
It supports the backup of multiple versions ...
Posted by snakebit on Mon, 28 Feb 2022 15:40:54 +0100
In the face of more and more high concurrency scenarios, the display of current limit is particularly important.
Of course, there are many ways to implement current limiting. Redis has very powerful functions. I have practiced three ways with redis, which can be implemented in a relatively simple way. Redis can not only limit current, but also ...
Posted by weiwei on Mon, 28 Feb 2022 11:18:28 +0100
The data of the Web application will be stored on the cloud side, and the data will not be cached locally. During data management, you will directly operate cloud side data. The Web SDK will guarantee the communication and communication security between your application and cloud database.
This sample application demonstrates how to ...
Posted by Yueee on Mon, 28 Feb 2022 03:29:50 +0100
1. in and exists
In is a hash connection between the outer table and the inner table, while exists is a loop loop loop for the outer table. Each loop loop loop queries the inner table. It has always been inaccurate to say that exists is more efficient than in.
If the two tables of the query are of the same size, there is little difference b ...
Posted by The Little Guy on Mon, 28 Feb 2022 01:45:33 +0100
This job is the three node deployment method of OceanBase cluster. Directly and remotely log in to the OceanBase node through the central control computer to deploy and start the observer and obproxy processes.
Since there are exactly seven physical machines on hand, OBD will be directly deployed as an OceanBase cluster wi ...
Posted by scm24 on Sun, 27 Feb 2022 16:10:18 +0100
Is your DDL execution transactionalRecently, flyway was integrated into the project. In terms of transaction processing in the official document, an interesting paragraph was found:If your database cleanly supports DDL statements within a transaction, failed migrations will always be rolled back (unless they were marked as non-transactional).If ...
Posted by peddel on Sun, 27 Feb 2022 10:42:21 +0100
Python wechat ordering applet course video
Python actual combat quantitative transaction financial management system
[Ji Li 01 group No. 08] SSM framework integration
This course uses MySQL database. Start MySQL first:
sudo service mysq ...
Posted by desmi on Sun, 27 Feb 2022 04:50:24 +0100
1. Reliable messaging for ultimate consistency
We have studied the CAP theory before and know that we generally guarantee P and A, abandon C and ensure the final consistency. Distributed transaction The core of using message queue to achieve final consistency is to split distributed transactions into multiple local transactions, and then coord ...
Posted by elflacodepr on Sat, 26 Feb 2022 14:09:51 +0100
01. Add, delete and modify
SQL1 insert record (I)
Now there are two users' response records, as follows:
User 1001 began to answer test paper 9001 at 10:11:12 p.m. on September 1, 2021, and submitted it 50 minutes later, with 90 points;User 1002 began to answer test paper 9002 at 7:1:2 a.m. on September 4, 2021, and quit the p ...
Posted by bjblackmore on Sat, 26 Feb 2022 10:37:33 +0100