In a serverless world, traditional databases scale differently. They need a rock solid foundation that Vitess and PlanetScale can provide.

Read the full story

Identity is a critical component of security. In the latest release of the Oracle Cloud Infrastructure (OCI) MySQL Database Service (MDS) users can be authenticated using OCI IAM (IAM and New! IAM Identity Domains), providing increased security, centralized management, and ease of use. MDS DBAs can leverage an individual user's identity in OCI IAM as well as map to groups of users within OCI IAM and IAM Identity Domains.

Create a PlanetScale database on the Prisma Data Platform; immediately store and query data from the browser

Read the full story

While exporting the table with MySQL native utility, we don’t have any control on the process, and also there will be no progress update as well on the process completion. So when exporting the larger table will consume high resource utilization and also the disk space usage will also be high.

MySQL shell utility will make the process easier. It will export the table and we can import the data back with a parallel thread and also will provide the current progress status on export/import progress.

util.exportTable() utility was introduced in Shell – 8.0.22 version, will export the data in a controlled manner. We can store the data in either local or Cloud Infrastructure Object Storage bucket as well.

We will see about the compression ratio along with the time taken for native MySQL vs Shell utility

Feature :

• Compression
• Progress status
• Supported output …

We all tried various alternative methods for modifying the table structure, but pt-online-schema-change (pt-osc) is the most convenient and preferred method for performing the alter online. It has more granular control too. But it may lead to data loss if proper precautionary steps are not taken care of.

In this blog, we are going to modify a column to a unique key using pt-osc, below I have shared the table structure.

mysql> show create table test\G
* 1. row *
Table: test
Create Table: CREATE TABLE test (
Personid int(11) NOT NULL AUTO_INCREMENT,
LastName varchar(255) NOT NULL,
FirstName varchar(255) DEFAULT NULL,
Age int(11) DEFAULT NULL,
PRIMARY KEY (Personid)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

I have inserted the data of 1000 rows using …

PlanetScale now supports zero downtime data migrations from your existing MySQL Database

Read the full story

Generally, most all web applications are going to follow the elements of CRUD: Create, Read, Update, and Delete. CodeIgniter 4 is a powerful PHP web development framework that provides a rapid development environment. The CodeIgniter 4 Models come enriched with built-in CRUD functionality, which is covered in this compilation of Medium posts…

Image by Dariusz Sankowski from Pixabay 

Disclaimer: I originally published these articles first over on …

New Oracle survey finds consumers on edge over high prices, out-of-stock products, and delivery delays. More Americans turning to gift cards and even DoorDashing gifts to avoid the holiday hassle.

This Veterans Day, Oracle is offering veterans free training and certification on Oracle Cloud Infrastructure and Oracle Autonomous Database.

This Veterans Day, Oracle is offering veterans free training and certification on Oracle Cloud Infrastructure and Oracle Autonomous Database.