The latest release of the MySQL Shell 8.0.13 (GA) introduced some interesting improvements and features, for more information see the full changelog here: https://dev.mysql.com/doc/relnotes/mysql-shell/8.0/en/mysql-shell-news-8-0-13.html. One of those features was the introduction of a convenient and easy way to import JSON documents to a MySQL Server database.…
Oct
24
2018
Oct
23
2018
One important way to protect your data is to keep your Tungsten Clustering software up-to-date.
A standard cluster deployment uses three nodes, which allows for no-downtime upgrades along with the ability to have a fully available cluster during maintenance.
Please note that with only two database cluster nodes, there is a window of vulnerability created by leaving zero failover candidates available when the lone slave is taken down for service.
The Best Practices: Staging Performing a No-Downtime Upgrade for a Staging Deployment
When upgrading a Staging-style deployment, all nodes are upgraded
at once in parallel via the tools/tpm update command
run from inside the staging directory on the staging host.
No Master switch happens, and all layers are restarted to use the new code. …
[Read more]
Oct
23
2018
Recently we had a customer that had issues with a filled disk on the server hosting their Docker pmm-server environment. They were not able to access the web UI, or even stop the pmm-server container because they had filled the /var/ mount point.
Setting correct expectations
The best way to avoid these kinds of issues in the first place is to plan ahead, and to know exactly with what you are dealing with in terms of disk space requirements. Michael Coburn has written a great blogpost on this matter:
We are now using …
[Read more]
Oct
23
2018
One of the most common questions about privileges in MySQL and MariaDB is how would a user revoke access to a particular table, in a large database with hundreds or thousands of tables, while keeping the rest available. Currently, there is no easy solution. Just grant access to everything else, individually. Not only does this reduce server performance, but is a nightmare to maintain. Reverse privileges solve this and more. And they are simple to explain to new admins too! So I look forward to sharing the knowledge during my presentation at PLE18.
DBAs would benefit from this talk the most. As it is a feature still under development, we are open for input from the community. Tell us what you think we should do to make this feature the best it can be.
What I’m looking forward to…
It will be quite …
[Read more]
Oct
23
2018
This will be a short rant: why is relay_log_space_limit still not dynamic ?
This is obviously a rhetorical question. I see no reason why this MySQL System Variable is not (yet) dynamic. Obviously, changing the value of this variable could need replication to be stopped (like for slave_parallel_type, slave_parallel_workers and slave_preserve_commit_order), but at least it would not need a MySQL
Oct
23
2018
The MySQL Development Team is very happy to announce the second 8.0 Maintenance Release of InnoDB Cluster!
In addition to bug fixes, 8.0.13 brings some new exciting features:
- Defining the next primary instance “in line”
- Defining the behavior of a server whenever it drops out of the cluster
- Improved command line integration for DevOps type usage
Here are the highlights of this release!…
Oct
22
2018
Mydbops team has presented at 15th edition Open source India Conference happened at Bangalore on 12-10-2018. Manosh malai ( Senior Devops/ DB Consultant ) and Kabilesh P R ( Co-Founder Mydbops ) has made presentation on “Evolution of DBA in the Cloud Era“. They have shared the value addition that DBA’s can bring into any organisation who have adopted to cloud ( DBaaS ). They have shared a case study of their consulting experience too.
Oct
22
2018
The MySQL Development team is very happy to announce that MySQL 8.0.13 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release. Please download 8.0.13 from dev.mysql.com or from the MySQL Yum, APT, or SUSE repositories.…
Oct
22
2018
Dear MySQL users,
MySQL Connector/Node.js is a new Node.js driver for use with the
X
DevAPI. This release, v8.0.13, is a maintenance release of
the
MySQL Connector/Node.js 8.0 series.
The X DevAPI enables application developers to write code that
combines
the strengths of the relational and document models using a
modern,
NoSQL-like syntax that does not assume previous experience
writing
traditional SQL.
MySQL Connector/Node.js can be downloaded through npm (see
https://www.npmjs.com/package/@mysql/xdevapi for details) or
from
https://dev.mysql.com/downloads/connector/nodejs/.
To learn more about how to write applications using the X DevAPI,
see
http://dev.mysql.com/doc/x-devapi-userguide/en/. For more
information
about how the X DevAPI is implemented in MySQL Connector/Node.js,
and
its usage, see …
Oct
22
2018
Dear MySQL users,
Version 8.0.13 is the latest General Availability release of the
8.0
series of MySQL Connector/J. It is suitable for use with MySQL
Server
versions 8.0, 5.7, 5.6, and 5.5. It supports the Java
Database
Connectivity (JDBC) 4.2 API, and implements the X DevAPI.
This release includes the following new features and changes,
also
described in more detail on
https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-13.html
As always, we recommend that you check the “CHANGES” file in
the
download archive to be aware of changes in behavior that might
affect
your application.
To download MySQL Connector/J 8.0.13 GA, see the “Generally
Available
(GA) Releases” tab at …