Replication - LINUX to WIN

--0-1036727360-1268901190=:91967
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hi,
I have done replication with Win to Win servers with mysql version 5.0.41-c=
ommunity-nt.=20

Now,=20
We have Enterprise Linux(Red Hat 4.1.2-14) and windows server2003.
Is it possible do the replication LINUX(Master) to WINDOWS SERVER2003(Slave=
) ?

It will be great help to me.

Thank you.

VIKRAM A
=0A The INTERNET now has a personality. YOURS! See your Yahoo! H=
omepage. http://in.yahoo.com/
--0-1036727360-1268901190=:91967--

Re: Replication - LINUX to WIN

--0016e6475b02330a6604820f1fae
Content-Type: text/plain; charset=ISO-8859-1

Yes, go ahead.

-Krishna

On Thu, Mar 18, 2010 at 2:03 PM, Vikram A wrote:

> Hi,
> I have done replication with Win to Win servers with mysql version
> 5.0.41-community-nt.
>
> Now,
> We have Enterprise Linux(Red Hat 4.1.2-14) and windows server2003.
> Is it possible do the replication LINUX(Master) to WINDOWS
> SERVER2003(Slave) ?
>
> It will be great help to me.
>
> Thank you.
>
> VIKRAM A
>
>
>
> The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
> http://in.yahoo.com/

--0016e6475b02330a6604820f1fae--

Re: Replication - LINUX to WIN

Hi Vikram,

There are a couple of potential problems with Linux to Windows
replication, but they are easily avoidable.

1) Table names: There are case-sensitivity differences between Linux and
Windows: Linux is case-sensitive as regards table names, whereas Windows
is not. Given that you are replicating from a Linux master to a Windows
slave, you shouldn't hit too many problems with this, but if you ever
reverse the order for some reason there could be problems.

2) MySQL versions: try to make sure that you always use the same version
of MySQL on client and slave (this is generally good replication advice
in all cases). There have been some bugs in replication that cause
problems when the master and slave are on different versions.

On Thu, 2010-03-18 at 14:03 +0530, Vikram A wrote:
> Hi,
> I have done replication with Win to Win servers with mysql version 5.0.41-community-nt.
>
> Now,
> We have Enterprise Linux(Red Hat 4.1.2-14) and windows server2003.
> Is it possible do the replication LINUX(Master) to WINDOWS SERVER2003(Slave) ?
>
> It will be great help to me.
>
> Thank you.
>
> VIKRAM A
>
>
>
> The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/


--
Ian Simpson
System Administrator
MyJobGroup


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Replication - LINUX to WIN

--0-1382979092-1268905684=:49481
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hello Ian Simpson,

Thank you for reply. We defined table names, fields in lower cases except t=
he KEYS . I hope the Key will not taken into the account[all in upper case]=
..

Regarding the version we will keep same version as you said.=20

Thank you

--- On Thu, 18/3/10, Ian Simpson wrote:

From: Ian Simpson
Subject: Re: Replication - LINUX to WIN
To: "Vikram A"
Cc: "MY SQL Mailing list"
Date: Thursday, 18 March, 2010, 9:33 AM

Hi Vikram,

There are a couple of potential problems with Linux to Windows
replication, but they are easily avoidable.

1) Table names: There are case-sensitivity differences between Linux and
Windows: Linux is case-sensitive as regards table names, whereas Windows
is not. Given that you are replicating from a Linux master to a Windows
slave, you shouldn't hit too many problems with this, but if you ever
reverse the order for some reason there could be problems.

2) MySQL versions: try to make sure that you always use the same version
of MySQL on client and slave (this is generally good replication advice
in all cases). There have been some bugs in replication that cause
problems when the master and slave are on different versions.

On Thu, 2010-03-18 at 14:03 +0530, Vikram A wrote:
> Hi,
> I have done replication with Win to Win servers with mysql version 5.0.41=
-community-nt.=20
>=20
> Now,=20
> We have Enterprise Linux(Red Hat 4.1.2-14) and windows server2003.
> Is it possible do the replication LINUX(Master) to WINDOWS SERVER2003(Sla=
ve) ?
>=20
> It will be great help to me.
>=20
> Thank you.
>=20
> VIKRAM A
>=20
>=20
>=20
>=A0 =A0   =A0The INTERNET now has a personality. YOURS! See your Yahoo=
! Homepage. http://in.yahoo.com/


--=20
Ian Simpson
System Administrator
MyJobGroup

=0A The INTERNET now has a personality. YOURS! See your Yahoo! H=
omepage. http://in.yahoo.com/
--0-1382979092-1268905684=:49481--

Re: Replication - LINUX to WIN

Hi Vikram,

As far as I know it's just table names: I think it's related to the fact
that the Windows file system is case-insensitive, while Linux
filesystems generally are not.

On Thu, 2010-03-18 at 15:18 +0530, Vikram A wrote:
> Hello Ian Simpson,
>
> Thank you for reply. We defined table names, fields in lower cases
> except the KEYS . I hope the Key will not taken into the account[all
> in upper case].
>
> Regarding the version we will keep same version as you said.
>
> Thank you
>
> --- On Thu, 18/3/10, Ian Simpson wrote:
>
> From: Ian Simpson
> Subject: Re: Replication - LINUX to WIN
> To: "Vikram A"
> Cc: "MY SQL Mailing list"
> Date: Thursday, 18 March, 2010, 9:33 AM
>
> Hi Vikram,
>
> There are a couple of potential problems with Linux to Windows
> replication, but they are easily avoidable.
>
> 1) Table names: There are case-sensitivity differences between
> Linux and
> Windows: Linux is case-sensitive as regards table names,
> whereas Windows
> is not. Given that you are replicating from a Linux master to
> a Windows
> slave, you shouldn't hit too many problems with this, but if
> you ever
> reverse the order for some reason there could be problems.
>
> 2) MySQL versions: try to make sure that you always use the
> same version
> of MySQL on client and slave (this is generally good
> replication advice
> in all cases). There have been some bugs in replication that
> cause
> problems when the master and slave are on different versions.
>
> On Thu, 2010-03-18 at 14:03 +0530, Vikram A wrote:
> > Hi,
> > I have done replication with Win to Win servers with mysql
> version 5.0.41-community-nt.
> >
> > Now,
> > We have Enterprise Linux(Red Hat 4.1.2-14) and windows
> server2003.
> > Is it possible do the replication LINUX(Master) to WINDOWS
> SERVER2003(Slave) ?
> >
> > It will be great help to me.
> >
> > Thank you.
> >
> > VIKRAM A
> >
> >
> >
> > The INTERNET now has a personality. YOURS! See your
> Yahoo! Homepage. http://in.yahoo.com/
>
>
> --
> Ian Simpson
> System Administrator
> MyJobGroup
>
>
>
>
> ____________________________________________________________ __________
> The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.


--
Ian Simpson
System Administrator
MyJobGroup


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org