/ Register

Get the most out of your Centmin Mod LEMP stack
Become a Member

MariaDB MariaDB 10.5.4 now available

Discussion in 'MariaDB & General MySQL news & discussions' started by eva2000, Jun 25, 2020.

Previous Thread Next Thread
Loading...
  1. Jun 25, 2020 #1
    eva2000

    eva2000 Administrator Staff Member

    58,895
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    9:10 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
  2. Jun 25, 2020 #2
    Dnyan

    Dnyan Member

    106
    24
    18
    Sep 16, 2017
    Ratings:
    +36
    Local Time:
    4:40 PM
    1.17.8
    10.3.22
    is anybody using it on live site (y) specially @rdan
     
  3. Jun 25, 2020 #3
    rdan

    rdan Well-Known Member

    5,452
    1,418
    113
    May 25, 2014
    Ratings:
    +2,212
    Local Time:
    7:10 PM
    Mainline
    10.2
    No, all my server are still on 10.3. Pretty solid and stable.
    10.4 consumes more CPU and and memory, not sure about 10.5.
     
  4. Jun 25, 2020 #4
    Dnyan

    Dnyan Member

    106
    24
    18
    Sep 16, 2017
    Ratings:
    +36
    Local Time:
    4:40 PM
    1.17.8
    10.3.22
    Kindly do update us with performance of 10.5 when you make a mind for switching to it and more specifically for performance impact on xF sites.

    Thank You for responding
     
  5. Jun 25, 2020 #5
    rdan

    rdan Well-Known Member

    5,452
    1,418
    113
    May 25, 2014
    Ratings:
    +2,212
    Local Time:
    7:10 PM
    Mainline
    10.2
    Maybe when Eva add support for 10.5 install in few months, then I'll test it on new server install only.
     
  6. Jun 25, 2020 #6
    Jon Snow

    Jon Snow Active Member

    917
    188
    43
    Jun 30, 2017
    Ratings:
    +293
    Local Time:
    8:10 AM
    Nginx 1.13.9
    MariaDB 10.1.31
    What would happen if we update and something goes wrong? Our databases would be beyond fixing and we'd have to restore all databases from a backup after reverting MariaDB to its previous version?
     
  7. Jul 9, 2020 #7
    Revenge

    Revenge Active Member

    469
    93
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +354
    Local Time:
    12:10 PM
    1.9.x
    10.1.x
    innodb_buffer_pool_instances was deprecated in this version with the following reason:

    "Having more than one buffer pool is no longer necessary."
     
  8. Jul 9, 2020 #8
    eva2000

    eva2000 Administrator Staff Member

    58,895
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    9:10 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    yup among other things MariaDB - What's New In MariaDB 10.5 ?

    For MariaDB 10.4 and 10.5, yes only way would be to restore from backups from prior major MariaDB version if you want to revert to previous major MariaDB version
     
  9. Jul 11, 2020 #9
    Revenge

    Revenge Active Member

    469
    93
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +354
    Local Time:
    12:10 PM
    1.9.x
    10.1.x
    Im using MariaDB 10.4.13 and for testing purposes, i installed MariaDB 10.3 on a test server and i restored a backup of my site.

    Everything is working fine, which means its possible to revert back to MariaDB 10.3 from 10.4, at least in some cases.
     
  10. Jul 11, 2020 #10
    eva2000

    eva2000 Administrator Staff Member

    58,895
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    9:10 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    Unfortunately there's no guarantees and depends on how MariaDB is configured and what features you using. And the statement is in general sense that InnoDB engine versions diverge from 10.3 to 10.4+ so future development work in 10.4+ is done with understanding it won't be backwards compatible with 10.3 and early. So the issue could be something further in the future that breaks and not necessarily now.

    Another example is possible doing transportable InnoDB table spaces for import/discard to physically move InnoDB data file/table spaces for backup/data restoration etc. That possibly won't be possible if your working server and staging/backup servers are differing 10.3/10.4/10.4 versions.
     
  11. Jul 20, 2020 #11
    negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    2:10 PM
    1.9.10
    10.1.11
    Agree, however waiting the newest reviews about version 10.5 from professional xf users like you :D

    I hope that, everything will be better on 10.5.x series instead of 10.4 but which minor version, we don't know yet. I think we must wait more minor version for upgrade like 10.5.15 etc
     
  12. Jul 20, 2020 #12
    rdan

    rdan Well-Known Member

    5,452
    1,418
    113
    May 25, 2014
    Ratings:
    +2,212
    Local Time:
    7:10 PM
    Mainline
    10.2
    I think you mean Eva, surely not me :)
     
  13. Jul 20, 2020 #13
    negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    2:10 PM
    1.9.10
    10.1.11
Previous Thread Next Thread
Loading...

.