/ Register

Learn about Centmin Mod LEMP Stack today
Register Now

MariaDB MariaDB Versions

Discussion in 'Install & Upgrades or Pre-Install Questions' started by Itworx4me, Mar 4, 2019.

Tags:
Previous Thread Next Thread
Loading...
Page 1 of 2
  1. Mar 4, 2019 #1
    Itworx4me

    Itworx4me Premium Member Premium Member

    339
    35
    28
    Mar 14, 2017
    Ratings:
    +65
    Local Time:
    6:18 PM
    Nginx 1.27.4
    MariaDB 10.6.21
    With all the different branches of MariaDB. Which branch do you want to use and why?

    Thanks,
    Itworx4me
     
  2. Mar 4, 2019 #2
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:18 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    Generally newer performs better for some situations/work loads or has more enhanced features. But newer branches of MySQL, Percona or MariaDB generally focus on multi-threaded performance at expense of single threaded performance. So single threaded performance MariaDB 5.5 is faster than 10.x while 10.x faster for multi-threaded performance. More cpu thread/cores you have the better you're equipped to handle faster MariaDB 10.x branches multi-threaded workloads. MariaDB increment 10.0, 10.1, 10.2, 10.3 all focus on subsequently improving that multi-threaded performance to work better with high cpu core/thread count cpus. There is of course other new or enhanced features with newer branches alot centered around MySQL replication and InnoDB performance and scalability.

    Centmin Mod 123.09beta01 defaults to MariaDB 10.1 branch as it's what I tested the most my automatic MySQL optimisations based on server environment detection.

    If you have a spare test VPS/server, you can manually enable the 10.1 to 10.2 upgrade routine in 123.09beta01 but any issues short term or long term wise you find would need to be reported to me but only resolution for that test VPS is to reinstall CentOS as I currently wouldn't have enough spare time to look into any issues with upgrade process (same with MariaDB 10.2 to 10.3 routine). So be prepared to backup data files and databases and wipe the server if MariaDB 10.2 test upgrade doesn't work.

    On test VPS, you can enable Centmin Mod 123.09beta01's centmin.sh menu option 11 submenu option 6 to upgrade MariaDB 10.1.x branch to MariaDB 10.2.x branch by first setting in persistent config file at /etc/centminmod/custom_config.inc the variable BEFORE running centmin.sh
    Code (Text):
    ENABLE_MARIADBTENTWOUPGRADE='y'

    There's also a variable ENABLE_MARIADBTENTHREEUPGRADE='y' to enable MariaDB 10.2.x to 10.3.x upgrades which is only supported on CentOS 7.x for now due to reported issues with CentOS 6. Again do on test VPS/server only and not live production server as MariaDB 10.2 to 10.3 has had even less long term testing than MariaDB 10.1 to 10.2 process. If you run into problems, my only solution for you is to setup a new VPS/server and reinstall Centmin Mod and migrate your site data and MySQL data if intact (if not that restore from MySQL backups).
    Code (Text):
    ENABLE_MARIADBTENTHREEUPGRADE='y'


    Code (Text):
    --------------------------------------------------------
     Centmin Mod Menu 123.09beta01 centminmod.com
--------------------------------------------------------
1).  Centmin Install
2).  Add Nginx vhost domain
3).  NSD setup domain name DNS
4).  Nginx Upgrade / Downgrade
5).  PHP Upgrade / Downgrade
6).  XCache Re-install
7).  APC Cache Re-install
8).  XCache Install
9).  APC Cache Install
10). Memcached Server Re-install
11). MariaDB MySQL Upgrade & Management
12). Zend OpCache Install/Re-install
13). Install/Reinstall Redis PHP Extension
14). SELinux disable
15). Install/Reinstall ImagicK PHP Extension
16). Change SSHD Port Number
17). Multi-thread compression: pigz,pbzip2,lbzip2...
18). Suhosin PHP Extension install
19). Install FFMPEG and FFMPEG PHP Extension
20). NSD Install/Re-Install
21). Update - Nginx + PHP-FPM + Siege
22). Add Wordpress Nginx vhost + Cache Plugin
23). Update Centmin Mod Code Base
24). Exit
--------------------------------------------------------
Enter option [ 1 - 24 ] 11
--------------------------------------------------------

    Code (Text):
    --------------------------------------------------------
     MariaDB MySQL Upgrade & Management Sub-Menu
