MySQL Engineering Blogs
Protecting your data – Part II: Preventing unwanted data changes on Group Replication members by asynchronous replication channels
Further to our earlier blog post about Fail-safe enhancements to Group Replication, where we discussed enhancements against data modification in members which are not ONLINE, we now present here additional changes to protect data from being accidentally modified by asynchronous replication...
MySQL Guide to Ports
There could be from one to over ten ports used within your MySQL ecosystem. It really depends on what you have enabled, which components you are using, how your applications connect, and other characteristics of your environment. From a security point, these ports need to be opened just wide...
MySQL 8.0: Support for BLOBs in TempTable engine
In some cases, the server creates internal temporary tables while processing statements. These tables could be stored in memory or on disk – the first option is preferred but there exist some limitations. One of such restrictions was presence of TEXT or BLOB columns in the table; as...
Audit Log’s JSON format logging
Blood, sweat, tears and the JSON format logging is finally supported by the Audit Log plugin. This comes in pair with the feature that allows to read log events, which could be useful for rapid analysis of the audit log trail without the need of accessing the files directly.…
Upgrading to MySQL 8.0 with Spatial Data
The big change from MySQL 5.7 to 8.0 when it comes to spatial data, is the support for multiple spatial reference systems and geographic computations. This means that the SRIDs of geometries actually have meaning and affect computations. In 5.7 and earlier, however, the SRIDs are ignored, and all...
Detecting Incompatible Use of Spatial Functions before Upgrading to MySQL 8.0
There are many changes to spatial functions in MySQL 8.0: Old aliases for functions have been removed (after being deprecated in 5.7) Functions that don’t support geographic computations raise errors if called with geographic data in their arguments Many functions support geographic...
Upgrading to MySQL 8.0? Here is what you need to know…
In my previous blog post, I had described the steps to perform an in-place upgrade for upgrading from MySQL 5.7 to MySQL 8.0. In this blog post, I will discuss about the considerations that needs to be taken into account while upgrading to MySQL 8.0 The general in-place upgrade requirement is that...
The connection_control plugin : Keeping brute force attack in check
To quote book of all knowledge:In cryptography, a brute-force attack consists of an attacker trying many passwords or passphrases with the hope of eventually guessing correctly. The attacker systematically checks all possible passwords and passphrases until the correct one is found.…
MySQL Community Server
- MySQL Cluster 7.6
- Connector/NET 6.9
- Connector/NET 6.10
- MySQL for Visual Studio 1.2
- Connector/C++ 1.1
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.