The Vitess team had a successful presence at Kubecon + CloudNativeCon North America 2020. This year's event was in a virtual format. It ran from Nov 17-20. We had 2 talks, a project booth and 3 office hours sessions. In addition, we had mentions in 2 major keynote talks. Day 1 # Day 1 was a non-keynote day. It opened relatively quietly for us. We had 25+ attendees at our office hours session hosted by maintainers Alkin Tezuysal, Deepthi Sigireddi and Derek Perkins.

MinervaDB Athena 2020 – Profiling Linux Operations for Performance and Troubleshooting by Tanel Poder

In Athena 2020, Tanel Poder talked about troubleshooting Linux operations performance based on the detailed forensics and evidence collection through0x.tools (Linux Process Snapper from Tanel), Which is a free, open source /proc file system sampling tool which annotates Linux thread handling activities more intuitively. The talk was really interesting for Open Source Database Systems folks who attended the conference because they spend most of their professional hours troubleshooting performance of their Database Infrastructure Operations for optimal performance and also in this talk Tanel’s approach was bottom-up (interpreting performance metrics with Linux probes) compared top-down approach (depending on Database Systems metadata views), You can download the PDF of the talk …

Running a MySQL Database Service (MDS) DB System, the MySQL managed solution by Oracle MySQL on Oracle Cloud Infrastructure, means forgetting about time-consuming duties such as upgrades, backups and configuration, among others. It is so possible to focus on the service, on data and at the same time take advantage of the usual monitoring assets to configure and scale the service optimally. That’s what I want to talk about in this post: how to monitor a DB System in a few steps.

OCI MDS OS Metrics Charts

An MDS DB System compute instance file system is protected from any access, but you don’t need to access it to create system metrics, as these are already exposed on your DB System administration page in OCI dashboard.

System charts exposed for the compute instance hosting the DB System

It is also possible to take advantage of OCI services to raise alarms when certain metric …

MySQL Cluster: MySQL Cluster is a real time, ACID-compliant transactional database. It is a combination of MySQL server and the NDB storage engine. Data is cached in memory and durably stored on disk. Indexed columns are always kept in memory while non-indexed columns can be kept in memory or disk. It was mainly designed for telecom databases with 99.999% availability and high performance. Unlike simpler sharded systems, MySQL Cluster transactions can transparently query and update all data in the system.

Key features of MySQL Cluster:

•     MySQL Cluster is designed using a shared nothing architecture

• Support for large database sizes

  •         With all columns kept in memory, can store upto few terabytes

  •         With some columns kept on disk, can store upto few petabytes

    …

This is a simple article with an examples for “how to configure replication filters for channel”

Starting from MySQL 8.0 replication filters can be global or channel-specific, enabling you to configure multi-source replicas with replication filters on specific replication channels. Channel specific replication filters are particularly useful in a multi-source replication topology when the identical database or table is present on multiple sources, and the replica is only required to replicate it from one source.

Example:

CHANGE REPLICATION FILTER REPLICATE_DO_DB =(test,test3,test4 ), REPLICATE_REWRITE_DB = ((test1,test3),(test2,test4)) FOR CHANNEL "node1";

my.cnf confiration to make replication filter setting persistent:

replicate-do-db=node1:test
replicate-do-db=node1:test3
replicate-do-db=node1:test4
replicate-rewrite-db=node1:test1->test3 …

We have many ways to install MySQL on linux machines such as source, binary and so on. But most of the Engineers always prefer default package managers (yum for RPM-Based distributions and apt for DPKG-Based distributions) for its ease of use and it can resolve all dependencies on its own. And of course, it is not possible to use package managers in environments where the internet is not allowed, but this is a different case. 

At some point, we need to install exactly specific version of MySQL for the following cases

• To create Production Replicas 
• To simulate an Production Issue on similar kind of environment
• To configure Disaster Recovery(DR)/UAT Setup
• Compatibility with opensource tools ( Eg , …

In my previous post I explained how to take a logical backup using the mysql shell utilities. In this post, we shall compare the speed of the backup and restoration process.

MySQL Shell Speed Test 

We are going to do a comparison of  backup and recovery speed of mysqldump and MySQL shell utility tools.

Below tools are used for speed comparison:

• mysqldump
• util.dumpInstance
• util.loadDump

Hardware Configuration

Two standalone servers with identical configurations.

Server 1

   * IP: …

In previous post we analyzed MySQL performance on x86 and ARM using the Cost-Performance Model (#cpm) where-in Cost and other resources (except compute power) was kept constant allowing compute power to differ. ARM being cheaper got more compute power for the same cost. That was a user perspective story but developers were also interested to understand how MySQL scale if we provide the same computing power.

We decided to go ahead with this and benchmark MySQL on x86 and ARM except this time with the same compute power (keeping all other resources memory, storage, etc… same) and allowing cost to differ with ARM variant cheaper than x86 variant. It would also help understand if ARM is really powerful for High-Performance Computing like databases.

Benchmarking Setup

…

In the world of the Databases, one of the most important value that we are all trying to achieve is High Availability. Not to loose our valuable data or in case one server fails to always have another to step in and take control.

So, it is critical to have along with our primary database, other identical instances, the replicas.

On this blog post, we will see the most famous ways to set up our replication.

The post Setting up Replication with various methods for MySQL 8 first appeared on dasini.net - Diary of a MySQL experts.

Cloud backup is a strategy increasingly used in organizations. Send copies of your data to the cloud, can help you to prevent a devastating IT crisis and ensure business continuity.

Currently, MySQL Enterprise Backup supports the following types of cloud storage services:

- Oracle Cloud Infrastructure (OCI) Object Storage

- OpenStack Swift or compatible object storage services

- Amazon Simple Storage Service (S3) or compatible storage service

The post Create a Cloud Backup with MySQL Enterprise Backup first appeared on dasini.net - Diary of a MySQL experts.