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 …

It’s been a while since I wrote about ClickHouse, there are a lot of new features that are worth mentioning, and for this, I recommend to follow the Altinity Blog but today I want to look at the improved integration of ClickHouse and MySQL.

There are two features:

1. Using MySQL protocol and MySQL client to connect to ClickHouse
2. Use MySQL tables to select and join with ClickHouse tables

Using MySQL Protocol

By enabling MySQL protocol in ClickHouse server, you will allow for the MySQL command line tool or applications that typically connect to MySQL to connect to ClickHouse and execute queries.

With this, keep in mind:

• It does not automatically allow you to use MySQL SQL syntax, you still need to write queries in ClickHouse-dialect.
• The same issue with datatypes. ClickHouse uses Int32/Int64 …

Understanding how MySQL handles connections and Troubleshooting MySQL error 1040 – Too many connections! How to interpret “MySQL error 1040 – Too many connections ! ” ?

When a client tries to log into MySQL it may sometimes be rejected and receive an error message saying that there are “too many connections“. This means that the maximum number of clients that may be connected to the server has been reached. Either the client will have to wait for another client to log off, or the administrator will have to increase the maximum number of connections allowed.

Information about connections to a server can be found using the SHOW STATUS statement:

SHOW STATUS LIKE 'max_used_connections';

Prerequisite – Few points to remember before working or troubleshooting MySQL ” Too many connections ! ” error

1. MySQL does not have it’s own thread handling mechanism / …

Last week I completed the Continuent Tungsten Solutions Training in London!

I spent two full days with eight of our customers and our host Chris Parker, one of Continuent’s Customer Success Directors, listening and learning, doing exercises, and getting to know a range of DBAs and System Engineers working in industries like telecom and e-commerce!

Chris did an incredible job guiding us and fielding questions on MySQL database management with Tungsten Clustering – I feel so lucky I got to do this – it was so fun!!

First we went through an install of a simple three-node cluster using allotted AWS ec2 instances. We created the directories and database users and got the Tungsten …

Care to give some detail about the usecase for a single transaction affecting 9 GB of data? Apart from backup restoration, that seems quite an anti-pattern…

LikeLiked by 1 person

Recently I had the discussion with one of my colleague about the impact of MySQL binary logs . It was a nice discussion and triggered me further to benchmark the MySQL with/without binary logs . The result is amazing

Server configuration :

• 4 CPU
• 8 GB RAM
• 100 GB SSD

MySQL version : 8.0.19

I have conducted the test with a bulk transaction . It is a single thread INSERT with 9.5 GB of data .

Test 1 – With binary log :

screen 1 :

from the screen 1, I had split my terminal to three screens .

1st screen : I have triggered the bulk INSERT

2nd screen : The INSERT has started to execute and in executing state .

3rd screen : You can see the individual table-space file ( .ibd ) keep growing ( 5.6 GB ) on …