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

• Continuously refine the QA process to improve product quality
• Troubleshoot and work with the development team to isolate issues
• Create and maintain automated tests
• Make Galera software builds (our build pipeline uses python, Jenkins, Docker and Qemu)
• Assist customers with their …

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: 

• Oracle MySQL Enterprise Product Suite
• Installation and Architecture
• Database Design
• MySQL …

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 …

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 …

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 Charity Majors, CEO/Cofounder of Honeycomb. Her talk is Debugging with Logs (and Other Events). Her presentation covers some of the lessons every engineer should know (and often learns the hard way): why good logging solutions are so expensive, why treating your logs as strings can be costly and dangerous, how logs can impact code …

What is a median value?

The median of an array of numbers is the value of the middle item in the array, assuming the array is sorted. If the array has an even number of items, the median represents the average of the two middle values in the array.

This value is very popular one tries to understand “in which half my value is?”. For example, I got a D (or 80) in my last test at school, am I in the top 50% of my class students or not?

As a practical example, let’s look into the process of retrieving the median value from the following array of school test grades: [55, 80, 95, 100, 99, 70, 60].

1. First, we’ll sort the array: [55, 80, 95, 100, 99, 70, 60]  ===> [55, 60, 70, 80, 95, 99, 100].
2. The array contains 7 items, which isn’t an even number, so therefore the median is the (7 / 2 + 1) item, which is the 4th item => 80.

Calculating the median value of …

This edition of Log Buffer covers Cloud, Oracle, SQL Server and MySQL and much more.

Cloud:

Introducing managed SSL for Google App Engine

Using Cloud Foundry CUPS to inject Spring Security credentials into a Spring Boot Application

ClusterControl in the Cloud – All Our Resources

Monitoring Amazon Aurora Audit Events with Amazon CloudWatch

Integrating Teradata with Amazon …

We are happy to announce that MySQL team is part of the OpenSource Lisbon 2017 as Gold sponsor. You can find our experts at the booth in expo area as well as you can listen the MySQL talk on Oracle MySQL: "How are you doing?" given by Mario Beck, the MySQL Sales Consulting Manager for EMEA. Mark your calendars for September 28, 2017 for OS Lisbon 2017!!! See more details at OS Lisbon 2017.