When mysql ruinned by Disaster

[MaFai]

--=====000_Dragon621152387636_=====
Content-Type: text/plain;
charset="big5"
Content-Transfer-Encoding: 7bit

Hello, mysql,

We have 1 master and salve in my lan.

If the master failed,coze the unrecoverable disaster.

At that time,I want to make the slave to be the master instead of the orginial one.

Do you agree my following step?

0.Stop slave.

1.All java program operating database should redirect to the new master mysql which it acts as slave before the master failed..

2.Copy the new master data to the third computer,and make the third mysql replicate the new master.

3.Start replicate

But the ip address would change too.It seems hard to slove this,if I doesn't reset the dns.

Any idea would be applicated.


Best regards.

MaFai
zh***@hkbn.com.hk
2003-07-29
--=====000_Dragon621152387636_=====
Content-Type: text/plain; charset=us-ascii

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw
--=====000_Dragon621152387636_=====--