In this tutorial, we’ll be going over every step of how to install MySQL on AlmaLinux. Database servers are the ...
The post How to Install MySQL on AlmaLinux appeared first on RoseHosting.
In this tutorial, we’ll be going over every step of how to install MySQL on AlmaLinux. Database servers are the ...
The post How to Install MySQL on AlmaLinux appeared first on RoseHosting.
In this blog post, we are going to show you how to fix corrupted tables in MySQL. MySQL is an ...
The post How To Fix Corrupted Tables in MySQL appeared first on RoseHosting.
In this blog post, we will show you ten useful mysqladmin commands for database administration. Mysqladmin is a client for ...
The post 10 Useful mysqladmin Commands for Database Administration appeared first on RoseHosting.
I’ve had this list on a post-it note on my monitor for all of 2022. I figured it was time to write it down, and reuse the space.
In summary, AWS suffers from the same problem that almost every other product does. It sacrifices improved security for backward compatibility of functionality. IMO this is not in the best practices of a data ecosystem that is under constant attack.
The uuid()
function in MySQL returns a 36 character
hex string, formatted as:
aa479ea9-1d9d-11ed-ba03-564760fe47b7
ColdFusion's createUUID()
function returns a 35
character hex string formatted as:
AA479EA9-1D9D-11ED-BA03564760FE47B7
Both store the same amount of data (16 bytes), the only difference is that there is an extra dash in the MySQL uuid() function result.
Here's some SQL I came up with to create a UUID using ColdFusion's formatting in raw SQL:
SELECT upper(concat(left(uuid(), 23), right(uuid(), 12)))
It is not an ideal solution because I am actually calling
uuid()
twice, but it is sufficient for my use case.
You could probably use a regex to remove the extra dash and avoid
calling uuid twice if you wanted to try and optimize it. Feel
free to post a comment if you can come up with a better way to do
it.
Now suppose you …
[Read more]
During previous months, I’ve had some time to satisfy my
curiosity about databases in containers and I started to test a
little bit MySQL in Kubernetes.
This is how it all began…
In January I had the chance to be trained on Kubernetes attending
the Docker and Kubernetes essentials Workshop of
dbi services. So I decided to prepare a session on this topic at
our internal dbi xChange event. And as if by magic, at the
same time, a customer asked for our support to migrate a MySQL
database to their Kubernetes cluster.
In general, I would like to raise two points before going into …
[Read more]
During previous months, I’ve had some time to satisfy my
curiosity about databases in containers and I started to test a
little bit MySQL in Kubernetes.
This is how it all began…
In January I had the chance to be trained on Kubernetes attending
the Docker and Kubernetes essentials Workshop of
dbi services. So I decided to prepare a session on this topic at
our internal dbi xChange event. And as if by magic, at the
same time, a customer asked for our support to migrate a MySQL
database to their Kubernetes cluster.
In general, I would like to raise two points before going into …
[Read more]
If you have worked with an RDBMS for some time, you will likely
have come across the statement SELECT 1
.
However, rarely is it correctly explained to engineers what the origin of SELECT 1 is, and why it’s useless and wasteful? A google search is not going to give you the response you would hope, these ranked responses are just as useless as the statement itself.
Bloat
Seeing a SELECT 1
confirms two things. First you are
using a generic ORM framework, quote, and second, you have never optimized your
SQL traffic patterns.
“Frameworks generally suck.
They CLAIM to improve the speed of development and abstract the
need to know SQL.
The REALITY is the undocumented cost to sub-optimal performance,
especially with data persistence.”
Connection Pooling
SELECT 1
comes from …
Today we are going to guide you on how to show all users in the MySQL users Database. A common ...
The post MySQL SHOW USERS: List All Users in a MySQL Database appeared first on RoseHosting.
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.