Galera Manager supports three modes for supporting your Percona XtraDB Clusters: deploying to either Amazon Web Services, deploying to your own on premises hosts, and also just monitoring your clusters. In this blog post, we will go thru houw you should deploying a 3-node Percona XtraDB Cluster via Galera Manager on Amazon Web Services Elastic Compute Cloud (AWS EC2). You will realise that this process happens with just a simple API key and instance selection, so effectively you can have a Galera Manager setup in under fifteen minutes!

On AWS EC2, it is worth noting that Galera Manager itself can be deployed on the free tier for testing purposes. However, in production environments, you might expect up to 100GB of logs on a monthly basis, so you should plan accordingly.

Obtain Galera Manager by …

It is a known good practice to keep only necessary indexes to reduce the write performance and disk space overhead. This simple rule is mentioned briefly in the official MySQL Documentation:https://dev.mysql.com/doc/refman/8.0/en/optimization-indexes.htmlHowever, in some cases, the overhead from adding a new index can be way above the expectations! Recently, I’ve been analyzing a customer case like […]

As a new Oracle employee working in the External Standards and Community Engagement group in the Czech Republic, I was happy to attend the first MySQL User Group meeting happening for after some time of inactivity in Prague. While I am not working directly on the MySQL team, I was interested to learn more about […]

Building robust LAMP stack apps | WooCommerce database optimization | PHP method chaining | CakePHP templating | wp_mail() is not broken.

Code, content, and community for developers.

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

Be sure you are subscribed to the weekly OpenLampTech newsletter so you don’t miss out on any of the great content!

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

Disclaimer: The majority of examples in this post, are performed in a personal development/learning workstation environment and should not be considered production quality or ready. Your particular goals and needs may vary. Like always, …

MySQL Enterprise Data Masking and De-Identification components were introduced in MySQL v. 8.0.33 and are available in Enterprise Edition and cloud version. Among other functionality, they provide functions that randomly select terms from user defined masking dictionaries. They are stored in a dedicated table and memory cache. So far, the schema of the table was fixed […]

The latest Episode of MySQL Shorts is now available! Check out Episode 55 on the MySQL YouTube Channel to learn restore a MySQL HeatWave backup to a new instance in Oracle Cloud.

MySQL Shorts Episode #55, discussing restoring a MySQL HeatWave backup, is now available.

Data is abstract. Geospatial design management is how engineers across various disciplines make sense of complex data to make more informed decisions and better understand the spatial relationships in the world around us. In this blog post, I explore how complex data and geographic features can be represented in MySQL. Geospatial data, often referred to in technical documentation as geodata, includes information related to locations on the Earth's surface. In MySQL, geographic features represent anything in the real world with a location and are defined as either Entities or Space. Type Definition Examples Entities Specific objects with defined boundaries and individual properties Landmarks: Mountains, rivers, forests, buildings Infrastructure: Roads, bridges, power lines Administrative areas: Countries, cities, states Points of interest: Restaurants, shops, ATMs Spaces Continuous areas defined by their location and characteristics Land cover: …

This blog demonstrates how to setup OpenVPN Access Server for access to MySQL HeatWave.

A little over a week ago, we released Galera Cluster for MySQL 8.0.35. Today, we have also made available binaries for Debian 12 “bookworm”.

As always we have binary installation documentation available, and if you are just after a quick install, the following is what is in your /etc/apt/sources.list.d/galera.list:

deb https://releases.galeracluster.com/galera-4.17/debian bookworm main
deb https://releases.galeracluster.com/mysql-wsrep-8.0.35-26.16/debian bookworm main

Happy installing, and the next step is to ensure that Debian 12 is enabled on Galera …