Filters

Severalnines Database Blog

Clear all

Apply

Filters

Close Filters

Categories:

ClusterControl

Backup Management

Monitoring & Alerting

Deployment & Scaling

Upgrades & Patches

Security & Compliance

Operational Reporting

Configuration Management

Recovery & Repair

Performance Management

Cloud

Industry News & Events

Database - General

Technologies:

Docker

Galera Cluster

MariaDB

MongoDB

MySQL

MySQL NDB Cluster

PostgreSQL

TimescaleDB

Tags:

Database - General

Learn about open source database technologies in our database blog. Here you will find a variety of topics on database technologies like MySQL, PostgreSQL, MongoDB, MariaDB and more.

Autonomous by Oracle: The Database That’s Cheaper Than Free

Aug 06, 2019

by Anne Hinkson

Is the future of database management autonomous? Oracle has developed the world’s first Autonomous Database, which guarantees to cut your cloud services bill by more than half. In fact, it’s the cheapest database on the market today. In this blog we explore the ideas behind autonomous databases and how they may affect your infrastructure.

Running a Data Warehouse on PostgreSQL

Aug 01, 2019

by Sebastian Insausti

PostgreSQL is so flexible that can serve as a simple relational database, time-series data database, and even as an efficient and low-cost data warehousing solution. In this blog, we’ll see what a data warehouse is, why is it needed, and why PostgreSQL could be the best option for it.

Running Big Data Analytics Queries Using SQL and Presto

Jul 31, 2019

by Bart Oles

Presto is a parallel distributed SQL engine that allows you to run interactive big data analytics queries on a wide variety of data sources. In this blog, we are going to show you how you can install it and use it with your existing RDBMS systems.

Big Data with PostgreSQL and Apache Spark

Jul 26, 2019

by Sebastian Insausti

Nowadays, Big Data Analytics is a common task in a company and there are several ways to perform this task. In this blog, we’ll see what Apache Spark is and how we can use it to work with our PostgreSQL database.

How to Run PHP 5 Applications with MySQL 8.0 on CentOS 7

Jul 25, 2019

by Ashraf Sharif

This blog walks you through running PHP 5 applications with the latest version of MySQL 8.0 on CentOS 7 operating system. This blog is based on the real experience that we faced when we were working with an internal project that requires PHP 5 application to be running alongside our new MySQL 8.0 in the new environment.

Oracle’s Ironclad Autonomous Database

Jul 23, 2019

by Anne Hinkson

Autonomous Database eliminates complexity, human error, and manual management, helping to ensure higher reliability, security, and more operational efficiency at the lowest cost.

An Introduction to Data Lakes

Jul 11, 2019

by Bart Oles

This blog provides an overview of the Data Lake concept. We’ll go through some of the changes in storing and processing unstructured data and available solutions either on-prem and in the cloud.

Database User Management: Managing Roles for MariaDB

Jun 26, 2019

by Sebastian Insausti

Managing privileges on a database can be a hard and time-consuming task if we’re working in large organizations or if you have a complex privilege structure created on the database side. In this blog, we’ll see how we can cope with the database user management by using roles and how to use them on MariaDB.

A Guide to the MariaDB Columnstore for MySQL Admins

Jun 25, 2019

by Paul Namuag

Big data processing and data warehousing plays an important role in analytics, forecasting, statistical reports, and more. This blog will help MySQL DBA's leverage the MariaDB ColumnStore (a columnar-storage engine system which is part of MariaDB AX) for these types of tasks.

Migrating from MySQL Enterprise to MariaDB 10.3

Jun 19, 2019

by Bart Oles

This blog provides an overview of the migration process between MySQL Enterprise 8.0 and MariaDB 10.3. In this blog post, we’ll go through some of the most important differences as well as the migration procedures.

Webinar Replay: High Availability in ProxySQL for HA MySQL infrastructures

Apr 24, 2017

by Krzysztof Ksiazek

