A Review of the New Analytic Window Functions in MySQL 8.0
Data is captured and stored for a variety of reasons. Hours beyond count (and even more budget) invested in collecting, ingesting, structuring, validating, and ultimately storing of data; to say that it is a valuable...
MongoDB vs MySQL NoSQL – Why Mongo is Better
There are so many database management systems (DBMS) to choose from ranging from relational to non-relational DBMS. In the past years, the Relational DBMS where more dominant but with recent data structure trends the non-relational...
How to Migrate from Oracle to MySQL / Percona Server
Migrating from Oracle to MySQL/Percona Server is not a trivial task. Although it is getting easier, especially with the arrival of MySQL 8.0 and Percona announced Percona Server for MySQL 8.0 GA. Aside from planning...
How to Migrate MySQL from Amazon EC2 to your On-Prem Data Center Without Downtime
Since its inception, there have been an increasing number of migrations to a cloud-based environment. After all, cloud computing can provide many benefits for businesses, especially those working with big data. However, as the demand...
Monitoring Your Databases with MySQL Enterprise Monitor
How to Monitor MySQL Databases? Operational visibility is a must in any production environment. It is crucial to be able to identify any issues as soon as possible, otherwise you may end up in serious...
Basic Administration Comparison Between Oracle, MSSQL, MySQL, PostgreSQL
The introduction of DevOps in organizations has changed the development process and also introduced some new challenges. In addition, developers and DevOps teams, along with their own chosen programming languages, also have their favorite database...
MySQL to MongoDB – An Admin Cheat Sheet
Most software applications nowadays involve some dynamic data storage for extensive future reference in the application itself. We all know data is stored in a database which falls into two categories that are: Relational and...
Automate Deployment of Your MySQL or Postgres Cluster From Backup
ClusterControl 1.7.1 introduces a new feature called Create Cluster from Backup, which allows you to deploy a new MySQL or Postgres-based cluster and restore data on it from a backup. This blog post shows how...
How to Use the Roles That Have Changed in MySQL 8.0
Database Security is important to any MySQL setup. Users are the foundation of any system. In terms of database systems, I generally think of them in two distinct groups: Application, service, or program users - basically...
MySQL Performance Benchmarking: MySQL 5.7 vs MySQL 8.0
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...
MySQL Performance Cheat Sheet
MySQL is extensive and has lots of areas to optimize and tweak for the desired performance. Some changes can be performed dynamically, others require a server restart. It is pretty common to find a MySQL...
What is MariaDB TX? How to Manage the New MariaDB MySQL Fork!
You may have heard about MariaDB TX and you may have wondered what it is? Is there a difference between it and MariaDB Server 10.3? In this blog post we would like to give you...