Just as you want to filter the rows of data returned in a SELECT query with the equality comparison operator (=), you can also create a conditional filter to test if 2 values are not equal to one another. Learn more in the following article.
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.
Image by Peggy und Marco Lachmann-Anke from …
[Read more]The cost of downtime can range from loss of business to severe reputation damage. Database downtime feels inevitable but is often preventable. The causes of database issues that lead to downtime can be categorized in the following ways: Human error System immaturity Application issues In this post, we will explore how PlanetScale can mitigate all three. Downtime due to human error We’ve all done it, dropped the wrong table or index and caused queries to dramatically slow or fail. This can lead to entire site outages, as well as cascading failure that impacts other systems. With standard MySQL, if you drop a table that you later find out was still in use, you are in a situation where you now have to restore from backup. Selecting the right backup, restoring, and bringing your site back online can take hours, which of course leads to high levels of stress for you and your team. To help prevent this type of outage, PlanetScale warns you if the table …
[Read more]Learn how PlanetScale protects against downtime due to human error system immaturity and app issues.
In part one of this series, we introduced the different ways to manage MySQL configurations. In this post, we will walk through different possibilities and the changes happening while modifying MySQL configurations with the operator.
Percona Distribution for MySQL Operator based on Percona XtraDB Cluster (PXC) provides three ways for managing MySQL, but the question is, what is the precedence among options? We will walk through several cases of using MySQL configs. For the sake of simplicity, we will play with the values of the Galera cache to see the effects.
configuration: | [mysqld] …[Read more]
We are moving right along with the OpenLampTech publication. This week’s issue has a great developer interview, in addition to all the curated MySQL, PHP, and LAMP stack content you’ve come to expect. Let’s get to it. Enjoy OpenLampTech issue #37!
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 #37, I’m sharing articles on:
In this blog, I will cover important aspects which you need to test when benchmarking replication setup. MySQL has great tools that could be used to test its performance. They include:
sysbench – https://github.com/akopytov/sysbench
BMK-kit – http://dimitrik.free.fr/blog/posts/mysql-perf-bmk-kit.html
mysqlslap – https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html
LinkBench – https://github.com/facebookarchive/linkbench
I will not describe how to use them here, as you can find instructions on the provided links or in the Percona blog by browsing tags …
[Read more]We’ve been measuring MySQL replication lag with heartbeats for more than a decade. It works, but can we do better? Let’s see.
We’ve been measuring MySQL replication lag with heartbeats for more than a decade. It works, but can we do better? Let’s see.
We’ve been measuring MySQL replication lag with heartbeats for more than a decade. It works, but can we do better? Let’s see.
New MySQL HeatWave capabilities released in 8.0.30
