[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…
[MongoDB]: 3.0 Installation
[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…
[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…
[MongoDB]: Capped Collection
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…
[MongoDB]: Geospatial Index
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]: Useful books & Interactive session urls
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
What is MongoDB ? Beautiful video !
https://www.youtube.com/watch?v=CvIr-2lMLsk
[Linux]: Bulk user creation script
[root@myhostname ~]# cat usercreation_script.sh #!/bin/bash # shell script to add a users to Linux server ## checking for highest volume partition on the server to create user’s home directory partition=`df -h | awk {‘print $4 ” ” $6 ‘} |…
MongoDB 3.0
Today MongoDB Inc is announcing the general availability of MongoDB 3.0. You can download here: www.mongodb.com/subscription/downloads MongoDB 3.0 expands the use cases for MongoDB by introducing a new pluggable storage engine architecture. A new storage engine, called WiredTiger, provides significantly improved…