MySQL HeatWave 9.0 was released under the banner of artificial intelligence. It includes a VECTOR datatype and can easily process and analyze vast amounts of proprietary unstructured documents in object storage, using HeatWave GenAI and Lakehouse.

Oracle Cloud Infrastructure also provides a wonderful GenAI Service, and in this post, we will see how to use OCI GenAI with MySQL HeatWave to build a custom RAG solution using the content of a WordPress site.

This article was written with the help of my colleague Ivan Ma …

Senior WordPress and WooCommerce developer Andrii Toniievych shares a great developer interview with the OpenLampTech newsletter audience.

Code, content, and community for developers.

The LAMP stack and the PHP technologies and frameworks it runs.

Andrii Toniievych provides services for complex WooCommerce projects in the e-commerce space including development, optimization, and tool configurations/integrations among others.

Needless to say, I am super-excited Andrii shared insightful information and knowledge with the OpenLampTech newsletter readers and community.

Subscribe to OpenLampTech to read and receive this content each week.

Thank you for reading this post. Please share it with someone else who would enjoy it as well.

Disclaimer: The majority of …

I could have set MySQL between parenthesis in the title as this article is more about how to use OpenTofu to deploy on OCI.

I will explain how to install OpenTofu and how to use it to deploy on OCI. I will also mention what are the required changes be able to use my previous Terraform deployment files.

As an example, let’s use the modules to deploy WordPress with MySQL HeatWave Database Service: oci-wordpress-mds.

Installing OpenTofu

If like me you are using a RPM based Linux distro, you can find the necessary information to create the yum repository on OpenTofu’s website:

$ sudo su -
# cat >/etc/yum.repos.d/opentofu.repo <<EOF
[opentofu]
name=opentofu …

Some time ago, we saw how we could deploy WordPress on OCI using MySQL HeatWave Database Service with Read Replicas. We had to modify WordPress to use a specific plugin that configures the Read/Write Splitting on the application (WordPress): LudicrousDB.

Today, we will not modify WordPress to split the Read and Write operations, but we will use MySQL Router 8.2.0 (see [1], [2], [3]).

Architecture

The …

Senior Backend Engineer Tanner Record discusses PHP, WordPress, and SQL in this developer interview for OpenLampTech.

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.

Tanner Record writes WordPress and PHP content in his Systematic WordPress Development newsletter, which I’m a recent fan of and highly recommend.

Be sure you’re subscribed to OpenLampTech to receive these posts (and more) directly I’m your inbox at publishing.

Grab your free subscription today.

…

Long-time WordPress and Vue.js software engineer Przemysław Hernik shares a fantastic developer interview with the OpenLampTech readers.

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.

Be sure you’re subscribed to the OpenLampTech newsletter so you …

Let’s see how to deploy WordPress and MySQL on a Kubernetes Cluster. The Kubernets cluster we are using is OKE (Oracle Kubernetes Engine) in OCI (Oracle Cloud Infrastructure):

OKE Cluster

We start by creating a Kubernetes Cluster on OCI using the Console:

We select the Quick create mode:

We need to name our cluster and make some choices:

When created, we can find it in the OKE Clusters list:

And we can see the pool of workers nodes and the workers:

kubectl

I like to use kubectl directly on my latop to manage my K8s Cluster.

On my Linux Desktop, I need to install kubernetes-client package (rpm).

Then on the K8s Cluster details, you can click on Access Cluster to get all the commands to use:

We need to copy them on our terminal and then, I like to also enable the bash completion for …

I already wrote on how to deploy WordPress on OCI using MySQL HeatWave, the MySQL Database Service in Oracle Cloud Infrastructure:

• Using MySQL Database Service for WordPress
• Deploying WordPress on OCI with MySQL Database Service: the easy way !
• Deploy WordPress on OCI using MDS – updated version
• Deploy WordPress on OCI with MySQL Database Service using Read Replicas
• …

If you’re looking for your PHP, MySQL, and LAMP stack media source, you’ve found it in OpenLampTech. I have one massive – and excellent – newsletter for you this week. Check it out!

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.

OpenLampTech issue #80 is sharing content on:

• WordPress …

One of the best ways to learn is to read and study others’ fantastic content. And that’s just what I do each week in OpenLampTech. Get ready for another knowledge-packed newsletter. This is OpenLampTech.

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.

In OpenLampTech issue #77, I’m looking at content covering:

• Linux File Permissions
• 5 Solid MySQL Books
• PHP isset() …