# which is best snowflake or My sql

?

##### Post Metadata
- Posted at: over 6 years ago
- Author title: Assistant Manager
- Net upvotes: 1


## Comments
### Comment 1

I would prefer Snowflake over MySQL because Snowflake you can scale up and scale down your compute automatically to accommodate volume. Snowflake also makes the use of Index irrelevant as all the data is stored in a proprietary Snowflake format with the Metadata Layer controlling the route to the data.

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: Solutions & Deployment Architect



### Comment 2

Depends on your needs.  MySQL is open source/free.   It or Postgres (another open source db) is good for pretty much any normal need.   You can install on your own equipment.

Snowflake is a “designed from the ground up to be a cloud data warehouse” service.   There is no version you can install.   From an enterprise view, it’s quite inexpensive compared to Teradata or any similar MPP database they are running in their data centers.   But it’s not free and open source.

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: Director Of Analytics at Trianz




## Related Product
[Snowflake](https://www.g2.com/products/snowflake/reviews)

## Related Category
[Data Warehouse](https://www.g2.com/categories/data-warehouse)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: almost 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: almost 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: almost 13 years ago
  - Comments: 4