title1
爬虫结果同步到mysql库
更新量少的表直接入库
部署地址:192.168.109.45
project-collie-app/app_lake/data_pump/sync_online/ic_spider_update_lake.yml
更新量大的表写kafka队列然后入库
写kafka队列:
部署地址:192.168.109.45
project-collie-app/app_lake/data_pump/sync_online/ic_spider_update_lake.yml
project-collie-app/app_lake/data_pump/sync_online/ic_ar_update_lake.yml
supervisor配置:(31个进程)
/etc/supervisor/conf.d/ic_spider_sync_lake.conf
读kafka更新mysql并写redis:
部署地址:192.168.109.200
project-collie-app/app_lake/data_pump/ic_lake/collie_ic_spider_update_lake_kafka.yml
supervisor配置:(75个进程)
/etc/supervisor/collie/ic_spider_update_lake_kafka.conf
data_type | topic | group |
---|---|---|
ic_base | ic-spider-ic_base | ic_spider_base-7f25e12efd197862ba57ee1ac4957092 |
ic_branch | ic-spider-ic_branch | ic_spider_branch-0dd285a5745e367b426e0d39339e6320 |
ic_change | ic-spider-ic_change | ic_spider_change-9faa47b4eab8c0e72c7a01bcdcfd90f3 |
ic_employee | ic-spider-ic_employee | ic_spider_employee-ca5b26304c5f784f5c19967e708e2681 |
ic_history_name | ic-spider-ic_history_name | ic_spider_history_name-6bf263431bb684568ef885902343f186 |
ic_industry | ic-spider-ic_industry | ic_spider_industry-3e5fa1404295a2ef7e692866b23c28e4 |
ic_partner | ic-spider-ic_partner | ic_spider_partner-f5ece1f5cccbf44179b3b5f59f76c030 |
ar_base | ic-spider-ar_base | ic_spider_ar_base-7c60cedcf9e3712602c0fc9c78d20c07 |
ar_partner | ic-spider-ar_partner | ic_spider_ar_partner-12d5ce6dd15e7e966659ed386195e558 |
增量数据从mysql库中导出
增量数据根据update_time从mysql获取
部署地址:192.168.109.200
project-collie-app/app_lake/data_pump/lake/lake_ic.yml
supervisor配置:(26个进程)
/etc/supervisor/collie/lake.conf
增量数据读redis查mysql获取
部署地址:192168.109.200
project-collie-app/app_lake/data_pump/ic_lake/collie_ic_spider_update_lake_redis.yml
supervisor配置:(11个进程)
/etc/supervisor/collie/ic_spider_update_lake_redis.conf