March 20, 2024

Vector Similarity Search with PostgreSQL’s pgvector – A Deep Dive

As the AI revolution surges forward, promising significant innovations, it also introduced new types of vector databases. A vector database stores data as high-dimensional vectors called embeddings, which are mathematical representations of features or attributes...

August 16, 2023

10 Considerations for Architecting a Multi-Cloud Database

Thinking about architecting a multi-cloud database? It’s an increasingly common topology nowadays. The adoption rate of a multi-cloud approach has been growing fast for years. It’s a solid option for a disaster recovery plan (DRP)...

October 6, 2023

Best Practices for Scaling A Multi-Cloud Database Infrastructure

Scaling a multi-cloud database infrastructure can be a complex and challenging task, but it's essential for businesses that require high scalability, availability, and reliability. With multi-cloud becoming increasingly popular, organizations are leveraging the benefits of...

December 8, 2023

What’s new in SQL Server 2022

SQL Server 2022 is the latest database version released by Microsoft in November 2022. The release builds upon previous versions to add more choice for SQL Server users when it comes to development languages, data...

Categories
Products
Technologies
Top Rated docs

October 28, 2013

Point-in-Time Recovery for MySQL Galera Cluster

**Update: 6th May, 2016 - This blog post has been updated to reflect ClusterControl v1.3.0 Data protection is vital for DB admins, especially when it involves data that is accessed and updated 24 hours a day....

October 23, 2013

Webinar Replay: Galera 3.0 Introduction and Cluster Management – with MySQL 5.6, Global Transaction IDs and WAN

The Severalnines & Codership teams came together to co-host two webinar sessions on Galera 3.0, MySQL 5.6, Global Transaction IDs and WAN. The sessions were held during EMEA/APAC as well as NA/LATAM timezones, which worked...

October 16, 2013

Understanding gcache in Galera

Galera uses a preallocated file with a specific size called gcache, used to store the writesets in circular buffer style. By default, its size is 128MB. In this post, we are going to explore how to leverage...

October 7, 2013

Installing a ClusterControl Standby Server

As you might already know, ClusterControl runs on a dedicated host. Failure of the ClusterControl host (or the datacenter it is running in) does not affect your running database cluster, however you cannot manage the cluster during...

October 1, 2013

Patch Updates and New Version Upgrades of Your Database Clusters

Database vendors regularly issue critical patch updates to address software bugs or known vulnerabilities, but for a variety of reasons, organizations are often unable to install them in a timely manner, if at all. Evidence...

September 17, 2013

Avoiding Deadlocks in Galera – Setting Up HAProxy for Single-Node Writes and Multi-Node Reads

Galera cluster has known limitations, one of them is that it uses cluster-wide optimistic locking. This may cause some transactions to rollback. With an increasing number of writeable masters, the transaction rollback rate may increase, especially...

September 12, 2013

Using BitTorrent Sync to Transfer Database Backups Offsite

BitTorrent Sync is a simple replication application providing encrypted bidirectional file transfers that can run behind NAT and is specifically designed to handle large files. By leveraging the simplicity of Bittorrent Sync, we can transfer...

September 10, 2013

Live Database Migration from MMM to MariaDB Galera Cluster

This is a guest post from Igor Shevtsov, a MySQL DBA based in Twickenham, UK. Igor has had the opportunity to deploy and manage different types of high availability MySQL solutions, and we invited him...

August 30, 2013

Clustering MySQL Backend in OpenStack

OpenStack uses a database to store data for all OpenStack services such as compute nodes available, running instances, state and so on. The DB takes part in every user request, from listing all instances to...

August 27, 2013

NoSQL Battle of the East Coast – Benchmarking MongoDB vs TokuMX Cluster

In this post we will compare performance of MongoDB and TokuMX, a MongoDB performance engine from Tokutek. We will conduct three simple experiments that (almost) anyone without any programming skills can try and reproduce. In...

August 23, 2013

Migrating MySQL Galera Cluster to a New Data Center Without Downtime

Are you tired and frustrated with your hosting or cloud provider? Have you seen a constant degradation in service levels and responsiveness? Or was the public cloud a bit too expensive after all, and you’re...

August 16, 2013

ClusterControl on the AWS Marketplace: Getting Started

Good news for AWS users! We are now available on AWS Marketplace. This allows you, with a single click of a button, to deploy ClusterControl in just a few minutes. Once ClusterControl is deployed, you...

Subscribe below to be notified of fresh posts