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_VERSION is not set #2768
• Several new automated …

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 …

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.

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 …

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. …

Introduction  To upgrade MySQL versions  we can use below method:-

1. 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. 
2. 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 …

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. …

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).
…

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 …

MySQL8.0: Performance Improvement with new features INSTANT ADD Column         Abstract- Flexible and dynamic concepts can help to balance maintainability and complexity. With ever bigger and growing dataset, the ability to do DDL instantly will help developers to scale more complex RDBMS solutions. In this paper, we outline performance measurements of various options of ALTER TABLE algorithm-COPY, INPLACE, INSTANT. We describe the definition of concept, advantages, and limitations and how it is value add on current business cases based on existing performance test.

                                                                          …