Does the Sphinx Storage Engine support RT indexes? Can you write to them from MariaDB?
You are viewing an old version of this article. View
the current version here.
Sphinx has a special RT (real time) index type. These indexes can accept writes (from the Sphinx doc):
RT index can be accessed using MySQL protocol. INSERT, REPLACE, DELETE, and SELECT statements against RT index are supported.
Does MariaDB support write statements to a rt index through the Sphinx Storage Engine? Can replication be made to update a Sphinx Storage Engine like a trigger on a table causing the new data to be inserted / updated / deleted on a Sphinx RT table? Triggers and Stored Routines have their own issues (like not being replicated in ROW based replication) but is there a way to tightly couple the rt index to changes in a slave db?
If I can make this work it would solve a difficult issue.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
