Tag: replication

Feed: Clustrix Blog. Author: Anders Karlsson. Spider is a storage engine for MariaDB Platform that allows you to build distributed databases from a standard MariaDB setup. The technology is not per se complicated, although the implementation is. This blog will explain how the Spider storage engine works, what it does and will also show some of the use cases.MariaDB Storage Engines Before we look at the Spider storage engine, let’s have a quick look at the Storage Engine concept. A storage engine is the implementation of code that manages the low level of data access in MariaDB. The storage engine ... Read More

Feed: Planet MySQL; Author: Severalnines; In the previous blog we showed you how to set up an environment in Amazon AWS EC2 that consists of a Percona Server 8.0 Replication Cluster (in Master - Slave topology). We deployed ProxySQL and we configured our application (Sysbench).  We also used ClusterControl to make the deployment easier, faster and more stable. This is the environment we ended up with... This is how it looks in ClusterControl: In this blog post we are going to review the requirements and show you how, in this setup, you can seamlessly perform master switches. Seamless Master Switch ... Read More

Feed: Clustrix Blog. Author: Ken Geiselhart. In the world of databases, having multiple copies of your database helps to serve your business in a multitude of ways. To achieve this, replication is used. Replication copies the contents of one server called a Primary to one or more servers called Replicas.One advantage of replication is the ability to separate the read requests from the write requests and direct those reads to a Replica, offloading that portion of a workload away from the Primary improving performance on the Primary. The main difference in basic replication, between a Primary and a Replica, is ... Read More

Feed: Redis Labs. Author: Fredric Paul. Early on Tuesday, November 12, the Redis Labs DevOps team started to get bursts of alerts from our production clusters located in the Amazon Web Services eu-central region (Frankfurt, Germany). Upon further examination, they realized a significant outage was happening in AWS’ eu-central-1 data center, which was confirmed on the AWS status page, and eventually covered in the press: Screenshot of the AWS Status page on November 12, 2019. Cloud outages are not new to us. We have been running production Redis clusters since early 2013 and during that time we’ve experienced more than ... Read More

Feed: Planet MySQL; Author: Severalnines; MySQL InnoDB Cluster consists of 3 components: MySQL Group Replication (a group of database server which replicates to each other with fault tolerance). MySQL Router (query router to the healthy database nodes) MySQL Shell (helper, client, configuration tool) In the first part of this walkthrough, we are going to deploy a MySQL InnoDB Cluster. There are a number of hands-on tutorial available online but this walkthrough covers all the necessary steps/commands to install and run the cluster in one place. We will be covering monitoring, management and scaling operations as well as some gotchas when ... Read More

Feed: Microsoft Azure Blog. Author: Rimma Nehme. This post was co-authored by Mikhail Shilkov, Software Engineer, Pulumi. Pulumi is reinventing how people build modern cloud applications, with a unique platform that combines deep systems and infrastructure innovation with elegant programming models and developer tools. We live in amazing times when people and businesses on different continents can interact at the speed of light. Numerous industries and applications target users around the globe: e-commerce websites, multiplayer online games, connected IoT devices, collaborative work and leisure experiences, and many more. All of these applications demand computing and data infrastructure in proximity to ... Read More

Feed: Blog – ArangoDB. Author: Jan Stücke. After two years of planning, preparation and a few lines of code, you can now enjoy an even more comfortable developers’ life with ArangoDB. Today, we are happy to announce the launch of ArangoDB’s managed service Oasis – a fully-managed graph database, document, and key-value store, as well as a full-text search engine – in one place. Oasis is available immediately for Google Cloud, AWS – and also Microsoft Azure will be available very soon. The goal for Oasis was and is to provide highly scalable and secure deployments with just a few ... Read More

Feed: Microsoft Azure Blog. Author: Rohit Tatachar. The Azure Container Registry team is happy to announce the preview of audit logs – one of our top items on UserVoice. In this release, we have new Azure portal and command-line interface (CLI) experiences to enable resource logs for diagnostic and audit evaluation of your registry logs. This feature enables a capability to monitor your container registry by providing an audit trail of all relevant user driven activities on the registry. These logs contain information related to authentication, login details, repository level activities, and other user-driven events. In addition to these logs, ... Read More

Feed: Planet MySQL; Author: MyDBOPS; In my previous blog, I have explained how the MySQL clone plugin works internally. In this blog, I am going to do a comparison of  Backup and Recovery speed of MySQL clone plugin with other available mysql open source backup tools. Below tools are used for speed comparison of Backup and Recovery, Clone-Plugin Xtrabackup mysqldump mydumper with myloader mysqlpump Test cases: Hardware Configuration: Two standalone servers are picked up with identical configuration. Server 1 * IP: 172.23.26.127 * CPU: 2 Cores * RAM: 4 GB * DISK: 200 GB SSD Server 2 * IP: 172.21.3.114 ... Read More

Feed: Blue Medora. Author: Nate Coppinger. MongoDB Multi-granular Locking System Are you experiencing high queues or slow response times in your MongoDB database? Well then, you may have a deeper issues within your database… a high MongoDB Lock Percentage. MongoDB can be a large and complicated database to manage and maintain, which means you will probably have multiple team members accessing and working on data at the same time. MongoDB employs a multi-granular lock system that allows users to concurrently work in the database and view the same data without making conflicting modifications. This Multi-granular locking system locks MongoDB and ... Read More