My main use case for MySQL on Ubuntu is that I have used it most recently for building a WordPress web application in a stack, where MySQL operated as the back-end database for that WordPress.

A specific example of how I used MySQL on Ubuntu in that WordPress web application project is that I was collecting different RSVPs of people coming to an event, and the MySQL on Ubuntu database back end acted as the data store for that, recording the names of the people who were coming to the event and the time in which they RSVP'd, allowing me to figure out how many people were coming and analyze the data for certain age groups.

MySQL on Ubuntu has positively impacted my organization by enabling me to use a database that is very easy to use, quick to set up, and inexpensive; this database provides business value because every web application nowadays needs some type of database, so for those that require SQL databases, MySQL on Ubuntu is a great way to do it.

A specific outcome that shows the positive impact of using MySQL on Ubuntu is the time saved during setup. I have tried to create a Postgres database before, and while that is quite easy to do, MySQL on Ubuntu is quicker, being at least 20% quicker.

The best features MySQL on Ubuntu offers in my experience are that both MySQL and Ubuntu are very well-used products with massive user communities behind them, which is very useful when I am stuck, want to see documentation, or read about tutorials. MySQL on Ubuntu specifically is very simple to use and quick to set up, and I could easily get a database up and running in less than 10 minutes, which is brilliant for proof of concept scenarios.

Its popularity has created a massive ecosystem of different drivers and tools with support available everywhere. The resource usage of the underlying hardware is typically low, making Ubuntu's default MySQL on Ubuntu config very lean and ideal for smaller servers, which also helps with cost management.

The part that has helped me the most about MySQL on Ubuntu is that because it is such a popular setup, there is a lot of documentation out there, making it very easy to use, which is useful nowadays when software engineers, DevOps engineers, and cloud engineers have so many tools that they need to learn.

I would say that MySQL on Ubuntu can be improved particularly in its scaling capabilities. Scaling up is quite easy by simply increasing the RAM or CPU of the underlying machine, especially when running it on AWS or GCP; however, scaling out is much harder to do. Even though a master-slave setup can help maintain a real-time backup or offload queries, achieving true horizontal scaling with numerous nodes at once can be tricky with MySQL on Ubuntu.

Additionally, one limitation is MySQL on Ubuntu's involvement from Oracle, a for-profit organization, which raises some concerns about its future as an open-source project. MariaDB is an alternative that many people use, developed by the original MySQL developers, and it presents a viable option for those wanting MySQL on Ubuntu functionality while ensuring true open-source status.

I have been using MySQL on Ubuntu for around two years.

MySQL on Ubuntu is stable; both the MySQL component and the Ubuntu component are very stable, popular, and actively maintained.

MySQL on Ubuntu's scalability is highly dependent on the underlying infrastructure. When running on EC2 instances, for example, I can scale it from zero to 10,000 machines or even higher.

The customer support I have experienced is excellent. I used AWS support, and they are very quick to respond. I also find support available from sources such as Stack Overflow, Reddit, and the documentation because MySQL on Ubuntu is such a common use case.

Positive

Before using MySQL on Ubuntu, I previously used Postgres on Ubuntu. The switch was due to a business requirement, and while Postgres was good, MySQL on Ubuntu was quicker to get up and running, though I feel Postgres might handle more complex data better.

The initial setup process requires building an EC2 instance and then installing MySQL on Ubuntu on it after choosing the operating system, which I selected as Ubuntu.

I did not purchase MySQL on Ubuntu through the AWS Marketplace. I purchased it by building an EC2 instance and then installing MySQL on Ubuntu on it after choosing the operating system, which I selected as Ubuntu.

I have indeed seen a return on investment, particularly in time saved, as using MySQL on Ubuntu has proven to be 15 to 20% quicker than building a Postgres database.

Regarding pricing, setup cost, and licensing, I do not remember the exact price, but I believe Ubuntu is open source, so I can assume that was free. As for MySQL on Ubuntu, I feel that was free as well or very low cost, but the actual machine running it generates the cost. Since MySQL on Ubuntu is quite lean, it results in low operational costs, making it favorable from a pricing perspective.

Before choosing MySQL on Ubuntu, I did not evaluate other options; it came as a requirement.

My advice to others looking into using MySQL on Ubuntu is to go for it; it is a very common way to utilize databases and operating systems together. I would rate this review a 9 out of 10.

Positive

Our main use case for MySQL on Ubuntu is for workforce analytics, where we have US data for Employbridge and Bluecrew, storing the candidate's historical data used for machine learning purposes.

