暂无图片
暂无图片
10
暂无图片
暂无图片
暂无图片

MySQL 30 周年庆!MySQL 企业版已开放下载!

原创 严少安 2025-05-14
691

是时候考虑将MySQL社区版升级到企业版了!

今年是 MySQL 30 周年!
(关注 #少安事务所 的朋友已经见我唠叨好几回了)

微信图片_20250514023018.jpg

五一假期 MySQL 放出的全球福利还在进行中,MySQL OCP 真·免费 考!

详情回看:

如果你已经领到考试券,建议尽快备考、约考,毕竟邻近 deadline 可不一定能约到好窗口。如果你还没领到券也没关系,你可以"出差"去趟坡县,大概率也是能领取的。交流群(入口在评论区)里已经多位大神高分通过。

微信图片_20250514021725.png

说回正题。

MySQL 企业版面向开发者免费下载

细心的网友发现,MySQL 企业版已面向开发者免费下载、使用。

20250514_010913.png

目前,可从官网直接下载 MySQL 企业版 9.3.0 最新版本,支持 Oracle Linux 9/8/7 操作系统 x86_64/arm64 架构,支持 Apple MacOS 15/14,支持 Microsoft Windows Server 2022, 2019, 2016 以及 Microsoft Windows 11。

20250514_021913.png

安装 MySQL 企业版,你可以探索最新特性,比如 MySQL 9.0 新引入的多语言引擎组件 MLE (The Multilingual Engine component),通过该组件,你可以使用 JavaScript 编写存储过程。

MySQL 企业版 9.3.0 安装示例

从官网下载 MySQL 企业版 9.3.0 安装包,上传到服务器指定目录,并解压缩。

[root@el7 mysql-ee-9.3]# ls
mysql-enterprise-9.3.0_el7_x86_64_bundle.tar
[root@el7 mysql-ee-9.3]# tar xf mysql-enterprise-9.3.0_el7_x86_64_bundle.tar 
[root@el7 mysql-ee-9.3]# ls
mysql-commercial-backup-9.3.0-1.1.el7.x86_64.rpm
mysql-commercial-client-9.3.0-1.1.el7.x86_64.rpm
mysql-commercial-client-plugins-9.3.0-1.1.el7.x86_64.rpm
mysql-commercial-common-9.3.0-1.1.el7.x86_64.rpm
mysql-commercial-devel-9.3.0-1.1.el7.x86_64.rpm
mysql-commercial-embedded-compat-9.3.0-1.1.el7.x86_64.rpm
mysql-commercial-icu-data-files-9.3.0-1.1.el7.x86_64.rpm
mysql-commercial-libs-9.3.0-1.1.el7.x86_64.rpm
mysql-commercial-libs-compat-9.3.0-1.1.el7.x86_64.rpm
mysql-commercial-server-9.3.0-1.1.el7.x86_64.rpm
mysql-commercial-test-9.3.0-1.1.el7.x86_64.rpm
mysql-connector-c++-commercial-9.3.0-1.1.el7.x86_64.rpm
mysql-connector-c++-commercial-compat-9.3.0-1.1.el7.x86_64.rpm
mysql-connector-c++-commercial-jdbc-9.3.0-1.1.el7.x86_64.rpm
mysql-connector-j-commercial-9.3.0-1.1.el7.noarch.rpm
mysql-connector-odbc-commercial-9.3.0-1.1.el7.x86_64.rpm
mysql-connector-odbc-commercial-setup-9.3.0-1.1.el7.x86_64.rpm
mysql-enterprise-9.3.0_el7_x86_64_bundle.tar
mysql-router-commercial-9.3.0-1.1.el7.x86_64.rpm
mysql-shell-commercial-9.3.0-1.1.el7.x86_64.rpm
README.txt
repodata

使用 yum 命令安装 MySQL 数据库。

[root@el7 mysql-ee-9.3]# yum install mysql-*.rpm

Dependencies Resolved

=================================================================================================================================
 Package                               Arch   Version          Repository                                                   Size
=================================================================================================================================
Installing:
 mysql-commercial-backup               x86_64 9.3.0-1.1.el7    /mysql-commercial-backup-9.3.0-1.1.el7.x86_64               116 M
 mysql-commercial-client               x86_64 9.3.0-1.1.el7    /mysql-commercial-client-9.3.0-1.1.el7.x86_64               205 M
     replacing  mariadb.x86_64 1:5.5.68-1.el7
 mysql-commercial-client-plugins       x86_64 9.3.0-1.1.el7    /mysql-commercial-client-plugins-9.3.0-1.1.el7.x86_64        63 M
 mysql-commercial-common               x86_64 9.3.0-1.1.el7    /mysql-commercial-common-9.3.0-1.1.el7.x86_64                11 M
 mysql-commercial-devel                x86_64 9.3.0-1.1.el7    /mysql-commercial-devel-9.3.0-1.1.el7.x86_64                 38 M
 mysql-commercial-embedded-compat      x86_64 9.3.0-1.1.el7    /mysql-commercial-embedded-compat-9.3.0-1.1.el7.x86_64       90 M
 mysql-commercial-icu-data-files       x86_64 9.3.0-1.1.el7    /mysql-commercial-icu-data-files-9.3.0-1.1.el7.x86_64       4.0 M
 mysql-commercial-libs                 x86_64 9.3.0-1.1.el7    /mysql-commercial-libs-9.3.0-1.1.el7.x86_64                  22 M
     replacing  mariadb-libs.x86_64 1:5.5.68-1.el7
 mysql-commercial-libs-compat          x86_64 9.3.0-1.1.el7    /mysql-commercial-libs-compat-9.3.0-1.1.el7.x86_64          6.1 M
     replacing  mariadb-libs.x86_64 1:5.5.68-1.el7
 mysql-commercial-server               x86_64 9.3.0-1.1.el7    /mysql-commercial-server-9.3.0-1.1.el7.x86_64               3.0 G
     replacing  mariadb-server.x86_64 1:5.5.68-1.el7
 mysql-commercial-test                 x86_64 9.3.0-1.1.el7    /mysql-commercial-test-9.3.0-1.1.el7.x86_64                 1.0 G
 mysql-connector-c++-commercial        x86_64 9.3.0-1.1.el7    /mysql-connector-c++-commercial-9.3.0-1.1.el7.x86_64        3.8 M
 mysql-connector-c++-commercial-compat x86_64 9.3.0-1.1.el7    /mysql-connector-c++-commercial-compat-9.3.0-1.1.el7.x86_64 8.2 M
 mysql-connector-c++-commercial-jdbc   x86_64 9.3.0-1.1.el7    /mysql-connector-c++-commercial-jdbc-9.3.0-1.1.el7.x86_64    59 M
 mysql-connector-j-commercial          noarch 1:9.3.0-1.1.el7  /mysql-connector-j-commercial-9.3.0-1.1.el7.noarch          2.8 M
 mysql-connector-odbc-commercial       x86_64 9.3.0-1.1.el7    /mysql-connector-odbc-commercial-9.3.0-1.1.el7.x86_64        93 M
 mysql-connector-odbc-commercial-setup x86_64 9.3.0-1.1.el7    /mysql-connector-odbc-commercial-setup-9.3.0-1.1.el7.x86_64  28 M
 mysql-router-commercial               x86_64 9.3.0-1.1.el7    /mysql-router-commercial-9.3.0-1.1.el7.x86_64               664 M
 mysql-shell-commercial                x86_64 9.3.0-1.1.el7    /mysql-shell-commercial-9.3.0-1.1.el7.x86_64                484 M
Installing for dependencies:
 keyutils-libs-devel                   x86_64 1.5.8-3.el7      base-aliyun                                                  37 k
 krb5-devel                            x86_64 1.15.1-55.el7_9  updates-aliyun                                              273 k
 libcom_err-devel                      x86_64 1.42.9-19.el7    base-aliyun                                                  32 k
 libkadm5                              x86_64 1.15.1-55.el7_9  updates-aliyun                                              180 k
 libselinux-devel                      x86_64 2.5-15.el7       base-aliyun                                                 187 k
 libsepol-devel                        x86_64 2.5-10.el7       base-aliyun                                                  77 k
 libverto-devel                        x86_64 0.2.5-4.el7      base-aliyun                                                  12 k
 openssl-devel                         x86_64 1:1.0.2k-26.el7_9
                                                               updates-aliyun                                              1.5 M
 pcre-devel                            x86_64 8.32-17.el7      base-aliyun                                                 480 k
 perl-JSON                             noarch 2.59-2.el7       base-aliyun                                                  96 k
 perl-Test-Simple                      noarch 0.98-243.el7     base-aliyun                                                 170 k
 unixODBC                              x86_64 2.3.1-14.el7     base-aliyun                                                 413 k

Transaction Summary
=================================================================================================================================
Install  19 Packages (+12 Dependent packages)

Total size: 5.9 G
Total download size: 3.4 M
Is this ok [y/d/N]: y
...
Installed:
  mysql-commercial-backup.x86_64 0:9.3.0-1.1.el7                   mysql-commercial-client.x86_64 0:9.3.0-1.1.el7                
  mysql-commercial-client-plugins.x86_64 0:9.3.0-1.1.el7           mysql-commercial-common.x86_64 0:9.3.0-1.1.el7                
  mysql-commercial-devel.x86_64 0:9.3.0-1.1.el7                    mysql-commercial-embedded-compat.x86_64 0:9.3.0-1.1.el7       
  mysql-commercial-icu-data-files.x86_64 0:9.3.0-1.1.el7           mysql-commercial-libs.x86_64 0:9.3.0-1.1.el7                  
  mysql-commercial-libs-compat.x86_64 0:9.3.0-1.1.el7              mysql-commercial-server.x86_64 0:9.3.0-1.1.el7                
  mysql-commercial-test.x86_64 0:9.3.0-1.1.el7                     mysql-connector-c++-commercial.x86_64 0:9.3.0-1.1.el7         
  mysql-connector-c++-commercial-compat.x86_64 0:9.3.0-1.1.el7     mysql-connector-c++-commercial-jdbc.x86_64 0:9.3.0-1.1.el7    
  mysql-connector-j-commercial.noarch 1:9.3.0-1.1.el7              mysql-connector-odbc-commercial.x86_64 0:9.3.0-1.1.el7        
  mysql-connector-odbc-commercial-setup.x86_64 0:9.3.0-1.1.el7     mysql-router-commercial.x86_64 0:9.3.0-1.1.el7                
  mysql-shell-commercial.x86_64 0:9.3.0-1.1.el7                   

Dependency Installed:
  keyutils-libs-devel.x86_64 0:1.5.8-3.el7   krb5-devel.x86_64 0:1.15.1-55.el7_9      libcom_err-devel.x86_64 0:1.42.9-19.el7  
  libkadm5.x86_64 0:1.15.1-55.el7_9          libselinux-devel.x86_64 0:2.5-15.el7     libsepol-devel.x86_64 0:2.5-10.el7       
  libverto-devel.x86_64 0:0.2.5-4.el7        openssl-devel.x86_64 1:1.0.2k-26.el7_9   pcre-devel.x86_64 0:8.32-17.el7          
  perl-JSON.noarch 0:2.59-2.el7              perl-Test-Simple.noarch 0:0.98-243.el7   unixODBC.x86_64 0:2.3.1-14.el7           

Replaced:
  mariadb.x86_64 1:5.5.68-1.el7         mariadb-libs.x86_64 1:5.5.68-1.el7         mariadb-server.x86_64 1:5.5.68-1.el7        

Complete!

启动数据库,登录数据库查验版本信息。

[root@el7 mysql-ee-9.3]# systemctl start mysqld
[root@el7 mysql-ee-9.3]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 9.3.0-commercial MySQL Enterprise Server - Commercial

Copyright (c) 2000, 2025, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select version();
+------------------+
| version()        |
+------------------+
| 9.3.0-commercial |
+------------------+
1 row in set (0.000 sec)

用 JavaScript 编写 MySQL 存储程序

在此之前,需要先安装多语言引擎(MLE)组件,这是 MySQL 企业版专属特性,社区版并不支持。

mysql> INSTALL COMPONENT 'file://component_mle';
Query OK, 0 rows affected (0.215 sec)

开始编写一个简单的 JavaScript 存储函数。

mysql> CREATE FUNCTION add_nos(arg1 INT, arg2 INT)
    ->   RETURNS INT LANGUAGE JAVASCRIPT AS 
    ->   $$
    $>     return arg1 + arg2
    $>   $$
    ->   ;
Query OK, 0 rows affected (0.01 sec)

执行该存储函数,验证其功能。

mysql> SELECT add_nos(20, 25);
+----------------+
| add_nos(20,25) |
+----------------+
|             45 |
+----------------+
1 row in set (0.030 sec)

本文主要内容就到这里,欢迎体验 MySQL 企业版,探索 MySQL 9.0 更多新特性。

对于正在备考 MySQL OCP 的桶子们,一定要上手安装一套 MySQL 企业版,实操是掌握相关知识点的最快路径。关于数据库认证的话题,推荐阅读:数据库考证到底有用么?国产时代DBA如何构建真实竞争力

写在最后

开发者可以顺畅的从官网下载 Oracle EE 和 MySQL EE,而且可以很便捷地安装使用,MySQL 30 周年真的在放送货真价实的福利。

反观国产数据库,以及国产操作系统和中间件,有几家在官网设置了“软件下载”页面呢?

开发者需要从微信、QQ、钉钉、飞书等即时通讯软件找到某网盘的链接,再下载安装包(要想下载快,还得开某网盘会员),这样真的合理且安全么?

下载完成后,能否按照官方文档(如果有,且正确)在一天之内拉起单机版呢?

广告时间

2025年5月23日-24日,ACMUG社区联合MySQL官方将于成都举办MySQL 30周年庆典。ACMUG社区与MySQL官方携手,联合 TiDB、移动云、阿里云、京东云、华为云、沃趣、腾讯云、万里数据库DBdoctor等一线厂商技术领袖,围绕MySQL技术演进、云原生实践、分布式转型等议题展开深度探讨,共赴这场技术盛宴,见证数据库生态的辉煌未来!

微信图片_20250514022515.jpg


Have a nice day ~


🌻 往期精彩 ▼

– / END / –

👉 这里可以找到我

👉 这里有得聊

如果对国产基础软件(操作系统、数据库、中间件)感兴趣,可以加群一起聊聊。
关注微信公众号:少安事务所,后台回复[群],即可看到入口。

如果这篇文章为你带来了灵感或启发,请帮忙『三连』吧,感谢!ღ( ´・ᴗ・` )~

最后修改时间:2025-05-14 09:58:20
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论