Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
K
kb
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 2
    • Issues 2
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Merge requests 0
    • Merge requests 0
  • Operations
    • Operations
    • Incidents
  • Analytics
    • Analytics
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Members
    • Members
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • granite
  • kb
  • Wiki
    • Data_stream
    • Ic
  • ic_lake_mysql

Last edited by songzp Aug 18, 2021
Page history
This is an old version of this page. You can view the most recent version or browse the history.

ic_lake_mysql

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

Clone repository
  • README
  • basic_guidelines
  • basic_guidelines
    • basic_guidelines
    • dev_guide
    • project_build
    • 开发流程
  • best_practice
  • best_practice
    • AlterTable
    • RDS
    • azkaban
    • create_table
    • design
    • elasticsearch
    • elasticsearch
      • ES运维
    • logstash
View All Pages