MySQL on Ubuntu works as a data warehouse for us, where we store this historical data that comes in the form of APIs. Then with the help of ETL, we transform it, and SQL acts as a data warehouse for us where we store the finalized data.

That is the only use case that we are currently using MySQL on Ubuntu for.

With MySQL on Ubuntu, we have much more capability of handling it in terms of specifications, and it helps us in reducing costs because MySQL on a cloud platform was costing us much. Using MySQL installation on Ubuntu has helped us save costs, improve our reliability, and maintain data privacy regarding personally identifiable information data.

Since our EC2 instance is deployed in a virtual private network with MySQL on Ubuntu installed, it is protected from unauthorized access and use, and we have also encrypted the data in MySQL. With the functions that MySQL on Ubuntu provides, we have much more capabilities in terms of manipulating the data and producing results that are useful for business purposes.

MySQL on Ubuntu has positively impacted our organization as a trusted data platform for many years across enterprises. We are following the same pattern here, and with the capabilities MySQL on Ubuntu provides and the fine tuning and optimization that the platform offers, along with Ubuntu, we have much more capabilities for fast processing of data. The way it handles MySQL and binary has helped us scale our data platform, achieving high availability and great performance with the analytics we perform.

I am not sure how MySQL on Ubuntu can be improved at the moment because we have not specified any anomalies regarding its integration with Ubuntu. Over the years, MySQL has improved and introduced new functions, so I hope that MySQL on Ubuntu can optimize its internal operations further.

In terms of user experience, MySQL on Ubuntu integrates easily with available IDEs such as JetBrains, Visual Studio Code, and DBeaver, so it works perfectly. The documentation is also good, and there is no issue with integration.

I have been using MySQL on Ubuntu since the last one or two years.

MySQL on Ubuntu is stable.

MySQL on Ubuntu's scalability is pretty good.

The customer support for MySQL on Ubuntu is fairly good, and we have a monthly meeting with them. There have not been any issues.

Positive

Before choosing MySQL on Ubuntu, we evaluated Microsoft SQL Server because of the data this organization had. Previously, the organization was using Microsoft SQL Server before acquiring this company, but because of the integration it required and its older syntax, it did not meet our needs. With new age developers coming in, MySQL on Ubuntu was the most preferred choice.

We originally started with MySQL on Ubuntu. Before developing the application, we created the architecture and looked for multiple options, ultimately choosing MySQL on Ubuntu to go with it.

We have a high-performance EC2 instance, and by installing MySQL on Ubuntu, we achieve high performance in terms of executions. Thanks to the optimization functions and internal functionalities of MySQL on Ubuntu, we maintain constant CPU metrics within the desired range. In terms of analytics speed, we achieve expected results, with significantly reduced downtime due to this scalability and improved processing speed.

We have integrated S3 as a data storage layer with MySQL on Ubuntu, so instead of storing data on a local disk, we use S3, which has fairly reduced our data storage cost. Time is also saved because we are using S3 Express, leading to good performance speeds.

MySQL on Ubuntu is a great platform to deploy your data. It integrates well with services for ETL, analytics, or even machine learning platforms. I would urge everyone to use MySQL on Ubuntu, especially when using AWS, as it provides an additional layer of VPC to achieve high scalability and availability.

I rate MySQL on Ubuntu a nine out of ten because it has been a good tool for us to integrate with our analytic services. The functions it provides, along with integration with our services and cloud services, have worked perfectly for us. We have not encountered a single downtime, and creating a cluster within our VPC has added a layer of data security and effective handling of encryption.

I have used MySQL on Ubuntu over the years, and I am currently working with some Docker products, but most of my experience with Docker is over Windows, not Linux.

Currently, I am not using MySQL on Ubuntu, but in the past, I have worked as a software developer and software architect, typically using it for end-user applications that manage data for the end-users, more in a back-office capacity. I have deployed MySQL on Ubuntu projects using the free version MariaDB, which is basically the same engine for the database.

MySQL on Ubuntu offers very good performance, it is secure, and it is easy to use.

MySQL on Ubuntu helps with data management processes primarily because it is easy to query the data and easy to connect from external or third-party software, such as Excel or Power BI, given some security configurations. It has very good performance, is easy to use, and provides secure methods to handle data.

I believe there could be improvements for MySQL on Ubuntu, particularly with AI integration in scripting tools such as GitHub Copilot, which provides examples and solutions for errors encountered during development.

