v1.2.0d

Version v1.2.0d introduces significant changes to v1.2.0c in order to improves usability and stability, and should be considered experimental.
Changes:

• Reduced the memory footprint of some classes (MySQL_Thread, MySQL_Session, MySQL_Data_Stream)
• several minor optimizations
• removed libinjection , issue #424
• upgraded jemalloc from 3.6.0 to 4.1.0
• added support for more commands in __query_parser_command_type : START TRANSACTION , SET , SHOW , SHOW TABLE STATUS
• auto tuning of shun_recovery_time_sec , issues #530 and #531
• disable multiplexing for LOCK TABLE in addition to LOCK TABLES
• deprecated the use of mysql_close() , replace with close_mysql() , a non blocking wrapper
• enforced mysql-ping_timeout_server, issue #535
• enforced mysql-monitor_replication_lag_timeout, issue #541
• enforced mysql-monitor_ping_timeout, issue #542
• implemented mysql-monitor_ping_max_failures that defines the number of missed heartbeats before considering a backend to be dead, issue #544
• kills all connections to a backend if failed, issue #543
• balance connections usage based on weight and used connections, useful in case of server failure. Issue #545
• added support for CentOS 6.7
• added support for CentOS 7
• added support for Ubuntu 15.10
• fixed bug in initial handshake
• bug fixes in handling of SET AUTOCOMMIT
• re-executes queries in Admin if SQLite3 is busy
• allows online upgrade from v1.1.x

v1.2.0c

This is 1.1.2 stable with:

• in v1.2.0a
  • experimental mirroring support, see https://github.com/sysown/proxysql/blob/v1.2.0/doc/mirroring.md
• in v1.2.0b
  • re-added support for Ubuntu12
  • re-added support for debugging , issue #467
  • avoid races condition in writing/reading mysql_servers table
• v1.2.0c
  • re-implemented fast forward , issue #528

v1.2.0b

This is 1.1.2 stable with:

• experimental mirroring support, see https://github.com/sysown/proxysql/blob/v1.2.0/doc/mirroring.md
• re-added support for Ubuntu12
• re-added support for debugging , issue #467
• avoid races condition in writing/reading mysql_servers table

Experimental realease with mirroring support

This is mostly 1.1.2 stable with experimental mirroring support
See https://github.com/sysown/proxysql/blob/v1.2.0/doc/mirroring.md

Latest stable of v1.1

Compared to v1.1.0:

Enhancements:

• improves performance reducing the calls to poll() : #459
• includes better support for Galera : #380
• compiles on FreeBSD
• compiles with clang
• has new variable client_found_rows : #445
• implements compression on backend : #363
• handles more gracefully a complete failure of backends : #461
• improves performance reducing the number of tasks performed on every MySQL_Thread loop : 97b3f3d
• upgrade SQLite3 from 3.8.4 to 3.9.2 : 6b05743
• COMMITs and ROLLBACKs are forwarded to backend only of a transaction is active : 439087d
• added several counters in mysql status : ab3b737
• in case of crash it signals again itself to generate a core dump : 57b4512
• added admin-version in global variables
• reduced number of calls to memory allocator
• shrink mysql net buffer when possible
• reduced memory footprint for system with low memory : 912a03c and 8c92912
• keep multiplexing enabled for @@Version and @@tx_isolation : 488f44b
• Admin Module now supports SHOW SCHEMAS : 08b18bd
• Admin Module supports "SELECT @@Version" : 995fe51
• in case of errors while retrieving replication lag, servers are now not shunned : #479
• Added CHECKSUM command for tables in Admin Module : 26235f9
• Improved memory utilization and performance for the buffering of resultset : #486
• Added table runtime_mysql_servers in Admin Module : #488
• Added table runtime_mysql_replication_hostgroups in Admin Module : #488
• Added table runtime_mysql_query_rules in Admin Module : #489
• Several improvements for MySQL_Monitor : #490
• Add MySQL-like SET syntax in Admin Module : #498
• Several code cleanup

Enhancement that are also incompatible changes:

• cache_ttl in Query Cache is now in milliseconds : #452
• table stats_mysql_query_digest stores also hostgroup : #446
• removed custom memory allocator #487

Bug fixes:

• Query Cache now supports distinct entries based on user/schema : 5eff88f
• fixed a small typo that prevented query rules to be loaded from config file : 87dbb9b
• signals handlers were installed on the parent process and not on the child process : b519c94
• fix length for parsing and filtering SET AUTOCOMMIT : 3497160
• allows empty password for mysql-monitor_password
• fixed init script : #425
• Fixed accounting of Server_Connections_connected : 2ea4149
• some failure could cause connections leak : 15195d1
• patch for bug in mariadb client library : e004b54
• improved reliability in case of graceful shutdown of mysqld : #476
• replication lag caused to duplicate entries in mysql_servers : #475
• incorrect parsing of comments in queries could lead to crash : 4b93a74
• implemented variable enforce_autocommit_on_reads to solve transactions opened on slaves : #485
• fixed a connection leak when restarting proxysql via PROXYSQL RESTART : #473

Incompatible change:

• digest_text is limited to 65000 bytes

Unfinished features.
These are features available in ProxySQL but yet not enabled as incomplete.

• MySQL_Logger now logs in a new format that is similar to MySQL protocol. This removes any reference to protobuf

v1.1.1-beta.6

Compared to v1.1.0:

Enhancements:

