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

ic_lake_mysql · Changes

Page history
update: 工商mysql库数据处理流程 authored Aug 18, 2021 by 宋志鹏's avatar 宋志鹏
Hide whitespace changes
Inline Side-by-side
Showing with 26 additions and 1 deletion
+26 -1
  • data_stream/ic/ic_lake_mysql.md data_stream/ic/ic_lake_mysql.md +26 -1
  • No files found.
data_stream/ic/ic_lake_mysql.md
View page @ 2aa155eb
...@@ -33,13 +33,26 @@ project-collie-app/app_lake/data_pump/sync_online/ic_spider_update_lake.yml ...@@ -33,13 +33,26 @@ project-collie-app/app_lake/data_pump/sync_online/ic_spider_update_lake.yml
## 更新量大的表写kafka队列然后入库 ## 更新量大的表写kafka队列然后入库
写kafka队列: 写kafka队列:
部署地址:192.168.109.45 部署地址: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_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: 读kafka更新mysql并写redis:
部署地址:192.168.109.200 部署地址:192.168.109.200
project-collie-app/app_lake/data_pump/ic_lake/collie_ic_spider_update_lake_kafka.yml 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 | | data_type | topic | group |
| ------ | ------ | ------ | | ------ | ------ | ------ |
...@@ -59,8 +72,20 @@ project-collie-app/app_lake/data_pump/ic_lake/collie_ic_spider_update_lake_kafka ...@@ -59,8 +72,20 @@ project-collie-app/app_lake/data_pump/ic_lake/collie_ic_spider_update_lake_kafka
## 增量数据根据update_time从mysql获取 ## 增量数据根据update_time从mysql获取
部署地址:192.168.109.200 部署地址:192.168.109.200
project-collie-app/app_lake/data_pump/lake/lake_ic.yml project-collie-app/app_lake/data_pump/lake/lake_ic.yml
supervisor配置:(26个进程)
/etc/supervisor/collie/lake.conf
## 增量数据读redis查mysql获取 ## 增量数据读redis查mysql获取
部署地址:192168.109.200 部署地址:192168.109.200
project-collie-app/app_lake/data_pump/ic_lake/collie_ic_spider_update_lake_redis.yml
\ No newline at end of file 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