IBM i

 View Only
  • 1.  Mariadb and Mysql on same AIX server.

    Posted Thu March 03, 2022 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 Thu March 03, 2022 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 Tue April 12, 2022 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
    ------------------------------



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

    Posted Wed April 13, 2022 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
    ------------------------------