Nice post!

LikeLiked by 1 person

• Are thinking the table fragmentation will be happened with only DELETE’s ?
• Do you believe the INSERT’s will also cause the table fragmentation ?

Yes, INSERT’s with the ROLLBACK can also create the table fragmentation . In this blog I am going to explain how the INSERT is causing the table fragmentation .

How the table fragmentations is happening with INSERT and ROLLBACK ?

When you triggered the INSERT, it will start to write the data into it’s table space file ( .ibd ) . Right ?

From the snap, I have created the table and started the transaction ( BEGIN ) with INSERT . Within the transaction the INSERT has been completed but still I did not commit / rollback the transaction .

You can check the table space file growth to 1.2 GB .

Now, I am going to rollback the transaction .

After the ROLLBACK completed, still the …

As our Percona Kubernetes Operator for Percona XtraDB Cluster gains in popularity, I am getting questions about its performance and how to measure it properly. Sysbench is the most popular tool for database performance evaluation, so let’s review how we can use it with Percona XtraDB Cluster Operator.

Operator Setup

I will assume that you have an operator running (if not, this is the topic for a different post). We have the documentation on how to get it going, and we will start a three-node cluster using the following cr.yaml file:

apiVersion: pxc.percona.com/v1-3-0
kind: PerconaXtraDBCluster
metadata:
  name: cluster1
  finalizers:
    - delete-pxc-pods-in-order
spec:
  secretsName: my-cluster-secrets
  sslSecretName: …

Just when we thought that IT and cloud terminology couldn’t get any more confusing, a new term was coined to seemingly simplify it all: hybrid cloud.

As is often the case, one cloud doesn’t fit all, and over the past few years, IT teams around the globe have realized that combining the capabilities of various public clouds (aka multi-cloud) with on-premises private clouds (aka hybrid cloud) enables organizations to tailor their technology environments to match their business drivers more effectively.

In fact, many predicted in 2019 that hybrid cloud would be the future (as opposed to multi-cloud) and it is increasingly looking that way.

“2019 will be the year cloud customers start to abandon the notion of multi-cloud and anchor on a hybrid-cloud future involving a mix of on-premise services, often enabled or augmented by services from their preferred cloud provider, and managed cloud services.” – …

The MySQL 8.0 DBA Certification is now available. 85 questions to get the first MySQL 8.0 certification ! You can find details on the Oracle Exam 1Z0-908 page.

This exams covers mostly all relevant topics for all MySQL 8.0 Administrator and you can register for it on Pearsonvue’s website.

Good luck if you are taking the exam !

Artwork credits: student by Wilson Joseph and Certificate by Berkah Icon from the Noun Project

You can now earn your MySQL 8.0 DBA Certification Exam is now available. It is Oracle Exam 1Z0-908 and I was one of the many question writers.  Some of you may remember when I was the head of MySQL Certification and I can assure you this is a very complete test of all your MySQL DBA skills. And it asks very relevant questions and not trivial facts. So anyone taking this exam and earning this certification really knows their MySQL!

So what do you need to know:

Architecture

• Configure client connections to the server
• Understand how MySQL stores data
• Understand how InnoDB stores data and logs
• Configure buffers and caches
• Understand and use the Data Dictionary

Security

Planning to attend Oracle Open World 2020 in London?  Make sure to:

• Visit our booth
• Join us at our evening reception
• Check out our MySQL sessions

MySQL Booth:

Located in Zone 4 , stop by to meet the MySQL EMEA team and learn the latest about MySQL from our local experts. 

MySQL Reception

Feb 12, 2020 - 6:00 PM - 11:00 PM
Tapa Tapa Warehouse K, Western Gateway ExCel West
London E16 1DR

Join us for a drink and a conversation on all things related to MySQL. Meet with Rich Mason, General Manager of the MySQL GBU and additional members from MySQL’s EMEA team for an open discussion.

Get face-to-face with MySQL executives, learn more about MySQL’s product strategy and mingle with peers and other MySQL …

My post-FOSDEM detox has started - despite preparing by reading some survival guides, I hadn't really fathomed the variety and quantity (and quality) of beer that would flow over four days.  On reflection however, the beer flow has been far exceeded by the flow of tech content and conversation.

On Thursday and Friday I attended the pre-FOSDEM MySQL Days fringe event, where there were two tracks of talks and tutorials on MySQL including sessions on :
 - MySQL Server simplification
 - MySQL replication tooling improvements
 - Configuring group replication
 - Troubleshooting group replication
 - Using DNS for loadbalancing and failover
 - Upgrading to MySQL 8.0 …

In this tutorial, we'll learn to build an Angular CRUD example from scratch using the latest version which is as the time of this writing Angular 9.

We'll be using a CRUD REST API mocked using json-server which lets you generate a complete working API with nearly zero-lines of code.

We'll not be learning how to use json-server but you can see the complete instructions from this tutorial after generating the Angular project.

Step 1 — Mocking the Backend Using json-server Step 2 — Creating an Angular 9 Module Step 3 — Importing Angular HttpClientModule and FormsModule Step 4 — Creating Angular Component(s) Step 5 — Adding Angular Routing Step 6 — Creating an Angular Service Step 7 — Creating a Model Step 8 — Implementing the CRUD Methods Step 9 — Calling the CRUD Methods

Prerequisites

As always, we'll need to have a few prerequisites for this tutorial:

The basic concepts of …

The I/O performance is vital for MySQL databases. Data is read and written to the disk in numerous places. Redo logs, tablespaces, binary and relay logs. With an increase of the usage of solid state drives I/O performance has significantly increased allowing users to push their databases even faster but even then I/O may become a bottleneck and a limiting factor of the performance of the whole database. In this blog post we will take a look at the things you want to check if you notice your I/O performance is high on your MySQL instance.

What does “High” I/O utilisation mean? In short, if the performance of your database is affected by it, it is high. Typically you would notice it as writes slowing down in the database. It will also clearly manifest as high I/O …