Overall, I would give MySQL on Ubuntu a nine out of ten because, despite some issues such as security concerns when changing passwords which compromised the database, it remains a very good database engine.

My experience with MySQL on Ubuntu is around three to four years.

Unfortunately, the backups on Ubuntu have not been particularly beneficial because the system was always up, but once while conducting tests, the backup of the database helped me.

I have not utilized replication and clustering capabilities with MySQL on Ubuntu.

While I have not dealt with support, there is a lot of documentation available for MySQL on Ubuntu, and GitHub Copilot provides substantial information that helps when encountering errors.

Setting up MySQL on Ubuntu was pretty easy, as it involved generating scripts from the tables and creating a backup in plain text.

I have not managed too much with the transactional support features of MySQL on Ubuntu, as I have focused more on design and data management rather than optimizing transactions, since I typically use those databases for small companies that do not require optimizing.

I deal more with design than data management, but I have also done some data management work there.

I have managed backups with MySQL on Ubuntu, but I have not handled recovery; it could be generated as a plain text file or encrypted files for more security.

I have only used basic security resources such as user and password with MySQL on Ubuntu, but I know that there are options to set up certificates for a more secure connection.

I would rate this product nine out of ten overall.

I used MySQL on Ubuntu for temporary storage of financial data utilized for analysis of creditworthiness as the main use case, as I had some streaming services that pulled in data from Equifax.

It helped streamline my data management processes because I needed somewhere to store the data rather than just an array in memory. I needed to have the data to have the record because at some points I have to go back to determine what was the basis of this credit assessment. The data was there and could recreate the calculation once the data was called, and the data was called timestamped, secure, and always available, which is the whole point of MySQL on Ubuntu. Otherwise, if I used an array, it would only be there for the life of the system being up; there would not be a necessity of saving any of the data that was just in a temporary array. By putting it in MySQL on Ubuntu, even if the node went down, the database would come back up.

Integration is always important regarding operating systems and these types of products, so being able to integrate and export or import from JSON structures is very critical. Sometimes that is a little complicated because of the sometimes hierarchical nature of JSON or XML data formats, which do not always match to how you can structure MySQL on Ubuntu as a third normal form. There are those sorts of things that sometimes get inexperienced people; it does not seem to make sense.

For denormalization, if you are trying to analyze it only, there is probably a shortcut that I have seen in some tools that once you define the third normal form type of data, it kind of automatically comes up with a way of analyzing it, turning it into an automated pivot table without you having to design the pivot table. Those things would be good to get the analysis.

Some of the analysis that I had to code from scratch in Python were really simple binomial algorithmic comparisons. Some of that could turn into AI functions. Instead of coding it directly, I could use normal language saying I want to analyze this data based on whether this company has good financial viability to extend a million dollars of credit for buying fuel around the world or whatever the parameter is. That is what I can see coming in the future, that somebody that does not know how to code or does not really want to spend the time coding could actually ask in natural language AI to come up with that. To some extent, I have done that more recently with ChatGPT anyway to come up with a piece of code that at the moment does not work perfectly, but it is still Python and gives me the basic framework to then make it work elegantly.

I dealt with MySQL on Ubuntu for about two years.

I assess the transactional support features of MySQL on Ubuntu as just very simple insert and read because there was only really one stream that inserted data, so there was not any multi-concurrency of entering records to the database. The multi-concurrent users were just accessing and running the algorithm in the nodes to actually get an evaluation. Basically, they called a thing, they said I wanted to give some credit to company A. The node would do a query to Equifax and Experian to get whatever they could get on that and some Dun & Bradstreet information as well, put that in the Ubuntu SQL database, MySQL on Ubuntu database, and then run another algorithm to determine based on a couple of statistical points of view whether to give them this credit or whether they have to prepay for anything.

Regarding MySQL on Ubuntu scalability, I never touched it in terms of scalability because we were not looking at terabytes of data; we were looking at gigabytes of data. I think the database hardly went above one gigabyte when I was there because it is very simple. It just says here is the name of the company and here is anything we have got from three of the main credit or fact information sources globally that might have information on that database. Then a quick search in a virtual web environment to see whether there was any more generic business information on those companies, such as whether director A has just been fired or director B has been in jail for fraud or something, to get a little sentiment analysis of all these other things. The total data was very little.

The initial setup was very straightforward because I have a lot of experience in various database technologies and in Python and creating servers in virtual servers in AWS.

