MySQL enable binlog

Angryshark_ one hundred and twenty-eight 2022-06-24 07:15:03 阅读数:277

mysqlenablebinlog

Check to see if it's on

> show variables like '%log_bin%';

Insert picture description here

Modify the configuration file

> vi my.cnf
server_id=1918
log_bin = mysql-bin
binlog_format = ROW

Check to see if it's on

> show variables like '%log_bin%';

Insert picture description here

copyright：author[Angryshark_ one hundred and twenty-eight]，Please bring the original link to reprint, thank you. https://en.javamana.com/2022/175/202206240050386090.html

《 Linux cross server file synchronization

[exploration of set classes in Java] 08 exploration of HashSet and TreeSet
ServiceStack. Source code analysis of redis (connection and connection pool)
Learning part 4 of Java Concurrent Programming_ Four functional interfaces, stream stream computing, forkjoin branch merging, future asynchronous callback
Cal command of Linux
How to use WGet to limit file download speed in Linux
How to install netstat command in Linux
Springboot global exception interceptor, friendly exception prompt
The installation method of apache+mysql+php running environment under Windows
Configure PHP development environment in MAC environment: apache+php+mysql
Linux Apache setting compression and caching
Several command line tools for browsing web pages under Linux
Launch conference of "luxury spring" Shanghai Asia Europe Limited Edition models
Using the Ninja -c out/release command to compile the SDK of Android webrtc, an error is reported and the Android NDK cannot be found for processing
Oracle case: ohasd crash on AIX
This article will introduce you to hadoop3 x
http net::ERR_ HTTP2_ PROTOCOL_ Error error finding
Centos7 deploying mysql-5.7
Easy car Interviewer: talk about MySQL memory structure, index, cluster and underlying principle!
MySQL concept - View
Installing es under Linux
A 100 day sprint for the interview of a Java factory - accumulated over time, three questions per day [day18] - a collection of wonderful questions
A 100 day sprint for the interview of a Java factory - accumulated over time, three questions per day [Day5] - Basic Part 2
How to set samesite of cookies in Weblogic
The file name in Tomcat in docker is displayed as a question mark in Chinese
Using Java and database to realize graphical interface
Error in spades analysis of Linux macro genome
During the test here, many messages will be received when the cloud pushes them to the device. Only two messages were sent from the cloud. Meaning: does the cloud SDK use qos1
Scheduledthreadpoolexecutor of Java core "16" j.u.c executor framework
Oracle SQL comprehensive application exercises
In the springboot project, create the config directory under the resources directory, application The little green leaf of YML is missing. How to solve it?
Connection timed out lost connection
How to solve the database connection failure of Java eclipse
Interface related problems of Java
Linux CentOS process text management
Recurrence and analysis of unauthorized access (cve-2010-3863) caused by non standardized path of "Java security" shiro1.0.0
Analysis of detailed source code of rocketmq nameserver
Rocketmq deferred message (scheduled message) version 4.9.3 optimized asynchronous delivery support
Springcloud has problems using ribbon
On object injection by spring5 framework
Automatic shutdown after Tomcat startup
How difficult is the Java Tutorial compared with other programming tutorials
What can I do after downloading Java
The classic case of java game the method of playing mobile java game by computer
What are the Linux view process commands? Linux usage considerations
What are the advantages of mybatis? Are there any defects in its actual application
Sudo automatic password input for Linux
[special topic of microservices] Integrated message queue under net6 -rabbitmq
Counter attack of flour dregs: MySQL 66 questions, 20000 words + 50 pictures
New spring annotations
Introduction to docker, it is enough to learn and understand this article
On update current in MySQL_ TIMESTAMP
Analysis of rocketmq 4.9.3 performance optimization source code
How does webstorm set the bootstrap auto prompt
Springboot outputs SQL statements in mybatis (idea)
Integrated GIS method in hive
Java MySQL BLOB data read / write operation
There are many linux time waits, which affect web business access
An example of MySQL accidental deletion recovery - using Myflash
Research on redis High Availability Mechanism
Linux cloud computing O & M Architect (serialized) - automated O & M ansible-03