MySQL Category



MySQL Cluster 7.3 GA released with foreign key support

No Comments »

MySQL 7.3 Cluster has been finally released as a general availability (GA) release. From now on foreign keys are fully supported in MySQL Cluster as well as new NoSQL JavaScript with node.js, Foreign Keys, and Auto-Tuned Clustering features. You can download it freely from mysql.com

Brief info from mysql.com:

MySQL Cluster is a write-scalable, real-time, ACID-compliant transactional database, designed to deliver 99.999% availability. With a distributed, multi-master architecture and no single point of failure, MySQL Cluster scales horizontally on commodity hardware with auto-sharding (partitioning) to serve read and write intensive workloads, accessed via SQL and NoSQL interfaces.

Read the rest of this entry »

Show slave status MySQL user permissions

No Comments »

I had a problem with granting correct MySQL user permissions to our in-house monitoring script. The problem was with MySQL user permissions that checked how many seconds behind the master is our MySQL slave server.

MySQL permissions you will need to set-up for the new user on the slave server are PROCESS and REPLICATION, it should work to execute “show slave status” command:

 

GRANT PROCESS, REPLICATION CLIENT ON dbname.* TO ‘monitoring’@’192.178.2.2’ IDENTIFIED BY ‘PWD_HERE’;

Read the rest of this entry »