Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
Migrate from Azure for MySQL database into MySQL Database Service (MDS)
High-level steps are in two phase Dump Schema Utility Export the schema of Azure for MySQL Instance into Oracle Cloud Object Storage. Load Dump Utility Import the schema from Object Storage to local compute Instance. More info:- https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-dump-instance-schema.html How does Migration Work? Suppose you wanted to do lift-shift of database called “sakila” , so “Schema […]
Apache Zeppelin on Oracle Cloud with MySQL
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 […]
Deploying Drupal in OCI using MySQL Database Service: the easy way !
If you plan to deploy a Drupal site to OCI using MySQL Database Service, there is a very easy way to perform that deployment: using OCI’s Resource Manager ! As you know, security is something very important for Oracle in OCI, therefor, exposing the database on the Internet is not allowed. Even if you are […]
Deploy Magento on MySQL Database Service & HeatWave
Magento is an Open-Source e-commerce platform written in PHP using multiple other PHP frameworks such as Laminas and Symphony. Magento source code is distributed under Open Software License v3.0. Deploying Magento is not always easy as it often requires registration. However the source code is also available on GitHub. Magento supports MySQL 8.0 since version 2.4.0 (July 28th 2020). In Magento’s documentation, there […]
Deploy WordPress on OCI using MySQL Database Service
In this post, I describe you how to deploy WordPress on OCI using MySQL Database Service. I wrote some Terraform recipes that you can find on my GitHub repository: oci-wordpress-mds. I will show how easy it’s to deploy directly from OCI’s dashboard using Resource Manager’s stack. I will also share the recent additions. The first think […]
MySQL Performance Tuning: Top 10 Easy Tips
MySQL is a proven, reliable database that is quick to set up easy to maintain, and has outstanding performance. However, that performance can usually be improved with the judicious use of the following tips that are all easy to implement. The best way to proceed is to work with one schema or database and go […]
Tips to Optimize MySQL Applications Query Performance
Performance issues are often stubborn things to cure. Suddenly a query or operation seems slow, or slower-ish. Sadly, the database is often pointed at as the culprit by developers who are either positive their code cannot be at fault or those who see databases as a mysterious box that does odd things at the direction […]
Using MySQL Database Service in OCI – Part 3: faster with MySQL HeatWave !
This post is the third and last of a series of articles dedicated to MySQL Database Service (MDS): The goal of this series if to get familiar with MDS, HeatWave and useful MySQL Shell utilities. We can now start a query on our MDS instance that has been populated with >200M rows: SQL > SELECT […]
Using MySQL Database Service in OCI – Part 2: importing Data to MySQL DB System
This post is the second of a series of articles dedicated to MySQL Database Service (MDS): The goal of this series if to get familiar with MDS, HeatWave and useful MySQL Shell utilities. Before we start, I would like to highlight that the fastest and recommended way to import data to a MySQL DB System […]
MySQL Query Optimization: Top 3 Tips
MySQL Query Optimization is usually simple engineering. But seeking information about how to tune queries is treated on many web reference sites like some Harry Potter-ish spell casting. There are simple tips you need to be aware of to get the best of your queries. One – The MySQL Query Optimizer wants to optimize your […]