Category: MySQL & MariaDB

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: Planet MySQL; Author: The Pythian Group; In this post, we will explore one approach to MySQL high availability with ProxySQL, Consul and Orchestrator. This is a follow up to my previous post about a similar architecture but using HAProxy instead. I’ve re-used some of the content from that post so that you don’t have to go read through that one, and have everything you need in here. Let’s briefly go over each piece of the puzzle: – ProxySQL is in charge of connecting the application to the appropriate backend (reader or writer). It can be installed on each application ... Read More

Feed: Planet MySQL; Author: Mark Callaghan; This is a hypothesis, perhaps it is true. I am biased given that I spent 15 years acknowledging tech debt on a vendor-based project (MySQL) and not much time on community-based projects. My theory on tech debt and OSS is that there is more acknowledgement of tech debt in vendor-based projects than community-based ones. This is an advantage for vendor-based projects assuming you are more likely to fix acknowledged problems. Of course there are other advantages for community-based projects.I think there is more acknowledgement of tech debt in vendor-based projects because the community is ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. How does a major technology services company equip itself to compete in the digital age – and provide services so outstanding that they can significantly advance the business prospects of their customers? All while reducing complexity, cutting costs, and tightening SLAs – in some cases, by 10x or more? For one such company, the solution is to deliver real-time, operational analytics with Kafka and MemSQL. In this company, data flowed through several data stores, and from a relational, SQL database, into NoSQL data stores for batch query processing, and back into SQL for BI, ... Read More

Feed: Planet MySQL; Author: Mikael Ronström; MySQL Cluster 8.0.18 RC2 was released a few weeks back packed with a set of new interesting things.One major change we have done is to increase the number of data nodes from 48 to 144. There is also ongoing work to fully support 3 and 4 replicas in MySQL Cluster 8.0. NDB has actually always been designed to handle up to 4 replicas. But the test focus have previously been completely focused on 2 replicas. Now we expanded our test focus to also verify that 3 and 4 replicas work well. This means that ... Read More

Feed: Planet MySQL; Author: Mark Callaghan; I am wary of papers with performance results for too many products.Too many means including results from systems for which you lack expertise. Wary means I have less faith in the comparison even when the ideas in the paper are awesome. I have expertise in MySQL, MongoDB, RocksDB, WiredTiger and InnoDB but even for them I have made and acknowledged ridiculous mistakes.Database configuration is too hard. There are too many options, most of them aren't significant and the approach is bottom-up. I an expert on this -- in addition to years of tuning I ... 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: Planet MySQL; Author: Tony Darnell; Installing MySQL on Oracle Cloud’s “Always Free” Compute Instance November 14, 2019 Leave a comment At Oracle’s OpenWorld 2019, Oracle announced an Oracle Cloud Free Tier, which includes Oracle Cloud services that will always be free – as long as you use them or keep them active. Most other hyperscale cloud vendors offer a free 12-month trial before they start charging you, so to see Oracle provide a “truly free” service is really great. And the free services are not just limited to one or two choices – you get a wide variety of free ... 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