DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]tomdelonge[/eluser]
@overzealous

I'm having troubles understanding how it could be handled by a library. My understanding is that with mysql, if you've got replication working, then there's a master database and several slave databases.

All write queries should go to the master and all read queries should come from the slaves.

These databases are on different servers. In codeigniter, in the config file called database.php, when you set up a connection you choose a hostname. Is that just supposed to be the master database? And if so, does mysql just reroute read queries and write queries accordingly? I guess I'm hoping that's the case (it'd be simplest from a development perspective), but I wouldn't have imagined that.

Am I understanding this correctly?