Building Reliable

Reliable software and Accurate data
are fundamentals of a successful business

September 6, 2018

Securing MicroServices

With migration to MicroServices architecture, it is extremely critical for us to control which user/service has access to which other services and which actions are permitted or should be denied.

April 25, 2017

Business value of Polyglot programming

When facing a technical problem, being technology agnostic enables you to pick the best tool for the job. You can also break a problem in to several smaller components and pick the best suitable technology for each.

March 12, 2012

MySQL Memory engine index

By default, Memory Engine uses Hash index type to index the table, which will make it pretty much unusable and very slow performer for prefix matches and range look-ups.

January 25, 2012

MySQL synchronous vs. asynchronous replication

When it comes to choose your MySQL replication setup you have the choice between Asynchronous replication or Semi-Synchronous replication.The way these two differ is interesting and would be very useful when you are choosing your architecture.

October 6, 2011

Determine MySQL table’s primary key dynamically

You may have been in a situation which you may need to figure out what is the PRIMARY key field of a given table. Or even if it is a compound key what are the columns building the PRIMARY key. This usually helps a lot when you’re making some generic tools to do some jobs on a given table.

July 5, 2011

MySQL triggers ; error 1442

MySQL Trigger is a powerful tool to provide the data consistency and accuracy among your tables or Database in general. The only disadvantage among Triggers is that they’re not able to update the same table they’re based on.

May 17, 2011

MySQL federated tables

MySQL FEDERATED Table is a proxy to a regular table located in another DB server. You will see the table as a local table while it’s being located in another MySQL Database Server.