Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
29 blog posts in 13 categories

How to Execute and Manage MySQL Backups for Oracle DBA’s

Whether you’re planning to migrate from Oracle database to MySQL or run your new project with MySQL, you need to know how to do copies of your data. In this blog post, we will cover some of the most typical cases of the data backups with reference to Oracle backup methods. We will tell you how to guard yourself against data loss, what tools and commands to use, and how can you recover your data.

Scaling Your Time-Series Database - How to Simply Scale TimescaleDB

How do you scale TimescaleDB? How do you convert a single TimescaleDB instance to cluster with no downtime? How does the application know which database node to access? This blog post provides an overview of how to use ClusterControl to scale your time-series data with minimal effort.

How to Achieve Automatic Failover for TimescaleDB

Failover is the process of moving to a healthy standby component, during a failure or maintenance event. The quicker it can be done, the faster you can be back online. If you’re looking at minimizing downtime and meet your SLAs through an automated approach for TimescaleDB, then this blog is for you.

Monitoring & Ops Management of MySQL 8.0 with ClusterControl

MySQL 8.0 is a big step forward in terms of data consistency, developer features, performance and availability. MySQL 8.0 shortens the gap between proprietary databases and open source world, making the migration decision much easier to take.

But how can you manage it, along with other relational open source databases? In this blog post, we look at the challenges of operating a MySQL 8.0 database, and see how important tasks like monitoring, alerting, backups and failover can be handled in an automated way.

An Introduction to TimescaleDB

Time-series data is becoming more and more present, as we capture and analyze data at a faster rate. This increases the demand for complex queries and scalable database solutions. This blog provides a high-level overview of the new database system “TimescaleDB”, and a quick hands-on to get you going.

Understanding the Effects of High Latency in High Availability MySQL and MariaDB Solutions

To insulate our database infrastructure from failures, we build redundant cluster systems. For instance, MySQL and MariaDB high availability can be implemented by master-slave as well as master-master replication solutions. There are a number of variables that affect our choice solution. In this blog, we will look into considerations around latency.

How to Manage MySQL - for Oracle DBAs

So, you are an Oracle DBA and your manager asked you to migrate a couple of Oracle databases to MySQL. Databases are migrated, and now what? How do you manage these MySQL databases?

In this blog, we show you how Oracle DBAs can best manage MySQL by covering the basic operations of MySQL with reference to similar tasks in your Oracle environment.

Migrating from Oracle Database to MariaDB - What You Should Know

For many organizations, migrating from Oracle to an open source database platform is just a matter of time. An Oracle to MariaDB migration can be a complex multistage process, but choosing the right database architecture and features can reduce the cost and time of the operation. This blog aims to help you better understand the details of the complexities involved and how to overcome them.

Basic Administration Comparison Between Oracle, MSSQL, MySQL, PostgreSQL

Supporting different types of databases in a mixed environment is not an easy task. In this blog post we will compare different types of RDBMS systems from the DBA/DevOps administration perspective.

Monitoring & Ops Management of MongoDB 4.0 with ClusterControl

MongoDB 4.0 added support for multi-document ACID transactions, which brings it closer to the relational world. But how can you manage it, along with other relational open source databases like MySQL, MariaDB and PostgreSQL? In this blog post, we look at the challenges of operating a MongoDB database, and see how important tasks like monitoring, alerting, backups and failover can be handled with ClusterControl.

Pages