MySQL Forums :: Utilities :: COME ON !! please give me a real answer


Advanced Search

Re: COME ON !! please give me a real answer
Posted by: Philippe Florent ()
Date: July 11, 2016 12:39AM

here are some details

$ cat /etc/mysql/fabric.cfg
[DEFAULT]
prefix =
sysconfdir = /etc
logdir = /var/log

[storage]
address = localhost:3306
user = fabric_store
password = *****************
database = mysql_fabric
auth_plugin = mysql_native_password
connection_timeout = 6
connection_attempts = 6
connection_delay = 1

[servers]
user = fabric_server
password = *****************
backup_user = fabric_backup
backup_password = *****************
restore_user = fabric_restore
restore_password = *****************
unreachable_timeout = 5

[protocol.xmlrpc]
address = 0.0.0.0:32274
threads = 5
user = admin
password = *****************
disable_authentication = no
realm = MySQL Fabric
ssl_ca =
ssl_cert =
ssl_key =

[protocol.mysql]
address = 0.0.0.0:32275
user = admin
password = *****************
disable_authentication = no
ssl_ca =
ssl_cert =
ssl_key =

[executor]
executors = 5

[logging]
level = INFO
url = file:///var/log/fabric.log

[sharding]
mysqldump_program = /usr/bin/mysqldump
mysqlclient_program = /usr/bin/mysql
prune_limit = 10000

[statistics]
prune_time = 3600

[failure_tracking]
notifications = 300
notification_clients = 50
notification_interval = 60
failover_interval = 0
detections = 3
detection_interval = 6
detection_timeout = 1
prune_time = 3600

[connector]
ttl = 1


$ mysqlfabric group lookup_groups
Fabric UUID: 5ca1ab1e-a007-feed-f00d-cab3fe13249e
Time-To-Live: 1

group_id description failure_detector master_uuid
-------- ----------- ---------------- ------------------------------------
mygroup None 1 adf6ec47-3f6f-11e6-afb4-0050569972ef


$ cat lookup_servers.xml
<?xml version="1.0" encoding="iso-8859-1"?>
<methodCall>
<methodName>group.lookup_servers</methodName>
<params>
<param>
<value><string>mygroup</string></value>
</param>
</params>
</methodCall>


$ sudo mysqlfabric manage start --daemonize

$ sudo netstat -tulpn | grep LISTEN
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 1005/exim4
tcp 0 0 0.0.0.0:10050 0.0.0.0:* LISTEN 4339/zabbix_agentd
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 710/mysqld
tcp 0 0 0.0.0.0:54863 0.0.0.0:* LISTEN 399/rpc.statd
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN 390/rpcbind
tcp 0 0 0.0.0.0:32274 0.0.0.0:* LISTEN 4778/python
tcp 0 0 0.0.0.0:32275 0.0.0.0:* LISTEN 4778/python
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 416/sshd
tcp6 0 0 ::1:25 :::* LISTEN 1005/exim4
tcp6 0 0 :::10050 :::* LISTEN 4339/zabbix_agentd
tcp6 0 0 :::111 :::* LISTEN 390/rpcbind
tcp6 0 0 :::33457 :::* LISTEN 399/rpc.statd
tcp6 0 0 :::22 :::* LISTEN 416/sshd

$ curl -H 'Content-Type: text/xml' -d @./lookup_servers.xml http://192.168.1.12:32274

$ curl -H 'Content-Type: text/xml' -d @./lookup_servers.xml http://127.0.0.1:32274

$ sudo tail -f /var/log/fabric.log
[INFO] 1468218460.701753 - MainThread - Starting failure detector.
[INFO] 1468218460.702324 - MainThread - Monitoring group (mygroup).
[INFO] 1468218460.702501 - Executor-4 - Started.
[INFO] 1468218460.706738 - XML-RPC-Server - XML-RPC protocol server ('0.0.0.0', 32274) started.
[INFO] 1468218460.706921 - XML-RPC-Server - Setting 5 XML-RPC session(s).
[INFO] 1468218460.707103 - XML-RPC-Session-0 - Started XML-RPC-Session.
[INFO] 1468218460.708592 - XML-RPC-Session-1 - Started XML-RPC-Session.
[INFO] 1468218460.709986 - XML-RPC-Session-2 - Started XML-RPC-Session.
[INFO] 1468218460.711250 - XML-RPC-Session-3 - Started XML-RPC-Session.
[INFO] 1468218460.712486 - XML-RPC-Session-4 - Started XML-RPC-Session.

$ sudo tail -f /var/log/mysql/error.log
2016-07-11T06:27:17.595889Z 12 [Note] Aborted connection 12 to db: 'mysql_fabric' user: 'fabric_store' host: 'localhost' (Got an error reading communication packets)
2016-07-11T06:27:17.596028Z 11 [Note] Aborted connection 11 to db: 'mysql_fabric' user: 'fabric_store' host: 'localhost' (Got an error reading communication packets)
2016-07-11T06:27:17.596117Z 10 [Note] Aborted connection 10 to db: 'mysql_fabric' user: 'fabric_store' host: 'localhost' (Got an error reading communication packets)
2016-07-11T06:27:17.596238Z 9 [Note] Aborted connection 9 to db: 'mysql_fabric' user: 'fabric_store' host: 'localhost' (Got an error reading communication packets)
2016-07-11T06:27:17.596373Z 8 [Note] Aborted connection 8 to db: 'mysql_fabric' user: 'fabric_store' host: 'localhost' (Got an error reading communication packets)
2016-07-11T06:27:17.596496Z 7 [Note] Aborted connection 7 to db: 'mysql_fabric' user: 'fabric_store' host: 'localhost' (Got an error reading communication packets)
2016-07-11T06:27:17.596607Z 6 [Note] Aborted connection 6 to db: 'mysql_fabric' user: 'fabric_store' host: 'localhost' (Got an error reading communication packets)
2016-07-11T06:27:17.596839Z 5 [Note] Aborted connection 5 to db: 'mysql_fabric' user: 'fabric_store' host: 'localhost' (Got an error reading communication packets)
2016-07-11T06:27:17.596970Z 4 [Note] Aborted connection 4 to db: 'mysql_fabric' user: 'fabric_store' host: 'localhost' (Got an error reading communication packets)
2016-07-11T06:27:40.608727Z 16 [Note] Aborted connection 16 to db: 'mysql_fabric' user: 'fabric_store' host: 'localhost' (Got an error reading communication packets)

Options: ReplyQuote


Subject Views Written By Posted
COME ON !! please give me a real answer 957 Philippe Florent 07/11/2016 12:21AM
Re: COME ON !! please give me a real answer 490 Philippe Florent 07/11/2016 12:39AM
Re: COME ON !! please give me a real answer 285 Nick Swenson 10/05/2016 03:17PM


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.