There is no problem mirroring databases between innoDB and MyISAM because all the really happens is that the slave runs the same queries as the master does.
When replicating from innodb to MyISAM you will have no problem at all and you often gain some speed, which means that you have the safety of innodb in the background and the speed of selectqueries on MyISAM tables for your users. If you want to replicate from MyISAM to innodb and your queries doesn't use BEGIN and COMMIT you will have to activate auto-commit on the server to make innodb save the results of the queries. If you want to set it all up, just make sure you start an update-log on your master server and connect the slave to it.. then if you're running mysql 4.0 or higher just issue the command "LOAD DATA FROM MASTER;" and the slave will become up-to-date. After that it will continue to read the updatelog and manage on its own. Hope this helps... Joakim -----Ursprungligt meddelande----- Från: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] För Kenneth Oncinian Skickat: den 28 april 2004 10:54 Till: DBMail mailinglist Ämne: Re: SV: [Dbmail] mirroring dbmail mySQL database Hi Mikael, Ok :) Although I dont know MySQL much...im still experimenting right now. Mikael Syska wrote: > Hey Kenneth > > Could be great if you posted the solution when/if you find it.... Soon I > will also be looking for the same to replicate the mysql db. > > Regards > Mikael > > >>-----Oprindelig meddelelse----- >>Fra: [EMAIL PROTECTED] >>[mailto:[EMAIL PROTECTED] På vegne af Kenneth Oncinian >>Sendt: 28. april 2004 10:02 >>Til: DBMail mailinglist >>Emne: Re: [Dbmail] mirroring dbmail mySQL database >> >>Thanks Ilja, >> >>Yes, I'm reading the MySQL manual at this very moment. >>Thanks again. >> >> >>regards, >>Kenneth >> >> >>Ilja Booij wrote: >> >>>You should probably read the MySQL manual on this. There's >> >>a chapter >> >>>on replication there, which might have some info on mixing >> >>InnoDB and >> >>>MyISAM tables. >>> >>>Ilja >>> >>>On Wed, 2004-04-28 at 03:02, Kenneth Oncinian wrote: >>> >>> >>>>Hi list, >>>>ALthough this sounds like more of an MySQL question, my >> >>knowledge in >> >>>>MySQL is very limited as of now so please bear with me :). >>>> >>>>In one of my server, I used the command: >>>>mysql -u root -p < sql/mysql/create_tables.mysql to create >> >>the mysql >> >>>>database. >>>> >>>>I would like to mirror that in one of my server as live >> >>backup because >> >>>>I would be doing some maintenance on the other server. >>>> >>>>But instead, I used the InndDB command to create the database using >>>>mysql -u root -p < sql/mysql/create_tables_innoDB.mysql in >> >>the backup >> >>>>server. >>>> >>>>My question is, can I still use the old MySQL database from >> >>the main >> >>>>server to the backup server? Could I just rsync the original >>>>/var/lib/mysql/dbmail to the backup server? >>>> >>>> >>>>thanks and best regards, >>>>Kenneth Oncinian >>>> >>>> >>> >>> >>>_______________________________________________ >>>Dbmail mailing list >>>[email protected] >>>https://mailman.fastxs.nl/mailman/listinfo/dbmail >> >> >>-- >>"Even if you're on the right track, you'll get run over if >>you just sit there." >> >>-- Will Rogers >> >>_______________________________________________ >>Dbmail mailing list >>[email protected] >>https://mailman.fastxs.nl/mailman/listinfo/dbmail >> > > > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail -- "Even if you're on the right track, you'll get run over if you just sit there." -- Will Rogers _______________________________________________ Dbmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
