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…
— 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. ‘ +…
Amazon DynamoDB Amazon DynamoDB is a fast and flexible NoSQL database service for all applications that need consistent, single-digit millisecond latency at any scale. It is a fully managed database and supports both document and key-value data models. Its flexible…
* ESG Labs Analyst Report http://www.youtube.com/watch?v=Cc1u6FKOqyM&list=TLSKCduSZqcdY * Economical Value Report http://www.actifio.com/resource-center/?show=analyst-reports
[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…
[srinivas@dbversitydotcom ~]$ curl -O http://downloads.mongodb.org/linux/mongodb-linux-x86_64-3.0.1.tgz % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 37.7M 100 37.7M 0 0 12.3M 0 0:00:03 0:00:03 –:–:– 12.3M [srinivas@dbversitydotcom ~]$ [srinivas@dbversitydotcom ~]$ [srinivas@dbversitydotcom…
#!/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…
Capped collections are fixed-size collections that support high-throughput operations that insert and retrieve documents based on insertion order. Capped collections work in a way similar to circular buffers: once a collection fills its allocated space, it makes room for new…
Let’s start with a simple example consisting of four points in a plane. The meaning of the units of the coordinate systems can be whatever you choose: cms, miles, kilometers etc. Now, let us insert these points into a collection…
MongoDB Reference Cards http://info.mongodb.com/rs/mongodb/images/mongodb_qrc_booklet.pdf The Little MongoDB Book (The ultimate Intro to MongoDB) http://openmymind.net/mongodb.pdf FYI … very useful MongoDB & Geospace Index Interactive sessions below. http://mongly.openmymind.net/tutorial/index http://mongly.openmymind.net/geo/index