MySQL on Ubuntu is very simple, easy, and quick to use for people with database expertise. For that light use of MySQL on Ubuntu, that was all I needed, so there was nothing that was inadequate, and I could easily access it. The node was fine and the accessibility for people around the world that were actually asking whether they could give credit to this company or whether they have to pay up front was the main thing that was being supported, so everything was fine. There were no limitations there because the data volume was fairly small; globally, they only probably looked at about a thousand different entities per month and so there was only about another thousand records each month added, and the analysis done to give a pretty much real-time determination of whether to extend credit or request prepayment.

AWS was basically my main cloud provider with this. The low cost is what I liked about using MySQL on Ubuntu because basically, I did not have much of a budget for the solution, just my time and a few units of AWS services to work on, because it had to be more than just something on my own PC in the office, so other people could access it, allowing me to actually create a front end as well with it. It is very lightweight regarding the pricing; I never got any issues and was within my department budget for all AWS services for development. We never actually got a production budget for it because things were changing and then COVID hit as well, so it slowed down the demand. I am not quite sure what they did with that solution after that company, but I know they were using it. I still sometimes get an error message that somehow gets into my current AWS account.

I just utilized the standard virtual high availability options on Ubuntu, so I had redundant nodes in two regions. I dealt with MySQL on Ubuntu a little bit, but we never really got the Docker setup completed; I had some experience working with it. I have still maintained some Redshift analysis and some code in Python on some AWS products in the last twelve months. I am not working day-to-day anymore in that area with the Amazon solutions by chance. I deal with a little Amazon Linux and maybe Elastic Disaster Recovery, but not in detail, so I am probably not really the best candidate at the moment. I rate MySQL on Ubuntu a ten out of ten.

We are using MySQL on Ubuntu to store our transactions, which, because we are a trading firm, are usually the buy and sell trades that we make. We use this more as a relational database.

The primary aspect of MySQL on Ubuntu that I appreciate is that it is extremely reliable among the RDBMS that I have used. Another important quality is that it extends with volume very well. Most RDBMS don't scale very well, but this one scales very well and has been very reliable and highly available. The performance of MySQL is supposed to be very good, which is another aspect I really appreciate.

MySQL on Ubuntu supports what is known as the ACID properties, which are atomicity, consistency, isolation, and durability. This supports my use cases very well because without having all of them together, it's tough to ensure the reliability and integrity of the system. Transaction management ensures that we can figure out the best way to leverage the database.

The security of AWS is set at a very high standard, and we do a good job of ensuring that we leverage the base security that comes with the cloud platform. It is a joint responsibility between the cloud platform provider and the tenant, which is us. We harden our platform very well and, on top of that, MySQL on Ubuntu provides clear permissioning and separation of concerns, allowing us to provide permissions only to the right set of people. There is very clear segregation of duties, and only the people who need access are given access. It supports encryption, enhancing our security posture. Security is one of the big concerns that MySQL on Ubuntu has lived up to for our use cases.

I have not seen too much of a response in terms of issues. Sometimes, if the indexing is not done very well, I have noticed slowness, but largely, it has performed pretty well. The only area where I would say I have seen potential for improvement is occasional slowness, but I cannot really attribute it to the product; it could also be the design of the database and the queries. I have not encountered any other significant challenges.

The slowness that occurs at times has not yet been established whether it is due to the design of the database, the queries, or the underlying software itself. I cannot comment on that right now.

We have been using MySQL on Ubuntu for about a year and a half now.

We have not used too much replication, but clustering is useful because that helps with high availability and scalability. Clustering definitely helps.

MySQL on Ubuntu stands out among its competitors because, after evaluating some of them, I figured out that this is the one I would be interested in using for our solutions. While we have used MS SQL in the past, AWS supports MySQL on Ubuntu very well, which has worked excellently for us.

Backup and recovery are absolutely essential; without that, it would be very tough to rely on the software, as the software will not perform if suddenly there is some kind of an outage. We definitely require the recovery mechanism and backup mechanism to be able to go back to the data. That gives us the confidence that we can run our critical applications. Mission-critical applications can be run on these platforms because they provide both backup solutions and recovery solutions.

The pricing of MySQL on Ubuntu is fairly plausible for what I am getting, especially when I compare it with everything else that I see. It becomes attractive if I can use some of the free tiers of AWS.

The deployment and management have improved significantly; previously, it would have been tough because many configurations needed to be taken care of. However, now, with just a few lines of code, we can deploy and manage it much more easily. Overall, I rate this review an eight out of ten.

Neutral