The latest from the MySQL community

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.

In this blog I share how MySQL binary logs get their unique numbers after noting my observations with MySQL binary logs sequencing. Recently I noted an odd binary log sequencing…

The post How MySQL Binary Log Gets Its Number first appeared on Change Is Inevitable.

A multi-tenant database is a database that serves multiple clients, or tenants, who share the same database schema but have separate data sets. One way to achieve data isolation for each client is to create a separate MySQL database for each tenant.

Some advantages of this approach are:

• It allows for easy backup and restore of individual tenant data.
• It simplifies the database administration and maintenance tasks, as each database can be managed independently.
• Scaling is easily achieved by adding more database servers and distributing tenant databases across them.

This approach requires a large number of tables on each server. Combined with the default value of innodb_file_per_table=ON, this results in a large number of files that affects crash …

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.