Showing entries 11 to 20 of 1468
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: mariadb (reset)
Column Level Masking on MySQL

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: …
[Read more]
Fun with Bugs #87 - On MySQL Bug Reports I am Subscribed to, Part XXI

After a 3 months long break I'd like to continue reviewing MySQL bug reports that I am subscribed to. This issue is devoted to bug reports I've considered interesting to follow in May, 2019:

  • Bug #95215 - "Memory lifetime of variables between check and update incorrectly managed". As demonstrated by Manuel Ung, there is a problem with all InnoDB MYSQL_SYSVAR_STR variables that can be dynamically updated. Valgrind allows to highlight it.
  • Bug #95218 - "Virtual generated column altered …
[Read more]
Fix Problems Proactively with SQL Diagnostic Manager for MySQL (formerly Monyog)

In the conclusion of our blog series, Benefits of SQL Diagnostic Manager for MySQL (formerly Monyog), we explore features of SQL Diagnostic Manager for MySQL that allow database administrators to proactively monitor and manage MySQL and MariaDB servers. If you missed it, feel free to read last week’s post on monitoring MySQL and MariaDB servers.

Fix Problems Proactively with Hundreds of Monitors

SQL Diagnostic Manager for MySQL includes hundreds of monitors that are designed to examine the configuration and security of MySQL and MariaDB servers automatically, identify problems and tuning opportunities, and provides database administrators with specific corrective actions.

Use Advisor Rules

The Advisor Rules feature is a set of best practices that enables database administrators to monitor MySQL …

[Read more]
Monitoring MySQL and MariaDB Servers

In week 5 of our Benefits of SQL Diagnostic Manager for MySQL (formerly Monyog) blog series, we detail MySQL and MariaDB monitoring features with SQL Diagnostic Manager for MySQL, including real-time monitoring and monitoring MySQL error logs. If you missed it, you can read our previous post on understanding database performance trends.

Fast Startup Time to Start Monitoring

Database administrators can start monitoring MySQL and MariaDB servers in less than a single minute. The unique architecture and low-footprint of SQL Diagnostic Manager for MySQL enable database administrators to install and configure all of the components that are required for monitoring MySQL and MariaDB servers very quickly.

The fast startup time is in sharp contrast with other monitoring and advisory …

[Read more]
Understand Database Performance Trends – SQL Diagnostic Manager for MySQL (formerly Monyog)

Next in our Benefits of SQL Diagnostic Manager for MySQL (formerly Monyog) blog series, we discuss monitoring and understanding performance trends using visual analytics and the display dashboard of SQL Diagnostic Manager for MySQL. If you missed it, you can read last week’s blog on identifying and analyzing problematic SQL queries.

View and Understand Trends By Analyzing Historical Data

Configure the time duration for storing the data collected by SQL Diagnostic Manager for MySQL. It stores the data in a high-performance database (that is, the embedded relational database management system SQLite). By analyzing historical data, quickly obtain answers to questions like:

  • How many times and when did database servers go down during the last six months? Which …
[Read more]
Galera Cluster at Percona Live Austin, DataOps.Barcelona and where next

It is July now, and summer is upon us. The team at Codership are busy making Galera Cluster 4 for MySQL, and we are just hot of the heels of celebrating the launch of Galera Cluster 4 with MariaDB Server 10.4

At the end of May, Galera Cluster had a booth and several talks at Percona Live Austin. This was the first time the event happened there, and we thoroughly enjoyed it. The key takeaway from that event would be Seppo Jaakola’s talk titled: Galera Cluster New Features. It covered the then upcoming MariaDB Server 10.4 release with Galera Cluster 4, went in-depth into how streaming replication works …

[Read more]
Find, Monitor, and Analyze Problematic SQL Queries – SQL Diagnostic Manager for MySQL (formerly Monyog)

In week 3 of our series, Benefits of SQL Diagnostic Manager for MySQL (formerly Monyog), we discuss how to identify and analyze problematic SQL queries using SQL Diagnostic Manager for MySQL. If you missed it, feel free to read our previous post on Agentless Monitoring and Cloud Readiness.

Find Problematic SQL Queries

MySQL and MariaDB currently lack advanced tools for profiling SQL queries (such as SQL Profiler of Microsoft’ SQL Server). While other monitoring tools for MySQL and MariaDB provide monitoring and advisory information on various system metrics, they do not pinpoint the problematic SQL queries. No amount of hardware upgrades and tuning of the parameters in the database server configuration file ‘my.cnf’ and the database server initialization file …

[Read more]
Galera Cluster 4 with MariaDB 10.4

Congratulations to Team MariaDB at MariaDB Corporation and MariaDB Foundation for releasing MariaDB 10.4.6 as Generally Available (GA) last week on 18 June 2019. This release is very exciting for Galera Cluster users as it comes with Galera 4 (it is now the first server to come with it!), with Galera wsrep library version 26.4.2.

What can Galera Cluster users expect from MariaDB 10.4? Some high level features include:

  • Streaming replication — a huge boost to large transaction support, since the node breaks transactions into fragments, replicates and certifies it across all secondary nodes while the transaction is still in progress. Read more about it in our dedicated documentation on streaming replication as well …
[Read more]
Blog from the Top — The Changing Landscape of Open Source (MySQL) and Money

This is the first in a series of blog articles in which I will discuss the changing landscape of open source and money. Or, more specifically, open source databases and money. And even more specifically MySQL and its all variants (AWS Aurora, MariaDB, Percona Server, RDS/MySQL) and money. But before going too deep into what is changing, let’s review all the traditional business models in and around the MySQL marketplace.

In general, these are the following types of companies in the MySQL commercial ecosystem, sorted by total annual revenue and addressable market size:

  • Developers who do not aim to monetize the open source code, just provide value to others and hope to get development and other contributions in return. This is the purest form of open source. For example, all …
[Read more]
Agentless Monitoring and Cloud Readiness with SQL Diagnostic Manager for MySQL (formerly Monyog)

Welcome back to our blog series, Benefits of SQL Diagnostic Manager for MySQL (formerly Monyog). Last week, we discussed some of the challenges associated with MySQL and MariaDB database systems. Today, we dive in to additional features of SQL Diagnostic Manager for MySQL, including agentless monitoring technology, cloud readiness, and customization options.

Agentless Monitoring

Unlike other monitoring and advisory tools for MySQL and MariaDB, SQL Diagnostic Manager for MySQL does not require installing monitoring agents on each MySQL and MariaDB server. Installing and maintaining monitoring agents can be a complex administration task by itself.

SQL Diagnostic Manager for MySQL uses a standard MySQL connection for monitoring. To collect data for the operating system from remote database servers, …

[Read more]
Showing entries 11 to 20 of 1468
« 10 Newer Entries | 10 Older Entries »