Migration from Oracle Database to MariaDB – A Deep Dive
In previous blogs, we discussed the topic of How to Migrate from Oracle to MySQL / Percona Server and most recently Migrating from Oracle Database to MariaDB - What You Should Know. Over the years...
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...
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...
Real Time Data Streaming with MongoDB Change Streams
Recently, MongoDB released a new feature starting from version 3.6, Change Streams. This gives you the instantaneous access to your data which helps you to stay up to date with your data changes. In today’s...
Considerations for Administering MongoDB
Below is an excerpt from our whitepaper “MongoDB Management and Automation with ClusterControl” which can be downloaded for free. Considerations for Administering MongoDB Built-in Redundancy A key feature of MongoDB is its built-in redundancy, in...
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...
An Overview of the Index Changes in PostgreSQL 11
The right application of indexes can make queries blazing fast. Indexes use pointers to access data pages in a speedy fashion. Major changes happened on Indexes in PostgreSQL 11, lots of much awaited patches have...
Top GUI Tools for PostgreSQL
Managing databases from the command line does come with a learning curve to get the most out of it. The command line can sometimes be arduous and the display may not be optimal for what...
How to Manage Your PostgreSQL Databases From the ClusterControl CLI
Did you know that apart from the ClusterControl web UI, you can also use a command line interface to manage your PostgreSQL instances? ClusterControl supports PostgreSQL streaming replication (both asynchronous and synchronous replication) as well...
An Overview of JSON Capabilities Within PostgreSQL
What is JSON? JSON stands for “JavaScript Object Notation” which is a type of data format popularly used by web applications. This means, the data would be transmitted between web applications and servers in such...
How to Optimize Performance of ClusterControl and Its Components
Monitoring and management are critical to any production environment because performance matters. Slow user interfaces that lag or do not respond, delayed alerts, and cluster job timeouts when the server is starved of resources are...
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...