A database is a special kind of structured, persistent, global variable with concurrent access over the network.

You write data to a cell of a row of a table in a schema in the server, and it is being kept around for you, with a lifetime longer than the runtime of your program. The database takes care of making sure of ordering access to that data, so there is a clearly defined series of changes to the data – locking, transactions, isolation are things that make databases popular.

And so one gets to have a lot of database schemas in server instances, and they grow. Sometimes that becomes a problem.

Databases don’t scale, even when they scale

These days, the MySQL server can easily utilize the resources even of very large servers. At work, we have taken instances easily up to 400.000 queries per …

In this tutorial, you’ll learn how to build a mood tracker application with Laravel 9, connect it to a PlanetScale MySQL database, make database schema changes, and deploy your database branch to production. You’ll use PlanetScale for the database, which gives you a fully managed MySQL-compatible database, unlimited scalability, a Git-like development workflow, zero downtime schema changes, and more. This blog post is over a year old and may be out of date.

Here are some of the highlights of what you’ll create: A production-ready MySQL database in PlanetScale 2 database branches: main for production and dev for development 2 tables, moods and entries, to store your daily entries and mood options Database migrations and a seeder to run on your development database Deploy non-blocking schema changes from development to production with PlanetScale branching and deploy requests. If you just want to get up and running with Laravel and …

Learn how to build a Laravel CRUD application connect it to a MySQL database and seed it with data.

On the previous article we saw how to easily deploy Apache Zeppelin on OCI with MySQL using Terraform.

In this article we will see how we can accelerate queries enabling MySQL HeatWave.

Enabling HeatWave

If you used a MySQL Database Service Shape compatible with HeatWave (MySQL.HeatWave.VM.Standard.E3), using the same Resource Manager Stack, you have the possibility to enable HeatWave and deploy a HeatWave Cluster for your MySQL.

The first think to do, is to edit the previous applied stack:

As we used a HeatWave compatible shape, we have the choice to deploy a HeatWave Cluster and we can choose it:

Save and Apply… the HeatWave cluster will be added:

If you …

Apache Zeppelin is a web-based notebook that enables data-driven, interactive data analytics, machine learning, and collaborative documents with SQL, Scala, Python, R. In this article we will see an easy method to deploy Apache Zeppelin on Oracle Cloud with MySQL Database Service.

Recently, somebody requested some help as he was trying to modify the structure of a large table. The requested modification was related in changing a fixed length string to a variable length string column.

If you don’t know it yet, MySQL supports multiple algorithms when altering a table (DDL):

• COPY: operations are performed on a copy
• INPLACE: operations may rebuild the table inplace (no copy)
• INSTANT: operations only change the metadata in the data dictionnary

The operation that interests us today needs to copy the full table. And this was the problem for the user as the MySQL Datadir could not store twice the amount of that large table.

In this blog post I will explain a method that can be used to solve this problem. There are also others method like a logical dump …

This week’s issue of OpenLampTech, the newsletter for PHP/MySQL developers is once again loaded to the brim with the best content I can curate for your reading pleasure. I absolutely enjoy running and sharing the newsletter and I hope you are enjoying the content just as much. Thank you!!!!

Do you need to learn MySQL? Just starting and confused about how to query a table and get the data you need? I am creating premium MySQL Beginners content for this specific reason. To help those who want to learn the basics of MySQL but don’t know where to start. Learn more about the premium blog posts as I develop and release them.

Tell me more!

Image by  …

Apache Zeppelin is a web-based notebook that enables data-driven,
 interactive data analytics, machine learning, and collaborative documents with SQL, Scala, Python, R.

Today we will see how we can deploy Apache Zeppelin on a Compute instance in Oracle Cloud Infrastructure (OCI) using MySQL Database Service (MDS).

You can manually deploy a compute instance and install zeppelin on it then connect to MySQL Database Service or you can use the Terraform modules I’m sharing on GitHub: https://github.com/lefred/oci-zeppelin-mds

Finally you can also deploy all this by just clicking on the follow button to use …

I always get interesting feedback on some posts. On my test case for discovering the STR_TO_DATE function’s behavior, the comment was tragically valid. I failed to cleanup after my test case. That was correct, and I should have dropped param table and the two procedures.

While appending the drop statements is the easiest, I thought it was an opportunity to have a bit of fun and write another procedure that will cleanup test case tables within the test_month_name procedure. Here’s sample dynamic drop_table procedure that you can use in other MySQL stored procedures:

CREATE PROCEDURE drop_table
( table_name  VARCHAR(64))
BEGIN
 
  /* Declare a local variable for the SQL statement. */
  DECLARE stmt VARCHAR(1024);
 
  /* Set a session variable with two parameter markers. */
  SET @SQL := CONCAT('DROP TABLE ',table_name);
 
  /* Check if the …

Recent improvements to MySQL Database Service: Support for version 8.0.28, MySQL version selection, MySQL simplified state management after maintenance events, and MySQL Database Service Data Masking and De-Identification Functions.