Dual-password capability makes it possible to seamlessly perform credential changes without downtime.
The post MySQL Security - Dual Password Support first appeared on dasini.net - Diary of a MySQL expert.
May
19
2020
May
19
2020
ProxySQL is proud to announce the fast track release of the latest stable version of ProxySQL 2.0.12 on 18th of May 2020
ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded here or alternatively from the ProxySQL Repository, and freely usable and accessible according to the GNU GPL v3.0 license.
Release Overview Highlights Enhancements
- Added tracking capability for variable
group_concat_max_len#2709 - Do not compile if
GIT_VERSIONis not set #2768 - Several new automated …
May
18
2020
Percona has enforced stronger security in Percona XtraDB Cluster (PXC) 8, but this requires some attention during the rollout of the new server version, so let see the why and what.
In PXC there are two different kinds of traffic: client-server exchange (ie: application traffic), and replication traffic. The latter refers to any SST/IST, write-set, and other service messages the nodes exchange.
In PXC 5.7 it is possible to activate SSL encryption by enabling the variable pxc-encrypt-cluster-traffic by following the instructions.
In PXC 8, we choose to enable encryption by default on all replication traffic, to have the highest out-of-box security enforcement.
While this is an obvious …
[Read more]
May
17
2020
This tutorial help to create dynamic image gallery using PHP and MySQL.The image upload and listing is very common functionality for web application.I have already shared Image Crop Functionality In Model Box Using PHP tutorial. I am extending my previous above tutorial and added image listing and gallery functionality.I have also added view image into […]
The post Dynamic Image Gallery Using PHP 7 & MySQLi appeared first on Phpflow.com.
May
16
2020
How to Audit only DML Actions ?
Step by step to
Enable Fine Grained MySQL Auditing for Insert/Update/Delete
Queries for all Users.
Before i talk about MySQL Audit Filtering , it is more important
to know below details:-
- What is MySQL Enterprise Audit ?
- Features of MySQL Audit.
- Why Audit is Important?
- How to Audit only DML statements for Particular/All Users ?
- Audit Log Restrictions
- Conclusions
What is MySQL Enterprise Audit? At high level, database auditing is the process to guard against misuse of information, track the use of database resources and activity like -Who accessed the database(Users) - Where these queries has been executed(Host Name). -What kind of queries has been executed to db(events/statements). -When did this happened(Time) Then we can have idea of “Why this …
[Read more]
May
16
2020
How to Install MySQL Enterprise Edition on Docker and Monitor it with MySQL Enterprise Monitor(MEM)?
Introduction Before I talk about installation of MySQL inside
docker, it's more important to know
what is Docker?
- Docker
is a tool designed to create , deploy ,and run an application any
where.
-It allow us to package up application with all requirements such
as libraries and other dependencies and ship it all as a
PACKAGE.
who uses Docker?
Developer : Docker enables developer to develop application
without spending much time on IT infrastructure.
Sysadmin :-Docker enables sysadmin to streamline the
software delivery, such as develop and deploy bug fixes and new
features without any roadblock.
Enterprise :-Docker works in the cloud , on premise ,and
supports both traditional and micro services deployments.
why Docker?
-Easily adapts to your working environment. …
May
16
2020
Introduction To upgrade MySQL versions we can
use below method:-
- INPLACE Upgrade :- It involves shutting down MySQL 5.7 server,replacing the old binaries with MySQL 8.0 binaries and then starting the MySQL 8.0 server on the old data directory.
- LOGICAL Upgrade:- It involves exporting SQL from MySQL 5.7 version using backup utility such as mysqldump or mysqlpump , installing the MySQL 8.0 binaries and then applying the SQL to the new version.
Before start upgrading the MySQL versions it is recommended to
have deeper analysis by visiting MySQL Documentation page.
Upgrading MySQL :- https://dev.mysql.com/doc/refman/8.0/en/upgrading.html
What is MySQL Upgrade Checker? Utility to check MySQL 5.7
server instances for compatibility errors and …
May
16
2020
Glimpse of MySQL Enterprise Data Masking
Abstract- Many organizational production
environment unwittingly breach sensitive information which causes
harm of reputation, brand name and million of dollar losses etc.
hence database environments will require some form of
sanitization in order to render the informational content
anonymous. In this paper, we outline research towards a business
challenge-why mask your data and the business value- benefits of
masked data. We describe a definition of concept, performance
measurements of sql query with/without masked data and limitation
of data masking with current release of MySQL. …
May
16
2020
Introduction MySQL offers two types of clustering solution for
managing Read/Write intensive workloads , ensuring Rock Solid
Availability. 1.MySQL InnoDB Cluster
2. MySQL NDB Cluster Glimpse of MySQL InnoDB Cluster
This Cluster is designed for users that uses MySQL
Server with InnoDB storage engine. It will serve as
a natural extension for users currently using MySQL Replication
with InnoDB to a new replication
architecture i.e Clustering on top of Group Replication. MySQL
InnoDB Cluster = MySQL Server + MySQL Shell + MySQL Router. MySQL
Server
- Group Replication Technology.
- Single-Primary /Multi-Primary Mode.
- Fault Tolerance.
- Conflict detection and resolution.
- Automatic distributed recovery.
MySQL Shell
- Multi-Language(Python , Java script , SQL). …
May
16
2020
How to Deploy MySQL InnoDB Replica Set in Production? Before i
talk about Deployment process of MySQL InnoDB Replica Set , it is
more important to know below details:-
- What is MySQL InnoDB Replica Set?
- What is prerequisite and limitation of using MySQL Replica Set?
- In what kind of scenarios MySQL Replica Set is not recommended.
- How to configure and deploy MySQL Replica Set- (step by step guide )
- How to use InnoDB Replica Set?
- What if Primary goes down? Does select query re-routed to another server?
- What if Secondary goes down while executing select queries?
§ I will answer these all question in
this blog. What is Replica Set ? MySQL InnoDB
ReplicaSet a quick and easy way to get MySQL
replication(Master-Slave), making it well suited to scaling out
reads, and …