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.

• MySQL :: MySQL Customers: Shopify

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.