As you may know, I started working with high load MySQL servers in 2010 (and then there are several entries that were noted in 2012 after I purchased back this domain :-D) and I mostly go with multi-slaves replications. These might be true in many practical cases where most of […]
First, we must keep in mind that the SaaS application architecture must support multi-tenant from beginning, otherwise we will struggle with scaling the application in the future. Application architecture level We must consider careful which is needed to separate: application, database, or what other else? It should use the same […]
When designing the scalable systems which can run on multiple nodes, one common problem to face is how to deal with scheduled tasks which must be run on one instance, not in multiple instances. When checking the AWS architecture for a team working on AWS, I found a problem of […]
This article was original written by By Eli White and was published at http://www.oracle.com/technetwork/articles/dsl/white-php-part2-355138.html. This includes tips for scaling your PHP-MySQL Web app based on real-world experiences at Digg, TripAdvisor, and other high-traffic sites. In Part 1 of this article, I explained the basic steps to move your application from a single server to […]
This article was original written by By Eli White and was published at http://www.oracle.com/technetwork/articles/dsl/white-php-part1-355135.html. This includes tips for scaling your PHP-MySQL Web app based on real-world experiences at Digg, TripAdvisor, and other high-traffic sites. Creating a Web application – actually writing the core code – is often the initial focus of a project. […]
Whenever analysts or journalists assemble lists of the top trends for this year, “big data” is almost certain to be on the list. While the catchphrase is fairly new, in one sense, big data isn’t really a new concept. Computers have always worked with large and growing sets of data, […]
This post explains how to add a new slave to the existing MySQL replication. New slave server can be added to the MySQL replication without stopping master or shutting down existing slave server. You will have to temporarily stop replication on the slave server in order to take the current […]
This tutorial describes how to setup MySQL replication. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that […]
