Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ MySQL log from the library than the main library     - Five strokes to find out the IP address you want to know (Linux)

- Installation Mesos + Marathon + Zookeeper under CentOS 7 (Server)

- Laravel cache paged results (Server)

- Realization of Linux operating system illegal IP censorship (Linux)

- installation of Piwik under Ubuntu (Programming)

- Boost-- time and date - (1) timer library introduction (Programming)

- Linux 10 useful examples of command-line completion (Linux)

- The difference between equals and == in Java (Programming)

- AngularJS asynchronous service testing and Mocking (Programming)

- How to set the default Fedora from the command line (Linux)

- Git uses a small mind (Linux)

- Compile and install the latest version of Redis Stable (Database)

- Using a proxy method under Linux terminal (Linux)

- SSH without password (Linux)

- MySQL 5.7.10 source code for the latest version of the installation process in detail (Database)

- MongoDB Installation under CentOS 6.6 (Database)

- JDK comes with tools jinfo (Linux)

- Tomcat itself through simple movement separation (Server)

- ctop: monitor container performance Linux command line artifact (Linux)

- Java-based data source database access (Programming)

  MySQL log from the library than the main library
  Add Date : 2018-11-21      
  In the group chat, a group of friends said, MySQL Library main library production downtime, but consistent master data from the database, but the logs from the library than the main library, it is not understood!

After consultation found that the production of the main library database is not set sync_binlog = 1, but for sync_binlog = 0

Therefore, when writing data to the main library, the transaction has been submitted, but the data in the binlog cache, no write to the disk, and the data has been synchronized to the library, at the moment the main library down, binlog cache data loss, resulting from library logs than the main library.

Group of friends from the master after reconfiguration and sync_binlog set to 1

sync_binlog importance and significance:

sync_binlog = n, n times after each transaction commits, MySQL will conduct a fsync like disk synchronization instruction to the data binlog_cache the mandatory written to disk.

In MySQL, the default setting is sync_binlog = 0, that is, without any mandatory disks refresh command, this time the performance is the best, but the risk is greatest. Because once the system Crash, all binlog information will be lost in the binlog_cache.
- Teach you how to protect the Linux operating system security tips (Linux)
- Migu online music player for Linux (Linux)
- Install the free open source financial software GnuCash 2.6.6 under Ubuntu (Linux)
- Linux installation and error under codeblocks exclude [Ubuntu 10.04] (Linux)
- Use the DBMS_SCHEDULER package to manage scheduled tasks (Database)
- Compile and install GCC 4.8.1 + GDB 7.6.1 + Eclipse in CentOS 6.4 in (Linux)
- Linux System Getting Started Learning: Statistical process a number of threads in Linux (Linux)
- Python console achieve progress bar (Programming)
- Security Knowledge: How to hide a backdoor PHP file tips (Linux)
- floating IP in OpenStack neutron (Server)
- Oracle View index and use indexes Precautions (Database)
- RHEL5 multipath configuration (Linux)
- Use Swift remove the spaces in the string (Programming)
- Learning Linux coding style (Programming)
- Ubuntu and Derivative Edition users install LMMS 0.4.15 (Linux)
- Linux five security TIPS (Linux)
- Detailed PHP code optimization [section] (explain reasons) (Programming)
- Use mod_wsgi Django application deployment (Server)
- Android WebView use layman (Programming)
- CentOS 6 adds disk quota limit (Linux)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.