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 MySQL and MySQL Heatwave. The Prague MySQL User Group held this meeting in the beautiful Oracle Prague office space.
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 …
[Read more]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 […]
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, …
[Read more]MySQL Shorts Episode #55, discussing restoring a MySQL HeatWave backup, is now available.
In this blog post, we explore how complex data and geographic features can be represented in MySQL.
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 …
[Read more]MySQL secure_file_priv | WooCommerce checkout – Hear About Us? | NativePHP | Drupal Commerce Core | WooCommerce shop data insights curated resource.
Code, content, and community for developers.
The LAMP stack and the PHP technologies and frameworks it runs.
Be sure you’re subscribed to the OpenLampTech newsletter so you don’t miss 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, …
[Read more]SMUG Meetup 2-2024