mysql replication

This morning Emilio and me have been playing with mysql 4.0.x replication capabilities. It’s incredible what can be done with this feature. We’ve tested the most simple way: a master and a slave. So, when you update, insert on the master, the slave is automagically updated too. You could be thinking… what happens if the server breaks down? well, the slave is there for you to be alive. And what if the slave breaks down? Then, the master keeps all updates in a binary file, and when the slave gets back, it AUTOMATICALLY receives all updates from master, and the life goes on🙂.

There are lot of possibilities to replicate data through a “computer farm”, but perhaps wait for mysql Cluster technology is worthy, so we can have balanced load as well as reliability.

6 comentarios en “mysql replication

  1. There is always a realistic way to fulfill any dream. There has never been a dream that you can’t have–at least, not the heart of it, not the part you love the most.

Responder

Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de WordPress.com

Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión / Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión / Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión / Cambiar )

Google+ photo

Estás comentando usando tu cuenta de Google+. Cerrar sesión / Cambiar )

Conectando a %s