Introduction  To upgrade MySQL versions  we can use below method:-

1. INPLACE Upgrade :- It involves shutting down MySQL 5.7  server,replacing the old binaries  with MySQL 8.0 binaries and then starting the MySQL 8.0 server on the old data directory. 
2. LOGICAL Upgrade:- It involves exporting SQL from MySQL 5.7 version using backup utility such as mysqldump or mysqlpump , installing the MySQL 8.0 binaries and then applying the SQL to the new version.

Before start upgrading the MySQL versions it is recommended to have deeper analysis by visiting MySQL Documentation page. Upgrading MySQL :- https://dev.mysql.com/doc/refman/8.0/en/upgrading.html What is MySQL Upgrade Checker? Utility to check MySQL 5.7 server instances for compatibility errors and …

Glimpse of MySQL Enterprise Data Masking Abstract- Many organizational production environment unwittingly breach sensitive information which causes harm of reputation, brand name and million of dollar losses etc. hence database environments will require some form of sanitization in order to render the informational content anonymous. In this paper, we outline research towards a business challenge-why mask your data and the business value- benefits of masked data. We describe a definition of concept, performance measurements of sql query with/without masked data and limitation of data masking with current release of MySQL. …

Introduction MySQL offers two types of clustering solution for managing Read/Write intensive workloads , ensuring Rock Solid Availability. 1.MySQL InnoDB Cluster
2. MySQL NDB Cluster Glimpse of MySQL InnoDB Cluster    This Cluster is designed for users that uses MySQL Server with InnoDB storage engine.    It will serve as a natural extension for users currently using MySQL Replication with InnoDB to a       new replication architecture i.e Clustering on top of Group Replication. MySQL InnoDB Cluster = MySQL Server + MySQL Shell + MySQL Router. MySQL Server

• Group Replication Technology.
• Single-Primary /Multi-Primary Mode.
• Fault Tolerance.
• Conflict detection and resolution.
• Automatic distributed recovery.

MySQL Shell

• Multi-Language(Python , Java script , SQL).
…

How to Deploy MySQL InnoDB Replica Set in Production? Before i talk about Deployment process of MySQL InnoDB Replica Set , it is more important to know below details:-

• What is MySQL InnoDB Replica Set?
• What is prerequisite and limitation of using MySQL Replica Set?
•  In what kind of scenarios MySQL Replica Set is not recommended.
•  How to configure and deploy MySQL Replica Set- (step by step guide )
• How to use InnoDB Replica Set?
• What if Primary goes down? Does select query re-routed to another server?
• What if Secondary goes down while executing select queries?

§      I will answer these all question in this blog.    What is Replica Set ? MySQL InnoDB ReplicaSet a quick and easy way to get MySQL replication(Master-Slave), making it well suited to scaling out reads, and …

MySQL8.0: Performance Improvement with new features INSTANT ADD Column         Abstract- Flexible and dynamic concepts can help to balance maintainability and complexity. With ever bigger and growing dataset, the ability to do DDL instantly will help developers to scale more complex RDBMS solutions. In this paper, we outline performance measurements of various options of ALTER TABLE algorithm-COPY, INPLACE, INSTANT. We describe the definition of concept, advantages, and limitations and how it is value add on current business cases based on existing performance test.

                                                                          …

NoSQL Development in MySQL Using Python.

In This Tutorial, I will talk about below topic:-
 Introduction to NoSQL + MySQL =MySQL 8.0.
 What is XdevAPI , Xprotocol , Xplugin ?
 How Application communicate with MySQL using XdevAPI ?
 Installation online and offline.
 How to use XdevAPI to develop application using MySQL as NoSQL databases (Similar to MongoDB , ES ) ?
 Conclusion.


Introduction to NoSQL + MySQL =MySQL 8.0

Whenever we have fast changing data , lots of data it is tedious task for application developers to depend on MySQL DBA/developer to get required schema details , instead MySQL document store has new paradigm shift over traditional SQL model which is schema-less , low maintenance, no need to maintain multiple databases (likewise one database for relational model and another for document model).
…

During this webinar, Tyler Duzan, Product Manager for MySQL and Cloud at Percona, will discuss Percona’s decision to delay Percona XtraDB Cluster 8.0 to ship it with Galera 4 instead of Galera 3, and why that matters. In addition, he’ll talk about the work done to integrate MySQL 8.0 features with Galera as well as how Percona is treating Kubernetes as one of its primary target platforms with this release. This webinar will provide an overall view of the current state of best-in-breed MySQL clustering as well as the Percona roadmap for the future.

Please join Tyler Duzan of Percona, on Tuesday, May 26 at 11 am EDT for his webinar “What’s New in Percona XtraDB Cluster (PXC) 8.0?”.

…

Percona XtraDB Cluster 8.0 comes with an upgraded Galera 4.0 library, which provides a new feature – streaming replication. Let’s review what it is and when it might be helpful.

Previous versions of Percona XtraDB Cluster with Galera 3.x had a limitation in how big transactions are handled.

Let’s review the performance under sysbench-tpcc workload when in parallel we update a big update on a table that is even non-related to the tables in the primary workload.

Without Streaming Replication

Let’s run two workloads.

1. sysbench-tpcc workload with 1 sec resolution
2. In parallel run UPDATE oltp.sbtest SET k=k+1 LIMIT 1000000

Running update:

mysql> update sbtest1 set k=k+1 limit 1000000;
Query OK, 1000000 rows affected (34.48 sec)
Rows matched: 1000000  Changed: …

We recently covered Installing Galera Cluster 4 with MySQL 8 on Ubuntu 18.04 , the new Galera version for MySQL High Availability. We got a request to see if we would be able to install it on Amazon Linux 2, and the short answer is yes, we are able to deploy Galera Cluster on Amazon Linux 2.

We have even published Installing a Galera Cluster on AWS guide for Geo-distributed MySQL Multi-master clustering which covers how to install a 3-node Galera Cluster on CentOS 7 to achieve disaster recovery . It turns out, Amazon Linux 2 tends to be quite compatible with this article ( …

In this post, the third in a series explaining the internals of InnoDB flushing, we’ll focus on tuning. (Others in the series can be seen at InnoDB Flushing in Action for Percona Server for MySQL and Give Love to Your SSDs – Reduce innodb_io_capacity_max!)

Understanding the tuning process is very important since we don’t want to make things worse or burn our SSDs. We proceed with one section per variable or closely-related variables. The variables are also grouped in sections based on the version of MySQL or Percona Server for MySQL where they are valid. A given variable may be present more …