In MySQL 5.7.8 we added support for version tokens. This is a new feature that enables you to prevent accessing incorrect or out-of-date data, and stray modifications executing on the wrong server.
For some backstory
When there are multiple MySQL instances running on a Linux machine, there is a reasonable chance that clients could connect to the wrong instance.…
New SSL alternatives SSL connections in previous versions of MariaDB Connector/C based on the OpenSSL library. The OpenSSL heartbleed bug, licensing problems and the lack of supporting different transport layers were the main reasons that we decided to offer SSL alternatives. In addition to OpenSSL the following SSL libraries are supported in Connector/C 3.0: GnuTLS […]
The post New in MariaDB Connector/C 3.0 – Part I: SSL appeared first on MariaDB.org.
In the previous EXPLAIN FORMAT=JSON is Cool! series blog post, we discussed the
group_by_subqueries
member (which is child of
grouping_operation
). Let’s now focus on the
grouping_operation
and other details of
GROUP BY
processing.
grouping_operation
simply shows the details of what happens when the
GROUP BY
clause is run:
mysql> explain format=json …[Read more]
Awesome.. +1 +1.. This is super useful for me and helped me to connect o Amazon RDS..
I've ran a simple test to see the performance impact of TLS on
MySQL connections with MySQL Connector/Python
The test results are in this Jupyter notebook.
TL;DR:
Not tested:
Testing functionalities and options for a database can be challenging at times, as a live production environment might be required. As I was looking for different options, I was directed by Derek Downey to this post in the Percona blog.
The blog discussed an interesting and fun tool from Percona, tpcc-mysql. I was interested in testing the tool so I decided to play around with it in an AWS EC2 server.
In this post I will expand on the Percona blog post, since the tool lacks documentation, as well as explain how I used it to create a MySQL Benchmark in AWS.
Why tpcc-mysql?
There are various reasons why tpcc-mysql could be a good …
[Read more]Too often developers and DBAs struggle to pinpoint the root cause of MySQL database performance issues, and then spend too much time in trying to fix them. Wouldn’t it be great to bypass wasted guesswork and get right to the issue?
In our upcoming webinar Tired of MySQL Making You Wait? we’re going to help you discover how to significantly increase the performance of your applications and reduce database response time.
In this webinar, Principal Architect Alexander Rubin and Database Evangelist Janis Griffin will provide the key steps needed to identify, prioritize, and improve query performance.
They will discuss the following topics:
What better to do during the holiday season than to read the Log Buffer? This log buffer edition is here to add some sparkle to Oracle, MySQL and SQL Server on your days off.
Oracle:
Check Out Our Latest Technical Resources for MySQL, MariaDB, PostgreSQL and MongoDB
This is our last s9s Tools & Resources communication in 2015 and as we prepare to kick off 2016, we’d like to take this opportunity to thank you for your support in the year gone by and to wish you a successful start to the new year!
This is a summary of all the resources we recently published. Please do check it out and let us know if you have any comments or feedback.
Momentum Highlights Severalnines breaks records on MongoDB, MySQL & PostgreSQL
At Etsy, we have a nice, clean, streamlined build process. We have a command for setting up RAID, and another for OS installation. OS installation comes with automagic for LDAP, Chef roles, etc.
We came across an odd scenario today when a co-worker was building a box that gave the following error:
Traceback (most recent call first): File “/usr/lib/anaconda/storage/partitioning.py”, line 1066, in allocatePartitions disklabel = disklabels[_disk.path] File “/usr/lib/anaconda/storage/partitioning.py”, line 977, in doPartitioning allocatePartitions(storage, disks, partitions, free) File “/usr/lib/anaconda/storage/partitioning.py”, line 274, in doAutoPartition exclusiveDisks=exclusiveDisks) File “/usr/lib/anaconda/dispatch.py”, line 210, in moveStep rc = stepFunc(self.anaconda) File “/usr/lib/anaconda/dispatch.py”, line 126, in gotoNext self.moveStep() File “/usr/lib/anaconda/dispatch.py”, line 233, in …
[Read more]
