Discover Centmin Mod today
Register Now

MariaDB Command to update MariaDB 10.0.x ?

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by RoldanLT, Jun 12, 2014.

  1. RoldanLT

    RoldanLT Well-Known Member

    3,978
    965
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,329
    Local Time:
    6:15 PM
    1.11
    10.2
    Since MariaDB 10.0.12 will be release today, What's the command to update my installation?
    Thanks !
     
  2. eva2000

    eva2000 Administrator Staff Member

    30,953
    6,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,416
    Local Time:
    8:15 PM
    Nginx 1.13.x
    MariaDB 5.5
    Just the usual. You can also do a YUM LIST first to check
    Code:
    yum list MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
    then update
    Code:
    yum update MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
     
    • Like Like x 1
  3. Floren

    Floren Active Member

    148
    76
    28
    Jun 6, 2014
    Ratings:
    +76
    Local Time:
    5:15 AM
    @eva2000 will switch soon to AXIVO MariaDB 10, once he completes the benchmarks. :D
     
  4. eva2000

    eva2000 Administrator Staff Member

    30,953
    6,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,416
    Local Time:
    8:15 PM
    Nginx 1.13.x
    MariaDB 5.5
    Maybe, we shall see. Might offer it up as an alternative so MariaDB 10 official or AXIVO MariaDB 10.. user choice :)
     
    • Like Like x 2
  5. RoldanLT

    RoldanLT Well-Known Member

    3,978
    965
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,329
    Local Time:
    6:15 PM
    1.11
    10.2
    Done upgrading my server :)
     
    • Like Like x 1
  6. BamaStangGuy

    BamaStangGuy Active Member

    475
    137
    43
    May 25, 2014
    Ratings:
    +181
    Local Time:
    4:15 AM
    What happens if I lose connection at the point where it is running the upgrade queries? How do I recover to that point?
     
  7. eva2000

    eva2000 Administrator Staff Member

    30,953
    6,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,416
    Local Time:
    8:15 PM
    Nginx 1.13.x
    MariaDB 5.5
  8. BamaStangGuy

    BamaStangGuy Active Member

    475
    137
    43
    May 25, 2014
    Ratings:
    +181
    Local Time:
    4:15 AM
    Yea I usually do screen but somehow managed to not do it this time. Got it all sorted out.
     
  9. eva2000

    eva2000 Administrator Staff Member

    30,953
    6,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,416
    Local Time:
    8:15 PM
    Nginx 1.13.x
    MariaDB 5.5
  10. BamaStangGuy

    BamaStangGuy Active Member

    475
    137
    43
    May 25, 2014
    Ratings:
    +181
    Local Time:
    4:15 AM
    What does InnoDB = On do in my.cnf? Its auto commented out on upgrades.
     
  11. eva2000

    eva2000 Administrator Staff Member

    30,953
    6,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,416
    Local Time:
    8:15 PM
    Nginx 1.13.x
    MariaDB 5.5
    same as skip-innodb command if InnoDB = Off
     
  12. BamaStangGuy

    BamaStangGuy Active Member

    475
    137
    43
    May 25, 2014
    Ratings:
    +181
    Local Time:
    4:15 AM
    So having it commented out is the same as having InnoDB = On since it is the default engine in MariaDB right? Is it actually XtraDB?
     
  13. eva2000

    eva2000 Administrator Staff Member

    30,953
    6,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,416
    Local Time:
    8:15 PM
    Nginx 1.13.x
    MariaDB 5.5
    Yup.. MariaDB 10 relies on InnoDB = On and enabled so best to set it that way.
     
    • Like Like x 1
  14. BoostN

    BoostN Member

    93
    18
    8
    Aug 19, 2014
    Ratings:
    +22
    Local Time:
    4:15 AM
    1.11.1
    10.0.28
    Code:
    show engines;
    This gives me the following:
    Code:
    MariaDB [(none)]> 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         |
    | MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                  | NO           | NO   | NO         |
    | BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears)             | NO           | NO   | NO         |
    | MyISAM             | DEFAULT | MyISAM storage engine                                                      | NO           | NO   | NO         |
    | InnoDB             | NO      | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | NULL         | NULL | NULL       |
    | ARCHIVE            | NO      | Archive storage engine                                                     | NULL         | NULL | NULL       |
    | FEDERATED          | NO      | FederatedX pluggable storage engine                                        | NULL         | NULL | NULL       |
    | PERFORMANCE_SCHEMA | YES     | Performance Schema                                                         | NO           | NO   | NO         |
    | Aria               | YES     | Crash-safe tables with MyISAM heritage                                     | NO           | NO   | NO         |
    +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
    10 rows in set (0.00 sec)
    
    I need to enable Innodb.. I've commented out the skip-innodb by doing:
    Code:
    #skip-innodb
    
    ..I've restart mysql with no luck.

    Any ideas?

    I'm a newbie, go easy on me!
     
  15. BoostN

    BoostN Member

    93
    18
    8
    Aug 19, 2014
    Ratings:
    +22
    Local Time:
    4:15 AM
    1.11.1
    10.0.28
    UPDATE:

    Fixed it. I had to remove the lb_LogFileXXX under the directory /var/lib/mysql/ and restart MySQL.
     
  16. eva2000

    eva2000 Administrator Staff Member

    30,953
    6,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,416
    Local Time:
    8:15 PM
    Nginx 1.13.x
    MariaDB 5.5
    • Like Like x 1