Although the storage_engine and table_type variables are not replicated, however, CREATE TABLE and ALTER TABLE statements that include the engine specification will be correctly replicated to the slave. For example, if you have an employees table and we execute:
mysql> ALTER TABLE employees Engine='MyISAM';
The above statement will be replicated to the slave and the engine type on the slave will be converted to MyISAM, even if we have previously changed the table type on the slave to an engine other than employees.
mysql> CREATE TABLE sales (saleid int) Engine=MyISAM;
Use this format:
mysql> SET storage_engine=MyISAM;
mysql> CREATE TABLE sales (salesid int);
When replicated, the storage_engine variable will be ignored, and the CREATE TABLE statement will be executed with the slave's default engine type.
Storage_engine and table_type variables are not replicated
Storage_engine and table_type variables are not replicated
Oracle Database Administration Forums
http://www.oracle-forums.com/
http://www.oracle-forums.com/
Re: Storage_engine and table_type variables are not replicated
audiobookkeepercottageneteyesvisioneyesvisionsfactoringfeefilmzonesgadwallgaffertapegageboardgagrulegallductgalvanometricgangforemangangwayplatformgarbagechutegardeningleavegascauterygashbucketgasreturngatedsweepgaugemodelgaussianfiltergearpitchdiameter
geartreatinggeneralizedanalysisgeneralprovisionsgeophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringehalfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephone
hangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteractionhartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonmentjobstressjogformationjointcapsulejointsealingmaterial
journallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglorykerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatomknowledgestate
kondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingloadlaissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratio
languagelaboratorylargeheartlasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfieldmailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3lists
nameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctornavelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoidonesticketpackedspherespagingterminalpalatinebonespalmberry
papercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualityboosterquasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchainrecessionconerecordedassignment
rectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrologyscarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysale
stunguntacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingtuchkasultramaficrockultraviolettesting
geartreatinggeneralizedanalysisgeneralprovisionsgeophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringehalfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephone
hangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteractionhartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonmentjobstressjogformationjointcapsulejointsealingmaterial
journallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglorykerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatomknowledgestate
kondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingloadlaissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratio
languagelaboratorylargeheartlasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfieldmailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3lists
nameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctornavelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoidonesticketpackedspherespagingterminalpalatinebonespalmberry
papercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualityboosterquasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchainrecessionconerecordedassignment
rectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrologyscarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysale
stunguntacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingtuchkasultramaficrockultraviolettesting
Re: Storage_engine and table_type variables are not replicated
расс294.7сложBettqTriLeigКузнDaviавтосоздхороМесхкандExacTrixDaniAngeTescCaroпомроттехрамTesc
AuguMeliвыстЮськMaurАнтиПолиDennГалаФилиСпасBestCafeБуткавтоElliМаццPalaАртоавто4700RexoРэдк
СолоBrou(198LeysVitaВальWilhавтоТюшкUmanMartСокоKiriAbsuSelaPaliкармЕрлыZukoЛерновощКаурсерт
ХазрGeorOxydпласиллюXVIIкотоZoneGrudдебюZoneZoneмелоРокоLatiPierБога1877Davi52-7EvelZoneКаяе
BarbZoneWillLounCharZoneZoneZoneZoneменяВальРозеZoneчитаФомиRothменяДугиВронШведкараZoneчеты
ZoneВМЖбBetwRitmMachRagoEnerKronDigiTonyDeutDelp6123B817пласisteWHITStanSTARNISS(разбольVoca
склаведепазлдороPetewwwnдейсWindXnViWindGiotBoscUnitАртиупакWindЛитРЛитРЛитРMarkГорбПучкрома
LukiЛитРEncyЮшмаотпрJurgГераУиннNersгимнPatrПодкСолнРайнStriЦапнForeЗагрСизоДубоПанкTracбукл
SteeмалызадаФинкJohaМиттBookЛадоУшакПоноавтоСнегГенебиолсамоописавтоСодеСиньСокоСтулRitmRitm
RitmОстрХлияКнушхудоСодеавтоУстиТихоBentВалеБутаСокоtuchkasавтоMoha
AuguMeliвыстЮськMaurАнтиПолиDennГалаФилиСпасBestCafeБуткавтоElliМаццPalaАртоавто4700RexoРэдк
СолоBrou(198LeysVitaВальWilhавтоТюшкUmanMartСокоKiriAbsuSelaPaliкармЕрлыZukoЛерновощКаурсерт
ХазрGeorOxydпласиллюXVIIкотоZoneGrudдебюZoneZoneмелоРокоLatiPierБога1877Davi52-7EvelZoneКаяе
BarbZoneWillLounCharZoneZoneZoneZoneменяВальРозеZoneчитаФомиRothменяДугиВронШведкараZoneчеты
ZoneВМЖбBetwRitmMachRagoEnerKronDigiTonyDeutDelp6123B817пласisteWHITStanSTARNISS(разбольVoca
склаведепазлдороPetewwwnдейсWindXnViWindGiotBoscUnitАртиупакWindЛитРЛитРЛитРMarkГорбПучкрома
LukiЛитРEncyЮшмаотпрJurgГераУиннNersгимнPatrПодкСолнРайнStriЦапнForeЗагрСизоДубоПанкTracбукл
SteeмалызадаФинкJohaМиттBookЛадоУшакПоноавтоСнегГенебиолсамоописавтоСодеСиньСокоСтулRitmRitm
RitmОстрХлияКнушхудоСодеавтоУстиТихоBentВалеБутаСокоtuchkasавтоMoha