I appreciate you visiting my corner of the internet and giving me your time. This week’s OpenLampTech developer newsletter is no less epic so you are spending your time wisely. Thank you!

Custom WooCommerce and Shopify Solutions

Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!

Learn More

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

This week in OpenLampTech issue #85, we have curated content on:

• Securing Laravel’s writer developer interview
• MySQL 5.7 EOL
• WordPress reusable blocks …

This post was originally published in July 2018 and was updated in July 2023.

Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL?  What are the differences between Aurora and RDS? How do I choose which one to use?

In this blog, we will answer all of these important questions and provide a general overview comparing the two database services, Aurora vs RDS.

Understanding DBaaS

DBaaS cloud services allow users to use databases without configuring physical hardware and infrastructure or installing software. But …

Using MySQL Shell, we can dump and load databases across cloud providers. In this post, we will discuss how to dump a MySQL database running in Azure to an Azure storage container and then load that data into a MySQL HeatWave instance running in Oracle Cloud Infrastructure.

Starting with MySQL Shell 8.0.33, it’s possible to fully enable SSL/TLS certificate-based authentication seamlessly across an InnoDB Cluster, ClusterSet or, ReplicaSet setup. Let’s dive into the details of the new features with complete examples of how to set up the strongest encryption configuration possible. Certificate Based Authentication For Intra-node Communication To secure and validate users for the […]

In a recent post I talked about how we can move data from MySQL running in AWS to a MySQL HeatWave Database instance running in Oracle Cloud Infrastructure (OCI) with just two commands using MySQL Shell. In this post, I will show how we can use a similar process to move data from Microsoft Azure to OCI. Prerequisites There are a few […]

MySQL Shell 8.0.33 added full SSL/TLS and certificate-based (passwordless) authentication support across all aspects of deployment of MySQL InnoDB Cluster, ClusterSet or ReplicaSet.

Written by Mitia Alexandrov We are used to working with databases through SQL. It has been this way for decades. Time has shown that in the enterprise world, we mostly keep and manage data in relational databases and use object-oriented practices in our software since most enterprise programming languages are object-oriented, including Java. Although Java […]

Helidon + MySQL Document Store

ChatGPT, a powerful language model developed by OpenAI, has a wide range of applications across various realms, including database development. In this article, we will demonstrate how developers, DBAs, and data analysts can harness the capabilities of ChatGPT to enhance data import into databases like MySQL.

The post How to Import Any Data Format to MySQL Using ChatGPT appeared first on Devart Blog.

Learn how to build a Laravel application backed by a MySQL PlanetScale database.