New answers tagged

0

RDS will handle replication issue itself that's why AWS made RDS. You focus on your work while AWS takes care of all these stuff (replication, backup, failover etc.) Create read replica of your RDS instance. Read replica is considered as slave while your RDS instance which is your master is called as Primary. If you want to set up slave externally below ...


0

One-liner doing pretty much the same as the awesome pt-show-grants: mysql --skip-column-names -A -e"SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') FROM mysql.user WHERE user<>''" | mysql --skip-column-names -A | sed 's/$/;/g' Based on unix tools only, no additional software needed. Execute from within a bash shell, assumed is you have ...



Top 50 recent answers are included