![]() ![]() Next, check whether the binary log is used or not with the following command: ![]() +-+-+ | Variable_name | Value | +-+-+ | bind_address | 127.0.0.1 | | binlog_annotate_row_events | ON | | binlog_cache_size | 32768 | | binlog_checksum | CRC32 | | binlog_commit_wait_count | 0 | | binlog_commit_wait_usec | 100000 | | binlog_direct_non_transactional_updates | OFF | | binlog_file_cache_size | 16384 | | binlog_format | MIXED | | binlog_optimize_thread_scheduling | ON | | binlog_row_image | FULL | | binlog_stmt_cache_size | 32768 | | encrypt_binlog | OFF | | gtid_binlog_pos | | | gtid_binlog_state | | | innodb_locks_unsafe_for_binlog | OFF | | log_bin | OFF | | log_bin_basename | | | log_bin_compress | OFF | | log_bin_compress_min_len | 256 | | log_bin_index | | | log_bin_trust_function_creators | OFF | | max_binlog_cache_size | 18446744073709547520 | | max_binlog_size | 1073741824 | | max_binlog_stmt_cache_size | 18446744073709547520 | | read_binlog_speed_limit | 0 | | sql_log_bin | ON | | sync_binlog | 0 | | wsrep_forced_binlog_format | NONE | +-+-+Īs you can see, the binary log is off in the MySQL server. To check it, first log in to MySQL with the following command: This post will show you how to enable and use binary log in MySQL on Linux.Ī server running Linux with MariaDB installed.īefore starting, you will need to verify whether the bin-log option is turned on or not and what binary log format is used. You can also use the binary log to perform any recovery operations in MySQL. In this case, a binary log will send the data from the master MySQL server to the slave server. The binary log is very useful when you are using MySQL replication. It has all the information, updates the database, deletes it, creates and deletes the table, and more. In simple terms, the binary log is a file set containing information on data modifications made to a MySQL server instance. In MySQL or MariaDB database, when you make any changes in the database, every event is logged. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |