[gentoo-dev] RFC: mysql-5.5 upgrade and mysql-5.1 mask news item

[gentoo-dev] RFC: mysql-5.5 upgrade and mysql-5.1 mask news item

[Brian Evans]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Title: MySQL 5.5 upgrade procedures
Author: Brian Evans <grknight@gentoo.org>
Content-Type: text/plain
Posted: 2014-08-14
Revision: 1
News-Item-Format: 1.0
Display-If-Installed: <dev-db/mysql-5.5

MySQL 5.5 is now stable across all arches. The upgrade process
will be require you to rebuild everything linked to
libmysqlclient.so.16 and libmysqlclient_r.so.16.

This may be done for you by portage with 'emerge @preserved-rebuild'.

A small number of libraries may not be automatically rebuilt against
the new MySQL libraries using preserved-rebuild.  If you have
difficulties with packages not finding the new libraries, install
app-portage/gentoolkit and run:
# revdep-rebuild --library libmysqlclient.so.16
# revdep-rebuild --library libmysqlclient_r.so.16

The official upgrade documentation is available here:
http://dev.mysql.com/doc/refman/5.5/en/upgrading.html

Please be sure to review the upgrade document for any possible actions
necessary before and after the upgrade. This includes running
mysql_upgrade after the upgrade completion.

Due to security flaws, MySQL 5.1 will be hard masked in 30 days after
this news item is posted.  It will remain in masked the tree for
3 months before removal.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (MingW32)

iQEcBAEBAgAGBQJT7RTxAAoJEE4V4vFnx44dC/YH/3jiU/9kSfqaLoAkLXIcegFM
b2us23rUXI0+Xws9otkq0kX4Zl+a/nrDmouB8+jh6OISbUt8/sif1JEvH+PO8xID
o0jJEgqslhCN5qUMtvSOMz5Dxrx2OwREM4s/EsDWV4wprW8M9auA5ZOl1Fm/HVtJ
eJwDVCE/fHyN8nYgNRxau/01dKdu35kfu4Q+KOfUaq9I55w2M+xb9SVkc6UZFB7R
xqh1zQhXpCzZbjZDrIkuEU23olUiTFB2e4eH9P6H9IghhFWZ+fa8NjTwCrSiwKvq
UOX+dodmklmCfgATVxAsxWEKPzyRomoeqHw9BdXZ2K6Xqm+wKux0ySmjen0eN3Q=
=r3DL
-----END PGP SIGNATURE-----

Re: [gentoo-dev] RFC: mysql-5.5 upgrade and mysql-5.1 mask news item

[Maxim Koltsov]

