** 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 + 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 + + [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 (all in main): + - 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] - - same as mysql-server-8 + - 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) - - no exotic hardware - - debian/watch file is present - - do not rely on obsolete package dependencies - - owning team: ubuntu-server - - bugs: ubuntu-server will be triaging all bugs + + - ubuntu-server will subscribe for package maintenance [Background information] MySQL Router is part of InnoDB cluster, and is lightweight middleware that provides transparent routing between a application and back-end 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 back-end MySQL Servers.
** 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 [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 part of InnoDB cluster, and is lightweight middleware - that provides transparent routing between a application and back-end - MySQL Servers. + 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. - 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 back-end MySQL Servers. + 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
