Want to subscribe to topics you're interested in?
Become a Member

MariaDB Mariadb 5.5 in centminmod 123.08stable

Discussion in 'Install & Upgrades or Pre-Install Questions' started by pritam sinha, Oct 28, 2015.

  1. pritam sinha

    pritam sinha New Member

    12
    2
    3
    Oct 23, 2015
    Ratings:
    +2
    Local Time:
    5:36 AM
    1.9
    5.5
    I have install centminmod 123.08stable which has installed mariadb 10.x but i want to use mariadb 5.5 for compatibility with my script.

    Will change yum repo base url in /inc/mariadb_install.inc will do or i need to change more?
    baseurl = Index of /10.0/centos6-amd64
    to
    baseurl = Index of /5.5/centos6-amd64


    Please tell the best method.:)
     
  2. eva2000

    eva2000 Administrator Staff Member

    30,156
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    10:06 AM
    Nginx 1.13.x
    MariaDB 5.5
    unfortunately not advisable to downgrade.. as there's alot more to do as it's much more involved that just changing yum repos but i don't provide free support for such

    what compatibility issues ?
     
  3. pritam sinha

    pritam sinha New Member

    12
    2
    3
    Oct 23, 2015
    Ratings:
    +2
    Local Time:
    5:36 AM
    1.9
    5.5
    My script is not compatible with mariadb 10.x. So forced to downgrade.:(

    Is there no option?
    Or i just use centminmod 123.07 or mariadb.inc from 123.07 ? :D
     
  4. eva2000

    eva2000 Administrator Staff Member

    30,156
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    10:06 AM
    Nginx 1.13.x
    MariaDB 5.5
    probably best to make you script compatible - but you should outline what the incompatibility is, as mariadb is meant to be drop in replacement and very rare that i see incompatibility
    still won't fully help as improper downgrade can possibly corrupt your data
     
  5. pritam sinha

    pritam sinha New Member

    12
    2
    3
    Oct 23, 2015
    Ratings:
    +2
    Local Time:
    5:36 AM
    1.9
    5.5
    My script is old and fully compatible with mysql 5.1 ,works fine with mariadb 5.5 but not with 10.x. possibly due to some deprecated options in 10.x.

    I dont have much important data (still i have backed them up). I just want my script to run with mariadb.

    Please add backward compatibility options in next centminmod versions atleast for nginx,mariadb and php.
     
  6. eva2000

    eva2000 Administrator Staff Member

    30,156
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    10:06 AM
    Nginx 1.13.x
    MariaDB 5.5
    i won't be re-adding MariaDB 5.5 support as I don't have time to maintain that many versions as MariaDB 10 and 10.1 soon are already on the table with MySQL 5.7 much later
    if it's deprecated 10.x options in /etc/my.cnf then correct way is to check mysql error log which will tell you exactly which options are not supported so you can remove them from /etc/my.cnf

    which options are reported as deprecated for you ?