MySQL semisynchronous replication provides improved data integrity because when a commit returns successfully, it's known that the data exists in at least two places “ the master and its slave. In this blog post, we review some of the MySQL configurations that influence the data integrity and performance aspects of semisynchronous replication. We'll be using InnoDB storage … [Read more...] about Data Integrity and Performance Considerations in MySQL Semisynchronous Replication
database
MongoDB Ruby Driver 2.5.x Case-Sensitivity Issues with Hostnames on Replica Sets
Having trouble connecting to MongoDB replica sets after upgrading the MongoDB Ruby driver to 2.5.x? We've recently received a few inquiries about this issue with the latest MongoDB Ruby driver version and wrote this post to share our findings on the problem and cause. The error message that was encountered on connection attempt was - No server is available matching preference: … [Read more...] about MongoDB Ruby Driver 2.5.x Case-Sensitivity Issues with Hostnames on Replica Sets
JSON: To ETL or to NoETL? The Big Data Question
NoETL. The little brother of NoSQL You have probably come across the term NoSQL. It was coined a few years back to describe a class of database systems that can scale across a large number of nodes for distributed (and sometimes global processing) of transactions (OLTP). Very early technologies were DynamoDB and Cassandra. These technologies trade in scalability for consistency … [Read more...] about JSON: To ETL or to NoETL? The Big Data Question
How to Find and Eliminate Duplicate Data in Your Database
Duplicate data is a problem that plagues many businesses, but it's relatively easy to spot and prevent ”once you understand its nature, and what to do about it. You also have many potential options to explore when identifying and eliminating duplicate data, so you can find the best methodology for your business and needs. But how do you get started if this is a new problem for … [Read more...] about How to Find and Eliminate Duplicate Data in Your Database
Data Testing: Why Traditional Approaches fail in the Era of Big Data
The contemporary business environment is characterized by proliferating data, growing customer demands, and shrinking budgets. It, therefore, calls for organizations to remain competitive by making the right decisions at the right time. The business world has witnessed a paradigm shift over the past several years. It's no longer imperative for business leaders to only rely on … [Read more...] about Data Testing: Why Traditional Approaches fail in the Era of Big Data