--------------------------------------------------------
0). Regenerate New MySQL Root User Password (local server)
1). MariaDB 5.2.x Branch Upgrade Only
2). MariaDB 5.2.x to MariaDB 5.5 YUM upgrade
3). MariaDB 5.5 to MariaDB 10.x YUM upgrade
4). MariaDB 5.5 to MariaDB 10.1.x YUM upgrade
5). MariaDB 10.x to MariaDB 10.1.x YUM upgrade
6). MariaDB 10.1.x to MariaDB 10.2.x YUM upgrade
7). MariaDB 10.2.x to MariaDB 10.3.x YUM upgrade
8). Back to Main menu
--------------------------------------------------------
Enter option [ 0 - 8 ] 6
--------------------------------------------------------

    Code (Text):
    -------------------------------------------------------------------------------
 This script's MariaDB 10.2.x upgrade process is still in beta testing stages.
 So please test on a test server and not a live production server. But if you use
 on live server or if MySQL databases already exist, please back them up before
 running this upgrade script via mysqldump - instructions at:
 http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html.

 ###################################################################
 ###          IMPORTANT MYSQLDUMP BACKUP BEFORE UPGRADE          ###
 ###        OR RISK DATA LOSS DUE TO MARIADB 10.2 Changes        ###
 ###################################################################

 For each DATABASENAME backup via mysqldump i.e.

  mysqldump --opt --routines DATABASENAME > /path/to/DATABASENAME_backup.sql
------------------------------------------------------------------------

Have you backed up your databases ? [y/n] y

MariaDB 10.2.x https://mariadb.com/kb/en/mariadb/what-is-mariadb-102/

!!  Note  !!
upgrade process can take more >5 minutes.. you may want to shutdown
nginx server to not show mysql errors to visitors on your site or
put site(s) into maintenance mode before proceeding with mysql upgrade

Do you want to continue with upgrade to MariaDB 10.2.x ? [y/n] y

    Code (Text):
    *************************************************
* Adjust old MariaDB 10.x /etc/my.cnf
  for MariaDB 10.2.x my.cnf compatibility
