There are over 250 new features in MySQL 8.0. The MySQL Manual is very good, but verbose. This is a list of new features in short bullet form. We have tried very hard to make sure each feature is only mentioned once. Note the similar list for MySQL 5.7. Please download MySQL 8.0 from dev.mysql.com or from the MySQL  Yum,  APT, or SUSE repositories. SQL DML Non-recursive CTEs [1] Recursive CTEs [1] Window functions [1] ORDER BY and DISTINCT with ROLLUP [1] LATERAL derived tables [1] Outer table references in derived tables [1] SQL DDL Instant ADD COLUMN [1] Instant RENAME COLUMN [1] Instant RE ..read more

MySQL 8.0 became Generally Available (GA) on April 19th, a great moment for us working on MySQL at Oracle. It is now a “fully grown adult” packed with new features, and improvements to existing features, as described here. This blog post focuses on the impact of replication performance improvements that went into MySQL 8.0. This is another long post, but I hope some people will enjoy the details. 1. What is new in MySQL 8.0 replication performance? MySQL 8.0 introduced many features related to replication, and quite a few of them are performance or monitoring improvements, as the following ..read more

In MySQL 8.0 we are improving the Performance Schema to support indexes. This increases the flexibility and ease of use of using performance_schema, as a number of monitoring queries will see a dramatic speed up in performance. Background Since it’s initial launch in MySQL 5.5, the Performance Schema has grown to 93 tables, with some of these exposing a lot of data. To use an example; consider a busy system with 1000 sessions connected (either working or idle) and a DBA performing a mysqldump or restore operation. A typical way to monitor this would be to measure the table I/O that this activ ..read more

It is very important for every DBA’s to backup their data frequently so that they can recover data if any problems occur such as Hardware failure, System crashes, Human mistakes. There are several ways to backup MySQL data. They are 1) Physical Backup 2) Logical Backup Physical Backup:               It is also called Raw Backup. It copies the directories and its files that has database contents. Logical Backup:             It is also called Text Backup. It converts all the available rows into single/multiple inserts and also contains create statements to create databases, tables, triggers and ..read more

The end-of-Life (EOL) date for MongoDB 3.4 is approaching As you may know, the End-of-Life (EOL) date for MongoDB 3.4 is approaching. This means that in January 2020, MongoDB is ending support for version 3.4.  What happens on January 31st, 2020? We will no longer allow customers to provision new instances of Databases for MongoDB 3.4; however, you will be able to restore your existing instance into a new version. In line with our version policy, we will remove access to the database and take a backup. This backup will be available to be restored into a new supported database version. We will ..read more

MongoDB is a free and open-source document database. It is classified as a NoSQL database which is different than traditional table-based SQL databases like MySQL and PostgreSQL. In MongoDB, data is stored in flexible, JSON-like documents where fields can vary from document to document. It does not require a predefined schema and data structure can be changed over time. In this tutorial, we will show you how to install and configure MongoDB Community Edition on a CentOS 7 server from the official MongoDB repositories. Before continuing with this tutorial, make sure you are logged in as a use ..read more

Improving Performance with the MySQL Performance Schema ..read more

MySQL 8.0 brought enormous changes and modifications that were pushed by the Oracle MySQL Team. Physical files have been changed. For instance, *.frm, *.TRG, *.TRN, and *.par no longer exist. Tons of new features have been added such as CTE (Common Table Expressions), Window Functions, Invisible Indexes, regexp (or Regular Expression)--the latter has been changed and now provides full Unicode support and is multibyte safe. Data dictionary has also changed. It’s now incorporated with a transactional data dictionary that stores information about database objects. Unlike previous versions, dicti ..read more

In todays article we will install MariaDB Galera cluster with HAproxy for load balanced MariaDB and wordpress. Galera is active-active clustering technology, meaning that it can support writes on all nodes which are then replicated across cluster. There is also active-passive clustering, where only node is writable. We will also install HAproxy for load balancing on our cluster. Install is going to be done on 5 CentOS 7 servers, three for MariaDB 10.1 Galera, one for Haproxy and one for wordpress. HAproxy works in such a way that it routes requests to each node in round robin mode, while pres ..read more

MySQL InnoDB cluster limitations: 01. A group can consist of maximum 9 servers. Attempting to add another server to a group with 9 members causes the request to join to be refused. 02. Limitations and issues described for multi-primary mode groups can also apply in single-primary mode clusters during a failover event, while the newly elected primary flushes out its applier queue from the old primary. 03. Individual transactions that result in GTID contents which are large enough that it cannot be copied between group members over the network within a 5 second window can cause failures in t ..read more