create mysql database automatically
Hello, i was wondering what is the best way of creating a mysql database automatically. Heard https://www.terraform.io/ may be a good option but it seems like its for larger projects and i don't really expect to have a large amount of data to begin with. Is there a better alternative or should i just go ahead and start learning Terraform
Terraform by HashiCorp
Terraform by HashiCorp
Terraform is an open-source infrastructure as code software tool that enables you to safely and predictably create, change, and improve infrastructure.
6 Replies
What’s the use case?
“Automatically creating a database” is a very loaded concept
My goal is to create something like https://www.tebex.io/ where people can create there own website and i help handle there payments. To do this i planned on having a mysql database for each store so it can store payment information and things like that. The reason im not wanting it to be in 1 mysql database is because that if that database would get leaked then everyone payment information would be leaked instead of just that stores payment information.
Tebex
Monetize Your Game Server - Tebex
Fund your game server costs with Tebex. The leading payment plugin for Minecraft, Rust, ARK, GTA V and more.
You definitely don’t want to manage thousands of isolated databases unless you’re a database engineer
You’re actually increasing the likelihood of leaks and other issues if you increase the overhead that much
So i just should have it all in 1 database?
or just a few databases and not a database per?
1 DB, maybe one prefixed table per customer Wordpress style
Alright thanks that makes more sense i was under the impression having it in multiple databases would be more secure and more scalable. Thanks again though ❤️