There are two simple ways to backup only the users and privileges in MySQL: 1- Using mysqlpump utility (as create user and grant statements): [shell
Category: Top MySQL News
Category Added in a WPeMatico Campaign
Backing up users and privileges in MySQL
There are two simple ways to backup only the users and privileges in MySQL: 1- Using mysqlpump utility (as create user and grant statements): [shell
Handy stored procedure for regular DBA tasks
As a stored procedures fan, I use MySQL stored procedures to get some of my DBA tasks accomplished. To make it simple, I have a template
Replication filter per channel is now available in MySQL!
On the same day last year, I wrote a post about replication filters in MySQL Multi Source Replication and whether we can set the filters per
Handy stored procedure for regular DBA tasks
As a stored procedures fan, I use MySQL stored procedures to get some of my DBA tasks accomplished. To make it simple, I have a template
What is the default sharding key in MySQL Cluster?
MySQL Cluster does an automatic sharding/partitioning to the tables across data nodes, enabling databases to scale horizontally to serve read and write-intensive workloads, but what
Replication filter per channel is now available in MySQL!
On the same day last year, I wrote a post about replication filters in MySQL Multi Source Replication and whether we can set the filters per
Partitions number in MySQL Cluster
As stated in the MySQL Cluster documentation: Partition. This is a portion of the data stored by the cluster. There are as many cluster partitions
What is the default sharding key in MySQL Cluster?
MySQL Cluster does an automatic sharding/partitioning to the tables across data nodes, enabling databases to scale horizontally to serve read and write-intensive workloads, but what
Partitions number in MySQL Cluster
As stated in the MySQL Cluster documentation: Partition. This is a portion of the data stored by the cluster. There are as many cluster partitions