MygramDB

English

日本語

English

日本語

Appearance

MygramDBSub-millisecond full-text search

In-memory search engine with MySQL / MariaDB binlog replication

View on GitHub
Benchmarks

MySQL FULLTEXT too slow?

MygramDB delivers sub-millisecond queries with in-memory indexing. No more timeout errors.

Real-time MySQL / MariaDB sync

GTID-based binlog replication for MySQL 8.4/9.x and MariaDB 10.6+/11.x. Keep writes where they are, just speed up search.

Full Unicode, multibyte-ready

ICU-based NFKC normalization with language-agnostic N-gram tokenization. Handles 3-byte and 4-byte UTF-8 out of the box — no language-specific plugins.

Dual Protocol

Memcached-like TCP and REST/JSON HTTP API. Easy integration.

BM25 scoring & highlighting

Rank results by BM25 relevance score, return highlighted snippets, and expand queries via synonym dictionaries.

Fuzzy search & faceted aggregation

Levenshtein fuzzy matching and filter-column aggregation with document counts.

Quick Start ​

MySQL requires GTID mode and a replication user:

sql
SET GLOBAL gtid_mode = ON;
CREATE USER 'repl_user'@'%' IDENTIFIED BY 'your_password';
-- SELECT: for initial snapshot of search target tables
GRANT REPLICATION SLAVE, REPLICATION CLIENT, SELECT ON mydb.* TO 'repl_user'@'%';
bash
docker run -d --name mygramdb \
  -p 11016:11016 -p 8080:8080 \
  -e MYSQL_HOST=your-mysql-host \
  -e MYSQL_USER=repl_user \
  -e MYSQL_PASSWORD=your_password \
  -e MYSQL_DATABASE=mydb \
  -e TABLE_NAME=articles \
  -e NETWORK_ALLOW_CIDRS=0.0.0.0/0 \
  ghcr.io/libraz/mygram-db:latest

WARNING

NETWORK_ALLOW_CIDRS=0.0.0.0/0 allows connections from any IP. For production, restrict to specific ranges (e.g., 10.0.0.0/8,172.16.0.0/12).

bash
echo "SEARCH articles hello world" | nc localhost 11016

Client Libraries ​

Node.js v1.6 compatible ​

bash
npm install mygramdb-client
bash
yarn add mygramdb-client
bash
bun add mygramdb-client
javascript
import { MygramClient } from 'mygramdb-client'

const client = new MygramClient({ host: 'localhost', port: 11016 })
const results = await client.search('articles', 'hello world')

mygramdb-client on GitHub

Go v1.6 compatible ​

bash
go get github.com/libraz/go-mygram-client
go
import mygram "github.com/libraz/go-mygram-client"

client := mygram.NewClient("localhost:11016")
defer client.Close()
client.Connect()

resp, _ := client.Search("articles", "hello world", mygram.SearchOptions{})

go-mygram-client on GitHub

Python v1.6 compatible ​

bash
pip install mygramdb-client
python
from mygramdb_client import MygramClient, ClientConfig

client = MygramClient(ClientConfig(host='localhost', port=11016))
await client.connect()

results = await client.search('articles', 'hello world')

python-mygramdb-client on GitHub

mysql-event-stream ​

A lightweight MySQL / MariaDB CDC (Change Data Capture) engine extracted from MygramDB. Parses binlog replication events and provides a streaming API for applications. Supports MySQL 8.4/9.x (VECTOR type, RSA auth) and MariaDB 10.11+/11.x (flavor auto-detection, domain-server-seq GTID, ANNOTATE_ROWS). Node.js (N-API) and Python (ctypes) bindings.

mysql-event-stream on GitHub