Amazon’s Relational Database Service is based on MySQL under the hood. So many colleagues and clients ask me – should I go with RDS or MySQL? As with every technology question, the answer is – it depends.

In this article, we are going to discuss 10 use cases of RDS or MySQL. Let’s get started below.

Ten Use Cases of RDS or MySQL

Here are some scenarios to help you decide:

1. I’m Replicating into Amazon from A Physical Datacenter

A: This setup is common if you’re using Amazon’s VPC or Virtual Private Cloud. With a router dropped into your datacenter, VPC allows you to extend and spinup virtual instances from Amazon as if they’re sitting in your own existing datacenter.

Great stuff, but you won’t be able to replicate from your existing master MySQL instance to cloud Amazon RDS instances. To do that, roll your own with MySQL 5.5 or Percona 5.5.  RDS can …

I’ve been getting more than my fair share of calls from recruiters of late. Even in this depressed economic climate where jobs are rarer than a cab at rush hour, it’s heartening to know that tech engineers are in great demand. And it’s even more heartening to think that the demand for MySQL DBAs has never been better.

In this article, I’m going to discuss the mythical MySQL DBA, the reason why MySQL DBA and target.com keep crashing and much more. So, let’s get started!

Why Target Keeps Crashing

My reckoning was confirmed by a Bloomberg news report about stalwart retailers suffering from a dearth of talented engineers. Bloomberg cited Target’s outage-prone e-commerce site as a symptom of, among other things the market’s shortage.

One of the challenges old-timers …

Continuing from our Top MySQL DBA interview questions (Part 1) here are five more questions that test a MySQL DBA’s knowledge, with two that will help suss out some personality traits.

6. Disk I/O

Disk performance should be an ever-present concern to a DBA. So, although they don’t need to be a storage specialist, they should have a working knowledge. Ask them about RAID versions, mirroring versus striping, and so forth. Mirroring combines two disks as a unit. Every write is duplicated on both disks.

If you lose one disk, you have an immediate copy. Like a tandem truck that has spare tires running in parallel. Lose one, and you don’t have to pull over immediately to replace it. Striping spreads I/O over multiple disks so you on the one hand increase throughput linearly as you add disks.

Introduction MySQL HeatWave Lakehouse brings the power and speed and convenience of MySQL HeatWave to querying data in object storage. In our first blog post in the HeatWave Lakehouse series presented an overview of the new capabilities of HeatWave Lakehouse and how it extends the MySQL HeatWave portfolio by allowing users to process and query […]

Setting up replication in MySQL is something we need to do quite often. Slaves die, replication fails, or tables and data get out of sync. Whenever we build a slave, we must start with a snapshot of all the data from the master database.

MySQLdump is the tried-and-true method of doing this, however it requires that we lock all the tables in the database. If we’re dumping a large database, this could be a significant period, where no writing can happen to our database for the duration of the backup. For many environments read-only is still an outage.

How to Create a Slave Using Xtrabackup

Enter hotbackups to the rescue. Percona comes with a tool that allows you to perform hotbackups of a running MySQL database, with no blocking. It’s able to do this because of Innodb & multi-version concurrency control (MVCC). Luckily we don’t need to dig into the guts to enjoy the benefits of this great technology.

Here’s …

This article is from 2006. MySQL has come a long way since then. MySQL 5.5 is very robust and feature-rich, matching Oracle in many different areas including datatypes, stored procedures and functions, high availability solutions, ACID compliance and MVCC, hotbackups, cold backups and dumps, full text, and other index options, materialized views and much more.  Here’s a high level mysql feature guide.

What really separates the two technologies is culture. MySQL, rooted in the open-source tradition is much more do-it-yourself, leaning towards roll-your-own solutions in many cases. Meanwhile, Oracle provides named and proven paths to solve specific problems.

You might also check out:  …

MySQL DBAs are in greater demand now than they’ve ever been. While some firms are losing the fight for talent, promising startups with a progressive bent are getting first dibs with the best applicants.

Whatever the case, interviewing for a MySQL DBA is a skill in itself so I thought I’d share a guide of top MySQL DBA interview questions to help with your screening process.
It’s long and detailed with some background to give context so I will be publishing this in two parts.

The History of The DBA As A Career

In the Oracle world of enterprise applications, the DBA has long been a strong career path. Companies building their sales staff required Peoplesoft or SAP, and those deploying the financial applications or e-business suite needed operations teams to manage those systems.

At the heart of that operations team were database administrators or DBAs, a catchall title that …

This blog post describes how to use MySQL Autopilot to automate many tasks in MySQL HeatWave Lakehouse, including schema inference, capacity estimation, load time estimation, load script generation, adaptive data sampling, parallel loading of data, and more.

The upcoming tutorial will focus on the ROUND function, which is used to round numeric values for precision and accuracy. Rounding is vital in databases to avoid discrepancies in calculations, particularly with financial and scientific data. The article will provide practical examples and insights into effectively using the ROUND function for reliable results in dbForge Studio for MySQL.

The post MySQL ROUND Function Examples appeared first on Devart Blog.

Writing tests for code that interacts with a database can be daunting. In this post, we discuss how you can easily set up a testing environment using Testcontainers and Node.js and write some tests for code that interacts with a MySQL database.