Causal consistency [1] is one of the consistency criteria that
can be used on distributed databases as consistency criteria.

Distributed database provides causal consistency if read and
write operations that are causally related are seen by every node
of the distributed system in the same order. Concurrent writes
may be seen in different order in diffrent nodes. Causal
consistency is waker than sequential consistency [2] but stronger
than eventual consistency [3]. See earlier blog for more detailed
description on eventual consistency …

This year is just about over. It’s almost time to welcome 2015.
In celebration of a fun year of sharing Sphinx-things, let’s
review 2014′s most popular posts. 1: Use Sphinx With MySQL This
one leads by a huge margin. Not a surprise. Many MySQL users get
frustrated with MySQL’s native fulltext search after hitting a
[...]

High season is coming, how do you make sure that MySQL will
handle the increased load? Stress tests could help with that, but
it’s not a good idea to run them in a production environment. In
this case Select_scan, Select_full_join and other MySQL counters
could quickly give you an idea of how many queries are not
performing well and could cause a performance degradation as the
load goes up.

Select_scan from SHOW GLOBAL STATUS indicates how many full table
scans were done since last MySQL restart. Scanning the entire
table is a resource intensive operation. It also forces MySQL to
store unnecessary data in the buffer pool, wasting memory and IO …

You can find a â€˜Quick Usage Tourâ€™ in our documentation. In
this post, Iâ€™m going to walk you through that tour and
elaborate on a few things. Enjoy! Things to consider Iâ€™m
assuming youâ€™ve already installed MySQL. Sphinx does not
require that you use MySQL, but the following examples do. Iâ€™m
installing Sphinx on Ubuntu [...]

MariaDB 10.1 server is now “Galera ready” with the latest 10.1.1
release. It includes wsrep (write set replication) patch that
enables server to load the wsrep provider (galera) library and
interact with it to provide multi-master synchronous replication
support. The patch implements hooks inside server and storage
engines to populate and apply the write sets on sender and
receiver nodes in a cluster respectively. The wsrep patch also
adds a number of system and …

A Wolf, a Dolphin and a Sphinx walk into a bar… nevermind. We’ll
skip the jokes. This post is about using SSL to set up a secure
connection between MySQL and Sphinx. Serious stuff! The Idea It
simple. Weâ€™re going to use Sphinx to index some data from MySQL
across a secure connection. So, weâ€™ll [...]

Sometimes users ask for something that doesn’t really make sense.
On the first glance. But then you start asking and realize that
the user was right, you were wrong, and it is, actually, a
perfectly logical and valid use case.

I’ve had one of these moments when I’ve heard about a request of
making triggers to work on the slave in the row-based
replication. Like, really? In RBR all changes made by triggers
are replicated from the master to slaves as row events. If
triggers would be fired on the slave they would do their changes
twice. And anyway, assuming that one only has triggers one the
slave (why?) in statement-based replication triggers would run on …

Let me start with a little story. You sit in your house near the
fireplace in the living room and need a book from the library…
Eh, no, sorry, wrong century. You’re building a robotic arm that
will open your beer or brew your coffee or supply you with
whatever other drinks of your choice… while you’ll be building
the next robotic arm. So, you — soldering iron in one hand and
Arduino in another — ask your little brother to bring a box with
specific resistors (that you unexpectedly run out of) from the
cellar. The problem — your brother is small and cannot tell a
resistor from a respirator. You explain that it’s small thing
with two …

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.