In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Development >
Share
Shulou(Shulou.com)06/03 Report--
Editor to share with you what are the formats of the binary log in mysql, I believe most people don't know much about it, so share this article for your reference. I hope you can learn a lot after reading this article. Let's learn about it together.
1. STATEMENT is the SQL statement recorded in the log file.
Every SQL statement that modifies the data is recorded in the log. Using the mysqlbinlog tool provided by MySQL, you can clearly see that when the text of each statement is copied from the master and slave, the slave parses the log to the original text and re-executes it in the slave library.
2. The ROW log format records the changes of each line of data in the log file, rather than recording SQL statements.
3. MIXED log format is the default log format of MySQL, which is a mixture of the first two log formats.
Example
# vim my.cnf # configure log-bin = / data/3306/mysql-binbinlog_format= "STATEMENT" # binlog_format= "ROW" # binlog_format= "MIXED" in the [mysql] module or modify the environment variable to modify the binlog mode mysql > SET global binlog_format='STATEMENT'. All the contents of the article "what are the binary log formats in mysql"? thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.