# A Massively Multi-user Datastore, Synced with Mobile Clients

DevFeed: [A Massively Multi-user Datastore, Synced with Mobile Clients](<https://devfeed.tech/articles/a-massively-multi-user-datastore-synced-with-mobile-clients-15470.md>)

Original publisher: [Read original article](<https://developer.squareup.com/blog/a-massively-multi-user-datastore-synced-with-mobile-clients>)

Author: Tad Book

Published: 2018-04-12T17:13:25Z

Content type: article

Language: en

Sources: [Square Corner Blog RSS Feed](<https://devfeed.tech/sources/square-corner-blog-rss-feed.md>)

Topics: [data](<https://devfeed.tech/topics/data.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Mobile](<https://devfeed.tech/topics/mobile.md>), [API](<https://devfeed.tech/topics/api.md>), [ui](<https://devfeed.tech/topics/ui.md>), [Development](<https://devfeed.tech/topics/development.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [apis](<https://devfeed.tech/tags/apis.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [development](<https://devfeed.tech/tags/development.md>), [migration](<https://devfeed.tech/tags/migration.md>), [mobile](<https://devfeed.tech/tags/mobile.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [ui](<https://devfeed.tech/tags/ui.md>)

## AI overview

Square describes how it re-architected its merchant catalog datastore for large, structured catalogs synchronized with mobile clients, including clients that may remain offline and diverge. The system uses an entity-attribute-value model and an append-only data model on sharded MySQL to support per-user consistency, flexible schemas, querying, and bulk API operations.

## Source excerpt

At Square, we manage large amounts of information for our merchants. This includes the data surrounding what a merchant sells -- their...