CentOS - Aug 2014 - How to update MySQL with CentOS 6 in most unintrusive way - in regard to perl and PHP packages

Dear fellow CentOS users,

for my few hobby projects (web games + forums) I have been using CentOS 5
(then 6) with Drupal and PostgreSQL plus few custom PHP and Perl scripts
written by mysef.

Since PostgreSQL version delivered with CentOS package has been a bit
dated, I always used the PGDG packages:

    # rpm -qa | grep -i pgdg

    pgdg-centos93-9.3-1.noarch
    postgresql93-9.3.5-1PGDG.rhel6.i686
    postgresql93-libs-9.3.5-1PGDG.rhel6.i686
    postgresql93-server-9.3.5-1PGDG.rhel6.i686

As a web developer this has been a very pleasant experience, since (by some
great magic) all the other CentOS packages (like php-pgsql and perl-DBD-Pg)
just worked with the PGDG packages.

Now I have decided to switch to WordPress for my new projects and am
(sadly) forced to switch the database too:

I have to use MySQL or MariaDB with CentOS 6.5.

So my question is: if anybody can recommend a similarly comfortable package
repository for MySQL/MariaDB - which wouldn't mess up any other CentOS
packages and which would update itself (with "yum update").

And please do not suggest something like Fedora or EPEL repositories,
because other than for MySQL/MariaDB I would like not to add any additional
packages to have my server as "stable" as possible.

Thank you for any hints
Alex

On Tue, Aug 05, 2014 at 03:10:47PM +0200, Alexander Farber
wrote:
>Dear fellow CentOS users,
>
>for my few hobby projects (web games + forums) I have been using CentOS 5
>(then 6) with Drupal and PostgreSQL plus few custom PHP and Perl scripts
>written by mysef.
>
>Since PostgreSQL version delivered with CentOS package has been a bit
>dated, I always used the PGDG packages:
>
>    # rpm -qa | grep -i pgdg
>
>    pgdg-centos93-9.3-1.noarch
>    postgresql93-9.3.5-1PGDG.rhel6.i686
>    postgresql93-libs-9.3.5-1PGDG.rhel6.i686
>    postgresql93-server-9.3.5-1PGDG.rhel6.i686
>
>As a web developer this has been a very pleasant experience, since (by some
>great magic) all the other CentOS packages (like php-pgsql and perl-DBD-Pg)
>just worked with the PGDG packages.
>
>Now I have decided to switch to WordPress for my new projects and am
>(sadly) forced to switch the database too:
>
>I have to use MySQL or MariaDB with CentOS 6.5.
>
>So my question is: if anybody can recommend a similarly comfortable package
>repository for MySQL/MariaDB - which wouldn't mess up any other CentOS
>packages and which would update itself (with "yum update").
>
>And please do not suggest something like Fedora or EPEL repositories,
>because other than for MySQL/MariaDB I would like not to add any additional
>packages to have my server as "stable" as possible.
>
>Thank you for any hints
>Alex
>_______________________________________________
>CentOS mailing list
>CentOS at centos.org
>http://lists.centos.org/mailman/listinfo/centos
Hi Alex,

MariaDB itself has RHEL/CentOS repos: 
https://mariadb.com/kb/en/mariadb/documentation/getting-started/getting-installing-and-upgrading-mariadb/mariadb-binary-packages/installing-mariadb-rpm-files/installing-mariadb-with-yum/

But you could limit EPEL repo to only include MariaDB packages and deps with  
'includepkgs=' directive in the /etc/yum.repos.d/epel.repo config file,
like

   [epel]
   ... default stuff ...
   includepkgs=MariaDB-* some-deps-package

See example here: 
http://wiki.centos.org/AdditionalResources/Repositories/CentOSPlus

Regards,
Martin

On Tue, Aug 5, 2014 at 8:10 AM, Alexander Farber
<alexander.farber at gmail.com> wrote:
>>
> Now I have decided to switch to WordPress for my new projects and am
> (sadly) forced to switch the database too:
>
> I have to use MySQL or MariaDB with CentOS 6.5.
>
> So my question is: if anybody can recommend a similarly comfortable package
> repository for MySQL/MariaDB - which wouldn't mess up any other CentOS
> packages and which would update itself (with "yum update").
If you are making changes, why not just move to CentOS7 which will
include reasonably current packages?
> And please do not suggest something like Fedora or EPEL repositories,
> because other than for MySQL/MariaDB I would like not to add any additional
> packages to have my server as "stable" as possible.
I wouldn't lump fedora and EPEL in the same sentence like that.
There is very little risk from adding packages from EPEL.  On the
other hand, because they have a policy of not overwriting base
packages, you won't find a newer mysql package there.

-- 
   Les Mikesell
     lesmikesell at gmail.com

On 08/05/2014 03:10 PM, Alexander Farber wrote:
> So my question is: if anybody can recommend a similarly comfortable package
> repository for MySQL/MariaDB - which wouldn't mess up any other CentOS
> packages and which would update itself (with "yum update").

check out the SCL:
http://wiki.centos.org/AdditionalResources/Repositories/SCL

Documentation on this repo:
https://access.redhat.com/site/documentation/en-US/Red_Hat_Software_Collections/1/html-single/1.0_Release_Notes/index.html