The purpose of this post if to show how you can automate the
creation and pruning of partitioned tables. If you want to read
about partitioning I recommend reading our manual.
In short partitioning makes it possible to spread
your individual tables across a file system according to the
partition rules you specify.
Reasons for partition your tables might be:
- Insert performance, smaller index trees for stable insert
throughput.
- Select performance, only read data from selected (aka
partitioning pruning) partitions.
- Delete performance, drop partitioning is must quicker than
doing range deletes of old data.
Partitioning definitions is part for the CREATE/ALTER table
statements, in …
This week MySQL turns 25 - - - on May 23rd to be exact. Join us in celebrating 25 years of great success.
Early on MySQL became the “M” in the LAMP stack that powered the open source revolution. It became and continues to be the most popular open source database. Early this year it earned the DB-Engine award for most popular database.
The most successful applications and websites we all know and use today, such as Twitter, Facebook, Booking but also Uber, Airbnb and many more, started with MySQL, grew up with MySQL and now scale with MySQL.
Over the years it has become the database of choice for many of the most successful open source applications like WordPress, Drupal, Joomla, Magento, and many more.
It has always been ranked the developers’ favorite …
[Read more]This week MySQL turns 25 - - - on May 23rd to be exact. Join us in celebrating 25 years of great success. Early on MySQL became the “M” in the LAMP stack that powered the open source revolution. It became and continues to be the most popular open source database. Early this year it earned the DB-Eng...
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.
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 …
[Read more]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 …
[Read more]
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:-
- 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 …