Want more timely Centmin Mod News Updates?
Become a Member

Oracle MySQL 8.0 GA Stable Release

Discussion in 'MariaDB & General MySQL news & discussions' started by eva2000, Apr 20, 2018.

  1. eva2000

    eva2000 Administrator Staff Member

    41,088
    9,194
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,104
    Local Time:
    2:52 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    Important issue with MySQL 8.0 on initial release that is overlooked is whether or not 3rd party backup tools support the MySQL 8.0 changes a critical piece is missing for Oracle MySQL 8 (GA) … « Serge Frezefond 's blog

     
  2. eva2000

    eva2000 Administrator Staff Member

    41,088
    9,194
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,104
    Local Time:
    2:52 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    MariaDB and MySQL creator Monty takes MySQL 8.0 for a spin and compares it to MariaDB 10.3 for single threaded tests Monty says: Congratulations to Oracle on MySQL 8.0

    Results are in seconds to complete
    Code (Text):
    Operation         |MariaDB|MySQL-8|
    
    -----------------------------------
    ATIS              | 153.00| 228.00|
    alter-table       |  92.00| 792.00|
    big-tables        | 990.00|2079.00|
    connect           | 186.00| 227.00|
    create            | 575.00|4465.00|
    insert            |4552.00|8458.00|
    select            | 333.00| 412.00|
    table-elimination |1900.00|3916.00|
    wisconsin         | 272.00| 590.00|
    -----------------------------------


    With that said looking forward to playing with MariaDB 10.2/10.3 more in future to compare with MySQL 8.0 :)
     
    • Informative Informative x 1
  3. eva2000

    eva2000 Administrator Staff Member

    41,088
    9,194
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,104
    Local Time:
    2:52 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    regarding
    Upgrading to MySQL 8.0 : Default Authentication Plugin Considerations

    and MySQL :: MySQL 8.0 Reference Manual :: 2.10.1.2 Changes Affecting Upgrades to MySQL 8.0

     
    Last edited: May 3, 2018
  4. eva2000

    eva2000 Administrator Staff Member

    41,088
    9,194
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,104
    Local Time:
    2:52 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    More testing for Oracle MySQL 8.0 on Centmin Mod 123.09beta01. I setup custom mysql-control command to manage multiple MySQL server instances more easily. For example, I setup 2x MariaDB 10.1 MySQL instances + Oracle MySQL 8.0.11 all on the same server with separate MySQL sockets, listening ports and MySQL data directories so can test various MySQL configurations to learn and compare MySQL 8.0 vs MariaDB 10.1 :D

    Code (Text):
    mysql-control
    
    Usage:
    
    mysql-control 1 mysqladmin ver
    mysql-control 2 mysqladmin ver
    mysql-control 3 mysqladmin ver
    mysql-control 8 mysqladmin ver
    
    mysql-control 1 show-engines
    mysql-control 2 show-engines
    mysql-control 3 show-engines
    mysql-control 8 show-engines

    mysql-control Main MariaDB 10.1
    Code (Text):
    /usr/bin/mysql-control 1 mysqladmin ver
    mysqladmin -P 3306 -S /var/lib/mysql/mysql.sock ver  
    mysqladmin  Ver 9.1 Distrib 10.1.32-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.1.32-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 1 hour 6 min 44 sec
    
    Threads: 1  Questions: 18  Slow queries: 0  Opens: 17  Flush tables: 1  Open tables: 11  Queries per second avg: 0.004
    

    Code (Text):
    /usr/bin/mysql-control 1 show-engines
    mysql -P 3306 -S /var/lib/mysql/mysql.sock -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        |
    | MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                                        | NO           | NO   | NO         |
    | PERFORMANCE_SCHEMA | YES     | Performance Schema                                                                               | NO           | NO   | NO         |
    | Aria               | YES     | Crash-safe tables with MyISAM heritage                                                           | NO           | NO   | NO         |
    | InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables | YES          | YES  | YES        |
    +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
    

    mysql-control Second MariaDB 10.1
    Code (Text):
    /usr/bin/mysql-control 2 mysqladmin ver
    mysqladmin -P 3307 -S /var/lib/mysql2/mysql.sock ver  
    mysqladmin  Ver 9.1 Distrib 10.1.32-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.1.32-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql2/mysql.sock
    Uptime:                 53 min 27 sec
    
    Threads: 1  Questions: 5  Slow queries: 0  Opens: 17  Flush tables: 1  Open tables: 11  Queries per second avg: 0.001
    

    Code (Text):
    /usr/bin/mysql-control 2 show-engines
    mysql -P 3307 -S /var/lib/mysql2/mysql.sock -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        |
    | MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                                        | NO           | NO   | NO         |
    | PERFORMANCE_SCHEMA | YES     | Performance Schema                                                                               | NO           | NO   | NO         |
    | Aria               | YES     | Crash-safe tables with MyISAM heritage                                                           | NO           | NO   | NO         |
    | InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables | YES          | YES  | YES        |
    +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
    

    mysql-control Oracle MySQL 8.0
    Code (Text):
    /usr/bin/mysql-control 8 mysqladmin ver 
    /usr/local/mysql/bin/mysqladmin -P 3407 -S /opt/mysql/data/mysql.sock ver   
    /usr/local/mysql/bin/mysqladmin  Ver 8.0.11 for el7 on x86_64 (MySQL Community Server - GPL)
    Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Server version          8.0.11
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /opt/mysql/data/mysql.sock
    Uptime:                 1 hour 44 min 44 sec
    
    Threads: 2  Questions: 10  Slow queries: 0  Opens: 110  Flush tables: 2  Open tables: 86  Queries per second avg: 0.001
    

    Code (Text):
    /usr/bin/mysql-control 8 show-engines
    mysql -P 3407 -S /opt/mysql/data/mysql.sock -e "SHOW ENGINES;"
    +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
    | Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |
    +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
    | FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |
    | MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
    | InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |
    | PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |
    | MyISAM             | YES     | MyISAM storage engine                                          | NO           | NO   | NO         |
    | MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
    | BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
    | CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |
    | ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |
    +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
    
     
    • Winner Winner x 1
  5. Vijay Singh Khatri

    Vijay Singh Khatri New Member

    4
    0
    1
    Jan 4, 2019
    Ratings:
    +0
    Local Time:
    10:22 PM
    8.0
    It's really awesome news for those who are using a MySQL database. Get the difference between MySQL and MariaDB from here.
     
  6. Revenge

    Revenge Active Member

    442
    92
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +333
    Local Time:
    5:52 PM
    1.9.x
    10.1.x
    What?
     
  7. eva2000

    eva2000 Administrator Staff Member

    41,088
    9,194
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,104
    Local Time:
    2:52 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    Yeah they no longer do that MariaDB version numbers have long since differed from Oracle MySQL nowadays
     
  8. tininho

    tininho New Member

    18
    1
    3
    May 22, 2019
    Ratings:
    +7
    Local Time:
    7:52 PM
    Nginx Ver: 1.17
    MariaDB Ver: 10.4
    I am more than eager to test out MySQL8 on Centminmod, but I can't/don't know how to install it myself. Is it possible to test this somehow (I could not figure it out from this topic) or should I just wait patiently?

    Looking for performance in WP All Import Woocommerce import jobs.
     
  9. eva2000

    eva2000 Administrator Staff Member

    41,088
    9,194
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,104
    Local Time:
    2:52 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    Unfortunately, no automated way for using MySQL 8 on Centmin Mod as yet. If you're unfamiliar with MySQL 8 I'd wait as their are drastic changes which can break existing web app's usage for reasons outlined in this thread.

    Unfortunately, no time to test MySQL 8 any further as I have been alot busier on my end with cPanel's latest price increases and after effects i.e. cPanel clients migrating to DirectAdmin and/or Centmin Mod - writing cPanel to Centmin Mod importer for some of my paying clients and having to learn DirectAdmin and writing up documentation for such for my own records :)
     
    • Like Like x 2
  10. Revenge

    Revenge Active Member

    442
    92
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +333
    Local Time:
    5:52 PM
    1.9.x
    10.1.x
    • Informative Informative x 1
  11. steph40

    steph40 Premium Member Premium Member

    57
    11
    8
    Jan 28, 2019
    Ratings:
    +23
    Local Time:
    12:52 PM
    1.1.5
    mariadb 10
    Wow, why would they do that?
     
  12. eva2000

    eva2000 Administrator Staff Member

    41,088
    9,194
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,104
    Local Time:
    2:52 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x