Showing entries 11 to 20 of 43061
« 10 Newer Entries | 10 Older Entries »
Comparisons of Proxies for MySQL

With a special focus on Percona Operator for MySQL

Overview

HAProxy, ProxySQL, MySQL Router (AKA MySQL Proxy); in the last few years, I had to answer multiple times on what proxy to use and in what scenario. When designing an architecture, many components need to be considered before deciding on the best solution.

When deciding what to pick, there are many things to consider, like where the proxy needs to be, if it “just” needs to redirect the connections, or if more features need to be in, like caching and filtering, or if it needs to be integrated with some MySQL embedded automation.

Given that, there never was a single straight answer. Instead, an analysis needs to be done. Only after a better understanding of the environment, the needs, and the evolution that the platform needs to achieve is it possible …

[Read more]
MySQL 8 – timestamp cannot be null and explicit_defaults_for_timestamp

A friend’s application started failing with MySQL causing error about timestamp columns and it needs urgent fixing from the database side. A timestamp column was not accepting the null values and they were sort of down. In this blog we will learn how MySQL is telling you, to follow what you say. When you define […]

The post MySQL 8 – timestamp cannot be null and explicit_defaults_for_timestamp first appeared on Change Is Inevitable.

MySQL Database Service – find the info: part 1 – backups

In this new series of articles we will explore the different sources of information available when using MySQL Database Service on OCI to effectively perform your daily DBA job.

Of course there is way less things to take care of, like backups, upgrades, operating system and hardware maintenance, …

But as a serious DBA, you want to know the status of all this and maintain some control.

Some information is available on OCI’s webconsole and some in Performance_Schema and Sys.

If you use MySQL Shell for Visual Studio Code, you have the possibility to see an overview of your server using the Performance Dashboard:

But today we will take a look at the backup, a very important responsibility of the DBA.

When you use MySQL Database Service on OCI, you can define the backup policy at the DB Instance’s creation. You can always modify it later:

In …

[Read more]
OpenLampTech issue #70 – Substack Repost

I’ve been enjoying OpenLampTech for 70 weeks now. Wow! That’s a lot of publishing. But, more importantly, a lot of learning. And forming relationships with the readers. I am so grateful you are reading OpenLampTech. Thanks!

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

In OpenLampTech issue #70, I am sharing some fantastic articles on:

  • ‘Tainted’ PHP code
  • Linux package dependencies
  • 10 useful PHP array functions
  • SQL NULL value
  • And much, much more

Thanks so much for …

[Read more]
MySQL Database Service - find the info: part 1 - backups

New series of articles about how to find useful information when using MySQL Database Service

MySQL Books: SQL Antipatterns, Volume 1

MySQL book review: SQL Antipatterns, volume 1

Which is the best Proxy for Percona MySQL Operator?

Overview

HAProxy, ProxySQL, MySQL Router (AKA MySQL Proxy), in the last few years I had to answer multiple times on what proxy to use and in what scenario. When designing an architecture there are many components that need to be considered before deciding what is the best solution.

When deciding what to pick, there are many things to consider like where the proxy needs to be, if it “just” needs to redirect the connections or if more features need to be in, like caching, filtering, or if it needs to be integrated with some MySQL embedded automation.

Given that, there never was a single straight answer, instead an analysis needs to be done. Only after a better understanding of the environment, the needs and the evolution that the platform needs to achieve is it possible to decide what will be the better choice.

However recently we have seen an increase in usage of MySQL on Kubernetes, especially with the …

[Read more]
Build a products listing application with Golang and MySQL

Learn how to build a products listing application with Golang and a MySQL database.

Read the full story

Build a products listing application with Golang and MySQL

Learn how to build a products listing application with Golang and a MySQL database.

Read the full story

Percona Monitoring and Management 2 Scaling and Capacity Planning

2022 was an exciting year for Percona Monitoring and Management (PMM). We’ve added and improved many features, including Alerting and Backup Management. These updates are designed to keep databases running at peak performance and simplify database operations. But as companies grow and see more demand for their databases, we need to ensure that PMM also remains scalable so you don’t need to worry about its performance while tending to the rest of your environment.

PMM2 uses VictoriaMetrics (VM) as its metrics storage engine. Percona’s co-Founder Peter Zaitsev wrote a detailed post about migration from Prometheus to VictoriaMetrics, One of the most significant differences in …

[Read more]
Showing entries 11 to 20 of 43061
« 10 Newer Entries | 10 Older Entries »