November 2020
« Apr    

MySQL : How to create multiple root user (Super admin)

I have a situation to create multiple root users for managing a large Database. I used to execute ‘ grant all *. user@localhost identified by ‘password’ ” to create super users earlier. But I realized that these users can’t alter the existing users permission set even though they can create same privilege set users.

Knowing […]

Nagios : How do I monitor Amazon RDS MySQL server

One of the recent requirement which I had ask to do was to setup some mechanism to monitor the MySQL RDS server where we do not have limited access towards the resources statistics and utilization.

Found that Percona has developed a tool for monitoring MySQL RDS Activities including RAM,Load and Disk utilization. One thing […]

Amazon RDS : Trigger Error – You might want to use the less safe log_bin_trust_function_creators variable

While I’m trying to execute triggers to a RDS Mysql database I got the following errors

ERROR 1419 (HY000) at line #: You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable).

I’m using the SUPER root account which will create at […]

AWS : Streaming Project [Adobe FMS server] Network Diagram


I’m sharing the network diagram of a streaming Project which I had wored recently using Adobe AWS streaming service. We uses auto-scale enabled EC2 instance and all the videos (both uploaded and recorded) are moved back to Adobe FMS dedicated server(x1.large). Pls note that we have customized the adobe FMS server which subscribed […]

mysqldump: Got error: 1556: You can’t use locks with log tables

I got the mysql error 1556 when I was backing up all the database from a remote mysql server (Amazon RDS )using a script.

mysqldump: Got error: 1556: You can’t use locks with log tables. when using LOCK TABLES

Solution :

You may need to disable “–lock-tables” option on your dump statement ie –lock-tables=0 […]

Amazon RDS : – How to change the mysql variables

I have asked to try AWS RDS feature for one of our heavily traffic web site. As per RDS planning and designing, it’s looks great features of managing someone who doesn’t any idea about databases. They are providing time based backup and restoration.

Here I’m listing out some of my findings


1. […]