MySQL Cluster / NDB & MyISAM mix

Hi guys.

Ok lets say i've 2 server running MySQL, NDB node and NDB manager on each.
Now I don't want to convert all tables to NDB instead I leave a few as
MyISAM.
Is it officially supported if I setup a master-master replication between
the two MySQL instances and add ignore entries for all NDB tables?

So basically I would convert all important tables to NDB and leave other
tables as MyISAM, but they would still be 'synced' via replication.

I've tested it and it look like it works... but... does it work by
coincidence? :)


Thanks, chris


--
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: MySQL Cluster / NDB & MyISAM mix

I can think of no reason why this shouldn't work, My administrator
colleagues would probably beat me with 2x4's for handing them such a
delicate construct to maintain in production but it seems perfectly
feasible to me :-)

- michael dykman

On Wed, Oct 14, 2009 at 11:03 AM, Christian Meisinger
wrote:
> Hi guys.
>
> Ok lets say i've 2 server running MySQL, NDB node and NDB manager on each=
..
> Now I don't want to convert all tables to NDB instead I leave a few as
> MyISAM.
> Is it officially supported if I setup a master-master replication between
> the two MySQL instances and add ignore entries for all NDB tables?
>
> So basically I would convert all important tables to NDB and leave other
> tables as MyISAM, but they would still be 'synced' via replication.
>
> I've tested it and it look like it works... but... does it work by
> coincidence? :)
>
>
> Thanks, chris
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail=
..com
>
>



--=20
- michael dykman
- mdykman@gmail.com

Don=92t worry about people stealing your ideas. If they=92re any good,
you=92ll have to ram them down their throats!

Howard Aiken

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

RE: MySQL Cluster / NDB & MyISAM mix

Thanks.

Yes it's a delicate construct but tables like 'IP2Location' give me a
headache as NDB tables.
Yet I have to test if 7.0.X can handle it.


-----Original Message-----
From: Michael Dykman [mailto:mdykman@gmail.com]=20
Sent: Mittwoch, 14. Oktober 2009 17:33
To: Christian Meisinger
Cc: mysql@lists.mysql.com
Subject: Re: MySQL Cluster / NDB & MyISAM mix

I can think of no reason why this shouldn't work, My administrator
colleagues would probably beat me with 2x4's for handing them such a
delicate construct to maintain in production but it seems perfectly
feasible to me :-)

- michael dykman

On Wed, Oct 14, 2009 at 11:03 AM, Christian Meisinger
wrote:
> Hi guys.
>
> Ok lets say i've 2 server running MySQL, NDB node and NDB manager on =
each.
> Now I don't want to convert all tables to NDB instead I leave a few as
> MyISAM.
> Is it officially supported if I setup a master-master replication =
between
> the two MySQL instances and add ignore entries for all NDB tables?
>
> So basically I would convert all important tables to NDB and leave =
other
> tables as MyISAM, but they would still be 'synced' via replication.
>
> I've tested it and it look like it works... but... does it work by
> coincidence? :)
>
>
> Thanks, chris
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =
=A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail.com
>
>



--=20
- michael dykman
- mdykman@gmail.com

Don=92t worry about people stealing your ideas. If they=92re any good,
you=92ll have to ram them down their throats!

Howard Aiken


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