Meilisearch 완전 정복 (Strapi V4 적용) — 로컬 AI 홈랩 초고속 검색 허브 구축

            ┌─ Strapi ─ 블로그 발행 → 자동 동기화 ──────────────┐
            │                                                    ↓
데이터 소스 ─┼─ n8n ──── KOSPI/뉴스/RSS ──────────────→  Meilisearch
            │                                                    ↑
            ├─ ComfyUI ─ 이미지 프롬프트 히스토리 ──────────────┤
            │                                                    │
            └─ Obsidian ─ 마크다운 노트 ─── SFTP → n8n ────────┘
                                                    ↓           ↓
                                              키워드 검색    하이브리드 RAG
                                                    ↓           ↓
WordPress InstantSearch 위젯          Qdrant(벡터) + Meilisearch(키워드)
(블로그 방문자 검색)                               ↓ RRF 병합
                                              Ollama LLM → 최종 답변

# 안전한 랜덤 키 생성 후 .env에 추가
echo "MEILI_MASTER_KEY=$(openssl rand -base64 32)" >> .env

# 확인
grep MEILI_MASTER_KEY .env

  meilisearch:
    image: getmeili/meilisearch:v1.7
    container_name: meilisearch
    restart: unless-stopped
    ports:
      - "7700:7700"
    volumes:
      - /mnt/data/02_automation/meilisearch/data:/meili_data
    environment:
      - MEILI_MASTER_KEY=${MEILI_MASTER_KEY}
      - MEILI_ENV=production
      - MEILI_NO_ANALYTICS=true
      - MEILI_MAX_INDEXING_MEMORY=4GiB
      - MEILI_MAX_INDEXING_THREADS=2
      - MEILI_EXPERIMENTAL_ENABLE_METRICS=true
    healthcheck:
      test: ["CMD","wget","--no-verbose","--tries=1","--spider","http://localhost:7700/health"]
      interval: 10s
      timeout: 5s
      retries: 3
    networks:
      - ai-common-net
    logging: *default-logging

# meilisearch-exporter 컨테이너는 필요 없습니다
# v1.3부터 /metrics 엔드포인트가 내장되어 있습니다

scrape_configs:
  - job_name: 'meilisearch'
    metrics_path: '/metrics'
    static_configs:
      - targets: ['meilisearch:7700']
    authorization:
      type: Bearer
      credentials: 'YOUR_MEILI_MASTER_KEY'  # .env의 MEILI_MASTER_KEY 값으로 교체

curl -L -o /tmp/meilisearch-grafana.json   https://raw.githubusercontent.com/meilisearch/meilisearch/main/assets/grafana-dashboard.json

# 다운로드 확인
ls -lh /tmp/meilisearch-grafana.json

# 1. Meilisearch가 실행 중인지 확인
docker ps | grep meilisearch

# 2. 마스터 키 환경변수 불러오기 (.env 파일 위치에서 실행)
export MEILI_MASTER_KEY=$(grep MEILI_MASTER_KEY .env | cut -d= -f2)

# 3. 연결 테스트
curl -s http://192.168.0.100:7700/health
# {"status":"available"} 가 나와야 정상

MEILI="http://192.168.0.100:7700"
KEY="${MEILI_MASTER_KEY}"

# ── blog-post 인덱스 ──────────────────────────────────
curl -s -X PUT "$MEILI/indexes/blog-post/settings/searchable-attributes" \
  -H "Authorization: Bearer $KEY" -H "Content-Type: application/json" \
  -d '["title","excerpt","category","subCategory","wpTags"]'

curl -s -X PUT "$MEILI/indexes/blog-post/settings/filterable-attributes" \
  -H "Authorization: Bearer $KEY" -H "Content-Type: application/json" \
  -d '["category","subCategory"]'

curl -s -X PUT "$MEILI/indexes/blog-post/settings/sortable-attributes" \
  -H "Authorization: Bearer $KEY" -H "Content-Type: application/json" \
  -d '["createdAt"]'

# ── market-data 인덱스 ────────────────────────────────
curl -s -X PUT "$MEILI/indexes/market-data/settings/searchable-attributes" \
  -H "Authorization: Bearer $KEY" -H "Content-Type: application/json" \
  -d '["title","content","source"]'

curl -s -X PUT "$MEILI/indexes/market-data/settings/filterable-attributes" \
  -H "Authorization: Bearer $KEY" -H "Content-Type: application/json" \
  -d '["type","date","source"]'

# ── prompt-library 인덱스 ─────────────────────────────
curl -s -X PUT "$MEILI/indexes/prompt-library/settings/searchable-attributes" \
  -H "Authorization: Bearer $KEY" -H "Content-Type: application/json" \
  -d '["prompt","tags","style","model","note"]'

curl -s -X PUT "$MEILI/indexes/prompt-library/settings/filterable-attributes" \
  -H "Authorization: Bearer $KEY" -H "Content-Type: application/json" \
  -d '["type","model","rating","dateStr"]'

# ── obsidian-vault 인덱스 ─────────────────────────────
curl -s -X PUT "$MEILI/indexes/obsidian-vault/settings/searchable-attributes" \
  -H "Authorization: Bearer $KEY" -H "Content-Type: application/json" \
  -d '["title","content","tags","category","excerpt"]'

