I was reading Grokking for Twitter system design and for sharding it mentioned, one way to shard is by creation time for tweets. The advantage to that approach being we can fetch tweets quickly since they will all be in one server. I am wondering how do they actually shard it by creation time? Is it by each day, since timestamps are different for each tweet. Or is a range of day time considered for sharding and storing in a particular dB server?
Any inputs to understand this better would be helpful. Thank you!
#tech #systemdesign
Want to see the real deal?
More inside scoop? View in App
More inside scoop? View in App
blind
SUPPORT
FOLLOW US
DOWNLOAD THE APP:
FOLLOWING
Industries
Job Groups
- Software Engineering
- Product Management
- Information Technology
- Data Science & Analytics
- Management Consulting
- Hardware Engineering
- Design
- Sales
- Security
- Investment Banking & Sell Side
- Marketing
- Private Equity & Buy Side
- Corporate Finance
- Supply Chain
- Business Development
- Human Resources
- Operations
- Legal
- Admin
- Customer Service
- Communications
Return to Office
Work From Home
COVID-19
Layoffs
Investments & Money
Work Visa
Housing
Referrals
Job Openings
Startups
Office Life
Mental Health
HR Issues
Blockchain & Crypto
Fitness & Nutrition
Travel
Health Care & Insurance
Tax
Hobbies & Entertainment
Working Parents
Food & Dining
IPO
Side Jobs
Show more
SUPPORT
FOLLOW US
DOWNLOAD THE APP:
comments
E.g. what to do with last year shard db? Or 10 years old db
See https://youtu.be/gvdXBC-NReQ