Untitled
unknown
plain_text
2 years ago
1.9 kB
7
Indexable
.yaml
dbName: 'auroraperf'
dbPassword: 'rdsbmsperf'
dbUser: 'rdsbmsperf'
enablePerformanceInsights: true
collectRdsMetrics: true
monitoringInterval: 60
accountId: "009703923026"
action: "customperf"
resumeOnFailures: 0
extraParams:
dbClusterExtraParams:
encrypted: true
get-engine-commit.sh
engine_public_version="$(/rdsdbbin/oscar/bin/mysql -u rdsbmsperf -p auroraperf -e "SELECT aurora_version();" -prdsbmsperf | grep -P '[\d.]+')"
MySQL_grep=$(echo $(strings /rdsdbbin/oscar/bin/mysqld | grep 'git-head' -m1))
engine_internal_version=$(echo $MySQL_grep | grep -P 'OscarMysql[\d]+-[\d.]+' -o | grep -P '[\d.]+')
engine_build_time=$(echo $MySQL_grep | grep -P '\d{4}-\d{2}-\d{2}T\d{2}:\d{2}:\d{2}UTC' -o)
engine_git_commit=$(echo $MySQL_grep | grep -P '[\w\d]{40}' -o -m1)
echo "engine_public_version: $engine_public_version engine_internal_version: $engine_internal_version engine_build_time: $engine_build_time engine_git_commit: $engine_git_commit"
Output:
engine_public_version: engine_internal_version: OscarMysql80-1.0.48962.0 engine_build_time: 2024-01-18T05:05:08UTC engine_git_commit: 7e180c7ea763389d4c605aac1edec7746e0f97f5
Now when I change the .yaml code to
dbName: 'rdsmbmsperf'
dbPassword: 'rdsbmsperf'
dbUser: 'rdsbmsperf'
enablePerformanceInsights: true
collectRdsMetrics: true
monitoringInterval: 60
accountId: "009703923026"
action: "customperf"
resumeOnFailures: 0
extraParams:
dbClusterExtraParams:
encrypted: true
Output:
ERROR 1049 (42000): Unknown database 'auroraperf'
engine_public_version: engine_internal_version: OscarMysql80-1.0.48962.0 engine_build_time: 2024-01-18T05:05:08UTC engine_git_commit: 7e180c7ea763389d4c605aac1edec7746e0f97f5
I want the get-engine-commit.sh to work with this dbName too which is 'rdsbmsperf' as it exists
Editor is loading...
Leave a Comment