MySQL Primary Use Case

Patryk Golabek
CTO/ Software Architect at Translucent Computing Inc
We use multiple models here because we do full development. What we deploy on MySQL is from the Helm chart or it's a Dockerized deployment of MySQL. So we're using the Helm stable chart right now. That's sort of the easiest way to deploy it - to say just one command and it bootstraps your whole database within your classical means or cluster. You can do it locally with mini-crews or developers, for organizational use, or Kubernetes. It's single-node Kubernetes. Also, you can just deploy MySQL locally with a Helm chart. Regarding production, we have a kind of automated process which is similar to what Spinnaker deploys, with a Helm chart as well as within the cluster. Some other solutions we don't run within the cluster, we use the Cloud version of the database which is Cloud SQL, Google Cloud, and AWS. Those are fully managed ones, of which there are two versions. We have our self-managed version which we run locally and with our DEV cluster and then there is production, as well. We also use a self-managed version since every cloud provider offers MySQL, even AWS. It depends on the client's needs, how flexible the client is, and also how comfortable they are with MySQL. We either go with our managed version or the Cloud version. Both are supported because today the Mica server that's actually accessing the database or the piece of software just needs a connection string, it doesn't care if it's running within the Synchronous Cloud. If it's running somewhere else in the Cloud, it's still a private connection on the same network. So the only differences here are in terms of money costs and whether it's managed or not managed. So for local development, you don't want to have a managed database in the Cloud. You don't need to be tethered to the Cloud, you'd rather just deploy locally. And because we have the same deployment scripts that run locally in DEV and testing, we use the same Helm chart and the same Docker version with MySQL to distribute that through our DEV environment to test the bills and run the test and there is a full QA environment for teaching, as well. View full review »
reviewer1246170
Application Development Analyst at a tech services company with 10,001+ employees
We sell MySQL to customers who need to build second tier applications, not their core application. For some of our customers, when they are planning to build their second tier application, they will choose MySQL rather than Oracle which is more expensive. View full review »
LeonMofor
Ingénieur Etude et Développement / Technical Lead Java at ATOS
MYSQL is our main database. We use it for every project. I use it for storage procedures, SQL administration, and database administration. We also use it for the development of reports, and projects that are deployed for our customers. It is also used to develop applications. The majority of companies use it for their development projects. View full review »
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
442,764 professionals have used our research since 2012.
reviewer1252344
COO at a tech vendor with 1-10 employees
The primary use case is as a reporting solution, data collection, data manipulation, and similar tasks. We install MySQL on Linux and Windows machines for testing our enterprise application. We are a solution provider and this product is part of our offering to our clients. View full review »
reviewer830019
CCO at a construction company with 11-50 employees
We primarily use the solution for the many small applications we use. However, we do not use it with our enterprise-level applications. View full review »
Grégory Tabourin
Infrastructure Platform Engineer at a cloud provider with 51-200 employees
We are an IT services provider, so the solution is for our customers. I can't answer for the customers in terms of how they use it. Typically, customers are running applications that need to connect MySQL and to store some of the data. View full review »
ctsanders
Partner at a tech services company with 51-200 employees
We utilize the DB as a data-repository solution for our front-end applications. The solution gives us the ability to run numerous instances on various geographical cloud servers. View full review »
reviewer1139685
Business Intelligence Manager at a translation and localization position with 501-1,000 employees
I'm not involved from the database side as much. I primarily use it for reviewing the data structure as the architecture before I build a data model in our BI tools. General querying is pretty much what I do, and also analyzing data types and data structures within the database itself. I review the data structure within them. And I use that to build the data model, which we have in our reporting environment. That's primarily all I use it for. View full review »
Haitham Elwany
IT Infrastructure & Data Platform Sr. Manager at a financial services firm with 1,001-5,000 employees
I am a senior manager of the infrastructure team and MySQL is one of the products that I work with. We use it in an e-commerce portal. The database is light and everything works smoothly. View full review »
reviewer1301145
CEO at a computer software company with 11-50 employees
The main reason that customers pick MySQL is that it's cost-efficient. View full review »
reviewer1399998
Deputy Manager at a university with 1,001-5,000 employees
I use MySQL to teach students about databases. They implement projects using this product. View full review »
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
442,764 professionals have used our research since 2012.