Atomics (or GCC intrinsics) were first introduced in InnoDB (5.0) by a patch from Mark Callaghan’s team at Google for mutexes and rw-locks. InnoDB code then was written in C. When the code was ported to C++ , part of the 5.6 release, there was no C++ standard for atomics.…
Facebook Twitter LinkedIn
We are proud to announce the latest release of ProxySQL version 2.1.1 on the 21st of April 2021
ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded from the ProxySQL Repository (instructions here) or for a Docker image check out the Official ProxySQL Docker Repository. ProxySQL is freely usable and accessible according to the GNU GPL v3.0 license.
Release Overview Highlights
ProxySQL v2.1.1 is a patch release comprising of minor
backward compatible changes and bug fixes. This release is the
first patch release of the 2.1 branch and inclues many fixes and
features that were introduced in the 2.0.x branches after 2.1 was
released.
Be sure to try out the ProxySQL …
[Read more]We are pleased to announce the release of MySQL Cluster 8.0.24, the latest GA, along with 7.6.18, 7.5.22, 7.4.32, and 7.3.33. MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides: In-Memory storage – Real-time performance (with optional checkpointing to disk) Transparent Auto-Sharding – Read & write scalability Active-Active/Multi-Master geographic replication 99.999% […]
Be it running reports or displaying data in some other
visualization, SQL SELECT column expressions should
be meaningful and understandable. To provide those valuable query
results, SQL Developers, use a multitude of available functions,
adjacent columns, or other means not readily apparent to
end-users. All that being said, the column names often suffer the
most as far as readability is concerned, taking on long function
call names or other combined expressions. But, as luck would be
on our side, there is an easy fix and that is aliasing columns
using the AS keyword. Although AS is
optional – in this particular context – I err on the side of
readability and use it when aliasing SELECT column
expressions.
A significant improvement has come to Galera Cluster 4 for MySQL, in the form of streaming replication. When you are dealing with large (greater than 2GB in size) or long running transactions, previous releases of Galera Cluster would reject the transaction; in the current release transactions can be split into fragmented chunks and those rows can be replicated in chunks to the other nodes even before commit. This is the feature that will remove you from all cluster stall issues due to large transaction processing!
While disabled by default, you can use it and configure it dynamically, and there is also the ability to monitor streaming replication progress. Come to this webinar to learn from the primary author, Seppo Jaakola, on why he implemented the feature, how you can use it, finding the optimal fragment size based on workload, and the design trade-offs for the initial release in where the focus was more on functionality over …
[Read more]For the sixth in the Competitor Comparison series in which we look at the main solutions for MySQL high availability, disaster recovery and geographic distribution, I got a chance to interview Matt Lang, Customer Success Director, Americas at Continuent. We focused on highly available, geo-scale, multi-region MySQL for mission-critical sites and apps with Do-it-Yourself (DIY) solutions as compared to MySQL clustering with Continuent Tungsten, the only complete, fully-integrated clustering solution for MySQL - on-premises, in the cloud, hybrid-cloud or multi-cloud.
Tags: Do-it-Yourself (DIY)high availability (HA)MySQL …
[Read more]MySQL 8.0.24 has been released today \o/
As usual, it’s highly advised to read the release notes to get informed about the changes and bug fixed.
MySQL is Open Source and each release contains contributions from our great Community. Let me thanks all the contributors on behalf of the entire MySQL Team: Thank you !
MySQL 8.024 includes contributions from Daniël van Eeden, Kaiwang Chen, Zhai Weixiang, Venkatesh Prasad Venugopal, Jingbo Zhao, Yuxiang Jiang, Brian Yue, Hope Lee, Stanislav Revin, Mattias Jonsson, Facebook and a suggestion from Dmitriy Philimonov.
Once again, thank you all for your great contributions.
Here is the list of the above contributions and related bugs:
…
[Read more]Dear MySQL users,
The MySQL developer tools team announces 8.0.24 as our General Availability (GA) for MySQL Workbench 8.0.
For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?152
The release is now available in source and binary form for a number of platforms from our download pages at:
http://dev.mysql.com/downloads/tools/workbench/
Enjoy!
A couple of years ago, MySQL Connector/Net shipped with a feature that allowed the connector to automatically create a SSH “tunnel” to a remote MySQL host. This could be useful in that it allows a remote MySQL host to only run with a secure port and a local client could connect to a local port to access it. We wrote about that feature in a blog post you can read here.
Today we are announcing that starting with the 8.0.24 release we are removing that feature. We decided to take this action for a few reasons. First, very few people were actually using the feature. Including a security sensitive feature that few people use is something we always want to examine. In addition, we were starting to encounter some friction between the encryption methods and ciphers that library supported and those that we wanted to support …
[Read more]
Dear MySQL users,
MySQL Shell 8.0.24 is a maintenance release of MySQL Shell 8.0
Series (a
component of the MySQL Server). The MySQL Shell is provided under
Oracle’s
dual-license.
MySQL Shell 8.0 is highly recommended for use with MySQL Server
8.0 and 5.7.
Please upgrade to MySQL Shell 8.0.24.
MySQL Shell is an interactive JavaScript, Python and SQL console
interface,
supporting development and administration for the MySQL Server.
It provides
APIs implemented in JavaScript and Python that enable you to work
with MySQL
InnoDB Cluster and use MySQL as a document store.
The AdminAPI enables you to work with MySQL InnoDB Cluster and
InnoDB
ReplicaSet, providing integrated solutions for high availability
and
scalability using InnoDB based MySQL databases, without requiring
advanced
MySQL expertise. For more information …
