Install MySQL plugin for Newrelic in a Minute

To use this plugin, you must have: a Java Runtime Environment (JRE) of 1.6 or higher at least one database to monitor (MySQL 5.0 or higher) a New Relic account New Relic Platform Installer (NPI) is a simple, lightweight command line tool that helps you easily download, configure and manage New Relic Platform Plugins Plugin […]

Database Sharding

    “share nonthing” : Key Law on database sharding Architecture. Small Databases are Fast, Big Databases are Slow !!! DB Sharding – Breaking a Bigger DB into a Smaller DB. Key Points on DB Sharding — Partition Data across master Writes and read are distributed Application needs modification Needs choice partitioning strategy for uniform […]

Quick MySQL Commands

To Login into the MySQL #mysql -u username -ppaswword and if its RDS : #mysql -h rds.indexpoint/dnsname/ip -u username -ppassword To List Databases mysql>show databases; To View tables mysql>use databasename; mysql>show tables; To View Contents Inside the Table mysql>select * from tablename; To Delete Database mysql>drop database dbname; To create Database user (we also need […]