IBM i Global

IBM i 

A space for professionals working with IBM’s integrated OS for Power systems to exchange ideas, ask questions, and share expertise on topics like RPG and COBOL development, application modernization, open source integration, system administration, and business continuity.


#Power


#IBMi
#Power
#Operatingsystems
#Servers
 View Only

  • 1.  Mariadb and Mysql on same AIX server.

    Posted 03/03/22 10:15 AM
    Hi All,

    Can we install mariadb and mysql on same server. I tried installing mariab on server with mysql and i got below confilct error.

    rpm -Uvh mariadb-10.4.18-1.aix7.2.ppc.rpm

    error: Failed dependencies:

            community-mysql conflicts with mariadb-3:10.4.18-1.ppc

            mariadb conflicts with (installed) community-mysql-8.0.20-1.ppc


    Regards,
    Karthik



    ------------------------------
    Karthik R
    ------------------------------


  • 2.  RE: Mariadb and Mysql on same AIX server.

    Posted 03/03/22 12:40 PM
    That sounds reasonable ... mariadb is supposed to be the ongoing replacement for mysql. The mariadb python driver works with either. To my understanding, you should be able to access your mysql database using mariadb and there is no reason to use mysql. But try it out on a test LPAR to be sure!!

    ------------------------------
    Jack Woehr
    IBM Champion 2021 -2022
    ------------------------------



  • 3.  RE: Mariadb and Mysql on same AIX server.

    Posted 04/12/22 06:07 AM
    Hi Team,

    I have used the AIX7,2 Mariab RPM since our OS version in tha machine is 7.2.0 still mysql version shows as 7.1.

     

    co51sv01> mysql --version
    /opt/freeware/bin/mysql Ver 15.1 Distrib 10.4.18-MariaDB, for AIX7.1 (powerpc) using readline 5.1
    co51sv01>

     

    OS Version:

     

    co51sv01> oslevel
    7.2.0.0
    co51sv01>

     

    RPM USED

    > ls -lrt *mariadb*

    -rwxrwxrwx    1 ekarrag  config     12819708 Feb 25 09:45 mariadb-10.4.18-1.aix7.2.ppc.rpm

    -rwxrwxrwx    1 ekarrag  config     32020978 Feb 25 09:47 mariadb-server-10.4.18-1.aix7.2.ppc.rpm

    -rwxrwxrwx    1 ekarrag  config       113498 Feb 25 09:56 mariadb-common-10.4.18-1.aix7.2.ppc.rpm

    -rwxrwxrwx    1 ekarrag  config       812722 Feb 25 09:56 mariadb-errmsg-10.4.18-1.aix7.2.ppc.rpm

    -rwxrwxrwx    1 ekarrag  config       339948 Feb 25 11:31 mariadb-connector-c-3.1.9-1.aix7.2.ppc.rpm

    zeus:/pt/karthik/mariadb>

    Regards,

    Karthik



    ------------------------------
    Karthik R
    ------------------------------

    Original Message


  • 4.  RE: Mariadb and Mysql on same AIX server.

    Posted 04/13/22 02:42 AM
    Hi

    When running workload in PASE you run them actually in an AIX OS with access to i/OS. PASE for IBM® i 7.2 is derived from AIX® 7.1, Technology Level 1. So mysql --version is actually showing the correct OS version. AIX version change throughout i/OS level. You may start here (https://www.ibm.com/docs/en/i/7.2?topic=pi-whats-new-i-72) and switch the OS level in the left pane.



    ------------------------------
    Markus Neuhold
    ------------------------------

    Original Message


Related Content