Re: Replication doesn't write to database.
here is the data you requested.
Slave:
mysql> SHOW VARIABLES LIKE 'server%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| server_id | 1 |
+---------------+-------+
1 row in set (0.00 sec)
mysql> SHOW VARIABLES LIKE '%bin%';
+-----------------------------------------+----------------------+
| Variable_name | Value |
+-----------------------------------------+----------------------+
| binlog_cache_size | 32768 |
| binlog_direct_non_transactional_updates | OFF |
| binlog_format | ROW |
| innodb_locks_unsafe_for_binlog | ON |
| log_bin | ON |
| log_bin_trust_function_creators | OFF |
| log_bin_trust_routine_creators | OFF |
| max_binlog_cache_size | 18446744073709547520 |
| max_binlog_size | 1073741824 |
| sql_log_bin | ON |
| sync_binlog | 0 |
+-----------------------------------------+----------------------+
11 rows in set (0.00 sec)
mysql> SHOW VARIABLES LIKE '%slave%';
+---------------------------+------------+
| Variable_name | Value |
+---------------------------+------------+
| init_slave | |
| log_slave_updates | ON |
| slave_compressed_protocol | OFF |
| slave_exec_mode | STRICT |
| slave_load_tmpdir | /tmp |
| slave_max_allowed_packet | 1073741824 |
| slave_net_timeout | 3600 |
| slave_skip_errors | OFF |
| slave_transaction_retries | 10 |
| sql_slave_skip_counter | |
+---------------------------+------------+
10 rows in set (0.00 sec)
Master
mysql> SHOW VARIABLES LIKE 'server%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| server_id | 2 |
+---------------+-------+
1 row in set (0.00 sec)
mysql> SHOW VARIABLES LIKE '%bin%';
+-----------------------------------------+----------------------+
| Variable_name | Value |
+-----------------------------------------+----------------------+
| binlog_cache_size | 32768 |
| binlog_direct_non_transactional_updates | OFF |
| binlog_format | ROW |
| innodb_locks_unsafe_for_binlog | ON |
| log_bin | ON |
| log_bin_trust_function_creators | OFF |
| log_bin_trust_routine_creators | OFF |
| max_binlog_cache_size | 18446744073709547520 |
| max_binlog_size | 1073741824 |
| sql_log_bin | ON |
| sync_binlog | 0 |
+-----------------------------------------+----------------------+
11 rows in set (0.00 sec)
mysql> SHOW VARIABLES LIKE '%slave%';
+---------------------------+------------+
| Variable_name | Value |
+---------------------------+------------+
| init_slave | |
| log_slave_updates | OFF |
| slave_compressed_protocol | OFF |
| slave_exec_mode | STRICT |
| slave_load_tmpdir | /tmp |
| slave_max_allowed_packet | 1073741824 |
| slave_net_timeout | 3600 |
| slave_skip_errors | OFF |
| slave_transaction_retries | 10 |
| sql_slave_skip_counter | |
+---------------------------+------------+
10 rows in set (0.00 sec)
Subject
Views
Written By
Posted
1842
February 14, 2014 05:13PM
891
February 16, 2014 12:16AM
1365
February 16, 2014 09:07AM
865
February 17, 2014 11:44AM
1016
February 17, 2014 01:31PM
958
February 20, 2014 12:44PM
969
February 26, 2014 12:21PM
873
February 26, 2014 03:33PM
797
February 27, 2014 08:20PM
Re: Replication doesn't write to database.
811
February 28, 2014 11:07AM
878
March 03, 2014 04:35PM
928
March 05, 2014 10:15AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.