MySQL FULLTEXT too slow?
MygramDB delivers sub-millisecond queries with in-memory indexing. No more timeout errors.
In-memory search engine
MygramDBSub-millisecond full-text search
In-memory search engine with MySQL / MariaDB binlog replication
Skip to content
SEARCH LATENCY"quantum physics"
MySQL FULLTEXT2,566ms
MygramDBin-memory0.08ms
27,600× faster · p50 on 1.1M docs
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 enforce_gtid_consistency = ON;
SET GLOBAL gtid_mode = OFF_PERMISSIVE;
SET GLOBAL gtid_mode = ON_PERMISSIVE;
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 TABLE_PRIMARY_KEY=id \
-e TABLE_TEXT_COLUMN=content \
-e TABLE_NGRAM_SIZE=2 \
-e REPLICATION_SERVER_ID=12345 \
-e NETWORK_ALLOW_CIDRS=0.0.0.0/0 \
ghcr.io/libraz/mygram-db:latestWARNING
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
docker exec mygramdb mygram-cli -p 11016 SYNC articles
echo "SEARCH articles hello world" | nc localhost 11016Client Libraries
See Official Clients for full Node.js, Python, and Go usage.
Node.js v1.7 compatible
bash
npm install mygramdb-clientbash
yarn add mygramdb-clientbash
bun add mygramdb-clientjavascript
import { createMygramClient } from 'mygramdb-client'
const client = createMygramClient({ host: 'localhost', port: 11016 })
await client.connect()
const results = await client.search('app_db.articles', 'hello world', {
limit: 10
})Go v1.7 compatible
bash
go get github.com/libraz/go-mygram-clientgo
import mygram "github.com/libraz/go-mygram-client"
client := mygram.NewClient("localhost:11016")
defer client.Close()
client.Connect()
resp, _ := client.Search("app_db.articles", "hello world", mygram.SearchOptions{
Limit: 10,
})Python v1.7 compatible
bash
pip install mygramdb-clientpython
from mygramdb_client import MygramClient, ClientConfig, SearchOptions
async with MygramClient(ClientConfig(host='localhost', port=11016)) as client:
results = await client.search(
'app_db.articles',
'hello world',
SearchOptions(limit=10),
)python-mygramdb-client on GitHub