Replication testing?
am 01.06.2010 08:34:43 von machielr------=_NextPart_000_0057_01CB0165.4AFF6F90
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0058_01CB0165.4AFF96A0"
------=_NextPart_001_0058_01CB0165.4AFF96A0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hi All
One of the managers requested me to find out about the
replication testing on MySQL as one of our clients need this to be done
soon.
Basically what they want to do is the following:
.. Currently a master slave replication is in place.
.. Testing will entail the following:
o Stop master database
o Switch over to Slave database and confirm everything is working as
should and all Data is available.
o Switch back to master database after it has been restored
o Confirm that all is working again and that all data are available on
both databases.
I am not yet to this part of my studying as I am fairly new to MySQL and I
am hoping someone can perhaps provide me with some info / resources on where
to get this info from.
Machiel Richards
MySQL DBA
Relational Database Consulting
RDC_Logo
------=_NextPart_001_0058_01CB0165.4AFF96A0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
charset=3Dus-ascii">
Hi All
class=3DMsoNormal> &=
nbsp; One of the managers requested me to =
find out
about the replication testing on MySQL as one of our clients need this =
to be
done soon.
class=3DMsoNormal> &=
nbsp; Basically what they want to do is =
the
following:
style=3D'margin-left:72.0pt;text-indent:-18.0pt;
mso-list:l0 level1 lfo1'> style=3D'font-family:Symbol'>
Currently a master =
slave
replication is in place.
style=3D'margin-left:72.0pt;text-indent:-18.0pt;
mso-list:l0 level1 lfo1'> style=3D'font-family:Symbol'>
Testing will =
entail the
following:
style=3D'margin-left:108.0pt;text-indent:-18.0pt;
mso-list:l0 level2 lfo1'> style=3D'font-family:"Courier New"'>
Stop master =
database
style=3D'margin-left:108.0pt;text-indent:-18.0pt;
mso-list:l0 level2 lfo1'> style=3D'font-family:"Courier New"'>
Switch over to =
Slave
database and confirm everything is working as should and all Data is =
available.
style=3D'margin-left:108.0pt;text-indent:-18.0pt;
mso-list:l0 level2 lfo1'> style=3D'font-family:"Courier New"'>
Switch back to =
master
database after it has been restored
style=3D'margin-left:108.0pt;text-indent:-18.0pt;
mso-list:l0 level2 lfo1'> style=3D'font-family:"Courier New"'>
Confirm that all =
is working
again and that all data are available on both databases.
I am not yet to this =
part of my
studying as I am fairly new to MySQL and I am hoping someone can perhaps
provide me with some info / resources on where to get this info =
from.
Machiel =
Richards
MySQL =
DBA
MS"'>Relational
Database Consulting
id=3D"Picture_x0020_1"
src=3D"cid:image001.jpg@01CB0165.471CB720" =
alt=3D"RDC_Logo">
------=_NextPart_001_0058_01CB0165.4AFF96A0--
------=_NextPart_000_0057_01CB0165.4AFF6F90--