DBA can configure user accounts such that too many consecutive login failures cause temporary account locking.
The post MySQL Security - Failed-Login Tracking and Temporary Account Locking first appeared on dasini.net - Diary of a MySQL expert.
May
12
2020
May
12
2020
As indicated in a previous post, I am working on a Planet MySQL Community (this name is not final, see below). In this post, I want to present what I think the requirements should be for this new aggregator. This is a Request for Comment (RFC): I do not claim completeness nor perfection, this might (will) evolve, and your remarks are welcome. A tl&dr is available in the
May
12
2020
ARM community that has developers from varied organizations has contributed some really good patches to MySQL. Most of them are awaiting acceptance. Blog is meant to analyze these patches along with their pros and cons. Hopefully this would help ease MySQL/Oracle to accept these long-awaited patches.
Community Patches
1. Optimizing checksum
- MySQL uses 2 types of checksum: crc32c and crc32. They both
are different since both uses different polynomials.
- crc32c is used in MySQL by InnoDB to calculate page-checksum.
- crc32 is used in MySQL for table checksum, binlog-checksum, etc…
crc32c
- Page checksum is calculated during each page read/write so crc32c can quickly show up as one of the top functions in perf report. Ensuring use of optimized versions of it could help improve the overall throughput of the system. …
May
11
2020
FromDual has the pleasure to announce the release of the new version 1.0.0 of its popular FromDual Ops Center focmm, a Graphical User Interface (GUI) for MySQL and compatible databases.
The FromDual Ops Center for MySQL and compatible databases (focmm) helps DBA's and System Administrators to better manage their MySQL and compatible databases farms. Ops Center makes DBA and Admins life easier!
The main task of Ops Center is to support you in your daily MySQL and compatible databases operation tasks. More information about FromDual Ops Center you can find here.
Download
The new FromDual Ops Center for MySQL and compatible databases
(focmm) can be downloaded from here. How to …
May
11
2020
FromDual has the pleasure to announce the release of the new version 1.0.0 of its popular FromDual Ops Center focmm, a Graphical User Interface (GUI) for MySQL and compatible databases.
The FromDual Ops Center for MySQL and compatible databases (focmm) helps DBA's and System Administrators to better manage their MySQL and compatible databases farms. Ops Center makes DBA and Admins life easier!
The main task of Ops Center is to support you in your daily MySQL and compatible databases operation tasks. More information about FromDual Ops Center you can find here.
Download
The new FromDual Ops Center for MySQL and compatible databases
(focmm) can be downloaded from here. How to …
May
11
2020
FromDual has the pleasure to announce the release of the new version 1.0.0 of its popular FromDual Ops Center focmm, a Graphical User Interface (GUI) for MySQL and compatible databases.
The FromDual Ops Center for MySQL and compatible databases (focmm) helps DBA's and System Administrators to better manage their MySQL and compatible databases farms. Ops Center makes DBA and Admins life easier!
The main task of Ops Center is to support you in your daily MySQL and compatible databases operation tasks. More information about FromDual Ops Center you can find here.
Download
The new FromDual Ops Center for MySQL and compatible databases
(focmm) can be downloaded from here. How to …
May
11
2020
MinervaDB Webinar – Building MySQL Infrastructure for Performance and Reliability
This is a webinar from Shiv Iyer ( Founder and Principal of MinervaDB ). He is a longtime ( 16 years ) Database Infrastructure Operations Architect with core expertise in performance, scalability and Database SRE in Open Source Database Systems. If you are building MySQL for Performance and Reliability, You must attend this webinar. Shiv explains in detail on how he and the team MinervaDB has built several planet-scale database infrastructure operations for high profile internet properties / companies from diversified verticals like CDNs, Mobile Ad. Networks, Social Media Applications, Online Commerce, Social Media Gaming and FinTech. This webinar is about building best practices and checklist for MySQL performance, capacity planning / sizing, scalability, high availability, fault-tolerance, observability & resilience and database security. You can …
[Read more]
May
11
2020
For more information on how to create a service look
at man systemd.service Install Directory for MCM installation is /opt
Download latest tar package of MCM from edelivery.oracle.com or
support.oracle.com (today this is package: MySQL Cluster Manager
1.4.8 TAR for Generic Linux x86 (64bit)) Run commands below once
you have downloaded the MCM package:
sudo su -
cd /opt
tar xzf /tmp/mcm-1.4.8-linux-glibc2.12-x86-64bit.tar.gz
mv mcm-1.4.8-linux-glibc2.12-x86-64bit mcm
cp /opt/mcm/mcm1.4.8/etc/mcmd.ini /opt/mcm/
mkdir /opt/mcm/mcm_data
Set manager-directory to folder /opt/mcm/mcm_data in configuration file:
cat /opt/mcm/mcmd.ini | sed 's/^##manager-directory.*/manager-directory = \/opt\/mcm\/mcm_data/' >> /opt/mcm/mcmd.ini
Structure should be:
…
May
11
2020
MySQL has been making huge progress on the JSON/NoSQL front as well ie. supporting many of the JSON access and manipulation features and operations. In this how-to tutorial, I am going to show you how to add a new JSON column with default value in an existing MySQL table using the ALTER TABLE statement. And, how to create a new table using CREATE TABLE with JSON column along with its default value.
May
08
2020
The authentication, the first level of security for each IT system, is the stage to verify the user identity through the basic username and password scheme. It is crucial to have a mechanism to protect and secure password storing and transmitting over network.
In MySQL, there is plenty of different authentication methods available, and last versions improved the security of this concept.
At the beginning, the mechanism, called mysql_old_password, was
pretty insecure: it’s based on a broken hashing function and the
password is 16 bytes long. It was not so complex for attackers to
find a plaintext password from the hash stored in the
password column of …
