Search
Ask A Question
In Process
Avatar
0
Nguyễn Thái Sơn Professional
Asked: 1670114138000 In: Java
Nguyễn Thái Sơn Professional Asked: 1670114138000 In: Java
thiết kế hệ thống trăm triệu user
Anh Dũng ơi, theo anh, khi đã xác định hệ thống này có nhiều user, mình phải để ý những vấn đề gì ạ, có phải là hiện có 100 user nếu sau này có 1 tỷ user phải scale như thế nào, cần thiết kế DB ra sao
  • 1 Answers
  • 129 Views
  • Answer
Remain: 5
1 Answer
Avatar
tvd12 Professional
Added an answer at: 1670130563000
tvd12 Professional
Added an answer at: 1670130563000
Anh nghĩ là có một số việc cần làm đó là:

  • Thiết kế bảng sao cho đơn giản gọn nhẹ, vừa đủ các trường và các index cần dùng
  • Nếu user lên quá nhiều và DB lúc đó không thể đáp ứng thì sẽ phân bổ dữ liệu vào các db khác nhau.
  • Sử dụng các hệ thống phụ trợ để giảm tải việc truy vấn vào db chính, ví dụ tạo db replica, hay các hệ thống trích xuất báo cáo riêng, cái này sẽ do đội Data Engineer làm sẽ tốt hơn.
  • 0
  • Reply
Ask A Question
  • Questions 963
  • Answers 2.0K
  • Best Answers 120
  • Users 422

Related Questions

Recent Activities

Show All Activities

Top Members

Trending Tags

ssl debug php laravel react-native qr stresstest thiết kế tầng trong dự án controllerservice serialization wordpress xss programming-language facebook vietqr network room database restful map video call tcp webrtc câu hỏi excel-object-mapper vuejs jquery đồ án tốt nghiệp lỗi font oracle postman cron elasticsearch di ioc format json get file zip zip file resttemplate design patterns architecture scheduled spring boot datetime #formatdate paginaiton microservices communication multi-threading synchronize otp message send mail ssl email send email jsonproperty join json to object scheduled solution spring websocket cors refactor export compliance config-css spring websocket stream api webflux mobile push-noti jenkins repository replica jotform refresh token access token maria db junit-test gorilla procedure filter exception null exception handler upload resilence4j bucket4j readmoretextview regex email qrcode list .net .net oop partition oop c# .net executor threadpool mq message queue app background h2 database gallery deadlock transaction monitoring main jsp servlet tomcat node.js watermark pdf excel profile properties image authentication plugin udp access app project management estimation database migration migration crawl data graduation thesis utf-8 file validate date connection pool thread pool concurrent convert date to number load balancer nginx synchronized lock graphql stress test test json file networking handy terminal study computer science webassembly assembly nan cookie session mail template mail cosmos-sdk push notification socket server round robin jetbrains validate btree glide floating point artificial intelligence ai private_key duration hyperloglog gateway dns exception handle transfer deploy contract uniswap s3 web ezymq-kafka ezyredis soap transfer git mongo integration-test branch boot-nodes springwebflux mysql index lưu trữ dữ liệu lớn spring-boot-test macos apache poi guide keycloak queue multiple tenant spring security extensions pancakeswap structure trong spring boot postgresql totp n cloud reliability python golang bash script messaging reactive roadmap anti-flooding cosmos jvm abstract class interface log4j non-blocking io career path singleton web3 client zookeeper soft delete centos ansible binding tracking location socket optimize resource eclip naming convention naming game-room game-server log4j-core jsp & servlet java core system environment variables load-balancing pgpool datasource spring data jpa schedule thread rest grapql asyncawait multithread math vector hibernateconfig javaw sjis shift jis stream blog java spring nodejs hibernate ipfs issue build bundle vue cli vue webpack fulltextsearch view sql css html dex decentralized exchange ethereum login javascript keep promise https nft game login thymeleaf erc721 contract erc20 web3 smart contract ropssten ropsten metamask windows 11 bitcoin eth ethereum flutter isolate backend nestjs java web springsecurity machine learning backend spring aop winforms deep learning model spring redis request pre nio io batch unit test slack log indexing sql server devops cors big project work frontend api cache draw.io content-disposition reactjs download datastructure javacore distraction programing callback async promise threadjava unity orm rust pointer panic merge commit .net core js kerberos security go netcore sosanh rabbitmq grpc ezyhttp python unicode front-end fe docker buffered server exyfox career spring-jpa jpa du học job bean spring reactjs fullstack c# kotlin sse websocket mysql springboot rxjava future push message android recyclerview android cast intellij maven netty multithreading msgpack json design-pattern library spring boot redis hazelcast atomicboolean volatile storage it git caching chat game nft blockchain freetank game-box jwt microservice search kafka get upload file download http opensource cloud languague programming database pagination editor stackask question ezyfox-boot ezyfox-server ezyfox phỏng vấn java ezyfoxserver