Showing entries 3076 to 3085 of 44047
« 10 Newer Entries | 10 Older Entries »
Automate MySQL Partitioning using events and procedures


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 …

[Read more]
Celebrating MySQL 25th Anniversary!

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]
Celebrating MySQL 25th Anniversary!

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

MySQL Security – Dual Password Support

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.

Releasing ProxySQL 2.0.12

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 …
[Read more]
Percona XtraDB Cluster 8.0 Behavior Change for pxc-encrypt-cluster-traffic

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]
Dynamic Image Gallery Using PHP 7 & MySQLi

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.

Using MySQL Enterprise Audit Filtering for only Insert/Update/Delete statements for Users


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

[Read more]
Step by Step INPLACE Upgrade from MySQL 5.7 to MySQL 8.0.13 using Upgrade Checker




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 …

[Read more]
Showing entries 3076 to 3085 of 44047
« 10 Newer Entries | 10 Older Entries »