I’ll introduce what I found when researching 「Shopify はデータベースに MySQL を採用している」 (“Shopify uses MySQL as their database”).
Background: Want to know about Shopify's database
When considering which DBMS to adopt for a web application that uses the Shopify API, I wondered 「Shopify はどの DBMS を採用しているのだろう？」 (“Which DBMS does Shopify use?”) and investigated.
Shopify Uses MySQL
The Shopify engineering blog states that they use MySQL.
- Official blog: How Shopify Manages Petabyte Scale MySQL Backup and Restore – Shopify Engineering
- PDF: ProxySQL at Shopify
MySQL Use Case
Shopify is also featured as a customer case study on the official MySQL website.
How to Export Shopify MySQL Data
It seems that external connections to Shopify’s MySQL are not possible in the first place.
- Shopify official community: SQL connection with Shopify - Shopify Community
- HEVO official blog: Shopify to MySQL: Steps to Load Data
Therefore, to migrate data stored in Shopify’s MySQL to your own MySQL, it seems you can only use one of the following methods:
- Export to CSV and import into your own MySQL
- Retrieve data via REST/GraphQL API and save to your own MySQL
That’s all from the Gemba, where I learned that while Shopify uses MySQL, you can’t connect to it externally, so it doesn’t really matter.