MySQL Workbench Alternatives – ClusterControl Configuration Management
MySQL configuration management consists of two major components - MySQL configuration files and runtime configuration. Applying configuration changes on the runtime environment can be done through MySQL server clients with no privilege for session variables...
The Battle of the NoSQL Databases – Comparing MongoDB and Oracle NoSQL
Modern IT needs to have a non-relational, dynamic schema (meaning no requirements for Joins Statements Queries) to provide support for Big Data/real-time applications. NoSQL databases were created with the notion of improving data processing performance...
Top Ten Reasons to Migrate from Oracle to PostgreSQL
Oracle Relational Database Management System (RDBMS) has been widely used by large organizations and is considered by far to be the most advanced database technology available in the market. It’s typically the most often compared...
Tips for Migrating from Proprietary to Open Source Databases
Back in the day proprietary databases were the only acceptable options. “No one ever got fired for buying from Oracle/Microsoft/IBM” was the saying. Huge, monolithic databases used for every single purpose. Paid support - that’s how...
Autonomous by Oracle: The Database That’s Cheaper Than Free
It is a known fact that over 80% of businesses fail within their first five years. Studies have shown that the number one reason for this failure is poor cash flow management. New business owners...
Comparing Temporary Tables for PostgreSQL & Oracle GTT
The temporary tables are a useful concept present in most SGBDs, even though they often work differently. This blog describes the technical features for this kind of tables either in PostgreSQL (version 11) or Oracle...
Oracle’s Ironclad Autonomous Database
NEWS ALERT: “The Marriott just revealing a massive data breach involving guest reservation database at its Starwood brand. Marriott says it was unauthorized access since 2014. This includes up to 500 million guests... For approximately...
How to Execute and Manage MySQL Backups for Oracle DBA’s
Migrating from Oracle database to open source can bring a number of benefits. The lower cost of ownership is tempting, and pushes a lot of companies to migrate. At the same time DevOps, SysOps or...
How to Migrate from Oracle DB to MariaDB
Migrating from Oracle database to MariaDB can come with a number of benefits: lower cost of ownership, access to and use of an open source database engine, tight integration with the web, an active community...
How to Manage MySQL – for Oracle DBAs
Open source databases are quickly becoming mainstream, so migration from proprietary engines into open source engines is a kind of an industry trend now. It also means that we DBA’s often end up having multiple...
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...
Migrating from Oracle Database to MariaDB – What You Should Know
Gartner predicts that by 2022, 50% of existing commercial databases will have been converted to open source databases. Even more, 70% of new in-house applications will be developed on an open source database platform (State...