Tweet !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=”//platform.twitter.com/widgets.js”;fjs.parentNode.insertBefore(js,fjs);}}(document,”script”,”twitter-wjs”); Despite the fact that it has become a laughingstock and cautionary tale among the digital elite, Yahoo’s properties are still visited by some 700 million normal people a month. 700 million! This humongous audience is attracted by several things: Yahoo Mail (still one of the leading mail platforms worldwide) Yahoo content (Finance, [...]

Tweet !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=”//platform.twitter.com/widgets.js”;fjs.parentNode.insertBefore(js,fjs);}}(document,”script”,”twitter-wjs”); Replication can allow you to take advantage of multiple storage engines for a single table ordatabase. What does that mean? With replication it’s possible to use one table type on themaster and another table type on the slave. Perhaps you want to have foreign keys, which areonly allowed using the InnoDB and [...]

Tweet !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=”//platform.twitter.com/widgets.js”;fjs.parentNode.insertBefore(js,fjs);}}(document,”script”,”twitter-wjs”); A replicated database is an excellent way to provide redundancy and high availability. Havingone or more slave databases running all the time means that you can roll onto one of the slaveservers in the instance of a machine failure or disaster. You can do the switch manually, or youcan program the application [...]

Tweet !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=”//platform.twitter.com/widgets.js”;fjs.parentNode.insertBefore(js,fjs);}}(document,”script”,”twitter-wjs”); MySQL’s replication falls on the simpler end of the spectrum, and doesn’t provide datamerging in its replication feature. Data is replicated to read-only servers. If changes are made in the replicated data, they aren’t replicated back to the master. More informationabout enabling merge replication in MySQL is available at http://dev.mysql.com/books/hpmysql-excerpts/ch07.html#hpmysql-CHP-7-SECT-7.3.

Tweet !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=”//platform.twitter.com/widgets.js”;fjs.parentNode.insertBefore(js,fjs);}}(document,”script”,”twitter-wjs”); With asynchronous replication, the replicated databases are always some amount oftime behind the primary database. The amount of time depends on numerous factors: how frequently the replication process grabs updates, how much data must be transferred to the replicated systems, and how fast the network will allow the data to move between [...]