• improves performance reducing the calls to poll() : #459
• includes better support for Galera : #380
• compiles on FreeBSD
• compiles with clang
• has new variable client_found_rows : #445
• implements compression on backend : #363
• handles more gracefully a complete failure of backends : #461
• improves performance reducing the number of tasks performed on every MySQL_Thread loop : 97b3f3d
• upgrade SQLite3 from 3.8.4 to 3.9.2 : 6b05743
• COMMITs and ROLLBACKs are forwarded to backend only of a transaction is active : 439087d
• added several counters in mysql status : ab3b737
• in case of crash it signals again itself to generate a core dump : 57b4512
• added admin-version in global variables
• reduced number of calls to memory allocator
• shrink mysql net buffer when possible
• reduced memory footprint for system with low memory : 912a03c and 8c92912
• keep multiplexing enabled for @@Version and @@tx_isolation : 488f44b
• Admin Module now supports SHOW SCHEMAS : 08b18bd
• Admin Module supports "SELECT @@Version" : 995fe51
• in case of errors while retrieving replication lag, servers are now not shunned : #479

Enhancement that are also incompatible changes:

• cache_ttl in Query Cache is now in milliseconds : #452
• table stats_mysql_query_digest stores also hostgroup : #446

Bug fixes:

• Query Cache now supports distinct entries based on user/schema : 5eff88f
• fixed a small typo that prevented query rules to be loaded from config file : 87dbb9b
• signals handlers were installed on the parent process and not on the child process : b519c94
• fix length for parsing and filtering SET AUTOCOMMIT : 3497160
• allows empty password for mysql-monitor_password
• fixed init script : #425
• Fixed accounting of Server_Connections_connected : 2ea4149
• some failure could cause connections leak : 15195d1
• patch for bug in mariadb client library : e004b54
• improved reliability in case of graceful shutdown of mysqld : #476
• replication lag caused to duplicate entries in mysql_servers : #475
• incorrect parsing of comments in queries could lead to crash : 4b93a74
• implemented variable enforce_autocommit_on_reads to solve transactions opened on slaves : #485

Incompatible change:

• digest_text is limited to 65000 bytes

Unfinished features.
These are features available in ProxySQL but yet not enabled as incomplete.

• MySQL_Logger now logs in a new format that is similar to MySQL protocol. This removes any reference to protobuf

v1.1.1-beta.5

Version 1.1.1.beta5

v1.1.1-beta.4

Compared to v1.1.0:

Enhancements:

• improves performance reducing the calls to poll() : #459
• includes better support for Galera : #380
• compiles on FreeBSD
• compiles with clang
• has new variable client_found_rows : #445
• implements compression on backend : #363
• handles more gracefully a complete failure of backends : #461
• improves performance reducing the number of tasks performed on every MySQL_Thread loop : 97b3f3d
• upgrade SQLite3 from 3.8.4 to 3.9.2 : 6b05743
• added several counters in mysql status : ab3b737
• in case of crash it signals again itself to generate a core dump : 57b4512
• added admin-version in global variables
• reduced number of calls to memory allocator
• shrink mysql net buffer when possible
• implemented new variable mysql-bug_mdev_8338

Enhancement that are also incompatible changes:

• cache_ttl is in Query Cache is now in milliseconds : #452
• table stats_mysql_query_digest stores also hostgroup : #446

Bug fixes:

• Query Cache now supports distinct entries based on user/schema : 5eff88f
• fixed a small typo that prevented query rules to be loaded from config file : 87dbb9b
• signals handlers were installed on the parent process and not on the child process : b519c94
• fix length for parsing and filtering SET AUTOCOMMIT : 3497160
• allows empty password for mysql-monitor_password

Incompatible change:

• digest_test is limited to 65000 bytes

Unfinished features.
These are features available in ProxySQL but yet not enabled as incomplete.

• MySQL_Logger now logs in a new format that is similar to MySQL protocol. This removes any reference to protobuf .
• COMMITs and ROLLBACKs are forwarded to backend only of a transaction is active : 439087d . This is currently disabled because of bug #469

v1.1.1-beta.3

Compared to v1.1.1-beta.2 :

Enhancements:

• more verbose log in case of error #462
• Admin module now support a read_only mode #463
• new global variable mysql-multiplexing allows to disable multiplexing #468

Bug fixes:

• prevent "Unknown database" to shun backends #464
• changed default datadir to /var/lib/proxysql #465
• disabled "smart" handling of COMMIT/ROLLBACK/autocommit #469

v1.1.1-beta.2

Compared to v1.1.0:

Enhancements:

• improves performance reducing the calls to poll() : #459
• includes better support for Galera : #380
• compiles on FreeBSD
• compiles with clang
• has new variable client_found_rows : #445
• implements compression on backend : #363
• handles more gracefully a complete failure of backends : #461
• improves performance reducing the number of tasks performed on every MySQL_Thread loop : 97b3f3d
• upgrade SQLite3 from 3.8.4 to 3.9.2 : 6b05743
• COMMITs and ROLLBACKs are forwarded to backend only of a transaction is active : 439087d
• added several counters in mysql status : ab3b737
• in case of crash it signals again itself to generate a core dump : 57b4512

Enhancement that are also incompatible changes:

• cache_ttl is in Query Cache is now in milliseconds : #452
• table stats_mysql_query_digest stores also hostgroup : #446

Bug fixes:

• Query Cache now supports distinct entries based on user/schema : 5eff88f
• fixed a small typo that prevented query rules to be loaded from config file : 87dbb9b
• signals handlers were installed on the parent process and not on the child process : b519c94
• fix length for parsing and filtering SET AUTOCOMMIT : 3497160

Unfinished features.
These are features available in ProxySQL but yet not enabled as incomplete.

• MySQL_Logger now logs in a new format that is similar to MySQL protocol. This removes any reference to protobuf .