Skip to content

Latest commit

 

History

History
45 lines (26 loc) · 1.25 KB

README.md

File metadata and controls

45 lines (26 loc) · 1.25 KB

go-mysql-sphinx

Connects to MySQL/MariaDB via the replication protocol, and sends updates to Sphinx.

Example quick start

docker-compose up

Usage

  1. Install Go

  2. Install dep

  3. Build

     $ make
    
  4. Configure MySQL/MariaDB

    • binlog_format must be ROW
    • binlog_row_image must be FULL (otherwise you may not be able to determine which documents should be updated)
  5. Configure Sphinx

    • index sync_state should exist and have the following structure

        type = rt
        rt_attr_string = binlog_name
        rt_attr_uint   = binlog_position
        rt_attr_string = gtid
        rt_attr_string = flavor
      
    • for every RT-index there should be a plain index with _plain suffix

    • if an index is partitioned, then its parts should have the same schema and names that end with _part_0, _part_1, etc.

    • searchd should expect all index files to be in the same folder (i.e. path of each index should have the same dirname)

  6. Configure go-mysql-sphinx

See example config file river.toml.

  1. Run

     $ ./bin/go-mysql-sphinx [-config config-file]