11.1.2. sql_host

SQL server host to connect to. Mandatory, no default value. Applies to SQL source types (mysql, pgsql, mssql) only.

In the simplest case when Sphinx resides on the same host with your MySQL or PostgreSQL installation, you would simply specify \"localhost\". Note that MySQL client library chooses whether to connect over TCP/IP or over UNIX socket based on the host name. Specifically \"localhost\" will force it to use UNIX socket (this is the default and generally recommended mode) and \"127.0.0.1\" will force TCP/IP usage. Refer to MySQL manual for more details.

Example:

 sql_host = localhost

\nweight(): 1727\n1 row in set (0.00 sec)\n```\n\nThen, go to http://sphinxsearch.com to keep learning about Sphinx.\n\nI'll be tweaking this configuration (to enable some cool features). When I do, I'll update this readme to show them off. \n\n##Option 3: Distributed##\n\nYou can use this container to play around with distributed indexing/search. \n\nJust start up a few Sphinx containers!\n\n###First Sphinx:###\n```\ndocker run -d -p 9306:9306 -p 9406:9406 QuickSphinx /sbin/my_init\n```\nThen, INSERT some content:\n```\nmysql -h0 -P9406\n...\ninsert into rt_test values (1, 'something', 'something');\ninsert into rt_test values (2, 'something else', 'something else');\n```\n\n###Second Sphinx:###\n```\ndocker run -d -p 9307:9306 -p 9407:9406 QuickSphinx /sbin/my_init\n```\nThen, INSERT some more content:\n```\nmysql -h0 -P9407\n...\ninsert into rt_test values (3, 'more', 'stuff');\ninsert into rt_test values (4, 'goes', 'here');\n```\nRepeat this for as long as you like. I'll stop at 2 Sphinx instances. You can run multiple Sphinx instances on one machine without Docker, but this way is a bit easier.\n\n###Configure the Master###\nConfiguration for your distributed index configuration will look something like this:\n```\nindex dist\n{\ntype=distributed\nagent=127.0.0.1:9306:rt_test\nagent=127.0.0.1:9307:rt_test\n\n}\nsearchd\n{\nlisten=9999:mysql41\nlog=/var/log/sphinx/searchd.log\nquery_log=/var/log/sphinx/query.log\nquery_log_format=sphinxql\nread_timeout=5\nmax_children=30\npid_file=/var/run/sphinx/searchd.pid\nworkers=threads\n}\n```\nThe two containers I have running are listening for MySQL protocol on 940\\* and for Sphinx protocol on 930\\*. So, when I start up searchd for this Master Sphinx instance, it will talk to the other Sphinges (plural for 'Sphinx') on 9306 and 9307, but you can open the MySQL command line tool on 9406 and 9407 to take a look at what's going on and add or take away stuff from your indexes.\n\n####HA####\nTo try out the high availability strategies provided by Sphinx, just push the same data into multiple indexes and list out each of the instances within the same 'agent'.\n\nLike this:\n```\nagent=127.0.0.1:9306|127.0.0.1:9307:test\n```\n\nAnd choose your [HA strategy](http://sphinxsearch.com/docs/current.html#conf-ha-strategy).\n\nLike this:\n```\nha_strategy = nodeads\n```\n\n\n###Start Searchd###\nThis Sphinx instance will be the middle-man, passing requests to all the searchds you've mapped out in the configuration. Save the configuration file somewhere and use it to start searchd. I'll name mine bsphinx.conf.\n\nFrom the directory where your configuration file lives, try this:\n```\n sudo searchd -c bsphinx.conf\n```\nNow, take a look at distributed search in action:\n```\nstefo@ubuntu:/var/www/html/QuickSphinx$ mysql -h0 -P9999\nWelcome to the MySQL monitor. Commands end with ; or \\g.\nYour MySQL connection id is 1\nServer version: 2.2.5-id64-release (r4825)\n\nCopyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.\n\nOracle is a registered trademark of Oracle Corporation and/or its\naffiliates. Other names may be trademarks of their respective\nowners.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nmysql> select * from dist;\n+------+\n| id |\n+------+\n| 1 |\n| 2 |\n| 3 |\n| 4 |\n+------+\n4 rows in set (0.30 sec)\n```\n1 and 2 are from the first Sphinx container, 3 and 4 are from the second. Just query the master. \n\nOne Sphinx to rule them all!\n","has_starred","hub_user","immutable_tags_settings",{"_72":11,"_73":74},"enabled","rules",[75],".*","is_automated","permissions",{"_79":17,"_80":11,"_81":11},"read","write","admin","user","storage_size",686486208,"orgData","recentTags",[88],{"_89":40,"_90":91,"_92":93,"_94":95,"_96":97,"_98":99,"_46":115,"_116":91,"_117":29,"_118":52,"_53":119,"_120":121,"_122":106,"_123":115,"_124":62,"_125":17},"content_type","creator",115662,"digest","sha256:07c20160f5784af21b18ce988c29c6a8579f6421d41894ce3916ed20814c8e88","full_size",143327084,"id",1440713,"images",[100],{"_101":102,"_92":93,"_103":104,"_105":106,"_107":108,"_109":110,"_111":104,"_112":-5,"_113":95,"_59":62,"_114":-5},"architecture","amd64","features","","last_pulled","2026-09-15T11:56:09.843192821Z","last_pushed","2019-03-28T20:43:31Z","os","linux","os_features","os_version","size","variant","2019-03-28T20:43:30.32789Z","last_updater","last_updater_username","media_type","latest","repository",422590,"tag_last_pulled","tag_last_pushed","tag_status","v2","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"routes/_layout.r.$namespace.$reponame.tags",{"_34":135,"_142":143,"_131":152,"_153":11},{"_36":136,"_38":137,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":138,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":65,"_66":67,"_68":11,"_69":29,"_70":139,"_76":17,"_77":141,"_82":29,"_83":84},[],[40],[52],{"_72":11,"_73":140},[75],{"_79":17,"_80":11,"_81":11},"tags",{"_144":60,"_145":-5,"_146":-5,"_147":148},"count","next","previous","results",[149],{"_89":40,"_90":91,"_92":93,"_94":95,"_96":97,"_98":150,"_46":115,"_116":91,"_117":29,"_118":52,"_53":119,"_120":121,"_122":106,"_123":115,"_124":62,"_125":17},[151],{"_101":102,"_92":93,"_103":104,"_105":106,"_107":108,"_109":110,"_111":104,"_112":-5,"_113":95,"_59":62,"_114":-5},[],"canDeleteTags","actionData","errors"]

yfix/sphinxsearch

Tags for yfix/sphinxsearch