Tag: database replication

MySQL Replication Options and their Challenges

Previously we discussed replication for MySQL systems.  In this post we will discuss various MySQL replication options. For MySQL, replication is the primary go-to strategy for high availability (HA) and, to some extent, scale. By providing additional copies of the primary database, a MySQL system using replication can withstand the loss […]

Does ClustrixDB use MySQL Replication Between its Nodes?

Here’s a common question we get asked at tradeshows, on customer calls, by analysts, and by our fellow devs and DBAs in the industry. Since this has come up a lot, let’s answer it in detail! TL;DR: ClustrixDB does not use MySQL Replication between nodes ClustrixDB is a true shared-nothing […]

(Trying to) Get Under the Hood of AWS’s New Aurora

Amazon’s Aurora Announcement Last week, Amazon announced Aurora with many interesting features promised. Let’s drill into the details a bit, and explore the ramifications. Architecture: Aurora’s overall design leverages a single write master, read-slave fanout architecture. Okay, sounds like MySQL—reads are scalable. Amazon has also written a lot about Aurora’s […]

Master-Master: Investigation of the Mysterious Duplicate Key Error

Mysterious Duplicate Key Error One thing I like about my role at Clustrix is that it allows me to work with real customer use cases and offers a unique opportunity to understand respective deployment architectures and learn something new and interesting from each and every engagement. I came across an […]

In-Memory Real-Time Analytics, Done Right

In-Memory There is a lot of hype in the media about in-memory computing and in-memory real-time analytics. SAP HANA has used savvy marketing and experimental projects across their customer base to create a storm of interest followed by real revenue. Now, everyone wants in. Oracle has jumped in recently with […]