*************************************************
    __  __               _         ____   ____    _   ___     ____
   |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \   |___ \    __  __
   | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | |    __) |   \ \/ /
   | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_  / __/  _  >  <
   |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)|_____|(_)/_/\_\
                                                             
            __     _            __                                  __
           / /___ | |_  ___    / /_ __ ___   _   _     ___  _ __   / _|
          / // _ \| __|/ __|  / /| '_ ` _ \ | | | |   / __|| '_ \ | |_
         / /|  __/| |_| (__  / / | | | | | || |_| | _| (__ | | | ||  _|
        /_/  \___| \__|\___|/_/  |_| |_| |_| \__, |(_)\___||_| |_||_|
                                             |___/     
         _        _   _              _                            _
        / \    __| | (_) _   _  ___ | |_  _ __ ___    ___  _ __  | |_  ___
       / _ \  / _` | | || | | |/ __|| __|| '_ ` _ \  / _ \| '_ \ | __|/ __|
      / ___ \| (_| | | || |_| |\__ \| |_ | | | | | ||  __/| | | || |_ \__ \
     /_/   \_\\__,_|_/ | \__,_||___/ \__||_| |_| |_| \___||_| |_| \__||___/
                   |__/

    Code (Text):
    mysql -t -e "SHOW PLUGINS;"
+-------------------------------+----------+--------------------+------------------------+---------+
| Name                          | Status   | Type               | Library                | License |
+-------------------------------+----------+--------------------+------------------------+---------+
| binlog                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| mysql_native_password         | ACTIVE   | AUTHENTICATION     | NULL                   | GPL     |
| mysql_old_password            | ACTIVE   | AUTHENTICATION     | NULL                   | GPL     |
| wsrep                         | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| MRG_MyISAM                    | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| MEMORY                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| CSV                           | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| MyISAM                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| CLIENT_STATISTICS             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INDEX_STATISTICS              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| TABLE_STATISTICS              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| USER_STATISTICS               | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| PERFORMANCE_SCHEMA            | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| InnoDB                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| INNODB_TRX                    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_LOCKS                  | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_LOCK_WAITS             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP                    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP_RESET              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMPMEM                 | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMPMEM_RESET           | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP_PER_INDEX          | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP_PER_INDEX_RESET    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_BUFFER_PAGE            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_BUFFER_PAGE_LRU        | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_BUFFER_POOL_STATS      | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_METRICS                | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_DEFAULT_STOPWORD    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_DELETED             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_BEING_DELETED       | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_CONFIG              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_INDEX_CACHE         | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_INDEX_TABLE         | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_TABLES             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_TABLESTATS         | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_INDEXES            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_COLUMNS            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_FIELDS             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_FOREIGN            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_FOREIGN_COLS       | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_TABLESPACES        | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_DATAFILES          | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_VIRTUAL            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_MUTEXES                | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_SEMAPHORE_WAITS    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_TABLESPACES_ENCRYPTION | ACTIVE   | INFORMATION SCHEMA | NULL                   | BSD     |
| INNODB_TABLESPACES_SCRUBBING  | ACTIVE   | INFORMATION SCHEMA | NULL                   | BSD     |
| Aria                          | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| SEQUENCE                      | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| user_variables                | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| FEEDBACK                      | DISABLED | INFORMATION SCHEMA | NULL                   | GPL     |
| partition                     | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| METADATA_LOCK_INFO            | ACTIVE   | INFORMATION SCHEMA | metadata_lock_info.so  | GPL     |
| QUERY_CACHE_INFO              | ACTIVE   | INFORMATION SCHEMA | query_cache_info.so    | BSD     |
| QUERY_RESPONSE_TIME           | ACTIVE   | INFORMATION SCHEMA | query_response_time.so | GPL     |
| QUERY_RESPONSE_TIME_AUDIT     | ACTIVE   | AUDIT              | query_response_time.so | GPL     |
+-------------------------------+----------+--------------------+------------------------+---------+

    Code (Text):
    mysql -t -e "SHOW ENGINES;"
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                                          | Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
| CSV                | YES     | CSV storage engine                                                               | NO           | NO   | NO         |
| MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                            | NO           | NO   | NO         |
| MyISAM             | YES     | MyISAM storage engine                                                            | NO           | NO   | NO         |
| SEQUENCE           | YES     | Generated tables filled with sequential values                                   | YES          | NO   | YES        |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                                               | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                        | NO           | NO   | NO         |
| Aria               | YES     | Crash-safe tables with MyISAM heritage                                           | NO           | NO   | NO         |
| InnoDB             | DEFAULT | Supports transactions, row-level locking, foreign keys and encryption for tables | YES          | YES  | YES        |
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+

    Code (Text):
    mysqladmin  Ver 9.1 Distrib 10.2.13-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version          10.2.13-MariaDB
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 0 sec

Threads: 4  Questions: 1  Slow queries: 0  Opens: 17  Flush tables: 1  Open tables: 11  Queries per second avg: 0.000

------------------------------------------------
MariaDB 10.2.x Upgrade completed
------------------------------------------------

    Then future MariaDB 10.2.x branch updates are done via yum
    Code (Text):
    yum upgrade MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared


    Upgrade MariaDB 10.1 To 10.2 & 10.2 To 10.3 Differences



    MariaDB 10.1 to 10.2 has changes you need to be aware of which may affect your script/mysql using app specifically and Centmin Mod may not have tested for it so read Upgrading from MariaDB 10.1 to MariaDB 10.2 (centmin.sh menu option 11 takes care of step 1 to 8 with exception of step 4, you need to do MySQL backups yourself) and inspect /etc/my.cnf before and after MariaDB 10.2 upgrades. Centmin Mod upgrade routines try to as best adjust /etc/my.cnf for MariaDB 10.2 compatibility with previous MariaDB 10.1 but if your web app/scripts have issues, you'll need to figure those out yourself.

    Same goes for MariaDB 10.2 to 10.3 upgrades Upgrading from MariaDB 10.2 to MariaDB 10.3 (centmin.sh menu option 11 takes care of step 1 to 8 with exception of step 4, you need to do MySQL backups yourself)

    One of the big changes is from MariaDB 10.2.2 and newer, innodb_strict_mode is enabled by default while previously it was disabled by default and default options for sql_mode have changed.

    Install MariaDB 10.3 By Default



    Centmin Mod 123.09beta01 and newer also has experimental and optional choice of installing MariaDB 10.3 as default version. See details at Beta Branch - allow MariaDB 10.3 MySQL to be default optionally. Again test on test VPS/server and not live production site servers.
     
  3. Mar 6, 2019 #3
    BamaStangGuy

    BamaStangGuy Active Member

    669
    192
    43
    May 25, 2014
    Ratings:
    +272
    Local Time:
    8:18 PM
    Just upgraded to 10.3 on Bama Politics.
     
  4. Mar 10, 2019 #4
    Itworx4me

    Itworx4me Premium Member Premium Member

    339
    35
    28
    Mar 14, 2017
    Ratings:
    +65
    Local Time:
    6:18 PM
    Nginx 1.27.4
    MariaDB 10.6.21
    @eva2000 Will this code work for updating the 10.1 branch too?
    Code (Text):
    yum upgrade MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
     
  5. Mar 11, 2019 #5
    Itworx4me

    Itworx4me Premium Member Premium Member

    339
    35
    28
    Mar 14, 2017
    Ratings:
    +65
    Local Time:
    6:18 PM
    Nginx 1.27.4
    MariaDB 10.6.21
    Bump
     
  6. Mar 11, 2019 #6
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:18 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    yum updates will also be used to update mariadb within same major version i.e. 10.1 or 10.2 or 10.3 just not for upgrading major versions
     
  7. Mar 15, 2019 #7
    Itworx4me

    Itworx4me Premium Member Premium Member

    339
    35
    28
    Mar 14, 2017
    Ratings:
    +65
    Local Time:
    6:18 PM
    Nginx 1.27.4
    MariaDB 10.6.21
    @eva2000 after running a yum update MariaDB wasn't updated to the newest version (10.1.38) So I tried running yum update again. I get this message:

    Code (Text):
    yum update
Loaded plugins: fastestmirror, langpacks, priorities, versionlock
Loading mirror speeds from cached hostfile
 * base: ewr.edge.kernel.org
 * epel: mirror.compevo.com
 * extras: mirror.fileplanet.com
 * rpmforge: mirror.teklinks.com
 * updates: mirror.fileplanet.com
267 packages excluded due to repository priority protections
Excluding 1 update due to versionlock (use "yum versionlock status" to show it)

    Why are 267 packages being exluded?

    Thanks,
    Itworx4me
     
  8. Mar 15, 2019 #8
    Itworx4me

    Itworx4me Premium Member Premium Member

    339
    35
    28
    Mar 14, 2017
    Ratings:
    +65
    Local Time:
    6:18 PM
    Nginx 1.27.4
    MariaDB 10.6.21
    @eva2000 Another thing I noticed was when I signed onto centmin. Then exit (24) it showed that there were yum updates. I didn't have time to do the updates and choose to do them later. So I signed back onto centmin tonight and then exited (24) to see the yum updates again. But this time it says there are no yum updates. Is this a bug because earlier today there were updates?

    Thanks,
    Itworx4me
     
  9. Mar 15, 2019 #9
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:18 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    not a bug but change in when yum update check is done Beta Branch - update inc/cpcheck.inc initial login routine updates in 123.09beta01

     
  10. Mar 15, 2019 #10
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    4:18 AM
    Nginx-1.29.x
    MariaDB 10.6.x
    For me i would like to have this disabled and get the updates as usual...
     
  11. Mar 15, 2019 #11
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:18 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    I will add an option so you can set a persist config variable to turn it on/off
     
  12. Mar 15, 2019 #12
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:18 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
  13. Mar 16, 2019 #13
    Itworx4me

    Itworx4me Premium Member Premium Member

    339
    35
    28
    Mar 14, 2017
    Ratings:
    +65
    Local Time:
    6:18 PM
    Nginx 1.27.4
    MariaDB 10.6.21
  14. Mar 17, 2019 #14
    Itworx4me

    Itworx4me Premium Member Premium Member

    339
    35
    28
    Mar 14, 2017
    Ratings:
    +65
    Local Time:
    6:18 PM
    Nginx 1.27.4
    MariaDB 10.6.21
    I am still getting this 267 packages being exluded. I am using this code to update:
    Code (Text):
    yum update --disableplugin=priorities --enablerepo=remi


    I have updated /etc/centminmod/custom_config.inc with:
    Code (Text):
    MENUEXIT_ALWAYS_YUMCHECK='y'

    How do I get the 267 packages to update???

    Thanks,
    Itworx4me
     
  15. Mar 17, 2019 #15
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:18 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    those packages are excluded for a reason they will conflict with what centmin mod uses so you can ignore that
     
  16. Mar 17, 2019 #16
    Itworx4me

    Itworx4me Premium Member Premium Member

    339
    35
    28
    Mar 14, 2017
    Ratings:
    +65
    Local Time:
    6:18 PM
    Nginx 1.27.4
    MariaDB 10.6.21
    Thank You @eva2000 but it still doesn't solve my issue. There is a new MarieDB version 10.1.38 that I would like to upgrade too. yum update should upgrade to that new version but its not listed. Are you saying that 10.1.38 will be in conflict with centmin? If the version isn't in conflict with centmin. How does a person go about upgrading said version? And why isn't it listed as upgrade??

    Thanks,
    Itworx4me
     
  17. Mar 17, 2019 #17
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:18 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    If you're on mariadb 10.1 branch i.e. 10.1.37 and there's a 10.1.38 update but it isn't showing then the problem is the geographical mirror for mariadb has yet to make it available so you need to wait you can try yum clean all and update and see if it is there - otherwise only thing you can do is wait for mirror to update
    Code (Text):
    yum clean all
yum update --disableplugin=priorities --enablerepo=remi
     
  18. Mar 17, 2019 #18
    Itworx4me

    Itworx4me Premium Member Premium Member

    339
    35
    28
    Mar 14, 2017
    Ratings:
    +65
    Local Time:
    6:18 PM
    Nginx 1.27.4
    MariaDB 10.6.21
    MariaDB - MariaDB 10.1.38 now available :(
     
  19. Mar 17, 2019 #19
    Itworx4me

    Itworx4me Premium Member Premium Member

    339
    35
    28
    Mar 14, 2017
    Ratings:
    +65
    Local Time:
    6:18 PM
    Nginx 1.27.4
    MariaDB 10.6.21
    You would think if it were release well over a month ago it would be available. I have never ran into an issue of upgrading a branch of MariaDB after you have posted it on centmin. Guess its a waiting game...

    Thanks for your help,
    Itworx4me
     
  20. Mar 19, 2019 #20
    Itworx4me

    Itworx4me Premium Member Premium Member

    339
    35
    28
    Mar 14, 2017
    Ratings:
    +65
    Local Time:
    6:18 PM
    Nginx 1.27.4
    MariaDB 10.6.21
    @eva2000 Do you have to recompile php to show the current version of mysql? I ran this code:
    Code (Text):
    mysql -V
mysql  Ver 15.1 Distrib 10.1.38-MariaDB, for Linux (x86_64) using readline 5.1


    It shows that I have 10.1.38 installed. But php is reporting that I am still using 10.1.37. Do I have to recompile php for php to show the correct version?

    Thanks,
    Itworx4me
     
Previous Thread Next Thread
Loading...
Page 1 of 2

.