If you have received the “Your PHP installation appears to be missing the MySQL extension which Is required by WordPress” ...
The post Your PHP installation appears to be missing the MySQL extension which Is required by WordPress appeared first on RoseHosting.
So your MySQL server has crashed. What do you do now? When a server is down, in my opinion, there are two steps that are essential and both are extremely important and neither should be neglected:
Too many people rush to Step #2 and lose pertinent diagnostics from Step #1. Likewise, too many people will spend too much time on Step #1 and delay getting to Step #2 and restoring service. The goal is to collect diagnostics as quickly as possible for later review while getting service restored as fast as possible.
As a Technical Account Manager (TAM) and assisting on server restoration calls, I have seen both issues at play. Technical resources have a tendency to get so bogged down in trying to understand the cause of the server outage that they …
[Read more]
Each SQL dialect is different in some way, shape, form, or
fashion from the next flavor. Some dialects have this
function, while others have that function. In this post, I cover
porting over Oracle SQL to MySQL in order to count the
number of occurrences of a specific weekday found in the current
given month (at the time of writing) purely as a learning
exercise focused on MySQL DATE functions and the
WITH clause…
Image by tigerlily713 from Pixabay
…
[Read more]
In this post, we will see how to setup MySQL NDB Cluster from a
docker image. I assume that the reader has some basic
understanding of docker and its terminology.
Steps to install MySQL NDB Cluster:
Let's create a MySQL NDB Cluster with the following
environment:
MySQL NDB Cluster version (Latest GA version)1 Management Node4
Data Nodes1 Mysqld ServerConfiguration slots for upto 4
additional API nodes
Note: Docker software must be installed and running on the
same host where we are planning to install MySQL NDB Cluster.
Also make sure we have enough resources allocated to docker so
that we shouldn’t face any issues later on.
Step 1: Get the MySQL NDB Cluster docker image on your
host
Users can get the MySQL NDB Cluster image from github site
(link). Then …
(based on a conversation with a colleague, and a bit of Twitter)
A Conundrum
A developer colleague paged me with this:
mysql> select
UNIX_TIMESTAMP("2021-03-26 03:07:00" + INTERVAL 2 YEAR) -
UNIX_TIMESTAMP("2021-03-26 02:07:00" + INTERVAL 2 YEAR) as delta\G
delta: 420
It is obviously wrong, and weirdly so. It only works for “2 year”, not with other values:
mysql> select
UNIX_TIMESTAMP("2021-03-26 03:07:00" + INTERVAL 1-11 year_month) -
UNIX_TIMESTAMP("2021-03-26 02:07:00" + INTERVAL 1-11 year_month) as delta\G
delta: 3600
mysql> select
UNIX_TIMESTAMP("2021-03-26 03:07:00" + INTERVAL 1-12 year_month) -
UNIX_TIMESTAMP("2021-03-26 02:07:00" + INTERVAL 1-12 year_month) as delta\G
delta: 3600
mysql> select
UNIX_TIMESTAMP("2021-03-26 03:07:00" + INTERVAL 1-13 year_month) -
UNIX_TIMESTAMP("2021-03-26 02:07:00" + INTERVAL 1-13 …[Read more]
As database footprints continue to explode, many companies are looking for ways to deal with such rapid growth. One approach is to refactor traditional relational databases to fit into a NoSQL engine, where horizontal scalability is easier. However, in many cases, this is in no way a trivial undertaking.
Another approach that has been gaining interest is the use of MyRocks as an alternative storage engine to the traditional InnoDB. While not for everyone, in certain use cases it could be a potential solution. As with so many things open source, the next standard questions are: which version should I use? Any differences with the engine if I use MyRocks with MySQL 5.7 vs 8.0?
In this post, I wanted to touch on this and give some high-level thoughts on MyRocks when it comes to the version of MySQL.
…
[Read more]Sometimes clients want that the information they collected from the user should be encrypted and stored in a database. Data encryption and…
Continue reading on Thinkdiff »
[Read more]It’s a problem for my students who purchased the new Apple hardware that uses Apple Silicon because they can’t install a Docker MySQL instance. However, there is Homebrew formula that works on macOS Big Sur and the new Apple silicon. It supports:
The Homebrew Formula does have conflicts that you may need to avoid. It is a solution for those with the new Apple silicon.
As always, I hope this helps those looking for a solution.
Recovering to a particular time in the past is called
Point-In-Time Recovery (PITR). With PITR you can rollback
unwanted DELETE without WHERE clause or
any other harmful command.
PITR with Percona XtraBackup is pretty straightforward and perfectly described in the user manual. You need to restore the data from the backup, then apply all binary logs created or updated after the backup was taken, but skip harmful event(s).
However, if your data set is large you may want to recover only the affected database or table. This is possible but you need to be smart when filtering events from the binary log. In this post, I will show how to perform such a partial recovery using Percona XtraBackup, …
[Read more]Nobody likes change, especially when that change may be challenging. When faced with a technical challenge, I try to remember this comment from Theodore Roosevelt: “Nothing in the world is worth having or worth doing unless it means effort, pain, difficulty.” While this is a bit of an exaggeration, in this case, the main concept is still valid. We shouldn’t shy away from an upgrade path because it may be difficult.
MySQL 8.0 is maturing and stabilizing. There are new features (too many to list here) and performance improvements. More and more organizations are upgrading to MySQL 8 and running it in production, which expedites the stabilization. While there is still some significant runway on 5.7 and it is definitely stable (EOL slated for October 2023), organizations need to be preparing to make the jump if they haven’t already.
What Changed?
So …
[Read more]