When we delete or change a record from the parent table, we encounter a deadlock. It causes locks to be placed on the child’s table to prevent orphan records. As a result, we must first alter data in the child table. When the SQL Server executes a query in parallel mode, multiple threads are created….
If you’re getting DB2 SQL Error SQLCODE 551 SQLSTATE 42501, chances are your user account doesn’t have the required privilege. Perhaps, you use a different user account from other clients. So, try to grant access to the account you’re using to run the query. The actual error message here is the SQLCODE -551, which corresponds…
In the digital age, data has emerged as a valuable resource driving innovation, decision-making, and business success. Data scalability is crucial for organizations to handle an increasing amount of data without compromising its performance and efficiency. However, not all data systems can effectively handle scalability demands. Several toxic elements can negatively impact data scalability as…
You may already know that when the mysqldump client utility performs logical backups, it produces a set of SQL statements that you can execute to reproduce the original database object definitions and table data. Although it dumps one or more MySQL databases for backup or transfer to another SQL server, there are 5 things that…
Autoscaling your webserver tier is typically straightforward. Image your Apache server with source code or without, then sync down files from S3 upon spinup. Roll that image into the autoscale configuration and you’re all set.With the database tier though, things can be a bit tricky. The typical configuration we see is to have a single…
Often when we think about speeding up and scaling, we focus on the application layer itself. We look at the web server tier, and database tier, and optimize the most resource-intensive pages. There’s much more we can do to speed things up if we only turn over the right stones. Whether you’re using WordPress or…
Today part of Amazon Web Services failed, taking down with it a slew of startups that all run on Amazon’s Cloud infrastructure. Airbnb was one of the biggest, but also Heroku, Reddit, Minecraft, Flipboard & Coursera were down with it. As it’s, you might think what the heck happened, and why should we care? Well, this…
As the number of mobile users and the complexity of mobile applications are constantly growing, one critical aspect that app developers and businesses must consider is “Mobile Scalability”. Mobile scalability refers to the ability of a mobile application or system to handle a growing number of users and increase data volumes without losing its performance…
If you’re headhunting a cloud computing expert, specifically someone who knows Amazon Web Services (AWS) and EC2, you’ll want to have a battery of questions to ask them to assess their knowledge. As with any technical interview focus on concepts and the big picture. As the 37Signals folks like to say “hire for attitude, train for skill”. Absolutely!…
Larry Summers, Director of the White House’s National Economic Council coined the phrase “preserving optionality” back when he was deputy secretary of the treasury under Robert Rubin in the Clinton administration. It was meant to describe a strategy of keeping options open and fluid, fighting the urge to make choices too soon, before all of…