【基础架构】solr搜索服务

kimmykuang commented 8 years ago

1.搭建solr服务 2.确定索引数据（基本：商品数据）字段 3.将mobile端关键字搜索从DB Like查询替换为solr查询 4.建立数据索引规则（新增/更新商品时触发增量索引 - 消息队列实现异步处理，定时脚本进行全量数据索引） 5.记录每一次搜索query（借助queue实现，redis=>mongodb） 6.实现搜索自动提示功能（暂定从t_brand&t_goods_class中做solr前缀匹配） 7.TODO

kimmykuang commented 8 years ago

索引字段：一、商品搜索

t_goods表： 1.goods_id (SKU) 2.goods_commonid 3.goods_name 4.goods_jingle 5.goods_price 6.goods_promotion_price 7.gc_id 8.have_gift 9.goods_promotion_type 10.brand_id 11.goods_verify 12.goods_state

t_goods_common表： 1.gc_name 2.brand_name 3.goods_attr 4.goods_body 5.mobile_body 6.goods_lock

kimmykuang commented 8 years ago

mobile端搜索请求返回格式： { "code": 200, "hasmore": false, "page_total": 1, "datas": { "goods_list": [ { "goods_id": "100000", "goods_name": "小米红米 3S 全网通 2GB内存 16GB ROM 经典金色移动联通电信4G手机双卡双待", "goods_jingle": "红米手机，上亿人次的选择！指纹识别，待机长/金属机身，不可思议的蜕变！", "goods_price": "699.00", "goods_promotion_price": "699.00", "goods_promotion_type": "0", "goods_marketprice": "699.00", "goods_image": "1_05220795046798202.jpg", "goods_salenum": "3", "evaluation_good_star": "5", "evaluation_count": "0", "is_virtual": "0", "is_presell": "0", "is_fcode": "0", "have_gift": "0", "store_name": "碧优丽丝", "is_own_shop": "1", "group_flag": false, "xianshi_flag": false, "goods_image_url": "/data/upload/shop/store/goods/1/1_05220795046798202_360.jpg" } ] } }

PHPStick / beaulys

【基础架构】solr搜索服务 #28