Join the community today
Register Now

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

    45,432
    10,308
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,987
    Local Time:
    1:30 PM
    Nginx 1.19.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

    45,432
    10,308
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,987
    Local Time:
    1:30 PM
    Nginx 1.19.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 :)
     
  3. eva2000

    eva2000 Administrator Staff Member

    45,432
    10,308
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,987
    Local Time:
    1:30 PM
    Nginx 1.19.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

    45,432
    10,308
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,987
    Local Time:
    1:30 PM
    Nginx 1.19.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         |
    +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
    
     
  5. Vijay Singh Khatri

    Vijay Singh Khatri New Member

    4
    0
    1
    Jan 4, 2019
    Ratings:
    +0
    Local Time:
    9:00 AM
    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

    458
    93
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +350
    Local Time:
    4:30 AM
    1.9.x
    10.1.x
    What?
     
  7. eva2000

    eva2000 Administrator Staff Member

    45,432
    10,308
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,987
    Local Time:
    1:30 PM
    Nginx 1.19.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 Active Member

    121
    26
    28
    May 22, 2019
    Nordic
    Ratings:
    +81
    Local Time:
    6:30 AM
    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

    45,432
    10,308
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,987
    Local Time:
    1:30 PM
    Nginx 1.19.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 :)
     
  10. Revenge

    Revenge Active Member

    458
    93
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +350
    Local Time:
    4:30 AM
    1.9.x
    10.1.x
  11. steph40

    steph40 Member

    74
    15
    8
    Jan 28, 2019
    Ratings:
    +31
    Local Time:
    11:30 PM
    1.1.5
    mariadb 10
    Wow, why would they do that?
     
  12. eva2000

    eva2000 Administrator Staff Member

    45,432
    10,308
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,987
    Local Time:
    1:30 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
  13. eva2000

    eva2000 Administrator Staff Member

    45,432
    10,308
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,987
    Local Time:
    1:30 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    Had a paying client hire me to switch their Centmin Mod 123.09beta01 installs from MariaDB 10.3 to MySQL 8.0 server due to their web app usage requirements. So had some quality time working with MySQL 8.0 on Centmin Mod :) MySQL 8 support is on Centmin Mod's long term To-Do/Wishlist outlined here :D But won't be available to general public anytime soon due to work and testing needed for automatic tuning and optimisation formulas for /etc/my.cnf settings based on detected server cpu, memory, disk resources. Lots of different and new MySQL 8 variables and settings to play with :)

    My tests on local VirtualBox CentOS 7 server with Centmin Mod 123.09beta01
    Code (Text):
    cat /etc/redhat-release ; cat /etc/centminmod-release
    CentOS Linux release 7.7.1908 (Core)
    123.09beta01.b301
    

    Code (Text):
    mysqladmin ver
    mysqladmin  Ver 8.0.18 for Linux on x86_64 (MySQL Community Server - GPL)
    Copyright (c) 2000, 2019, 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.18
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 17 min 55 sec
    Threads: 2  Questions: 7  Slow queries: 0  Opens: 132  Flush tables: 3  Open tables: 52  Queries per second avg: 0.006
    

    Code (Text):
    yum -q list mysql-community-client mysql-community-server mysql-community-libs-compat mysql-community-devel mysql-community-common --disableexcludes=main
    Installed                           Packages
    mysql-community-client.x86_64       8.0.18-1.el7  @mysql80-community
    mysql-community-common.x86_64       8.0.18-1.el7  @mysql80-community
    mysql-community-devel.x86_64        8.0.18-1.el7  @mysql80-community
    mysql-community-libs-compat.x86_64  8.0.18-1.el7  @mysql80-community
    mysql-community-server.x86_64       8.0.18-1.el7  @mysql80-community
    Available                           Packages
    mysql-community-client.i686         8.0.18-1.el7  mysql80-community
    mysql-community-common.i686         8.0.18-1.el7  mysql80-community
    mysql-community-devel.i686          8.0.18-1.el7  mysql80-community
    mysql-community-libs-compat.i686    8.0.18-1.el7  mysql80-community
    

    Centmin Mod command shortcuts
    Code (Text):
    mysqlstatus
    Redirecting to /bin/systemctl status mysqld.service
    ● mysqld.service - MySQL Server
       Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)
      Drop-In: /etc/systemd/system/mysqld.service.d
               └─limits.conf
       Active: active (running) since Mon 2019-10-28 15:47:27 UTC; 17min ago
         Docs: man:mysqld(8)
               http://dev.mysql.com/doc/refman/en/using-systemd.html
     Main PID: 28644 (mysqld)
       Status: "Server is operational"
       CGroup: /system.slice/mysqld.service
               └─28644 /usr/sbin/mysqld
    Oct 28 15:47:21 centos7.localdomain systemd[1]: Stopped MySQL Server.
    Oct 28 15:47:21 centos7.localdomain systemd[1]: Starting MySQL Server...
    Oct 28 15:47:27 centos7.localdomain systemd[1]: Started MySQL Server.
    
     
  14. eva2000

    eva2000 Administrator Staff Member

    45,432
    10,308
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,987
    Local Time:
    1:30 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    So apparently looks like MySQL 8's minor version upgrades are one way only and can not be downgraded MySQL 8 Minor Version Upgrades Are ONE-WAY Only - Percona Database Performance Blog ! So with MySQL 8 from Oracle or Percona, even minor version upgrades require a full mysql database backup for all databases on the server !
     
  15. BamaStangGuy

    BamaStangGuy Premium Member Premium Member

    651
    189
    43
    May 25, 2014
    Ratings:
    +264
    Local Time:
    10:30 PM
    Saw this coming from a mile away and so did MariaDB. Oracle can suck it. Percona is the one left screwed now by sticking down the same line. Their support team is going to have fun with this.
     
  16. pamamolf

    pamamolf Premium Member Premium Member

    3,858
    379
    83
    May 31, 2014
    Ratings:
    +731
    Local Time:
    6:30 AM
    Nginx-1.17.x
    MariaDB 10.3.x
    Mysql 8 shouldn't compared with Mariadb 10.4 ?
     
  17. eva2000

    eva2000 Administrator Staff Member

    45,432
    10,308
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,987
    Local Time:
    1:30 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    Yeah it's a pretty big gotcha for folks unaware. Imagine all the other control panels out their offering MySQL 8 support as well ! But then question is how many folks usually run a downgrade of MySQL minor versions ? But then even if folks did do backups, most folks only backup their own databases and not ones from the system i.e. database named = mysql etc. So that's downtime if they downgrade MySQL 8 and forget to backup the system databases too.

    Also imagine the amout of extra database related backup disk storage required if you now need to backup prior to each MySQL 8 minor version upgrade !

    Looks like for MySQL 8, you want to have more control over minor/major upgrade routines and maybe implement a version lock (YUM) to prevent automated MySQL 8 minor version updates and then script a full all databases on server backup + yum version unlock + mysql yum upgrade type routine. For the MariaDB to Oracle MySQL 8 auto switch script I wrote for Centmin Mod I am testing for a paying client, I am going to add the yum version unlock and add scripted approach to MySQL 8 YUM upgrades.

    Totally different with how MariaDB 10.4 changed https://community.centminmod.com/threads/interesting-look-at-whats-new-in-mariadb-10-4.17676/. Long term right now, I'd stick with MariaDB 10.3 or MySQL 5.7 if you need to be able to switch between MySQL versions from MariaDB, Oracle and Percona. If you use MySQL 8.0, don't expect to be able to easily switch to MariaDB 10.4 and vice versa without a full backup and restore and cross your fingers.

    And there's general differences too https://community.centminmod.com/threads/mariadb-mysql-vs-oracle-mysql-vs-percona-mysql.13853/
     
    Last edited: Jan 12, 2020
  18. buik

    buik “A winner never stops trying.” Premium Member

    1,309
    360
    83
    Apr 29, 2016
    Ratings:
    +1,073
    Local Time:
    5:30 AM
    Hihi 4 pages for one lousy MySQL release, do not make me laugh :)

    I really don't understand the problem at all.
    If you really want to make speed gains you will have to break with the code past.
    Compatibility code is always difficult.

    It is clear in advance what the conditions are.

    If you don't want this, it's fine too.
    As long as there are sufficient alternatives.
    And there are lots of alternatives.

    Next!
     
  19. eva2000

    eva2000 Administrator Staff Member

    45,432
    10,308
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,987
    Local Time:
    1:30 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    MySQL 8 is an exciting release hence the amount of discussions. Though the drastic changes for performance will bring along of gotchas if you don't read all the documentation. Hence, why I have only been testing MySQL 8 in non-production environments to ensure my level of know-how is adequate. This insight regarding minor version rollbacks is just another tidbit of info to add to my knowledge bank :D

    Yes so that's why I stick with MariaDB 10.3 for now - MariaDB 10.4 like MySQL 8.0 have more drastic changes too.