# ── homelab-events 인덱스 ─────────────────────────────
curl -s -X PUT "$MEILI/indexes/homelab-events/settings/searchable-attributes" \
  -H "Authorization: Bearer $KEY" -H "Content-Type: application/json" \
  -d '["title","content","source","instance"]'

curl -s -X PUT "$MEILI/indexes/homelab-events/settings/filterable-attributes" \
  -H "Authorization: Bearer $KEY" -H "Content-Type: application/json" \
  -d '["severity","type","date","source"]'

echo "전체 인덱스 설정 완료"

# blog-post 인덱스의 검색 대상 속성이 잘 들어갔는지 확인
curl -s "http://192.168.0.100:7700/indexes/blog-post/settings/searchable-attributes"   -H "Authorization: Bearer ${MEILI_MASTER_KEY}"
# 출력 예시: ["title","excerpt","category","subCategory","wpTags"]

# 전체 인덱스 목록 확인 (데이터가 들어온 후)
curl -s "http://192.168.0.100:7700/indexes"   -H "Authorization: Bearer ${MEILI_MASTER_KEY}" | python3 -m json.tool | grep '"uid"'

docker exec -it strapi sh -c "cd /opt/app && npm install @strapi/plugin-meilisearch && exit"
docker compose restart strapi

module.exports = ({ env }) => ({
  meilisearch: {
    config: {
      host: 'http://meilisearch:7700',      // 컨테이너명 사용 (같은 네트워크)
      apiKey: env('MEILI_MASTER_KEY'),
    }
  },
});

curl -X POST "http://192.168.0.100:7700/keys" \
  -H "Authorization: Bearer ${MEILI_MASTER_KEY}" \
  -H "Content-Type: application/json" \
  -d '{
    "name": "WordPress Search Key",
    "actions": ["search"],
    "indexes": ["blog-post"],
    "expiresAt": null
  }'
# 응답에서 "key" 값을 복사 → WordPress 설정에 사용

function agibop_enqueue_meilisearch() {
    wp_enqueue_script('instantsearch',
        'https://cdn.jsdelivr.net/npm/instantsearch.js@4/dist/instantsearch.production.min.js',
        [], '4', true);
    wp_enqueue_script('meili-instantsearch',
        'https://cdn.jsdelivr.net/npm/@meilisearch/instant-meilisearch/dist/instant-meilisearch.umd.min.js',
        ['instantsearch'], '0.19', true);
}
add_action('wp_enqueue_scripts', 'agibop_enqueue_meilisearch');

<div id="meili-search-wrap">
  <div id="meili-searchbox"></div>
  <div id="meili-refinement"></div>   <!-- 카테고리 필터 -->
  <div id="meili-hits"></div>
  <div id="meili-pagination"></div>
</div>

<script>
const searchClient = instantMeiliSearch(
  'https://meilisearch.agibop.com',   // Cloudflare Tunnel 외부 URL
  'YOUR_SEARCH_ONLY_KEY'
);
const search = instantsearch({ indexName: 'blog-post', searchClient });

search.addWidgets([
  instantsearch.widgets.searchBox({
    container: '#meili-searchbox',
    placeholder: '블로그 검색...',
  }),
  instantsearch.widgets.refinementList({  // 카테고리 필터 위젯
    container: '#meili-refinement',
    attribute: 'category',
    transformItems(items) {
      const labels = { 'ai-lab': 'AI랩', 'finance': '재테크', 'home-lab': '홈랩' };
      return items.map(i => ({ ...i, label: labels[i.label] || i.label }));
    },
  }),
  instantsearch.widgets.hits({
    container: '#meili-hits',
    templates: {
      item: (hit) => `
        <a class="meili-hit" href="/${hit.slug}/">
          <span class="meili-cat">${hit.category}</span>
          <strong>${hit._highlightResult.title.value}</strong>
          <p>${hit._highlightResult.excerpt?.value || ''}</p>
        </a>`,
      empty: '<p>검색 결과가 없습니다.</p>',
    },
  }),
  instantsearch.widgets.pagination({ container: '#meili-pagination' }),
]);
search.start();
</script>

매시간 실행 ─┬─→ Yahoo Finance API (KOSPI 지수) ─┐
             └─→ 금융 RSS 피드                  ─┘
                                                  ↓
                          데이터 정형화 + URL 해시로 id 생성
                                                  ↓
                            Meilisearch: market-data 인덱스 Upsert
                                                  ↓
                                          결과 로그 (콘솔)

# 날짜 필터 + 키워드 검색
curl -X POST "http://192.168.0.100:7700/indexes/market-data/search" \
  -H "Authorization: Bearer ${MEILI_MASTER_KEY}" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "코스피 상승",
    "filter": "date = \"2026-07-01\"",
    "limit": 5
  }'

const feeds = [
  // 기존 5개 ...
  // 추가 예시:
  { url: 'https://www.hani.co.kr/rss/',     category: '뉴스',  source: '한겨레' },
  { url: 'https://www.sedaily.com/RSS/RssNews.xml', category: '경제', source: '서울경제' },
];