This blog provides details for the replay of our webinar on high availability in ProxySQL for HA MySQL infrastructures; as well as answers to the many questions asked during this session.

Video: Galera Cluster in Cluster control

Apr 14, 2017

by Art van Scheppingen

ClusterControl provides advanced deployment, management, monitoring, and scaling functionality to get your Galera clusters up-and-running.

How to Bootstrap MySQL or MariaDB Galera Cluster - Updated

Apr 10, 2017

by Ashraf Sharif

This blog discusses in-depth about cluster bootstrap. Unlike standard MySQL server and MySQL Cluster, the way to start a MySQL or MariaDB Galera Cluster requires you to start a node in a cluster as a reference point, before the remaining nodes are able to join and form the cluster. Bootstrapping is an initial step to introduce a database node as primary component, before others see it as a reference point to sync up data.

Calculating the Total Cost of Ownership for MySQL Management

Apr 07, 2017

by Art van Scheppingen

This blog post will show you how to calculate the total cost of ownership (TCO) for database servers and how to optimize your cost.

A Comparison of Cloud Providers

Mar 10, 2017

by Ashraf Sharif

This blog post covers a general comparison between cloud providers with sections on product and pricing, infrastructure, integration and security

Database Sharding: How does it work?

Sep 20, 2016

by Krzysztof Ksiazek

Why do we shard? How does sharding work? What are the different ways to shard a database? This post goes through some of the theory behind sharding.

New ClusterControl Subscriptions for Managing MySQL, MongoDB and PostgreSQL

Sep 14, 2016

by Jean-Jérôme Schmidt

Announcing our new pricing plans for ClusterControl, the single console to deploy, monitor and manage your entire database infrastructure. Whether you’re looking to manage standalone instances, need high availability or have 24/7 SLA requirements for your databases, ClusterControl now comes with three enhanced options for you to chose from in addition to its Community Edition.

MySQL, MongoDB or PostgreSQL DBA Webinar Replays

Jul 19, 2016

by Severalnines

This blog provides an overview and links to our different webinar replays and blog series for the MySQL, MariaDB, Percona, MongoDB and PostgreSQL DBA.

New Whitepaper: MySQL Replication Blueprint

Apr 29, 2016

by Jean-Jérôme Schmidt

MySQL Replication Blueprint whitepaper - this includes all aspects of a Replication topology with the ins and outs of deployment, setting up replication, monitoring, upgrades, performing backups and managing high availability using proxies.

Webinar Replay: Become a MongoDB DBA (If You’re Really a MySQL User)

Apr 27, 2016

by Jean-Jérôme Schmidt

These are replay details for our new webinar series: ‘How to Become a MongoDB DBA’.

Webinar Replay: The MySQL Replication Blueprint

Apr 06, 2016

by Jean-Jérôme Schmidt

These are the replay details of our webinar on the MySQL Replication Blueprint with MySQL 5.6 and 5.7, which includes all aspects of a Replication topology with the ins and outs of deployment, setting up replication, monitoring, upgrades, performing backups and managing high availability using proxies.

New Whitepaper: MySQL Replication for High Availability

Mar 22, 2016

by Jean-Jérôme Schmidt

This whitepaper covers all you need to know to get started with or refreshed on MySQL Replication, including information about the latest features introduced in 5.6 and 5.7.

MySQL Load Balancing with ProxySQL - An Overview

Mar 07, 2016

by Krzysztof Ksiazek

An overview of ProxySQL, an SQL-aware load balancer for MySQL and MariaDB. This blog post explains the concepts behind ProxySQL, and goes through installation and configuration.

Webinar Replay: Managing MySQL Replication for High Availability

Feb 04, 2016

by Jean-Jérôme Schmidt

Replay details for the live webinar ‘Managing MySQL Replication for High Availability’ with live demos.

ClusterControl

The only management system you’ll ever need to take control of your open source database infrastructure.

Learn more

Database - General