Please join Percona CEO Peter Zaitsev as he presents “Performance Analyses and Troubleshooting Technologies for Databases” on Wednesday, August 7th, 2019 at 11:00 AM PDT (UTC-7).

Register Now

Have you heard about the USE Method (Utilization – Saturation – Errors), RED (Rate – Errors – Duration) or Golden Signals (Latency – Traffic – Errors – Saturations)?

In this presentation, we will talk briefly about these different-but-similar “focuses” and discuss how we can apply them to data infrastructure performance analysis troubleshooting and monitoring.

We will use MySQL as an example, but most of this talk applies to other database technologies as well.

…

Data is an invaluable asset to any organisation and every data should not be viable to all DB users. I had a requirement from one of our Support client to hide (mask) a few columns to the end user. Those columns contains sensitive information like payment details and mobile numbers.

In this blog post I am going to explain the how data masking features in Maxscale can be benefitted in such use case.

Maxscale Masking

Masking filter was introduced on the Maxscale 2.1 version . Below is a simple scenario. The columns “name” and “mobile” from the table student has to be masked.

[root@labs7.mydbops.com ~]# maxscale --version                                                           MaxScale 2.3.6

#Table Structure 

mysql> show create table student\G
*************************** 1. row ***************************
       Table: …

This week is our pleasure to remind following shows where you can find MySQL & MySQL Community experts: 

• Kansas Linux Fest (KLF), Wichita, Kansas City, US, August 9-11, 2019

  • Do not miss to listen MySQL talks given by David Stokes, the MySQL Community Manager as follows:
    • "MySQL Without the SQL - Oh My!"
    • "The Proper Care and Feeding of a MySQL Database for Busy Linux Administrators"
  • Watch the organizers' website for timing and place!
• FrOSCon 2019, Snkt. Augustin, Germany, August 10-11, 2019
  • Come to talk to us to our MySQL booth and do not miss the talk by Carsten Thalheimer, the MySQL …

Database Reliability Engineering – How to decide RAID for your Database Infrastructure ? What is RAID?

RAID stands for Redundant Array of Independent Disks (Originally, the term RAID was defined as Redundant Array of Inexpensive Disks). The name indicates that the disk drives are independent, and are multiple in number. RAID storage uses multiple disks in order to provide fault tolerance, to improve overall performance, and to increase storage capacity in a system. This is in contrast with older storage devices that used only a single disk drive to store data.How the data is distributed between these drives depends on the RAID level used. The main advantage of RAID, is the fact that, to the operating system the array of disks can be presented as a single disk.RAID is fault tolerant because in most of the RAID level’s data is redundant in multiple disks, so …

This tutorial explains about MySQL UPSERT command with the help of simple examples. An upsert is a smart operation that turns into an INSERT or UPDATE whichever is applicable. Also, it is an atomic transaction, which means completed in a single step. Let’s understand – If a record is new, then UPSERT triggers an INSERT. [...]

The post MySQL UPSERT | INSERT or UPDATE appeared first on TechBeamers.

This tutorial explains about MySQL UPSERT command with the help of simple examples. An upsert is a smart operation that turns into INSERT or UPDATE whichever is applicable. Also, it is an atomic transaction, which means complete in a single step. Let’s understand – If a record is new, then UPSERT triggers an INSERT. But, […]

The post MySQL UPSERT | INSERT or UPDATE Whichever is Applicable appeared first on TechBeamers.

This tutorial explains MySQL DATE data type and walks you through some of the standard date functions. It will help you use and handle dates more efficiently with MySQL. MySQL DATE data type The DATE is a temporal data type for accessing and setting dates by applications. It accepts DATE values only in YYYY-MM-DD format. [...]

The post MySQL Date and Date Functions appeared first on TechBeamers.

This tutorial explains about MySQL DATE data type and walks you through some of the standard date functions. It will help you use and handle dates more efficiently with MySQL. MySQL DATE is a temporal data type for accessing and setting dates by applications. It accepts DATE values only in YYYY-MM-DD format. And MySQL doesn’t […]

The post MySQL Date and Date Functions appeared first on TechBeamers.

This tutorial explains MySQL LOWER()/LCASE() functions which convert the upper case characters of a string to the LOWER case. We’ll describe the functioning of this method with the help of simple examples. 1. LOWER()/LCASE() Syntax 2. LOWER()/LCASE() to convert text to lower case 3. LOWER()/LCASE() on table data 4. LOWER()/LCASE() on binary text Let’s now [...]

The post MySQL LOWER() and LCASE() Functions Explained appeared first on TechBeamers.

This tutorial explains MySQL LOWER()/LCASE() functions which convert the upper case characters of a string to the LOWER case. We’ll describe the functioning of this method with the help of simple examples. 1. LOWER()/LCASE() Syntax 2. LOWER()/LCASE() to convert text to lower case 3. LOWER()/LCASE() on table data 4. LOWER()/LCASE() on binary text Let’s now […]

The post MySQL LOWER() and LCASE() Functions Explained appeared first on TechBeamers.