MySQL on Ubuntu 24.04 LTS

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