MySQL Community FAQs

Instructions on how to convert to MySQL Community Edition from Oracle MySQL can be found here.

The best way to check your version is to connect to the database and issue the following command:

        mysql> show global variables like '%version%';

Possible Outputs

Enterprise Edition:

        +-------------------------+---------------------------------------------------------+ 
        | Variable_name           | Value                                                   | 
        +-------------------------+---------------------------------------------------------+
        | version                 | 5.6.26-enterprise-commercial-advanced-log               |
        | version_comment         | MySQL Enterprise Server - Advanced Edition (Commercial) |
        +-------------------------+---------------------------------------------------------+

Community Edition:

        +-------------------------+------------------------------+
        | Variable_name           | Value                        |
        +-------------------------+------------------------------+
        | version                 | 5.6.26-log                   |
        | version_comment         | MySQL Community Server (GPL) |
        +-------------------------+------------------------------+

If you don't have a MySQL account, you can query the MySQL packages directly on the database server. The output may vary depending on the MySQL version installed:

        linux> yum list installed |grep -i mysql

Enterprise:

        mysql-commercial-server.x86_64   5.7.15-1.1.el7            installed

or

        MySQL-server-advanced.x86_64        5.6.28-1.el6           installed

Community:

        mysql-community-server.x86_64      5.7.20-1.el7            installed

or

        MySQL-server.x86_64              5.5.41-1.el6              installed

There are forums on MySQL that covers the following topics:

• Database related topics (e.g. performance, replication, cluster, security, and etc.)
• Programming Languages (PHP, Perl, Python, C++, and etc.)
• Jobs & Recruiting

If your faculty or unit is supported by UBC IT’s Database Administration team, please contact them via their webform.

If your faculty or unit is not supported by UBC IT's Database Administration team, you can find support from a number of open source forums, such as the MySQL community forum, or from a commercial version of MySQL (such as Percona ) for more in-depth support.

Yes, the MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and more. For more information, please visit MySQL's Workbench site.

We do not offer training; however, there are a number of third party companies that offer this training that you might be able to find online

Please complete our Database Administration Team webform for assistance on this.

MySQL Community Edition runs on both Linux and Windows operation systems For more information, please visit this page.

You can find the information about lifecycles on the following pages:

• MySQL Product Support EOL Announcements
• MySQL Database Supported Platforms

Please fill out the Database Administration Team webform for assistance.

UBC IT Database Administration team offers a 24 hours monitoring service for their database services.

Please fill out the Database Administration Team webform for more information.

Yes, please fill out the Database Administration Team webform and we will get in touch with you about it.

If it is a generally available (GA) product, then it should be reasonable to use.

Instructions on how to convert to MySQL Community Edition from Oracle MySQL can be found here.