** Description changed: [Availability] All mysql-server-8 binary packages are already in main, but mysql- router, mysql-testsuite and mysql-source-8. From those, mysql-router should be in main judging its importance to mysql setups: upstream: - https://github.com/mysql/mysql-server/tree/8.0/router rmadison: mysql-router | 8.0.17-0ubuntu2 | eoan/universe amd64, arm64, armhf, i386, ppc64el, s390x mysql-router | 8.0.17-0ubuntu3 | focal/universe amd64, arm64, armhf, i386, ppc64el, s390x [Rationale] Before mysql-server-8, mysql-router wasn't part of the upstream mysql- server source. It got included from commit: commit 07f77542cb3 Author: Andrzej Religa <andrzej.rel...@oracle.com> Date: Fri Aug 10 13:45:46 2018 wl#10799 integrate MySQL Router into MySQL Server repository describe: mysql-8.0.12-77027-g07f77542cb3 Before that the last available mysql-router was: (mysql-router-2.1.6.tar.gz) distributed apart from the main mysql-server code. [Security] Couldn't find any cve specific to mysql-router in: - cve.mitre.org (only mysql-server CVEs) - www.openwall.com (only mysql-server CVEs) - binaries usr/bin/mysqlrouter_plugin_info usr/bin/mysqlrouter usr/bin/mysqlrouter_passwd - no suid/sgid bits - no services - mysql-router default ports: 6446/tcp 6447/tcp 3306/tcp 6448/tcp 6449/tcp 33060/tcp https://dev.mysql.com/doc/mysql-port-reference/en/ mysql-ports-reference-tables.html [Quality assurance] - source as mysql-server-8, binary is still in universe - possible to config based on documentation - do not ask debconf questions by default - no long-term outstanding bugs (mysql behind) - important bugs / upstream supportability: - ubuntu pushing new debian mysql-server pkgs (tks to @rbasak). - mysql-server-8 is already in main - contains tests: <source>/router/tests - uses debian/watch - does not rely on obsolete packages - no exotic hardware + bugs since it was G/A (2018-04-19) + + https://dev.mysql.com/doc/relnotes/mysql-router/en/news-8-0-x.html + + All MySQL Router BUGS in upstream community: + (ordered by version, only 8.0.xx matter, as they were GA) + + https://tinyurl.com/vvkx46q + [UI standards] N/A [Dependencies] pool/main/g/glibc/libc6_2.30-0ubuntu2_amd64.deb pool/main/libe/libevent/libevent-core-2.1-7_2.1.11-stable-1_amd64.deb pool/main/libe/libevent/libevent-extra-2.1-7_2.1.11-stable-1_amd64.deb pool/main/g/gcc-9/libgcc1_9.2.1-19ubuntu1_amd64.deb pool/main/g/gcc-9/libgcc-9-dev_9.2.1-19ubuntu1_amd64.deb pool/main/o/openssl/libssl1.1_1.1.1c-1ubuntu4_amd64.deb pool/main/g/gcc-9/libstdc++6_9.2.1-19ubuntu1_amd64.deb pool/main/z/zlib/zlib1g_1.2.11.dfsg-1ubuntu3_amd64.deb - recommends: pool/main/libi/libidn2/libidn2-0_2.2.0-2_amd64.deb pool/main/g/glibc/libc6-dev_2.30-0ubuntu2_amd64.deb All dependencies are in main. [Standards compliance] - Meets FHC (https://en.wikipedia.org/wiki/Filesystem_Hierarchy_Standard) - Same Debian policy standards are mysql-server. [Maintenance] - well maintained in Debian/Ubuntu (will be maintained with mysql-server-8) - ubuntu-server will subscribe for package maintenance [Background information] MySQL Router is lightweight middleware that provides transparent routing between your application and any backend MySQL Servers. It can be used for a wide variety of use cases, such as providing high availability and scalability by effectively routing database traffic to appropriate backend MySQL Servers. The pluggable architecture also enables developers to extend MySQL Router for custom use cases. Failover Typically, a highly available MySQL setup consists of a single master and multiple slaves and it is up to the application to handle failover, in case the MySQL master becomes unavailable. Using MySQL Router, application connections will be transparently routed based on load balancing policy, without implementing custom application code. Load Balancing MySQL Router provides additional scalability and performance by distributing database connections across a pool of servers. For example, if you have a replicated set of MySQL Servers, MySQL Router can distribute application connections to them in a round-robin fashion.
** Description changed: [Availability] All mysql-server-8 binary packages are already in main, but mysql- router, mysql-testsuite and mysql-source-8. From those, mysql-router should be in main judging its importance to mysql setups: upstream: - https://github.com/mysql/mysql-server/tree/8.0/router rmadison: mysql-router | 8.0.17-0ubuntu2 | eoan/universe amd64, arm64, armhf, i386, ppc64el, s390x mysql-router | 8.0.17-0ubuntu3 | focal/universe amd64, arm64, armhf, i386, ppc64el, s390x + + There are juju charms already relying on it: + + https://github.com/openstack/charm-mysql-router/tree/master/src + + being actively developed. [Rationale] Before mysql-server-8, mysql-router wasn't part of the upstream mysql- server source. It got included from commit: commit 07f77542cb3 Author: Andrzej Religa <andrzej.rel...@oracle.com> Date: Fri Aug 10 13:45:46 2018 wl#10799 integrate MySQL Router into MySQL Server repository describe: mysql-8.0.12-77027-g07f77542cb3 Before that the last available mysql-router was: (mysql-router-2.1.6.tar.gz) distributed apart from the main mysql-server code. [Security] Couldn't find any cve specific to mysql-router in: - cve.mitre.org (only mysql-server CVEs) - www.openwall.com (only mysql-server CVEs) - binaries usr/bin/mysqlrouter_plugin_info usr/bin/mysqlrouter usr/bin/mysqlrouter_passwd - no suid/sgid bits - no services - mysql-router default ports: 6446/tcp 6447/tcp 3306/tcp 6448/tcp 6449/tcp 33060/tcp https://dev.mysql.com/doc/mysql-port-reference/en/ mysql-ports-reference-tables.html [Quality assurance] - source as mysql-server-8, binary is still in universe - possible to config based on documentation - do not ask debconf questions by default - no long-term outstanding bugs (mysql behind) - important bugs / upstream supportability: - ubuntu pushing new debian mysql-server pkgs (tks to @rbasak). - mysql-server-8 is already in main - contains tests: <source>/router/tests - uses debian/watch - does not rely on obsolete packages - no exotic hardware bugs since it was G/A (2018-04-19) https://dev.mysql.com/doc/relnotes/mysql-router/en/news-8-0-x.html All MySQL Router BUGS in upstream community: (ordered by version, only 8.0.xx matter, as they were GA) https://tinyurl.com/vvkx46q [UI standards] N/A [Dependencies] pool/main/g/glibc/libc6_2.30-0ubuntu2_amd64.deb pool/main/libe/libevent/libevent-core-2.1-7_2.1.11-stable-1_amd64.deb pool/main/libe/libevent/libevent-extra-2.1-7_2.1.11-stable-1_amd64.deb pool/main/g/gcc-9/libgcc1_9.2.1-19ubuntu1_amd64.deb pool/main/g/gcc-9/libgcc-9-dev_9.2.1-19ubuntu1_amd64.deb pool/main/o/openssl/libssl1.1_1.1.1c-1ubuntu4_amd64.deb pool/main/g/gcc-9/libstdc++6_9.2.1-19ubuntu1_amd64.deb pool/main/z/zlib/zlib1g_1.2.11.dfsg-1ubuntu3_amd64.deb - recommends: pool/main/libi/libidn2/libidn2-0_2.2.0-2_amd64.deb pool/main/g/glibc/libc6-dev_2.30-0ubuntu2_amd64.deb All dependencies are in main. [Standards compliance] - Meets FHC (https://en.wikipedia.org/wiki/Filesystem_Hierarchy_Standard) - Same Debian policy standards are mysql-server. [Maintenance] - well maintained in Debian/Ubuntu (will be maintained with mysql-server-8) - ubuntu-server will subscribe for package maintenance [Background information] MySQL Router is lightweight middleware that provides transparent routing between your application and any backend MySQL Servers. It can be used for a wide variety of use cases, such as providing high availability and scalability by effectively routing database traffic to appropriate backend MySQL Servers. The pluggable architecture also enables developers to extend MySQL Router for custom use cases. Failover Typically, a highly available MySQL setup consists of a single master and multiple slaves and it is up to the application to handle failover, in case the MySQL master becomes unavailable. Using MySQL Router, application connections will be transparently routed based on load balancing policy, without implementing custom application code. Load Balancing MySQL Router provides additional scalability and performance by distributing database connections across a pool of servers. For example, if you have a replicated set of MySQL Servers, MySQL Router can distribute application connections to them in a round-robin fashion. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1852367 Title: [MIR] mysql-router (mysql-8.0) To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1852367/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
