How to setup and install Elasticsearch: From a single node to a cluster of nodes
Elasticsearch is a complex software incomparable to other mainstream database software, whether it's RDBMS or NoSQL. It functions primarily as your search engine and works as your document database to store valuable data for analytics....
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)...
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...
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...
ClusterControl 1.2.4 Released
The Severalnines team is pleased to announce the release of ClusterControl 1.2.4. This release contains key new features along with performance improvements and bug fixes. We have outlined some of the key features below. For...
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....
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...