curl -X POST "https://n8n.agibop.com/webhook/meili-prompt-save" \
  -H "Content-Type: application/json" \
  -d '{
    "prompt": "futuristic AI robot, neon blue, cinematic, 8K, detailed",
    "type": "comfyui",
    "model": "juggernautXL_v9Rdphoto2Lightning",
    "style": "cinematic",
    "tags": "로봇,SF,네온,8K",
    "rating": 5,
    "note": "조명 각도 45도, steps=20이 최적"
  }'

curl -X POST "https://n8n.agibop.com/webhook/meili-prompt-save" \
  -H "Content-Type: application/json" \
  -d '{
    "prompt": "[verse] 밤하늘 별빛 아래 [chorus] 우리의 이야기",
    "type": "music",
    "model": "ACE-Step-1.5-XL",
    "style": "K-pop ballad, 80 BPM",
    "tags": "발라드,K팝,감성",
    "rating": 4,
    "note": "infer_steps=50이 품질 좋음"
  }'

# 음악 프롬프트 중 별점 4 이상만 검색
curl -X POST "http://192.168.0.100:7700/indexes/prompt-library/search" \
  -H "Authorization: Bearer ${MEILI_MASTER_KEY}" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "발라드",
    "filter": "type = \"music\" AND rating >= 4",
    "sort": ["rating:desc"],
    "limit": 10
  }'

# 하이라이팅 포함 노트 검색 (오타 허용)
curl -X POST "http://192.168.0.100:7700/indexes/obsidian-vault/search" \
  -H "Authorization: Bearer ${MEILI_MASTER_KEY}" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "Strapii n8n연동",
    "attributesToHighlight": ["title","content"],
    "highlightPreTag": "**",
    "highlightPostTag": "**",
    "limit": 5
  }'
# "Strapii" 오타도 "Strapi" 결과를 반환합니다

# 이번 달 critical 이벤트 전체 조회
curl -X POST "http://192.168.0.100:7700/indexes/homelab-events/search" \
  -H "Authorization: Bearer ${MEILI_MASTER_KEY}" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "",
    "filter": ["severity = \"critical\"", "date >= \"2026-07-01\""],
    "sort": ["createdAt:desc"],
    "limit": 50
  }'

Qdrant 결과:      [A순위1, B순위2, C순위3]  → 점수: 1/(60+1), 1/(60+2), ...
Meilisearch 결과: [B순위1, D순위2, A순위3]  → 점수: 1/(60+1), 1/(60+2), ...

RRF 합산:  A = 1/61 + 1/63 ≈ 0.0322  (양쪽 상위권)
           B = 1/62 + 1/61 ≈ 0.0326  (양쪽 상위권, 1위)
           C = 1/63         ≈ 0.0159  (Qdrant만)
           D = 1/62         ≈ 0.0161  (Meilisearch만)

최종 순위: B → A → D → C  (양쪽에서 높게 나온 문서가 상위)

curl -X POST "https://n8n.agibop.com/webhook/hybrid-search" \
  -H "Content-Type: application/json" \
  -d '{
    "query": "2026년 삼성전자 1분기 실적 요약",
    "indexes": ["blog-post", "market-data", "news-feed"],
    "top_k": 5,
    "generate": true
  }'

# 응답 구조:
# {
#   "query": "...",
#   "answer": "Ollama가 생성한 답변",
#   "sources": [{ "id": "...", "title": "...", "source": "market-data" }, ...],
#   "stats": { "meilisearch_hits": 9, "qdrant_hits": 5 }
# }

curl -X POST "http://192.168.0.100:7700/multi-search" \
  -H "Authorization: Bearer ${MEILI_MASTER_KEY}" \
  -H "Content-Type: application/json" \
  -d '{
    "queries": [
      { "indexUid": "blog-post",      "q": "Strapi", "limit": 3 },
      { "indexUid": "news-feed",       "q": "Strapi", "limit": 3 },
      { "indexUid": "obsidian-vault",  "q": "Strapi", "limit": 3 },
      { "indexUid": "prompt-library",  "q": "Strapi", "limit": 2 }
    ]
  }'

const results = $json.results || [];
const LABEL = { 'blog-post': '블로그', 'news-feed': '뉴스', 'obsidian-vault': 'Obsidian', 'prompt-library': '프롬프트' };

const merged = results.flatMap(r =>
  (r.hits || []).map(h => ({
    ...h,
    _index: r.indexUid,
    _indexLabel: LABEL[r.indexUid] || r.indexUid,
  }))
);

return [{ json: { total: merged.length, results: merged } }];

# 스냅샷 생성 (비동기, /meili_data/snapshots/에 저장됨)
curl -X POST "http://192.168.0.100:7700/snapshots" \
  -H "Authorization: Bearer ${MEILI_MASTER_KEY}"

# [NAS]로 자동 복사 (cron 또는 n8n Schedule로 자동화)
rsync -avz /mnt/data/02_automation/meilisearch/data/snapshots/ \
  192.168.0.150:/volume1/backup/meilisearch/