v1.2.0h

Version v1.2.0h introduces the follow changes to v1.2.0f (changes to v1.2.0g were not documented):

• Logging
  • improved the logging of all queries , #561
  • logger now logs also information about client, server, hostgroup_id , digest and duration
• Enhancements on routing (query rules) :
  • mysql_query_rules is now extended and supports matching criteria on client address, proxy address, proxy port, and digest of the query , #537
  • added new global variables mysql-query_retries_on_failure (default to 1) that specifies how many times a query can be re-executed if failed
  • added new column retries in mysql_query_rules to allow to change the number of times a queries can be retried/re-executed
• Enhancements on SSL support
  • if a backend is configured to use SSL , Monitor module will use SSL too
  • use of SSL connections is now non-blocking after connect() : Note, connect() on SSL is still a blocking call and will be fixed in a future version
  • fixed a bug that caused a crash if a client was compiled against MySQL 5.7 library #583
  • prevent clients from connecting using SSL #540
• Scheduler #578 (further documentation required)
  • a new table scheduler is added to Admin module
  • ProxySQL can now calls external scripts at regular intervals
• general improvements and bug fixes
  • drastically reduced restart time #576
  • fixes file descriptors (not connections) leak #567
  • fixes a bug in counting current connections to backend #581
  • adds a counter of active transactions in fight #581
  • enforces variable mysql-monitor_connect_timeout . Without this Monitor could hang #584