How do I convert to MySQL Community Edition from Oracle MySQL?
Instructions on how to convert to MySQL Community Edition from Oracle MySQL can be found here.
I'm not sure if I am using Enterprise or Community Edition. How do I determine that?
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 version_comment | 5.6.26-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial) |
Community Edition:
| Variable_name | Value |
| version version_comment | 5.6.26-log 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
Are there any sources of support or information on MySQL community?
There are forums on MySQL that covers the following topics:
I would like to get support on the community edition from UBC IT's Data Administration team, how do I do that?
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.
Does MySQL provide any visual tools?
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.
Where can I find MySQL training and certification?
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
Who can I get help for high availability architecture?
Please complete our Database Administration Team webform for assistance on this.
What operating systems can be used with MySQL Community Edition?
MySQL Community Edition runs on both Linux and Windows operation systems For more information, please visit this page.
Where can I find information regarding the lifecycles of MySQL community?
You can find the information about lifecycles on the following pages:
I want to perform database backup, but I don't have the privileges to do it. What do I do?
Please fill out the Database Administration Team webform for assistance.
Do you provide any monitoring services for my database?
UBC IT Database Administration team offers a 24 hours monitoring service for their database services.
We want UBC IT's Database Administration team to onboard our database. What sort of fee is required to do that?
Please fill out the Database Administration Team webform for more information.
Can you help me upgrade MySQL version?
Yes, please fill out the Database Administration Team webform and we will get in touch with you about it.
Is it okay to use MySQL 8,9, future releases?
If it is a generally available (GA) product, then it should be reasonable to use.
I think I'm using Enterprise MySQL. How do I move onto Community?
Instructions on how to convert to MySQL Community Edition from Oracle MySQL can be found here.