
Новые сообщения [новые:0]
Дайджест
Горячие темы
Избранное [новые:0]
Форумы
Пользователи
Статистика
Статистика нагрузки
Мод. лог
Поиск
|
|
30.03.2014, 22:21:44
|
|||
|---|---|---|---|
|
|||
Падает репликация Mysql. |
|||
|
#18+
Падает Slave вот с такой ошибкой. 140330 19:44:34 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140330 19:44:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140330 19:44:35 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140330 19:44:35 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140330 19:44:35 [Note] Plugin 'FEDERATED' is disabled. 140330 19:44:35 InnoDB: The InnoDB memory heap is disabled 140330 19:44:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140330 19:44:35 InnoDB: Compressed tables use zlib 1.2.7 140330 19:44:35 InnoDB: Using Linux native AIO 140330 19:44:35 InnoDB: Initializing buffer pool, size = 128.0M 140330 19:44:35 InnoDB: Completed initialization of buffer pool 140330 19:44:35 InnoDB: highest supported file format is Barracuda. 140330 19:44:35 InnoDB: Waiting for the background threads to start 140330 19:44:36 InnoDB: 5.5.35 started; log sequence number 18952623360 140330 19:44:36 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000467' at position 357983317, relay log '/var/lib/mysql/mysql-relay-bin.000002' position: 253 140330 19:44:36 [Note] Event Scheduler: Loaded 0 events 140330 19:44:36 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.35-0+wheezy1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian) 140330 19:44:36 [Note] Slave I/O thread: connected to master 'replication@5.9.136.37:3306',replication started in log 'mysql-bin.000467' at position 357983317 140330 19:44:37 [ERROR] Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master; the first event 'mysql-bin.000467' at 357983317, $ 140330 19:44:37 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master; the$ 140330 19:44:37 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000467', position 357983317 ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
30.03.2014, 22:40:22
|
|||
|---|---|---|---|
Падает репликация Mysql. |
|||
|
#18+
БарашIncrease max_allowed_packet on masterНе пробовали? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
30.03.2014, 23:43:13
|
|||
|---|---|---|---|
|
|||
Падает репликация Mysql. |
|||
|
#18+
Пробовал вот конфиг мастера. Не я его настраивал. Пытаюсь теперь настроить репликацию # generic configuration options [client] #large-pages port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld] server-id = 1 replicate-do-db = rundl user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock datadir = /var/lib/mysql tmpdir = /tmp #tmpdir = /dev/shm connect_timeout = 600 character-set-server = utf8 #collation-server = utf8_bin #language = /usr/share/mysql/english log-warnings = 3 back_log = 500 max_connections = 100 max_connect_errors = 10 table_open_cache = 16384 max_allowed_packet = 512M binlog_cache_size = 128M max_heap_table_size = 1024M sort_buffer_size = 1024M join_buffer_size = 8M thread_cache_size = 64 thread_concurrency = 16 query_cache_size = 64M query_cache_limit = 4M query_cache_type = OFF ft_min_word_len = 4 default-storage-engine = INNODB thread_stack = 256K transaction_isolation = REPEATABLE-READ tmp_table_size = 4G log-bin = mysql-bin binlog_format = row sync_binlog = 1 log_slave_updates log-error = /var/log/mysql/mysql-bin.err slow_query_log = /var/log/mysql/mysql-slow.log long_query_time = 10 #*** MyISAM Specific options key_buffer_size = 256M read_buffer_size = 8M read_rnd_buffer_size = 1024M bulk_insert_buffer_size = 128M myisam_sort_buffer_size = 256M myisam_max_sort_file_size = 1G myisam_repair_threads = 4 myisam_recover # *** INNODB Specific options *** innodb_additional_mem_pool_size = 32M innodb_buffer_pool_size = 10G innodb_data_file_path = ibdata1:10M:autoextend innodb_file_per_table innodb_thread_concurrency = 200 innodb_flush_log_at_trx_commit = 2 innodb_flush_method=O_DIRECT innodb_doublewrite=0 innodb_support_xa=0 innodb_log_buffer_size = 8M innodb_log_file_size = 1G innodb_log_files_in_group = 3 innodb_max_dirty_pages_pct = 80 innodb_lock_wait_timeout = 120 [mysqldump] quick quote-names max_allowed_packet = 1024M [myisamchk] key_buffer_size = 256M sort_buffer_size = 2048M read_buffer = 32M write_buffer = 32M ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
02.04.2014, 11:23:32
|
|||
|---|---|---|---|
|
|||
Падает репликация Mysql. |
|||
|
#18+
Решил перенастроив мастер. Но возникла другая проблема, мастер не пишет бинарные логи. Изменения в базе есть а вот записи в логи нет. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
03.04.2014, 09:25:28
|
|||
|---|---|---|---|
Падает репликация Mysql. |
|||
|
#18+
лучше избегать использования replicate-do-db и прочих фильтров. они работают не так как себе представляет большинство пользователей. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|

start [/forum/topic.php?fid=47&mobile=1&tid=1835028]: |
0ms |
get settings: |
9ms |
get forum list: |
15ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
47ms |
get topic data: |
8ms |
get forum data: |
2ms |
get page messages: |
25ms |
get tp. blocked users: |
1ms |
| others: | 199ms |
| total: | 312ms |

| 0 / 0 |
