930692 - mrepo: add 'mysql56' repo mirrored from Oracle MySQL 5.6 repo

Status: RESOLVED FIXED

(Infrastructure & Operations :: Infrastructure: Puppet, task)

Description

[Sheeri Cabral [:sheeri]]

MySQL now has repos for MySQL 5.6, as announced on October 15th. So we should change around puppet.....

Comment 1

[:Atoll]

I checked the Oracle yum site but they're still only offering MySQL 5.5 for OL6 (which hopefully is compatible with EL6):

http://public-yum.oracle.com/repo/OracleLinux/OL6/MySQL/x86_64/

:sheeri is following up with her source to find out where the new repository is at, so we can begin mirroring it.

Comment 2

[Sheeri Cabral [:sheeri]]

It's been announced! http://insidemysql.com/announcing-new-yum-repositories-for-mysql/

Comment 3

[:Atoll]

Attachment: add mysql56 repo mirroring from Sun

Their repo RPM contains the below entry, which I've converted to puppet syntax in this attachment. If everything looks good, we can try shipping it. Hopefully they permit mirroring :)

$ cat etc/yum.repos.d/mysql-community.repo 
[mysql-community]
name=MySQL Community Server 
baseurl=http://repo.mysql.com/yum/mysql-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

Comment 4

[Sheeri Cabral [:sheeri]]

looks good to me! ship it!

Comment 5

[Sheeri Cabral [:sheeri]]

So the one comment I have is that the repo mirroring is from Oracle, not Sun. Sun hasn't existed in three and a half years :D

Comment 6

[:Atoll]

(In reply to Sheeri Cabral [:sheeri] from comment #5)
> So the one comment I have is that the repo mirroring is from Oracle, not
> Sun. Sun hasn't existed in three and a half years :D

Good catch, is that issue only present in the attachment title? I looked over the patch and I think I avoided saying Sun elsewhere.

Comment 7

[Sheeri Cabral [:sheeri]]

Comment on attachment 824034 [details] [diff] [review]
add mysql56 repo mirroring from Sun

Review of attachment 824034 [details] [diff] [review]:
-----------------------------------------------------------------

Looks good to me!

Comment 8

[:Atoll]

Pushed with syntax fixes, r77454. However, mirroring fails as Oracle prohibits directory indexes of their Yum repo. We'll either need to switch to reposync or ask them to fix it. (Removing private flag for that purpose.)

To do this, we'll have to realize() the mysql-community repo on mrepo servers with enabled => 0, and then configure mrepo to use the 'reposync' method rather than the default http method.

Comment 9

[:Atoll]

Attachment: change http://repo.mysql.com to reposync://repo.mysql.com

Looking at the reposync implementation [1] it seems that we just replace 'http://' with 'reposync://' and mrepo does all the rest, including generating a temporary yum.conf and handling everything for us. Terrific!

The relevant defaults are:

 +## Delete packages that are no longer in the repo
 +reposync-cleanup = yes
 +
 +## Only download the latest packages
 +reposync-newest-only = no

And we can change those as needed once this actually works. Proposed patch attached.

[1] https://github.com/dagwieers/mrepo/commit/9fa1de464cef41de0cb07b807dee410771d98177

Comment 10

[:Atoll]

Topic revised to reflect the Infra side of this task only - we'll do the removal of the old repo(s) someday in the future when they're no longer in use.

Comment 11

[:Atoll]

Comment on attachment 827088 [details] [diff] [review]
change http://repo.mysql.com to reposync://repo.mysql.com

r77535 and it seems to be running without errors, at least, which is an improvement over before. Need to check back tomorrow to see if the repo mirrored correctly for i386/x86_64.

Comment 12

[Brian Hourigan [:digi]]

It looks like this repo is working properly - can this bug be closed?