Tag: cluster

Miscellaneous

Performing a Live Migration from a MongoDB Cluster to Amazon DynamoDB

Migrating data from one database to other can be quite challenging with respect to data consistency, downtime of applications, and key design differences between the target and source databases. AWS Data Migration Service (AWS DMS) helps you migrate databases like MongoDB, Oracle, MySQL, and Microsoft SQL Server to AWS quickly, securely, and seamlessly. The source …

Clustering

Partial LCP in MySQL Cluster 7.6.4

Today MySQL Cluster 7.6.4 DMR is out. This new version contains some very interesting new developments in the area of checkpointing. When I developed the original NDB algorithms in the late 90s the computer I had access to had 2 CPUs, 1 GByte of memory. At the time we were aiming at 10.000 updates per …

Miscellaneous

Get Started with Amazon Elasticsearch Service: Use Dedicated Master Instances to Improve Cluster Stability

Welcome to this introductory series on Elasticsearch and Amazon Elasticsearch Service (Amazon ES). In this and future articles, we provide the basic information that you need to get started with Elasticsearch on AWS. What dedicated master instances are and why you need them Dedicated master instances perform a single function in an Elasticsearch cluster: orchestration. …

Clustering

How to convert galera node to async slave and vice-versa with MariaDB Galera Cluster

Recently, I was working with one of our customer and this is what their requirement as they want to automate this process for converting galera node to async slave and make async slave to galera node without shutting down any server. ———- I’ve tested locally with my galera cluster and it’s working smoothly. But with …

Miscellaneous

Percona XtraDB Cluster 5.6.38-26.23 Is Now Available

  Percona announces the release of Percona XtraDB Cluster 5.6.38-26.23 (PXC) on January 24, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.38-26.23 is now the current release, based on the following: All Percona software is open-source and free. Fixed Bugs PXC-889: Fixed an issue where a node …

Clustering

What is the default sharding key in MySQL Cluster?

MySQL Cluster does an automatic sharding/partitioning to the tables across data nodes, enabling databases to scale horizontally to serve read and write-intensive workloads, but what is the default sharding key used in partitioning the data? According to the recent update (Oct, 2016) of the MySQL Cluster white paper, primary key is the default sharding key: …