Question: I have the same exact problem that's in this [question](https://stackoverflow.com/questions/5070237/problemas-com-parse-xml-iphone), but it didn't get any good answers.

I'm trying to parse an XML file with an `ISO-8859-1` encoding, but everytime there's an accentuated word, it gets truncated and doesn't show properly.

```
Example: 

Original Word: Interés 

Word Shown: és

```

Answer: 
* Using MySQL replication.
* using active-pasive with [rdbd](http://www.drbd.org/) + [heartbeat](http://linux-ha.org/wiki/Heartbeat)

In any case you would need use DNS to automatically update the IP or VIP
We did this once with 6 mysql servers doing replication in a circular chain. The replication chain was:

```
A -> B -> C -> D -> E -> F -> A

```

When a failover was detected the master was moved from A to B (an so forth) - DNS was updated for the master - but reads where taken from random member of the chain.