What is AuroraDB ?
Amazon Aurora is a fully-managed, MySQL-compatible, relational database engine that combines the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. It delivers up to five times the performance of MySQL without requiring changes…
[MySQL]: SQL script to list MyISAM & innodb_file_per_tables
— It needs to be run from an account that has read permission for the INFORMATION_SCHEMA database. select msg as `==> Checking current version of MySQL.` from ( select ‘This script should be run on MySQL version 5.6. ‘ +…
[MariaDB]: Installation on Amazon EC2 machine
[srinivas@dbversity.com ~]$ sudo yum install mariadb-server mariadb Loaded plugins: amazon-id, rhui-lb Package 1:mariadb-5.5.41-2.el7_0.x86_64 already installed and latest version Resolving Dependencies –> Running transaction check —> Package mariadb-server.x86_64 1:5.5.41-2.el7_0 will be installed –> Processing Dependency: perl-DBI for package: 1:mariadb-server-5.5.41-2.el7_0.x86_64 –> Processing…
[MySQL]: Long running query stopper shell script & alerting mechanism
#!/bin/bash > /home/srinivas/MySQL_Long_Query_Kill.log RECIPIENT=srinivas@dbversity.com,santhosh@dbversity.com RECIPIENTCC=test@dbversity.com RECIPIENTBCC=dbversity@gmail.com SEC=700 IFS=’|’ if [[ $SEC -lt 700 ]]; then echo “Usage: All the MySQL queries are less than $SEC seconds, So no MySQL process to Kill ….” exit 1 fi mysqladmin proc -v|grep Query|grep…
AuroraDB – 5x better performance than standard MYSQL
Aurora on Amazon RDS Amazon Aurora is a fully-managed, MySQL-compatible, relational database engine that combines the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. It delivers up to five times the performance…
Difference between MySQL INT(1) or INT(10) .. etc
I know im not alone in thinking that it affected the size of the data field. An unsigned int has the max value of 4294967295 no matter if its INT(1) or int(10) and will use 4 bytes of data. …
[PostgreSQL]: Write-Ahead Logging (WAL)
Write-Ahead Logging (WAL) Write-Ahead Logging (WAL) is a standard method for ensuring data integrity. A detailed description can be found in most (if not all) books about transaction processing. Briefly, WAL‘s central concept is that changes to data files (where…
10 Reasons PostgreSQL is Better Than SQL Server
Why would anyone want to use PostgreSQL instead of SQL Server? There are a lot of factors to consider when choosing how to store your data. Sometimes we need to look deeper than the standard choice and consider something new….
SQL or NoSQL? … Both with MariaDB 10
Dynamic columns came to my attention a few days back. Since then I read a little bit more in the documentation (see Dynamic columns in the Knowledge Base) and played with it a little. The reason I became curious was…
[MySQL]: Top MySQL DBA Interview questions
The first questions I would ask when interviewing a potential DBA would be one that would help me find out about his/her skills and in particular if they are aware of MySQL specific idiosyncrasies. Instead of asking about specific query,…