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]MySQL databases power your business, and every minute of downtime has costs. High availability is essential and you can minimize risk with MySQL Group Replication.
The post Minimizing Risk with MySQL Group Replication appeared first on Datavail.
Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter.
This blog post is with Dana Van Aken, a Ph.D. student in Computer Science at Carnegie Mellon University. Her talk is titled Automatic Database Management System Tuning Through Large-Scale Machine Learning. DBMSs are difficult to manage because they have hundreds of configuration “knobs” that control factors such as the amount of memory to use for …
[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]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 ...continue reading "Probability perspective on MySQL Group replication and Galera Cluster"
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!
Recently, Oracle added new certification for MySQL,
MySQL Cloud Service 2018 Implementation Essentials
This exam is all about MySQL Enterprise Edition with MySQL Cloud Service. Best study resource for this exam is “MySQL official documentation”. Along with MySQL Enterprise topics given in exam topics, 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]
With the next version of MySQL that is MySQL 8, there is a very
nice feature of creating "roles" which can be assigned
certain privileges and then these roles can be assigned to users,
thus helping us in maintaining the principle of least
privilege.
It makes our life as developers and DBAs easier as we do not have
to remember what are the specific privileges assigned to
different users. These "roles" can simply be assigned or
de-assigned from users as necessary.
The setup process is pretty easy and intuitive.
1. Create Role:
CREATE ROLE 'read', 'write', 'read_write';
Which essentially …
