In this continuing series of posts of fundamental DBA security tasks, we will look at passwords again, the good, the bad and the outright ugly. This group of tasks will help you find insecure users with poor passwords and provide … Continue reading →
Jun
25
2020
Jun
24
2020
The new MySQL Shell or mysqlsh
has provisions for loading user plugins in Python or JavaScript
that are loaded when the shell starts up. I am just taking my
initial steps into this area and wanted to share with you how
easy it is to create a plug-in to produce a report.
The ability to write and run your own scripts for
information that you want on a regular basis is very useful. The
idea behind this was a discussion with a community member who had
issues with a locked account that unknowingly locked and knowing
when passwords where changed. This is a typical bit of work
for a DBA that would be better automated and saved as a script
for future uses.
The Query
The query collects several vital facets of
information for dealing with passwords and accounts.
SELECT concat(User, '@',Host) as
User, …
Jun
24
2020
Usually, database people are familiar with table fragmentation with DELETE statements. Whenever doing a huge delete, in most cases, they are always rebuilding the table to reclaim the disk space. But, are you thinking only DELETEs can cause table fragmentation? (Answer: NO).
In this blog post, I am going to explain how table fragmentation is happening with the INSERT statement.
Before going into the topic, we need to know that with MySQL, there are two kinds of fragmentation:
- Fragmentation where some of the InnoDB pages are completely free inside the table.
- Fragmentation where some of the InnoDB pages are not completely filled (the page has some free space).
There are three major cases of table fragmentation with INSERTs :
- INSERT with ROLLBACK
- Failed INSERT statement
- Fragmentation with page-splits
…
[Read more]
Jun
24
2020
In this post, I’ll cover examples of the MySQL
TRIM() function. TRIM() removes
specific characters – or spaces – from a given string, at either:
the beginning, ending, or potentially in both locations depending
on several factors. With an optional keyword argument that
controls which character(s) – if any – are removed,
TRIM() can be tricky so let’s gain
understanding with several easy-to-digest examples…
Photo by Peter Beukema on Unsplash
OS, Software, and DB used:
- OpenSuse Leap 15.1
- MySQL 8.0.20
Self-Promotion:
If you enjoy …
[Read more]
Jun
23
2020
A few days ago, a customer got in touch asking how they could use Percona Monitoring and Management (PMM) to monitor the roles played by each node in an InnoDB cluster. More specifically, they wanted to check when one of the nodes changed its role from Primary to Secondary, or vice-versa. PMM allows for a high level of flexibility and customization through its support for custom queries, and we just have to be creative on how we approach the problem. In this post, we present the steps we did to test our solution, including the deployment of a 3-node InnoDB Cluster hosted in the same server (for testing) and a PMM 2 server, and connecting them together. Even though this has already been covered in other blog …
[Read more]
Jun
23
2020
Watch our latest on-demand webinar: Deploying Hybrid & Multi-Cloud Applications With Ultimate MySQL Availability. Learn about the pros and cons of single cloud region vs multi-region cloud deployments … and more.
Tags: MySQL Cloud hybrid cloud Multi-Cloud Webinar High Availability tungsten clustering …
[Read more]
Jun
23
2020
Passwords lists abound on the net. They exist to: Get a laugh out of silly passwords… 123456 anyone? Develop a dictionary file to check user passwords either for validation or cracking. From MySQL 5.6 the validate_password plugin has been available. … Continue reading →
Jun
22
2020
Webinar date: July 8th, 2020 @9AM PST
Webinar title: Learn How Credorax is Increasing its SaaS Application Security with MySQL EE.
Speakers:
- Mike Frank, MySQL Product Management Director
- Greg Paks, VP R&D and Operations IT for Credorax
In this webinar, you will learn how Credorax leverages MySQL
EE security features for their SaaS platform. Credorax’s
SaaS application handles global and domestic domestic
payments for merchants and partners, so security is a
top priority for the company.
Discover how MySQL EE is used in the Credorax production
environment to address the security challenges. Learn
Credorax best practices to protect their global
operation across Europe, the US, the …
Jun
22
2020
Webinar date: July 8th, 2020 @9AM PST Webinar title: Learn How Credorax is Increasing its SaaS Application Security with MySQL EE. Speakers: Mike Frank, MySQL Product Management Director Greg Paks, VP R&D and Operations IT for Credorax Register now In this webinar, you will learn how Credorax levera...
Jun
22
2020
In this blog post, we are going to look into how to perform online migration from MySQL 5.6 standalone setup to a new replication set running on MySQL 5.7, deployed and managed by ClusterControl.
The plan is to set up a replication link from the new cluster running on MySQL 5.7 to the master running on MySQL 5.6 (outside of ClusterControl provision), which uses no GTID. MySQL does not support mixing GTID and non-GTID in one replication chain. So we need to do some tricks to switch between non-GTID and GTID modes during the migration.
Our architecture and migration plan can be illustrated as …
[Read more]