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.
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 [...]
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 [...]
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 [...]
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
You may need to disable “–lock-tables” option on your dump statement ie –lock-tables=0 [...]
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