[-- Attachment #1: Type: text/plain, Size: 2027 bytes --]

2014-08-14 23:58 GMT+04:00 Brian Evans <grknight@gentoo.org>:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Title: MySQL 5.5 upgrade procedures
> Author: Brian Evans <grknight@gentoo.org>
> Content-Type: text/plain
> Posted: 2014-08-14
> Revision: 1
> News-Item-Format: 1.0
> Display-If-Installed: <dev-db/mysql-5.5
>
> MySQL 5.5 is now stable across all arches. The upgrade process
> will be require you to rebuild everything linked to
> libmysqlclient.so.16 and libmysqlclient_r.so.16.
>
> This may be done for you by portage with 'emerge @preserved-rebuild'.
>
> A small number of libraries may not be automatically rebuilt against
> the new MySQL libraries using preserved-rebuild.  If you have
> difficulties with packages not finding the new libraries, install
> app-portage/gentoolkit and run:
> # revdep-rebuild --library libmysqlclient.so.16
> # revdep-rebuild --library libmysqlclient_r.so.16
>
>
Random question: why isn't it covered by subslots?


> The official upgrade documentation is available here:
> http://dev.mysql.com/doc/refman/5.5/en/upgrading.html
>
> Please be sure to review the upgrade document for any possible actions
> necessary before and after the upgrade. This includes running
> mysql_upgrade after the upgrade completion.
>
> Due to security flaws, MySQL 5.1 will be hard masked in 30 days after
> this news item is posted.  It will remain in masked the tree for
> 3 months before removal.
>

I guess you meant 'remain masked in the tree' or 'remain in the tree
masked'.

-----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.17 (MingW32)
>
> iQEcBAEBAgAGBQJT7RTxAAoJEE4V4vFnx44dC/YH/3jiU/9kSfqaLoAkLXIcegFM
> b2us23rUXI0+Xws9otkq0kX4Zl+a/nrDmouB8+jh6OISbUt8/sif1JEvH+PO8xID
> o0jJEgqslhCN5qUMtvSOMz5Dxrx2OwREM4s/EsDWV4wprW8M9auA5ZOl1Fm/HVtJ
> eJwDVCE/fHyN8nYgNRxau/01dKdu35kfu4Q+KOfUaq9I55w2M+xb9SVkc6UZFB7R
> xqh1zQhXpCzZbjZDrIkuEU23olUiTFB2e4eH9P6H9IghhFWZ+fa8NjTwCrSiwKvq
> UOX+dodmklmCfgATVxAsxWEKPzyRomoeqHw9BdXZ2K6Xqm+wKux0ySmjen0eN3Q=
> =r3DL
> -----END PGP SIGNATURE-----
>
>

[-- Attachment #2: Type: text/html, Size: 2961 bytes --]

Re: [gentoo-dev] RFC: mysql-5.5 upgrade and mysql-5.1 mask news item

[Maxim Koltsov]

[-- Attachment #1: Type: text/plain, Size: 2027 bytes --]

2014-08-14 23:58 GMT+04:00 Brian Evans <grknight@gentoo.org>:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Title: MySQL 5.5 upgrade procedures
> Author: Brian Evans <grknight@gentoo.org>
> Content-Type: text/plain
> Posted: 2014-08-14
> Revision: 1
> News-Item-Format: 1.0
> Display-If-Installed: <dev-db/mysql-5.5
>
> MySQL 5.5 is now stable across all arches. The upgrade process
> will be require you to rebuild everything linked to
> libmysqlclient.so.16 and libmysqlclient_r.so.16.
>
> This may be done for you by portage with 'emerge @preserved-rebuild'.
>
> A small number of libraries may not be automatically rebuilt against
> the new MySQL libraries using preserved-rebuild.  If you have
> difficulties with packages not finding the new libraries, install
> app-portage/gentoolkit and run:
> # revdep-rebuild --library libmysqlclient.so.16
> # revdep-rebuild --library libmysqlclient_r.so.16
>
>
Random question: why isn't it covered by subslots?


> The official upgrade documentation is available here:
> http://dev.mysql.com/doc/refman/5.5/en/upgrading.html
>
> Please be sure to review the upgrade document for any possible actions
> necessary before and after the upgrade. This includes running
> mysql_upgrade after the upgrade completion.
>
> Due to security flaws, MySQL 5.1 will be hard masked in 30 days after
> this news item is posted.  It will remain in masked the tree for
> 3 months before removal.
>

I guess you meant 'remain masked in the tree' or 'remain in the tree
masked'.

-----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.17 (MingW32)
>
> iQEcBAEBAgAGBQJT7RTxAAoJEE4V4vFnx44dC/YH/3jiU/9kSfqaLoAkLXIcegFM
> b2us23rUXI0+Xws9otkq0kX4Zl+a/nrDmouB8+jh6OISbUt8/sif1JEvH+PO8xID
> o0jJEgqslhCN5qUMtvSOMz5Dxrx2OwREM4s/EsDWV4wprW8M9auA5ZOl1Fm/HVtJ
> eJwDVCE/fHyN8nYgNRxau/01dKdu35kfu4Q+KOfUaq9I55w2M+xb9SVkc6UZFB7R
> xqh1zQhXpCzZbjZDrIkuEU23olUiTFB2e4eH9P6H9IghhFWZ+fa8NjTwCrSiwKvq
> UOX+dodmklmCfgATVxAsxWEKPzyRomoeqHw9BdXZ2K6Xqm+wKux0ySmjen0eN3Q=
> =r3DL
> -----END PGP SIGNATURE-----
>
>

[-- Attachment #2: Type: text/html, Size: 2961 bytes --]

Re: [gentoo-dev] RFC: mysql-5.5 upgrade and mysql-5.1 mask news item

[Brian Evans]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 8/14/2014 4:03 PM, Maxim Koltsov wrote:
> 
> 
> 
> 2014-08-14 23:58 GMT+04:00 Brian Evans <grknight@gentoo.org 
> <mailto:grknight@gentoo.org>>:
> 
> Title: MySQL 5.5 upgrade procedures Author: Brian Evans
> <grknight@gentoo.org <mailto:grknight@gentoo.org>> Content-Type:
> text/plain Posted: 2014-08-14 Revision: 1 News-Item-Format: 1.0 
> Display-If-Installed: <dev-db/mysql-5.5
> 
> MySQL 5.5 is now stable across all arches. The upgrade process will
> be require you to rebuild everything linked to libmysqlclient.so.16
> and libmysqlclient_r.so.16.
> 
> This may be done for you by portage with 'emerge
> @preserved-rebuild'.
> 
> A small number of libraries may not be automatically rebuilt
> against the new MySQL libraries using preserved-rebuild.  If you
> have difficulties with packages not finding the new libraries,
> install app-portage/gentoolkit and run: # revdep-rebuild --library
> libmysqlclient.so.16 # revdep-rebuild --library
> libmysqlclient_r.so.16
> 
> 
>> Random question: why isn't it covered by subslots?

1) The old virtual was EAPI2
2) This is long overdue by a year at least
3) Only 2 packages in the tree currently have virtual/mysql:=

This will be corrected in the future as 5.6 now has subslots.

> 
> 
> The official upgrade documentation is available here: 
> http://dev.mysql.com/doc/refman/5.5/en/upgrading.html
> 
> Please be sure to review the upgrade document for any possible
> actions necessary before and after the upgrade. This includes
> running mysql_upgrade after the upgrade completion.
> 
> Due to security flaws, MySQL 5.1 will be hard masked in 30 days
> after this news item is posted.  It will remain in masked the tree
> for 3 months before removal.
> 
> 
>> I guess you meant 'remain masked in the tree' or 'remain in the
>> tree masked'.

Yes, sorry.  I'm not the best writer in the world.  At least in code I
can fake it.

Brian

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (MingW32)

iQEcBAEBAgAGBQJT7RdaAAoJEE4V4vFnx44dq28H/2iZ8Y1vVOoFlYardBH3/C3h
mjfEJe4tg1RNlNfa+pCJxZ4nt9thYMqKriG1olfIu2C3rJWDKR0NlDOh4BXrX24n
baYm0lzCoOpftZeI3JtaL3bS0cMwkt7e/HtuOmCy87ZXPQoou5Eq9FtNfchMRKfT
lW06bWHo/swwUShQtMWWQK6X5a1ZX2JOHK9xvjl2yrBLAx22zijVR4LOOeC28JYO
wZrVworD2HLw64Xs14PDKGfc+5eFtJ9gSItLr2dfYqBrqY7LBd19G0QNASvj0t1n
rpAwZC6Lx5oKm7WicRz/HMeX2A35x1JAigi87hlQTzyR/YCtXyEy9bT9YFoe0WM=
=I/W7
-----END PGP SIGNATURE-----

Re: [gentoo-dev] RFC: mysql-5.5 upgrade and mysql-5.1 mask news item

[Tom Wijsman]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 14 Aug 2014 15:58:41 -0400
Brian Evans <grknight@gentoo.org> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Title: MySQL 5.5 upgrade procedures
> Author: Brian Evans <grknight@gentoo.org>
> Content-Type: text/plain
> Posted: 2014-08-14
> Revision: 1
> News-Item-Format: 1.0
> Display-If-Installed: <dev-db/mysql-5.5
> 
> MySQL 5.5 is now stable across all arches. The upgrade process
> will be require you to rebuild everything linked to [...]
       ^^
       This word 'be' should be removed.

The other typo has already mentioned, as well as a question asked; so,
apart from that the rest of the news item looks good to me.

- -- 
With kind regards,

Tom Wijsman (TomWij)
Gentoo Developer

E-mail address  : TomWij@gentoo.org
GPG Public Key  : 6D34E57D
GPG Fingerprint : C165 AF18 AB4C 400B C3D2  ABF0 95B2 1FCD 6D34 E57D
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iQEcBAEBAgAGBQJT7RiqAAoJEPWZc8roOL/QWD4H/jeGkrKHalQIVMw2Db51XKKd
EumDXKuH9V8Ua7pp8733yl7MufvhEFd5JT+XmQvscMtxEbuYsREbk1c2SNldFSwp
pCPbSjkUaVg0Mo2bnzB1aFxliTMIB2ui+lt/8gIuTK/V1Be1JGJmTrQuzf+8sVgh
xVy9WSuVTi99i7m5EFaMoZ65Kyj8Xmb69gB0gZFpc9Hydn3zpGNtd9kRbYiAHy/T
/xgUoj0KU5o2WZ8tElsfp/su2KHjhF2JGRSN4+rw11nD1Om+k7//IgYSkZDYrqi8
NWFGuiG8EB6sRttIhCzH6CtUlMjB2ZU8hT8aLloqmluFxmHDheuP/BbSee1EJ30=
=zv9o
-----END PGP SIGNATURE-----

Re: [gentoo-dev] RFC: mysql-5.5 upgrade and mysql-5.1 mask news item

[Manuel Rüger]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

On 08/14/2014 09:58 PM, Brian Evans wrote:
> Display-If-Installed: <dev-db/mysql-5.5

Display also if <virtual/mysql-5.5 ?

Maybe you can add an additional note that mariadb is now the
recommended mysql package?


Cheers,

Manuel
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0

iQJ8BAEBCgBmBQJT7SBeXxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w
ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXQ4MDA1RERERkM0ODM2QkE4MEY3NzY0N0M1
OEZCQTM2QzhEOUQ2MzVDAAoJEFj7o2yNnWNc9gwP/RFJ1EfTd2BsaoSNy7arE6AX
uBt0SC9k7iPcC3fT0qEd39Zr3fRyuphQltef+BytTlGvWORpnca5y99XUEqt9Xoq
/EgXnQ3CjAQQQe3zn5D78sOaTLxP0rh7Obu0kA1hDhgjT7244WMye5Srof8VkdPz
AArcsGBYU6Wj1j+3FmAMh3IbCeojS5WqAm2b+ur111WYulOG7Y0Z3r+YRN4OzTsm
iF8e92/PBwtOywEFCP3wOPZKCaZ0lvNs8QoD6XvYqodLdmo/caLj16N+VxAFb77c
2JVUyTOxGwmYh5j22pBpU9hbRo6zDikTQZudAyq6EWXrxTs2DRLPMhXVp+B8RGjR
55hFPlcjaHmwF9CZMsLF0Yi5AaVXGVcRuHroMdPyxY0dyI9OGcpEXXZRiKpc34Ro
WJiHf16ojaaNoFYoYR0X9X+0zbgnemwo9ULHeKo6lINEV508Y6U1qilB+VYwXc3X
J2hBb3Dg1+bpRGVkOh06FscDzubE0CobAmWkgpmXrYevSQvzC4FKe+DZbg3kTYbB
iC6Z+ZScUG4ncaQpiWHksl185Xc2Cc/3q4T33kD044ZiQbiQnTuj0bapVkf6RcAa
aH8AhrcZHSbaM19ADHhIPZf+T7TyYpDSxlP2QMlTZfs6rxIbiHUFfiijHj0ExO2c
dS415hDgMyULIM5cUQ7q
=/Uj4
-----END PGP SIGNATURE-----

Re: [gentoo-dev] RFC: mysql-5.5 upgrade and mysql-5.1 mask news item

[Brian Evans]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 8/14/2014 4:47 PM, Manuel Rüger wrote:
> On 08/14/2014 09:58 PM, Brian Evans wrote:
>> Display-If-Installed: <dev-db/mysql-5.5
> 
> Display also if <virtual/mysql-5.5 ?
Not sure if this is needed as mariadb was never stable before.
I would expect most people using it were updating as the ~arch
versions progressed.

> 
> Maybe you can add an additional note that mariadb is now the 
> recommended mysql package?

This doesn't seem appropriate for an update news.  Maybe more for the
Gentoo Monthly Newsletter.  If dev-db/mysql is upgraded, they won't
get mariadb unless they actively switch.

While you can do some swap back initially, once you start using unique
features, it is hard to swap.  This will be even more true in 5.6/10.0
with GTID replication which is not compatible. (Must be enabled by the
admin by hand, not automatic.)

Brian
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (MingW32)

iQEcBAEBAgAGBQJT7iA/AAoJEE4V4vFnx44dkzEIAIr0XC4F1i4a1YciCdPwlEaB
NSOLPLsy90wikIFEH/PZgFDLyMG+LiCPW3hERT/jpQQ1YbKBv33dO60+8mskhax7
dUpVenKhcDXFM5CYauFr8bjDCqsRY05M4Mecn7in5mxZbRjD6B2q68acbLUY1yCf
MQ+62mg1VQJIhbtPTAOKEIPefJWYupFgJfv45Qpw4gbN315wUx6YPCAvVPcJ7LIS
FPUakDUWvaUrgvjgWcZA1dyZumLa4ggk1DyUegx3eg/hwLsEukSH2rI2r74eVePx
EtMJDKf/j5xdOC3E7x8cTepVehl4/rWzi4qK8TtQK94G8CPpgE/rbA3JJG4ro10=
=UJmc
-----END PGP SIGNATURE-----