Completed

Mysql-proxy - configuração

Published on the June 20, 2018 in IT & Programming

About this project

Open

Sistema de replicação MySQL usando 4 servidores:
10.0.0.1 - mysql-proxy (recebe as solicitacoes e distribui para os outros servidores)
10.0.0.3 - Mysql Master (somente escrita e Update)
10.0.0.4 - Mysql slave 01 (somente leitura)
10.0.0.7 - Mysql slave 02 (somente leitura)
O sistema já está funcionando há mais de 1 ano... Mas agora o proxy começa a travar e no seu log aparece as seguintes mensagens:

2018-06-20 14:42:47: (debug) network-mysqld.c.1680: network_mysqld_write(CON_STATE_SEND_QUERY) returned an error
2018-06-20 14:42:47: (debug) [network-mysqld.c:1134]: error on a connection (fd: -1 event: 0). Closing client connection.
2018-06-20 14:42:47: (debug) [network-mysqld.c:1134]: error on server connection (fd: 1389 event: 2).
Closing client connection.
2018-06-20 14:42:48: (debug) [network-mysqld.c:1134]: error on server connection (fd: 1151 event: 2). Closing client connection.

2018-06-20 14:42:55: (debug) network-mysqld.c.1680: network_mysqld_write(CON_STATE_SEND_QUERY) returned an error
2018-06-20 14:42:55: (debug) [network-mysqld.c:1134]: error on a connection (fd: -1 event: 0). Closing client connection.
2018-06-20 14:42:56: (debug) [network-mysqld.c:1134]: error on server connection (fd: 1289 event: 2).
Closing client connection.
2018-06-20 14:42:56: (debug) [network-mysqld.c:1134]: error on server connection (fd: 1228 event: 2). Closing client connection.

2018-06-20 14:43:01: (debug) [network-mysqld.c:1134]: error on server connection (fd: 1161 event: 2). Closing client connection.

---
Preciso de uma pessoa com conhecimento em mysql-proxy para analisar o log e corrigir o problema.

Category IT & Programming
Subcategory Other
Project size Medium
Is this a project or a position? Project
I currently have Not applicable
Required availability As needed
API Integrations Other (Other APIs)

Delivery term: Not specified

Skills needed