OOW17 is just around the corner. And again this year the MySQL team is very proud to present you their work mostly on MySQL 8.0 but also on NDB and all Enterprise tools we have. This year, we will also focus on the place MySQL has in Oracle’s Cloud !
Of course MySQL’s Community is also present in the schedule with very interesting talks. The full schedule related to the MySQL sessions can be found here.
Let’s focus on the agenda for the event:
Sunday, October 1st Moscone South Room 160
In this blog post, I will demonstrate how to run and use sysbench histograms.
One of the features of sysbench that I often I see overlooked (and rarely used) is its ability to produce detailed query response time histograms in addition to computing percentile numbers. Looking at histograms together with throughput or latency over time provides many additional insights into query performance.
Here is how you get detailed sysbench histograms and performance over time:
sysbench --rand-type=uniform --report-interval=1 --percentile=99 --time=300 --histogram --mysql-password=sbtest oltp_point_select --table_size=400000000 run
There are a few command line options to consider:
Percona announces the release of Percona XtraDB Cluster 5.6.37-26.21 on September 20, 2017. Binaries are available from the downloads section or our software repositories.
Percona XtraDB Cluster 5.6.37-26.21 is now the current release, based on the following:
All Percona software is open-source and free.
…
[Read more]In this blog post, we’ll look at how ProxySQL improves MySQL SSL connection performance.
When deploying MySQL with SSL, the main concern is that the initial handshake causes significant overhead if you are not using connection pools (i.e., mysqlnd-mux with PHP, mysql.connector.pooling in Python, etc.). Closing and making new connections over and over can greatly impact on your total query response time. A customer and colleague recently educated me that although you can improve SSL encryption/decryption performance with the AES-NI hardware extension on modern Intel processors, the actual overhead when creating SSL connections comes from the handshake when multiple roundtrips between the server and client are needed.
With ProxySQL’s support for SSL on its backend connections and connection pooling, we can have it sit in front of any application, on the same server (illustrated below):
…
[Read more]
This has results for IO-bound Linkbench on a large server. I
previously shared results for in-memory & low-concurrency
Linkbench.
tl;dr
Configuration
I used my Linkbench repo and helper scripts to run sysbench with
maxid1=1B, loaders=4 and requestors=16 so there will be 4+1
concurrent connections doing the load (4 for link/count tables, 1
for node table) and 16 connections running transactions after the
load finishes. My linkbench repo …
Comparing Oracle MySQL Group Replication and Galera Cluster through a probability perpective seems quite interesting.
At commit time both use a group certification process that requires network round trips. The required time for these network roundtrips is what will mainly determined the cost of a transaction. Let us try to compute an estimate of the [...]
Join Galera Cluster team! Both jobs are key positions at Codership. You will influence a great deal to Galera Cluster user experience. We have thousands of users.
Galera Cluster QA Engineer
The QA Engineer/release manager will be responsible for working with the development team at Codership and create and execute tests, make builds of Galera Cluster and develop and extend test automation frameworks.
You will be also working closely with MariaDB development and quality assurance teams to prioritize software bug fixes.
Tasks
On Sunday I will travel over to Dublin for Percona Live 2017.
I have two sessions, a keynote on the Wednesday morning where I’ll be talking about all the fun new stuff we have planned at Continuent and some new directions we’re working on.
I also have a more detailed session on our new appliers for Kafka, Elasticsearch and Cassandra, that’s Tuesday morning.
If you haven’t already booked to come along, feel free to use the discount code SeeMeSpeakPLE17 which will get you 15% off!
Filed under: Presentations and Conferences Tagged: continuent, mysql,
percona live, …
Recently, Oracle added new certification for MySQL,
MySQL Cloud Service 2018 Implementation Essentials
This exam is all about MySQL Enterprise Edition 5.6. with MySQL Cloud Service. Best study resource for this exam is “MySQL official documentation”. Along with MySQL Enterprise topic, this exam also includes one major part of MySQL Cloud Service.
Exam Topics:
Hi,
In this post I am going to show some tricks on using BATS
framework + PyTest + Python X Plugin things, to have combined,
simple test solutions.
Let’s describe MySQL X Plugin side, here is the full class:
# Connecting to MySQL and working with a Session
import mysqlx
class MyXPlugin:
def __init__(self, schema_name, collection_name):
# Connect to a dedicated MySQL server
self.session = mysqlx.get_session({
'host': 'localhost',
'port': 33060,
'user': 'bakux',
'password': 'Baku12345',
'ssl-mode': mysqlx.SSLMode.DISABLED
})
self.schema_name = schema_name
self.collection_name = collection_name
# Getting schema object
self.schema = self.session.get_schema(self.schema_name)
# Creating collection
self.schema.create_collection(self.collection_name, reuse=True)
# Getting collection object …[Read more]