MySQL Engineering Blogs
Exporting Masked and De-Identified Data from MySQL
In all likelihood your MySQL database contains valuable and sensitive information. Within that database, MySQL protects that data using features such as encryption, access controls, auditing, views, and more. However in many cases you may need to share some of this data, but must at the same time...
Shows w/ MySQL this week
Just a friendly reminder for the busy week we have ahead of us... Please find below the shows you can find our MySQL staff at: First show where you can fid us at is the Oracle Code in Shenzen, China 2019, April 16, 2019 JSON is one of the flexible data for data exchange and storage...
Removal of implicit and explicit sorting for GROUP BY
In MySQL, historically GROUP BY was used to provide sorting as well. If a query specified GROUP BY, the result was sorted as if ORDER BY was present in the query.mysql-5.7> CREATE TABLE t (id INTEGER, cnt INTEGER); Query OK, 0 rows affected (0.03 sec) mysql-5.7> INSERT INTO t VALUES...
Support for Admin Interface in MySQL server
For some time, there have been several requests to the MySQL dev team to add dedicated support for an admin to connect to the MySQL server. We received a contribution from Facebook, bug#90395 , to add this functionality, which we then paired with more requirements, implemented in WL#12138 and...
The –bind-address option now supports multiple addresses
Before the implementation of WL#11652 in MySQL 8.0.13 , the MySQL server listened to incoming connection requests either on one or all configured network interfaces. However, in case the underlying platform supports several network interfaces it might be useful to allocate more than one network...
MySQL Connection Handling and Scaling
In this post we describe MySQL connections, user threads, and scaling. We hope that an increased understanding of how MySQL works will help application developers and system administrators to make good choices and trade-offs. We describe how connections work in a plain community server and we do...
Where you can find MySQL in April & May 2019
.As a continue of the blog post submitted on Jan 31, we would like to share with you the list of events & conferences where you can find MySQL Community team and/or MySQL experts at. Please find below the list with all known details we have right now. April 2019: Oracle Code, Rome,...
Group Replication – Consistent Reads Deep Dive
On previous posts about Group Replication consistency we: introduced consistency levels; explained how to configure the primary failover consistency; presented how to configure transaction consistency levels to achieve the consistency required by your applications. In blog 3. we presented the...
MySQL Community Server
- MySQL Installer 8.0
- Connector/C++ 8.0
- Connector/J 8.0
- Connector/NET 8.0
- Connector/Node.js 8.0
Which backup features do you require for your MySQL database backups?
"The Documents contained within this site may include statements about Oracle's product development plans. Many factors can materially affect Oracle's product development plans and the nature and timing of future product releases. Accordingly, this Information is provided to you solely for information only, is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle.