Master slave replication of a database that has been running for a period of time
Preface: a few days ago, the master-slave replication of MySQL database that has been running for a period of time and has not opened bin log was made. Hereby, the detailed operation steps and instructions are recorded. Note that this synchronization does not use ...
Posted by virtuexru on Wed, 11 May 2022 23:14:11 +0300
The original content of GreatSQL community cannot be used without authorization. Please contact Xiaobian and indicate the source for reprint.[toc]introduceFirst of all, let's introduce it Sanitizer The project is an open source project produced by Google. The project includes memory and thread error detection tools such as ASAN, LSAN, MSAN and ...
Posted by realnsleo on Wed, 11 May 2022 07:47:07 +0300
MySQL common instructions
Modify table structure
service mysql start
#Start the MySQL service. mysql55 is the server name specified when installing the MySQL server
net start mysql55
#Stop mysql service
net stop mysql55
#Create database Set character set Set collation
create database Database name character set gb2 ...
Posted by a94060 on Wed, 11 May 2022 00:09:32 +0300
1. Modify field related information
2. Modify constraints
3. Modify other options
4. Modify table name
create table if not exists table name(
Field type constraints,
[constraint information]# last line information without comma
)engine=InnoDB[MyIASM] default charset=utf8;
For examp ...
Posted by aiikcmo on Tue, 10 May 2022 23:39:45 +0300
MySQL multi table & foreign key & database design
1.1 multi table description
1.2 disadvantages of single meter
1.2.1 data preparation
1.2.2 single table problems
1.3.1 two tables are designed
Table 1.3.2 relationship analysis
1.3.3 problems in multi meter design
1.4 foreign key constraints
1.4.1 what ...
1. Introduction to mybatis
1.1 what is MyBatis?
MyBatis official website
MyBatis is an excellent persistence layer framework that supports common SQL queries, stored procedures and advanced mapping. MyBatis eliminates almost all the manual setting of JDBC code and parameters and the retrieval of result sets. MyBatis uses simple XML or ann ...
Demo in mysql
Full backup of zipper during mysql demonstration:
1, Demonstrate the first and second full backups.
1. First, there is the business system table.
//Enter the test database.
//Create business table user_data and give the initial business data.
create table user_data(
insert into user_da ...
Posted by Mark.P.W on Tue, 10 May 2022 06:57:38 +0300
It has been several months since the last article was published. Recently, there are many things to resume work, which has been delayed for some time. Look back at zabbix5 The 0beta 1 version has been released! The functions of the new version are described below. 5.0 has not been officially released at present. Do not use it in production envi ...
Posted by waldo on Tue, 10 May 2022 02:30:16 +0300
What is JDBC
JDBC (Java database connectivity) is a Java API used to execute SQL statements. It provides unified access to a variety of relational databases. It is composed of a group of classes and interfaces written in Java language
Connect before mysql8
Database driver name: com mysql. jdbc. Driver
url connection: ...
Posted by mrhinman on Mon, 09 May 2022 06:28:50 +0300
Hello, nice to meet you.
Starting from September, I decided to launch the goal of "weekly blog": publish at least one blog every week, which can be a variety of source code analysis and study, or a problem encountered in recording work.
After a period of aimless study, I found that it didn't seem to be very useful. I forgot what I had ...
Posted by kid_drew on Mon, 09 May 2022 00:21:49 +0300