Showing entries 101 to 110 of 43511
« 10 Newer Entries | 10 Older Entries »
Configuring Keyring for Encryption Using AWS Key Management Service in Percona Server for MySQL

The AWS KMS component is now available in Percona Server for MySQL starting from version 8.0.30. This addition enables data-at-rest encryption by utilizing the AWS KMS component, providing the functionality to create and manage cryptographic keys across AWS services.How do we set up encryption using AWS KMS?You should only load a keyring component with a […]

MySQL General Tablespaces: A Powerful Storage Option for Your Data

Managing storage and performance efficiently in your MySQL database is crucial, and general tablespaces offer flexibility in achieving this. This blog discusses general tablespaces and explores their functionalities, benefits, and practical usage, along with illustrative examples.What are MySQL general tablespaces?In contrast to the single system tablespace that holds system tables by default, general tablespaces are […]

A year in MySQL Blogging – top blogs, summary and review

The year 2023 surely was a successful year in MySQL blogging. I managed to publish 24 MySQL blogs in total both personal and Percona blog. This post is a reflection…

The post A year in MySQL Blogging – top blogs, summary and review first appeared on Change Is Inevitable.

The Various Methods to Backup and Restore ProxySQL

ProxySQL is a high-performance SQL proxy that runs as a daemon watched by a monitoring process. The process monitors the daemon and restarts it in case of a crash to minimize downtime.The daemon accepts incoming traffic from MySQL clients and forwards it to backend MySQL servers.The proxy is designed to run continuously without needing to […]

Newsletter Repost: Developer Interview With Davor Minchorov – OpenLampTech

Software engineer Davor Minchorov shares a fantastic developer interview with the OpenLampTech newsletter readers.

Code, content, and community for developers.

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

Be sure you’re subscribed to OpenLampTech so you don’t miss out on any of the great content published each week.

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 …

[Read more]
Audit DROP Statements in Percona Server for MySQL

Managing database servers involves different aspects, among which security is critical. We know that we should always grant the minimal required permissions to the different user accounts in the database, as having a user with high-level permission can lead to unexpected results, such as having an index drop affecting the system performance or even more […]

Newsletter Repost – OpenLampTech issue #111

Advanced SQL queries | WooCommerce shortcodes | Open Source alternatives | Laravel in 2024 | PHP if/else spiral.

Code, content, and community for developers.

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

Be sure you are subscribed to the OpenLampTech newsletter so you can receive all the great 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 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, just because you can do something …

[Read more]
How to filter MySQL slow queries using pt-query-digest

The pt-query-digest is my go-to tool in order to perform slow query analysis, improve query performance and thus overall MySQL performance. In this blog post, I’m going to highlight the…

The post How to filter MySQL slow queries using pt-query-digest first appeared on Change Is Inevitable.

Introducing the MySQL Audit Log Filter Plugin

We’re happy to introduce Audit Log Filter — our newly upgraded audit plugin. Its functionality has been significantly improved in comparison to Audit Log and currently mirrors the functionality of the MySQL Enterprise Audit plugin. Starting with Percona Server for MySQL 8.0.34-26, the Audit Log Filter is available in a technical preview mode. You’re welcome […]

Newsletter Repost: Developer Interview With Ryan Szrama – OpenLampTech

Long-time Drupal developer Ryan Szrama shares a fantastic developer interview with the OpenLampTech newsletter readers

Code, content, and community for developers.

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

Ryan Szrama is very active in Drupal development, developing plugins and specific commerce-first software using Drupal.

Consider subscribing to OpenLampTech to receive this content and more each week directly to your inbox.

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 …

[Read more]
Showing entries 101 to 110 of 43511
« 10 Newer Entries | 10 Older Entries »