Ahoi, I made three proposals for Percona Live. (Even I know being
a lonely (sniff) freelancer with no backup). At least I'm
for sure an early adopter about the three topics I submitted and
know for sure what I'm talking about *g*
Even being Puppet certified. Ansible is my love. Never been that
fast in doing automation \o/
This is a tutorial about Docker and Galera/MySQL.
A few days ago I came across the announcement that MaxScale 1.3 finally supports Persistent Connection.
ProxySQL has supported Persistent Connection since it was a prototype (sometime back in 2013). I am therefore very happy that the MaxScale Team finally introduced a long awaited feature.
However, MaxScale's implementation has a serious drawback and I consider it a serious bug (more details towards the end of the article). A bug so serious that it shouldn't reach any GA release.
I like running benchmarks, and given the new feature in MaxScale, I thought it a good time to compare ProxySQL vs MaxScale again. It's been around 6 months since the previous benchmark.
ProxySQL vs MaxScale Benchmark setup
The benchmark setup is very simple:
A few days ago I came across the announcement that MaxScale 1.3 finally supports Persistent Connection.
ProxySQL has supported Persistent Connection since it was a prototype (sometime back in 2013). I am therefore very happy that the MaxScale Team finally introduced a long awaited feature.
However, MaxScale's implementation has a serious drawback and I consider it a serious bug (more details towards the end of the article). A bug so serious that it shouldn't reach any GA release.
I like running benchmarks, and given the new feature in MaxScale, I thought it a good time to compare ProxySQL vs MaxScale again. It's been around 6 months since the previous benchmark.
ProxySQL vs MaxScale Benchmark setup
The benchmark setup is very simple:
The previous post in the EXPLAIN FORMAT=JSON is Cool! series showed an example of the query
select dept_name from departments where dept_no in (select dept_no from dept_manager where to_date is not null)
, where the subquery was materialized into a temporary table and then joined with the outer query. This is known as a semi-join optimization. But what happens if we turn off this optimization?
EXPLAIN FORMAT=JSON
can help us with this investigation too. …
[Read more]Naturally, I ran into this problem in the middle of the night when the client was asleep and I had no access to the Magento administrative interface. The short story is that after running a re-index of the site, the home page began returning a 404 erro...
We could use inotify-tools to monitor file or directory IO state
yum install inotify-tools
#inotifywait -m /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd
Setting up watches. Watches established. /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY …[Read more]
The source of this post is in this gist on nbviewer.
After reading about the difference between MySQL Connector/Python and MySQLdb on this blog post I wondered how the C Extension option in Connector/Python would perform.
If you want to run the code yourself you'll need: Jupyter/IPython, Python 3, Requests, MySQLdb, Connector/Python, Matplotlib, Pandas and MySQL.
In [1]:
%matplotlib notebook
In [2]:
import random
import gzip
import time
import pandas as pd
import matplotlib.pyplot as plt
import requests
import mysql.connector
import MySQLdb
for imp in [mysql.connector, MySQLdb]:
print('Using {imp} {version}'.format(imp=imp.__name__, version=imp.__version__))
print('C Extension for …[Read more]
When trying out new software there are many other questions you may ask and one of those is going to be the one above. The answer requires you to have built your software to capture and record low level database metrics and often the focus of application developers is slightly different: they focus on how … Continue reading Is MySQL X faster than MySQL Y? – Ask queryprofiler
The post Is MySQL X faster than MySQL Y? – Ask queryprofiler first appeared on Simon J Mudd's Blog.
Usually when one says “SSL” or “TLS” it means not a specific protocol but a family of protocols. Wikipedia article has the details, but in short — SSL 2.0 and SSL 3.0 are deprecated and should not be used anymore (the well-known POODLE vulnerability exploits the flaw in SSL 3.0). TLS 1.0 is sixteen years […]
The post The State of SSL in MariaDB appeared first on MariaDB.org.
The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.10, MariaDB Galera Cluster 5.5.47, and MariaDB Galera Cluster 10.0.23. See the release notes and changelogs for details on each release. Download MariaDB 10.1.10 Release Notes Changelog What is MariaDB 10.1? MariaDB APT and YUM Repository Configuration Generator Download MariaDB Galera Cluster 5.5.47 […]
The post MariaDB 10.1.10 and MariaDB Galera Cluster 5.5.47 and 10.0.23 now available appeared first on MariaDB.org.