Highly Scalable Fault Tolerant Scalable Systems Considertions

Highly Scalable Fault Tolerant Scalable Systems Considertions: Dr Tanenbaum on Fault Tolerant Operating Systems. https://en.wikipedia.org/wiki/Andrew_S._Tanenbaum Murphys Law: https://en.wikipedia.org/wiki/Edward_A._Murphy,_Jr. https://en.wikipedia.org/wiki/Murphy%27s_law If there’s more than one possible outcome of a job or tasks and one of those outcome will result in disaster or an undesirable consequence , …

MySQL Ramp Up

MYSQL: Add Column to Existing Table and Make it Auto Increment and Add Primary Key Constraint Link : Alter Table and Add Column ALTER TABLE StudentPortalData ADD StudentPortalDataID INT UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (StudentPortalDataID); Query Plan and Query Profile for Executed Queries …

Apache Drill Setup and Usuage

Apache Drill Setup and Usuage: Install and Configure Apache Drill http://drill.apache.org/docs/installing-drill-on-windows/ sqlline> !connect “jdbc:drill:zk=local” Enter username for jdbc:drill:zk=local: admin Enter password for jdbc:drill:zk=local: ***** http://localhost:8047/ SELECT derivedtable.ItemID ,AVG( CAST (derivedtable.TimeSpent AS INTEGER)) AvgTimeSpent FROM ( SELECT rawresponsetime.Time10.`id` ItemID ,rawresponsetime.Time10.`value` `TimeSpent` FROM ( SELECT (flatten(`time`)) `Time10`, …