1(self.webpackChunk_N_E=self.webpackChunk_N_E||[]).push([[3998],{98045:function(e,t,n){(window.__NEXT_P=window.__NEXT_P||[]).push(["/airbyte-connectors/mysql",function(){return n(78140)}])},78140:function(e,t,n){"use strict";n.r(t),n.d(t,{CH:function(){return l},__toc:function(){return g},chCodeConfig:function(){return c}});var a=n(52322),i=n(28287),s=n(20337),o=n(93988);n(58614);var r=n(71199),d=n(65854);let l={annotations:d.ds,Code:d.EK},c={staticMediaQuery:"not screen, (max-width: 768px)",lineNumbers:!0,showCopyButton:!0,themeName:"material-theme-darker"},g=[{depth:2,value:"Overview",id:"overview"},{depth:3,value:"Features",id:"features"},{depth:3,value:"Data type mapping",id:"data-type-mapping"},{depth:2,value:"Getting started",id:"getting-started"},{depth:3,value:"Requirements and prerequisites",id:"requirements-and-prerequisites"},{depth:3,value:"Set up guide",id:"set-up-guide"},{depth:4,value:"Step 1: (Optional, but recommended) Create a dedicated read-only user",id:"step-1-optional-but-recommended-create-a-dedicated-read-only-user"},{depth:4,value:"Step 2: Set up the MySQL source",id:"step-2-set-up-the-mysql-source"},{depth:4,value:"Step 3: (Optional) Setting up CDC based syncing",id:"step-3-optional-setting-up-cdc-based-syncing"},{depth:4,value:"Step 4: (Optional) Connection via SSH Tunnel",id:"step-4-optional-connection-via-ssh-tunnel"},{depth:3,value:"Troubleshooting",id:"troubleshooting"}];function h(e){let t=Object.assign({h1:"h1",h2:"h2",p:"p",h3:"h3",table:"table",thead:"thead",tr:"tr",th:"th",tbody:"tbody",td:"td",code:"code",a:"a",ul:"ul",li:"li",h4:"h4",ol:"ol",strong:"strong"},(0,r.a)(),e.components);return l||u("CH",!1),l.Code||u("CH.Code",!0),(0,a.jsxs)(a.Fragment,{children:[(0,a.jsx)("style",{dangerouslySetInnerHTML:{__html:'[data-ch-theme="material-theme-darker"] { --ch-t-colorScheme: dark;--ch-t-foreground: #EEFFFF;--ch-t-background: #212121;--ch-t-lighter-inlineBackground: #212121e6;--ch-t-editor-background: #212121;--ch-t-editor-foreground: #EEFFFF;
1--ch-t-editor-lineHighlightBackground: #00000050;--ch-t-editor-rangeHighlightBackground: #FFFFFF0d;--ch-t-editor-infoForeground: #3794FF;--ch-t-editor-selectionBackground: #61616150;--ch-t-focusBorder: #FFFFFF00;--ch-t-tab-activeBackground: #212121;--ch-t-tab-activeForeground: #FFFFFF;--ch-t-tab-inactiveBackground: #212121;--ch-t-tab-inactiveForeground: #616161;--ch-t-tab-border: #212121;--ch-t-tab-activeBorder: #80CBC4;--ch-t-editorGroup-border: #00000030;--ch-t-editorGroupHeader-tabsBackground: #212121;--ch-t-editorLineNumber-foreground: #424242;--ch-t-input-background: #2B2B2B;--ch-t-input-foreground: #EEFFFF;--ch-t-input-border: #FFFFFF10;--ch-t-icon-foreground: #C5C5C5;--ch-t-sideBar-background: #212121;--ch-t-sideBar-foreground: #616161;--ch-t-sideBar-border: #21212160;--ch-t-list-activeSelectionBackground: #212121;--ch-t-list-activeSelectionForeground: #80CBC4;--ch-t-list-hoverBackground: #212121;--ch-t-list-hoverForeground: #FFFFFF; }'}}),"\n",(0,a.jsx)(t.h1,{children:"MySQL"}),"\n",(0,a.jsx)(t.h2,{id:"overview",children:"Overview"}),"\n",(0,a.jsx)(t.p,{children:"This page contains the setup guide and reference information for the MySQL source connector."}),"\n",(0,a.jsx)(t.h3,{id:"features",children:"Features"}),"\n",(0,a.jsxs)(t.table,{children:[(0,a.jsx)(t.thead,{children:(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.th,{align:"left",children:"Feature"}),(0,a.jsx)(t.th,{align:"left",children:"Supported"}),(0,a.jsx)(t.th,{align:"left",children:"Notes"})]})}),(0,a.jsxs)(t.tbody,{children:[(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:"Full Refresh Sync"}),(0,a.jsx)(t.td,{align:"left",children:"Yes"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:"Incremental - Append Sync"}),(0,a.jsx)(t.td,{align:"left",children:"Yes"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:"CDC"}),(0,a.jsx)(t.td,{align:"left",children:"Yes"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:"SSL Support"}),(0,a.jsx)(t.td,{align:"left",children:"Yes"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:"SSH Tunnel Connection"}),(0,a.jsx)(t.td,{align:"left",children:"Yes"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:"Arrays"}),(0,a.jsx)(t.td,{align:"left",children:"Yes"}),(0,a.jsx)(t.td,{align:"left",children:"Byte arrays are not supported yet"})]})]})]}),"\n",(0,a.jsx)(t.h3,{id:"data-type-mapping",children:"Data type mapping"}),"\n",(0,a.jsxs)(t.table,{children:[(0,a.jsx)(t.thead,{children:(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.th,{align:"left",children:"MySQL Type"}),(0,a.jsx)(t.th,{align:"left",children:"Resulting Type"}),(0,a.jsx)(t.th,{align:"left",children:"Notes"})]})}),(0,a.jsxs)(t.tbody,{children:[(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"bit(1)"})}),(0,a.jsx)(t.td,{align:"left",children:"boolean"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"bit(>1)"})}),(0,a.jsx)(t.td,{align:"left",children:"base64 binary string"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"boolean"})}),(0,a.jsx)(t.td,{align:"left",children:"boolean"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"tinyint(1)"})}),(0,a.jsx)(t.td,{align:"left",children:"boolean"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"tinyint(>1)"})}),(0,a.jsx)(t.td,{align:"left",children:"float"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"tinyint(>=1) unsigned"})}),(0,a.jsx)(t.td,{align:"left",children:"float"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"smallint"})}),(0,a.jsx)(t.td,{align:"left",children:"float"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"mediumint"})}),(0,a.jsx)(t.td,{align:"left",children:"float"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"int"})}),(0,a.jsx)(t.td,{align:"left",children:"float"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"bigint"})}),(0,a.jsx)(t.td,{align:"left",children:"float"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"float"})}),(0,a.jsx)(t.td,{align:"left",children:"float"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"double"})}),(0,a.jsx)(t.td,{align:"left",children:"float"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"decimal"})}),(0,a.jsx)(t.td,{align:"left",children:"float"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"binary"})}),(0,a.jsx)(t.td,{align:"left",children:"string"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"blob"})}),(0,a.jsx)(t.td,{align:"left",children:"string"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"date"})}),(0,a.jsx)(t.td,{align:"left",children:"string"}),(0,a.jsxs)(t.td,{align:"left",children:[(0,a.jsx)(t.code,{children:"ISO 8601"})," date string. ZERO-DATE value will be converted to NULL. If column is mandatory, convert to EPOCH."]})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsxs)(t.td,{align:"left",children:[(0,a.jsx)(t.code,{children:"datetime"}),", ",(0,a.jsx)(t.code,{children:"timestamp"})]}),(0,a.jsx)(t.td,{align:"left",children:"string"}),(0,a.jsxs)(t.td,{align:"left",children:[(0,a.jsx)(t.code,{children:"ISO 8601"})," datetime string. ZERO-DATE value will be converted to NULL. If column is mandatory, convert to EPOCH."]})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"time"})}),(0,a.jsx)(t.td,{align:"left",children:"string"}),(0,a.jsxs)(t.td,{align:"left",children:[(0,a.jsx)(t.code,{children:"ISO 8601"})," time string. Values are in range between 00:00:00 and 23:59:59."]})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"year"})}),(0,a.jsx)(t.td,{align:"left",children:"year string"}),(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.a,{href:"https://dev.mysql.com/doc/refman/8.0/en/year.html",children:"MySQL Docs"})})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsxs)(t.td,{align:"left",children:[(0,a.jsx)(t.code,{children:"char"}),", ",(0,a.jsx)(t.code,{children:"varchar"})," with non-binary charset"]}),(0,a.jsx)(t.td,{align:"left",children:"string"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsxs)(t.td,{align:"left",children:[(0,a.jsx)(t.code,{children:"char"}),", ",(0,a.jsx)(t.code,{children:"varchar"})," with binary charset"]}),(0,a.jsx)(t.td,{align:"left",children:"base64 binary string"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"tinyblob"})}),(0,a.jsx)(t.td,{align:"left",children:"base64 binary string"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"blob"})}),(0,a.jsx)(t.td,{align:"left",children:"base64 binary string"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"mediumblob"})}),(0,a.jsx)(t.td,{align:"left",children:"base64 binary string"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"longblob"})}),(0,a.jsx)(t.td,{align:"left",children:"base64 binary string"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"binary"})}),(0,a.jsx)(t.td,{align:"left",children:"base64 binary string"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"varbinary"})}),(0,a.jsx)(t.td,{align:"left",children:"base64 binary string"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"tinytext"})}),(0,a.jsx)(t.td,{align:"left",children:"string"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"text"})}),(0,a.jsx)(t.td,{align:"left",children:"string"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"mediumtext"})}),(0,a.jsx)(t.td,{align:"left",children:"string"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"longtext"})}),(0,a.jsx)(t.td,{align:"left",children:"string"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"json"})}),(0,a.jsx)(t.td,{align:"left",children:"serialized json string"}),(0,a.jsxs)(t.td,{align:"left",children:["E.g. ",(0,a.jsx)(t.code,{children:'{"a": 10, "b": 15}'})]})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"enum"})}),(0,a.jsx)(t.td,{align:"left",children:"string"}),(0,a.jsx)(t.td,{align:"left"})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"set"})}),(0,a.jsx)(t.td,{align:"left",children:"string"}),(0,a.jsxs)(t.td,{align:"left",children:["E.g. ",(0,a.jsx)(t.code,{children:"blue,green,yellow"})]})]}),(0,a.jsxs)(t.tr,{children:[(0,a.jsx)(t.td,{align:"left",children:(0,a.jsx)(t.code,{children:"geometry"})}),(0,a.jsx)(t.td,{align:"left",children:"base64 binary string"}),(0,a.jsx)(t.td,{align:"left"})]})]})]}),"\n",(0,a.jsx)(t.p,{children:"If a specific type isn't mentioned in this list, it's typically converted into a string."}),"\n",(0,a.jsx)(t.h2,{id:"getting-started",children:"Getting started"}),"\n",(0,a.jsx)(t.h3,{id:"requirements-and-prerequisites",children:"Requirements and prerequisites"}),"\n",(0,a.jsx)(t.p,{children:"For utilizing the MySQL source, ensure you have the following:"}),"\n",(0,a.jsxs)(t.ul,{children:["\n",(0,a.jsx)(t.li,{children:"MySQL Server version 8.0, 5.7, or 5.6."}),"\n",(0,a.jsx)(t.li,{children:"Establishment of a dedicated read-only user account that can access all tables necessary for replication."}),"\n",(0,a.jsxs)(t.li,{children:["Ensure Y42 can access your database. This requirement depends on your network configuration. We suggest adding ",(0,a.jsx)(t.a,{href:"/ingesting-data-overview/ip-whitelist",children:"Y42's production IP addresses"}),", to your whitelist."]}),"\n"]}),"\n",(0,a.jsx)(t.h3,{id:"set-up-guide",children:"Set up guide"}),"\n",(0,a.jsx)(t.h4,{id:"step-1-optional-but-recommended-create-a-dedicated-read-only-user",children:"Step 1: (Optional, but recommended) Create a dedicated read-only user"}),"\n",(0,a.jsx)(t.p,{children:"This stage is optional but strongly suggested to allow better permission management and auditing."}),"\n",(0,a.jsxs)(t.ol,{children:["\n",(0,a.jsxs)(t.li,{children:["To create a dedicated database user, execute the following commands on your database:","\n",(0,a.jsx)(l.Code,{codeConfig:c,northPanel:{tabs:[""],active:"",heightRatio:1},files:[{name:"",focus:"",code:{lines:[{tokens:[{content:"CREATE USER",props:{style:{color:"#F78C6C"}}},{content:" '",props:{style:{color:"#EEFFFF"}}},{content:"y42",props:{style:{color:"#82AAFF"}}},{content:"'@",props:{style:{color:"#EEFFFF"}}},{content:"'",props:{style:{color:"#89DDFF"}}},{content:"%",props:{style:{color:"#C3E88D"}}},{content:"'",props:{style:{color:"#89DDFF"}}},{content:" IDENTIFIED ",props:{style:{color:"#EEFFFF"}}},{content:"BY ",props:{style:{color:"#F78C6C"}}},{content:"'",props:{style:{color:"#89DDFF"}}},{content:"your_password_here",props:{style:{color:"#C3E88D"}}},{content:"'",props:{style:{color:"#89DDFF"}}},{content:";",props:{style:{color:"#EEFFFF"}}}]}],lang:"sql"},annotations:[]}]}),"\n",(0,a.jsxs)(t.ul,{children:["\n",(0,a.jsxs)(t.li,{children:["The appropriate permissions vary between the ",(0,a.jsx)(t.code,{children:"STANDARD"})," and ",(0,a.jsx)(t.code,{children:"CDC"})," replication methods. For the ",(0,a.jsx)(t.code,{children:"STANDARD"})," replication method, only the ",(0,a.jsx)(t.code,{children:"SELECT"})," permission is needed.","\n",(0,a.jsx)(l.Code,{codeConfig:c,northPanel:{tabs:[""],active:"",heightRatio:1},files:[{name:"",focus:"",code:{lines:[{tokens:[{content:"GRANT SELECT ON ",props:{style:{color:"#F78C6C"}}},{content:"<",props:{style:{color:"#89DDFF"}}},{content:"database name",props:{style:{color:"#F78C6C"}}},{content:">",props:{style:{color:"#89DDFF"}}},{content:".",props:{style:{color:"#EEFFFF"}}},{content:"* ",props:{style:{color:"#89DDFF"}}},{content:"TO ",props:{style:{color:"#F78C6C"}}},{content:"'",props:{style:{color:"#89DDFF"}}},{content:"y42",props:{style:{color:"#C3E88D"}}},{content:"'",props:{style:{color:"#89DDFF"}}},{content:"@",props:{style:{color:"#EEFFFF"}}},{content:"'",props:{style:{color:"#89DDFF"}}},{content:"%",props:{style:{color:"#C3E88D"}}},{content:"'",props:{style:{color:"#89DDFF"}}},{content:";",props:{style:{color:"#EEFFFF"}}}]}],lang:"sql"},annotations:[]}]}),"\n"]}),"\n",(0,a.jsxs)(t.li,{children:["For ",(0,a.jsx)(t.code,{children:"CDC"})," replication method, ",(0,a.jsx)(t.code,{children:"SELECT, RELOAD, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT"})," permissions are required.","\n",(0,a.jsx)(l.Code,{codeConfig:c,northPanel:{tabs:[""],active:"",heightRatio:1},files:[{name:"",focus:"",code:{lines:[{tokens:[{content:"GRANT SELECT",props:{style:{color:"#F78C6C"}}},{content:", RELOAD, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT ",props:{style:{color:"#EEFFFF"}}},{content:"ON ",props:{style:{color:"#F78C6C"}}},{content:"*",props:{style:{color:"#89DDFF"}}},{content:".",props:{style:{color:"#EEFFFF"}}},{content:"* ",props:{style:{color:"#89DDFF"}}},{content:"TO ",props:{style:{color:"#F78C6C"}}},{content:"'",props:{style:{color:"#89DDFF"}}},{content:"y42",props:{style:{color:"#C3E88D"}}},{content:"'",props:{style:{color:"#89DDFF"}}},{content:"@",props:{style:{color:"#EEFFFF"}}},{content:"'",props:{style:{color:"#89DDFF"}}},{content:"%",props:{style:{color:"#C3E88D"}}},{content:"'",props:{style:{color:"#89DDFF"}}},{content:";",props:{style:{color:"#EEFFFF"}}}]}],lang:"sql"},annotations:[]}]}),"\n"]}),"\n"]}),"\n"]}),"\n"]}),"\n",(0,a.jsx)(t.h4,{id:"step-2-set-up-the-mysql-source",children:"Step 2: Set up the MySQL source"}),"\n",(0,a.jsxs)(t.ol,{children:["\n",(0,a.jsxs)(t.li,{children:["Create a new source, select ",(0,a.jsx)(t.strong,{children:"MySQL (Airbyte)"})," from the Source type dropdown and enter a name for it."]}),"\n",(0,a.jsx)(t.li,{children:"On the source setup page, create a new MySQL secret, enter a unique name for it."}),"\n",(0,a.jsxs)(t.li,{children:["For the ",(0,a.jsx)(t.strong,{children:"Host"}),", ",(0,a.jsx)(t.strong,{children:"Port"}),", and ",(0,a.jsx)(t.strong,{children:"DB Name"}),", enter the hostname, port number, and name for your MySQL database."]}),"\n",(0,a.jsxs)(t.li,{children:["For ",(0,a.jsx)(t.strong,{children:"User"})," and ",(0,a.jsx)(t.strong,{children:"Password"}),", enter the username and password you created in ",(0,a.jsx)(t.a,{href:"#step-1-optional-but-recommended-create-a-dedicated-read-only-user",children:"Step 1"}),"."]}),"\n",(0,a.jsxs)(t.li,{children:["(Optional) If you want to use CDC replication select ",(0,a.jsx)(t.strong,{children:"Logical Replication (CDC)"})," as the replication method and enter the n
1ames of the replication slot and publication you created."]}),"\n",(0,a.jsxs)(t.li,{children:['(Optional) If you want to connect via SSH tunnel, select "SSH Tunnel Method": ',(0,a.jsx)(t.strong,{children:"SSH Key Authentication"})," or ",(0,a.jsx)(t.strong,{children:"Password Authentication"}),"."]}),"\n"]}),"\n",(0,a.jsx)(t.h4,{id:"step-3-optional-setting-up-cdc-based-syncing",children:"Step 3: (Optional) Setting up CDC based syncing"}),"\n",(0,a.jsx)(t.p,{children:"Binary logging is enabled by default since Mysql 8.0. For older versions make sure you have these parameters in your mysql server configuration:"}),"\n",(0,a.jsx)(l.Code,{codeConfig:c,northPanel:{tabs:[""],active:"",heightRatio:1},files:[{name:"",focus:"",code:{lines:[{tokens:[{content:"server-id = 1 (any none-zero value)",props:{}}]},{tokens:[{content:"log_bin = mysql-bin",props:{}}]},{tokens:[{content:"binlog_format = ROW (default)",props:{}}]},{tokens:[{content:"binlog_row_image = FULL (default)",props:{}}]},{tokens:[{content:"binlog_expire_logs_seconds = 864000 (recommended minimum)",props:{}}]}],lang:"text"},annotations:[]}]}),"\n",(0,a.jsx)(t.p,{children:"During the secret setup set the replication method to Logical Replication."}),"\n",(0,a.jsx)(t.h4,{id:"step-4-optional-connection-via-ssh-tunnel",children:"Step 4: (Optional) Connection via SSH Tunnel"}),"\n",(0,a.jsx)(t.p,{children:'In case of an SSH connection, select "SSH Tunnel Method" other than "No Tunnel" and configure SSH tunneling:'}),"\n",(0,a.jsxs)(t.ol,{children:["\n",(0,a.jsxs)(t.li,{children:["For ",(0,a.jsx)(t.strong,{children:"SSH Tunnel Jump Server Host"}),", enter the hostname or IP address for the intermediate (bastion) server that Y42 will connect to."]}),"\n",(0,a.jsxs)(t.li,{children:["For ",(0,a.jsx)(t.strong,{children:"SSH Connection Port"}),", enter the port on the bastion server. The default port for SSH connections is 22."]}),"\n",(0,a.jsxs)(t.li,{children:["For ",(0,a.jsx)(t.strong,{children:"SSH Login Username"}),", enter the username to use when connecting to the bastion server. ",(0,a.jsx)(t.strong,{children:"Note:"})," This is the operating system username and not the MySQL username."]}),"\n",(0,a.jsxs)(t.li,{children:["For authentication:","\n",(0,a.jsxs)(t.ul,{children:["\n",(0,a.jsxs)(t.li,{children:["If you selected ",(0,a.jsx)(t.strong,{children:"SSH Key Authentication"}),", set the ",(0,a.jsx)(t.strong,{children:"SSH Private Key"})," to the private key that you are using to create the SSH connection.\nTo generate a private key for SSH Tunneling, execute the following command:","\n",(0,a.jsx)(l.Code,{codeConfig:c,northPanel:{tabs:[""],active:"",heightRatio:1},files:[{name:"",focus:"",code:{lines:[{tokens:[{content:"ssh-keygen ",props:{style:{color:"#FFCB6B"}}},{content:"-t rsa -m PEM -f myuser_rsa",props:{style:{color:"#C3E88D"}}}]}],lang:"bash"},annotations:[]}]}),"\n","The command produces the private key in PEM format and the public key remains in the standard format used by the ",(0,a.jsx)(t.code,{children:"authorized_keys"})," file on your bastion server. Add the public key to your bastion host to the user you want to use for data sync. The private key is provided via copy-and-paste to the configuration screen."]}),"\n",(0,a.jsxs)(t.li,{children:["If you selected ",(0,a.jsx)(t.strong,{children:"Password Authentication"}),", enter the password for the operating system user to connect to the bastion server. ",(0,a.jsx)(t.strong,{children:"Note:"})," This is the operating system password and not the MySQL password."]}),"\n"]}),"\n"]}),"\n"]}),"\n",(0,a.jsx)(t.h3,{id:"troubleshooting",children:"Troubleshooting"}),"\n",(0,a.jsxs)(t.ul,{children:["\n",(0,a.jsxs)(t.li,{children:["Certain issues might arise when trying to map values from MySQL's datetime field to other relational databases. MySQL allows zero values for date/time as an alternative to ",(0,a.jsx)(t.code,{children:"NULL"}),", which may not be compatible with other databases. To mitigate this issue, you can use the JDBC connector in the source setting and input the following key-value pair: ",(0,a.jsx)(t.strong,{children:(0,a.jsx)(t.code,{children:"zerodatetimebehavior=Converttonull"})})]}),"\n",(0,a.jsxs)(t.li,{children:["A few users have encountered difficulties when trying to connect to Amazon RDS MySQL or MariaDB, indicated by the error message: ",(0,a.jsx)(t.code,{children:"Cannot create a PoolableConnectionFactory"}),". To rectify this problem, include ",(0,a.jsx)(t.strong,{children:(0,a.jsx)(t.code,{children:"enabledTLSProtocols=TLSv1.2"})})," in the JDBC parameters."]}),"\n",(0,a.jsxs)(t.li,{children:["Some users have reported an error when attempting to connect to Amazon RDS MySQL: ",(0,a.jsx)(t.code,{children:"Error: HikariPool-1 - Connection is not available, request timed out after 30001ms."})," Often, this issue stems from the VPC disallowing public traffic. Nevertheless, we suggest you go through ",(0,a.jsx)(t.a,{href:"https://aws.amazon.com/premiumsupport/knowledge-center/rds-cannot-connect/",children:"the AWS RDS troubleshooting checklist"})," to ensure the appropriate permissions/settings have been granted for database connection."]}),"\n"]})]})}function u(e,t){throw Error("Expected "+(t?"component":"object")+" `"+e+"` to be defined: you likely forgot to import, pass, or provide it.")}let m={MDXContent:function(){let e=arguments.length>0&&void 0!==arguments[0]?arguments[0]:{},{wrapper:t}=Object.assign({},(0,r.a)(),e.components);return t?(0,a.jsx)(t,{...e,children:(0,a.jsx)(h,{...e})}):h(e)},pageOpts:{filePath:"pages/airbyte-connectors/mysql.mdx",route:"/airbyte-connectors/mysql",timestamp:1723136979e3,pageMap:[{kind:"MdxPage",name:"404",route:"/404"},{kind:"Meta",data:{404:{title:"Page not found",display:"hidden",theme:{layout:"raw"}},index:{title:"Home",display:"hidden",theme:{pagination:!1,toc:!1}},home:{title:"â Y42.com",type:"page",href:"https://www.y42.com"},tutorials:{title:"Tutorials",type:"page",href:"/docs/tutorials",display:"hidden"},"api-reference":{title:"API reference",type:"page",href:"https://y42-public-api.readme.io/reference",newWindow:!0},login:{title:"Log in",type:"page",href:"https://y42.dev",newWindow:!0},_essentials:{title:"Essentials",type:"separator"},"getting-started":{title:"Getting started",theme:{collapsed:!0}}
1,"working-with-assets":"Working with assets",integrations:"Required integrations","version-control":"Version control","branch-environments":"Branch environments","_platform-interface":{title:"Platform interface",type:"separator"},"platform-interface-overview":"Overview","platform-interface-modes":"Modes","_ai-copilot":{title:"AI Copilot",type:"separator"},"ai-copilot-overview":"Overview","documentation-wizard":"Documentation Wizard","sql-completion":"SQL Completion","_ingesting-data":{title:"Ingesting data",type:"separator"},"ingesting-data-overview":"Overview","sql-ingestion-migration":{title:"SQL Ingstion Migration Guide",display:"hidden"},"cdata-connectors":"CData connectors","airbyte-connectors":"Airbyte connectors","fivetran-sources":"Fivetran sources","python-sources":"Python sources","csv-seeds":"CSV seeds","reference-data-from-data-warehouse":"Reference data from your data warehouse","_transforming-data":{title:"Transforming data with dbt",type:"separator"},"transforming-data-overview":"Overview","dbt-models":"Models",snapshots:"Snapshots",exposures:"Exposures",analyses:"Analyses","_testing-data-quality":{title:"Testing data quality",type:"separator"},"testing-data-overview":"Overview","column-tests":"Column tests","table-tests":"Table tests","data-diff":"Data diff","anomaly-detection-tests":"Anomaly detection","_automating-workflows":{title:"Automating workflows",type:"separator"},"scheduled-builds":"Run pipelines on a schedule","python-actions":"Sync with external workflows using Python",alerts:"Alerts","_monitoring-data-assets":{title:"Monitoring data assets",type:"separator"},"asset-health-status":"Asset health status","asset-health-dashboard":"Asset health dashboard","asset-health-history":"Asset health history","_managing-your-account":{title:"Managing your account",type:"separator"},"identity-and-access-management":"Identity and access management (IAM)",organizations:"Organizations",spaces:"Spaces","user-settings":"User settings","---":{type:"separator"},"behavior-changes":"Behavior changes"}},{kind:"MdxPage",name:"ai-copilot-overview",route:"/ai-copilot-overview"},{kind:"Folder",name:"airbyte-connectors",route:"/airbyte-connectors",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}}
1,applications:{title:"Applications",display:"hidden"},databases:{title:"Databases",display:"hidden"},"file-transfers":{title:"File transfers",display:"hidden"},others:{title:"Others",display:"hidden"},"amazon-ads":{title:"Amazon Ads"},bigquery:{title:"BigQuery"},"facebook-marketing":{title:"Facebook Marketing"},faker:{title:"Faker"},"file-import":{title:"File import"},gcs:{title:"Google Cloud Storage"},"google-ads":{title:"Google Ads"},"google-analytics-4":{title:"Google Analytics 4"},"google-sheets":{title:"Google Sheets"},hubspot:{title:"Hubspot"},jira:{title:"Jira"},mysql:{title:"MySQL"},mssql:{title:"MSSQL"},postgres:{title:"Postgres"},s3:{title:"S3"},salesforce:{title:"Salesforce"},shopify:{title:"Shopify"},stripe:{title:"Stripe"}}},{kind:"MdxPage",name:"amazon-ads",route:"/airbyte-connectors/amazon-ads"},{kind:"MdxPage",name:"bigquery",route:"/airbyte-connectors/bigquery"},{kind:"MdxPage",name:"facebook-marketing",route:"/airbyte-connectors/facebook-marketing"},{kind:"MdxPage",name:"faker",route:"/airbyte-connectors/faker"},{kind:"MdxPage",name:"file-import",route:"/airbyte-connectors/file-import"},{kind:"MdxPage",name:"gcs",route:"/airbyte-connectors/gcs"},{kind:"MdxPage",name:"google-ads",route:"/airbyte-connectors/google-ads"},{kind:"MdxPage",name:"google-analytics-4",route:"/airbyte-connectors/google-analytics-4"},{kind:"MdxPage",name:"google-sheets",route:"/airbyte-connectors/google-sheets"},{kind:"MdxPage",name:"hubspot",route:"/airbyte-connectors/hubspot"},{kind:"MdxPage",name:"jira",route:"/airbyte-connectors/jira"},{kind:"MdxPage",name:"mssql",route:"/airbyte-connectors/mssql"},{kind:"MdxPage",name:"mysql",route:"/airbyte-connectors/mysql"},{kind:"MdxPage",name:"postgres",route:"/airbyte-connectors/postgres"},{kind:"MdxPage",name:"s3",route:"/airbyte-connectors/s3"},{kind:"MdxPage",name:"salesforce",route:"/airbyte-connectors/salesforce"},{kind:"MdxPage",name:"shopify",route:"/airbyte-connectors/shopify"},{kind:"MdxPage",name:"stripe",route:"/airbyte-connectors/stripe"}]},{kind:"MdxPage",name:"airbyte-connectors",route:"/airbyte-connectors"},{kind:"MdxPage",name:"alerts",route:"/alerts"},{kind:"MdxPage",name:"analyses",route:"/analyses"},{kind:"Folder",name:"anomaly-detection-tests",route:"/anomaly-detection-tests",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"configure-anomaly-detection":"Configure anomaly detection","all-columns-anomalies":"All columns anomalies","anomaly-tests-parameters":"Anomaly tests parameters"}},{kind:"MdxPage",name:"all-columns-anomalies",route:"/anomaly-detection-tests/all-columns-anomalies"},{kind:"MdxPage",name:"anomaly-tests-parameters",route:"/anomaly-detection-tests/anomaly-tests-parameters"},{kind:"MdxPage",name:"configure-anomaly-detection",route:"/anomaly-detection-tests/configure-anomaly-detection"}]},{kind:"MdxPage",name:"anomaly-detection-tests",route:"/anomaly-detection-tests"},{kind:"MdxPage",name:"asset-health-dashboard",route:"/asset-health-dashboard"},{kind:"MdxPage",name:"asset-health-history",route:"/asset-health-history"},{kind:"MdxPage",name:"asset-health-status",route:"/asset-health-status"},{kind:"MdxPage",name:"behavior-changes",route:"/behavior-changes"},{kind:"Folder",name:"branch-environments",route:"/branch-environments",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"virtual-data-builds":"Virtual Data Builds","publish-assets":"Publish assets","continuous-integration":"Continuous integration (CI)","custom-schemas-databases":"Building into custom schemas or databases"}},{kind:"MdxPage",name:"continuous-integration",route:"/branch-environments/continuous-integration"},{kind:"MdxPage",name:"custom-schemas-databases",route:"/branch-environments/custom-schemas-databases"},{kind:"MdxPage",name:"publish-assets",route:"/branch-environments/publish-assets"},{kind:"MdxPage",name:"virtual-data-builds",route:"/branch-environments/virtual-data-builds"}]},{kind:"MdxPage",name:"branch-environments",route:"/branch-environments"},{kind:"Folder",name:"cdata-connectors",route:"/cdata-connectors",children:[{kind:"Meta",data:{"api-aircall":"AirCall",airtable:"Airtable",bigquery:"BigQuery","bing-ads":"Bing Ads",facebook:"Facebook","facebook-ads":"Facebook Ads","google-ads":"Google Ads","google-analytics":"Google Analytics","google-sheets":"Google Sheets",hubspot:"Hubspot",db2:"IBM DB2",instagram:"Instagram",linkedin:"LinkedIn",linkedinads:"LinkedIn Ads",mariadb:"MariaDB",mongodb:"MongoDB",mysql:"MySQL",pinterest:"Pinterest",postgres:"Postgres",salesforce:"Salesforce",snapchatads:"Snapchat Marketing",shopify:"Shopify",snowflake:"Snowflake",stripe:"Stripe","youtube-analytics":"YouTube Analytics",zendesk:"Zendesk"}},{kind:"MdxPage",name:"airtable",route:"/cdata-connectors/airtable"},{kind:"MdxPage",name:"api-aircall",route:"/cdata-connectors/api-aircall"},{kind:"MdxPage",name:"bigquery",route:"/cdata-connectors/bigquery"},{kind:"MdxPage",name:"bing-ads",route:"/cdata-connectors/bing-ads"},{kind:"MdxPage",name:"db2",route:"/cdata-connectors/db2"},{kind:"MdxPage",name:"facebook-ads",route:"/cdata-connectors/facebook-ads"},{kind:"MdxPage",name:"facebook",route:"/cdata-connectors/facebook"},{kind:"MdxPage",name:"google-ads",route:"/cdata-connectors/google-ads"},{kind:"MdxPage",name:"google-analytics",route:"/cdata-connectors/google-analytics"},{kind:"MdxPage",name:"google-sheets",route:"/cdata-connectors/google-sheets"},{kind:"MdxPage",name:"hubspot",route:"/cdata-connectors/hubspot"},{kind:"MdxPage",name:"instagram",route:"/cdata-connectors/instagram"},{kind:"MdxPage",name:"linkedin",route:"/cdata-connectors/linkedin"},{kind:"MdxPage",name:"linkedinads",route:"/cdata-connectors/linkedinads"},{kind:"MdxPage",name:"mariadb",route:"/cdata-connectors/mariadb"},{kind:"MdxPage",name:"mongodb",route:"/cdata-connectors/mongodb"},{kind:"MdxPage",name:"mysql",route:"/cdata-connectors/mysql"},{kind:"MdxPage",name:"pinterest",route:"/cdata-connectors/pinterest"},{kind:"MdxPage",name:"postgres",route:"/cdata-connectors/postgres"},{kind:"MdxPage",name:"salesforce",route:"/cdata-connectors/salesforce"},{kind:"MdxPage",name:"shopify",route:"/cdata-connectors/shopify"},{kind:"MdxPage",name:"snapchatads",route:"/cdata-connectors/snapchatads"},{kind:"MdxPage",name:"snowflake",route:"/cdata-connectors/snowflake"},{kind:"MdxPage",name:"stripe",route:"/cdata-connectors/stripe"},{kind:"MdxPage",name:"youtube-analytics",route:"/cdata-connectors/youtube-analytics"},{kind:"MdxPage",name:"zendesk",route:"/cdata-connectors/zendesk"}]},{kind:"MdxPage",name:"cdata-connectors",route:"/cdata-connectors"},{kind:"MdxPage",name:"column-tests",route:"/column-tests"},{kind:"MdxPage",name:"csv-seeds",route:"/csv-seeds"},{kind:"MdxPage",name:"data-diff",route:"/data-diff"},{kind:"Folder",name:"dbt-models",route:"/dbt-models",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}
1},"create-a-dbt-model":"Create a dbt model","materialization-types":"Materialization types","incremental-models":"Incremental models",macros:"Macros",packages:"Packages",hooks:"Hooks",jinja:"Jinja templating","sql-fluff":"Linting with SQLFluff","generate-staging-models":"Generate staging models","bigquery-partitioning-and-clustering":"BigQuery partitioning and clustering","sql-header":"Configure SQL before model execution","preview-changes-locally":"Preview changes locally"}},{kind:"MdxPage",name:"bigquery-partitioning-and-clustering",route:"/dbt-models/bigquery-partitioning-and-clustering"},{kind:"MdxPage",name:"create-a-dbt-model",route:"/dbt-models/create-a-dbt-model"},{kind:"MdxPage",name:"generate-staging-models",route:"/dbt-models/generate-staging-models"},{kind:"MdxPage",name:"hooks",route:"/dbt-models/hooks"},{kind:"MdxPage",name:"incremental-models",route:"/dbt-models/incremental-models"},{kind:"MdxPage",name:"jinja",route:"/dbt-models/jinja"},{kind:"MdxPage",name:"macros",route:"/dbt-models/macros"},{kind:"MdxPage",name:"materialization-types",route:"/dbt-models/materialization-types"},{kind:"MdxPage",name:"packages",route:"/dbt-models/packages"},{kind:"MdxPage",name:"preview-changes-locally",route:"/dbt-models/preview-changes-locally"},{kind:"MdxPage",name:"sql-fluff",route:"/dbt-models/sql-fluff"},{kind:"MdxPage",name:"sql-header",route:"/dbt-models/sql-header"}]},{kind:"MdxPage",name:"dbt-models",route:"/dbt-models"},{kind:"MdxPage",name:"documentation-wizard",route:"/documentation-wizard"},{kind:"MdxPage",name:"exposures",route:"/exposures"},{kind:"MdxPage",name:"fivetran-sources",route:"/fivetran-sources"},{kind:"Folder",name:"getting-started",route:"/getting-started",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"account-setup":{title:"1. Set up an account"},"create-a-space":{title:"2. Create a space"},"ingest-data":{title:"3. Ingest data"},"transform-data":{title:"4. Transform data"},"schedule-build":{title:"5. Schedule a build"},"merge-changes":{title:"6. Merge changes"}}},{kind:"MdxPage",name:"account-setup",route:"/getting-started/account-setup"},{kind:"Folder",name:"create-a-space",route:"/getting-started/create-a-space",children:[{kind:"Meta",data:{"bigquery-gcp":{title:"BigQuery and Google Cloud Storage"},"snowflake-aws":{title:"Snowflake and Amazon Web Services S3"},"snowflake-azure":{title:"Snowflake and Azure Blob Storage"},snowflake:{display:"hidden",title:"Snowflake"}}},{kind:"MdxPage",name:"bigquery-gcp",route:"/getting-started/create-a-space/bigquery-gcp"},{kind:"MdxPage",name:"snowflake-aws",route:"/getting-started/create-a-space/snowflake-aws"},{kind:"MdxPage",name:"snowflake-azure",route:"/getting-started/create-a-space/snowflake-azure"},{kind:"MdxPage",name:"snowflake",route:"/getting-started/create-a-space/snowflake"}]},{kind:"MdxPage",name:"create-a-space",route:"/getting-started/create-a-space"},{kind:"MdxPage",name:"ingest-data",route:"/getting-started/ingest-data"},{kind:"MdxPage",name:"merge-changes",route:"/getting-started/merge-changes"},{kind:"MdxPage",name:"schedule-build",route:"/getting-started/schedule-build"},{kind:"MdxPage",name:"transform-data",route:"/getting-started/transform-data"}]},{kind:"MdxPage",name:"getting-started",route:"/getting-started"},{kind:"Folder",name:"identity-and-access-management",route:"/identity-and-access-management",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"invite-users":"Invite users to an organization","invitation-policy":"Set organization invitation policy","manage-roles":"Manage roles","api-keys":"API keys","single-sign-on":"Single sign-on (SSO)","two-factor-authentication":"Two-factor authentication (2FA)"}},{kind:"MdxPage",name:"api-keys",route:"/identity-and-access-management/api-keys"},{kind:"MdxPage",name:"invitation-policy",route:"/identity-and-access-management/invitation-policy"},{kind:"MdxPage",name:"invite-users",route:"/identity-and-access-management/invite-users"},{kind:"MdxPage",name:"manage-roles",route:"/identity-and-access-management/manage-roles"},{kind:"Folder",name:"single-sign-on",route:"/identity-and-access-management/single-sign-on",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}
1},okta:"Okta",saml:"SAML",oauth2:"OAuth2"}},{kind:"MdxPage",name:"oauth2",route:"/identity-and-access-management/single-sign-on/oauth2"},{kind:"MdxPage",name:"okta",route:"/identity-and-access-management/single-sign-on/okta"},{kind:"MdxPage",name:"saml",route:"/identity-and-access-management/single-sign-on/saml"}]},{kind:"MdxPage",name:"single-sign-on",route:"/identity-and-access-management/single-sign-on"},{kind:"MdxPage",name:"two-factor-authentication",route:"/identity-and-access-management/two-factor-authentication"}]},{kind:"MdxPage",name:"index",route:"/"},{kind:"Folder",name:"ingesting-data-overview",route:"/ingesting-data-overview",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},secrets:"Secrets","sync-modes":"Sync modes","source-data-freshness":"Source data freshness","ip-whitelist":"IP address whitelist"}},{kind:"MdxPage",name:"ip-whitelist",route:"/ingesting-data-overview/ip-whitelist"},{kind:"MdxPage",name:"secrets",route:"/ingesting-data-overview/secrets"},{kind:"MdxPage",name:"source-data-freshness",route:"/ingesting-data-overview/source-data-freshness"},{kind:"MdxPage",name:"sync-modes",route:"/ingesting-data-overview/sync-modes"}]},{kind:"MdxPage",name:"ingesting-data-overview",route:"/ingesting-data-overview"},{kind:"Folder",name:"integrations",route:"/integrations",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"data-warehouse":"Data warehouse","git-repository":"Git repository"}},{kind:"MdxPage",name:"data-warehouse",route:"/integrations/data-warehouse"},{kind:"Folder",name:"git-repository",route:"/integrations/git-repository",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"connect-github-repository":"Connect your GitHub repository","connect-gitlab-repository":"Connect your GitLab repository"}},{kind:"MdxPage",name:"connect-github-repository",route:"/integrations/git-repository/connect-github-repository"},{kind:"MdxPage",name:"connect-gitlab-repository",route:"/integrations/git-repository/connect-gitlab-repository"}]},{kind:"MdxPage",name:"git-repository",route:"/integrations/git-repository"}]},{kind:"Folder",name:"organizations",route:"/organizations",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"customize-your-organization":"Customize your organization","delete-an-organization":"Delete an organization"}},{kind:"MdxPage",name:"customize-your-organization",route:"/organizations/customize-your-organization"},{kind:"MdxPage",name:"delete-an-organization",route:"/organizations/delete-an-organization"}]},{kind:"Folder",name:"platform-interface-modes",route:"/platform-interface-modes",children:[{kind:"Meta",data:{"asset-list":"Asset list","code-editor":"Code editor",lineage:"Lineage","asset-catalog":"Asset catalog"}},{kind:"MdxPage",name:"asset-catalog",route:"/platform-interface-modes/asset-catalog"},{kind:"MdxPage",name:"asset-list",route:"/platform-interface-modes/asset-list"},{kind:"MdxPage",name:"code-editor",route:"/platform-interface-modes/code-editor"},{kind:"MdxPage",name:"lineage",route:"/platform-interface-modes/lineage"}]},{kind:"MdxPage",name:"platform-interface-modes",route:"/platform-interface-modes"},{kind:"MdxPage",name:"platform-interface-overview",route:"/platform-interface-overview"},{kind:"Folder",name:"python-actions",route:"/python-actions",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"sync-data-with-census":"Sync data with Census","sync-data-with-hightouch":"Sync data with Hightouch","send-slack-notifications":"Send Slack notifications"}},{kind:"MdxPage",name:"send-slack-notifications",route:"/python-actions/send-slack-notifications"},{kind:"MdxPage",name:"sync-data-with-census",route:"/python-actions/sync-data-with-census"},{kind:"MdxPage",name:"sync-data-with-hightouch",route:"/python-actions/sync-data-with-hightouch"}]},{kind:"MdxPage",name:"python-actions",route:"/python-actions"},{kind:"MdxPage",name:"python-sources",route:"/python-sources"},{kind:"MdxPage",name:"reference-data-from-data-warehouse",route:"/reference-data-from-data-warehouse"},{kind:"MdxPage",name:"scheduled-builds",route:"/scheduled-builds"},{kind:"MdxPage",name:"snapshots",route:"/snapshots"},{kind:"Folder",name:"spaces",route:"/spaces",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}
1},"create-a-space":{title:"Create a space",href:"/getting-started/create-a-space"},"customize-a-space":"Customize a space","configure-space-integrations":"Configure space integrations","automatically-delete-unused-tables":"Automatically delete unused tables","delete-a-space":"Delete a space",secrets:{title:"Secrets",href:"/ingesting-data-overview/secrets"}}},{kind:"MdxPage",name:"automatically-delete-unused-tables",route:"/spaces/automatically-delete-unused-tables"},{kind:"MdxPage",name:"configure-space-integrations",route:"/spaces/configure-space-integrations"},{kind:"MdxPage",name:"customize-a-space",route:"/spaces/customize-a-space"},{kind:"MdxPage",name:"delete-a-space",route:"/spaces/delete-a-space"}]},{kind:"MdxPage",name:"sql-completion",route:"/sql-completion"},{kind:"MdxPage",name:"sql-ingestion-migration",route:"/sql-ingestion-migration"},{kind:"MdxPage",name:"table-tests",route:"/table-tests"},{kind:"MdxPage",name:"testing-data-overview",route:"/testing-data-overview"},{kind:"MdxPage",name:"transforming-data-overview",route:"/transforming-data-overview"},{kind:"Folder",name:"user-settings",route:"/user-settings",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"configure-user-profile":"Configure user profile","secure-your-user-account":"Secure your user account","manage-linked-identities":"Managed linked Git identities","customize-user-interface":"Customize user interface","delete-user-account":"Delete your user account"}},{kind:"MdxPage",name:"configure-user-profile",route:"/user-settings/configure-user-profile"},{kind:"MdxPage",name:"customize-user-interface",route:"/user-settings/customize-user-interface"},{kind:"MdxPage",name:"delete-user-account",route:"/user-settings/delete-user-account"},{kind:"MdxPage",name:"manage-linked-identities",route:"/user-settings/manage-linked-identities"},{kind:"MdxPage",name:"secure-your-user-account",route:"/user-settings/secure-your-user-account"}]},{kind:"MdxPage",name:"user-settings",route:"/user-settings"},{kind:"Folder",name:"version-control",route:"/version-control",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"commit-changes":"Commit changes","stash-changes":"Stash changes","revert-changes":"Revert changes","working-with-branches":"Working with branches","pull-requests":"Pull requests"}},{kind:"MdxPage",name:"commit-changes",route:"/version-control/commit-changes"},{kind:"MdxPage",name:"pull-requests",route:"/version-control/pull-requests"},{kind:"MdxPage",name:"revert-changes",route:"/version-control/revert-changes"},{kind:"MdxPage",name:"stash-changes",route:"/version-control/stash-changes"},{kind:"MdxPage",name:"working-with-branches",route:"/version-control/working-with-branches"}]},{kind:"Folder",name:"working-with-assets",route:"/working-with-assets",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"project-configuration":"Project configuration","stateful-data-assets":"Stateful assets","asset-properties":"Asset properties","selecting-assets-to-run":"Selecting assets to run","development-modes":"Development modes"}},{kind:"MdxPage",name:"asset-properties",route:"/working-with-assets/asset-properties"},{kind:"MdxPage",name:"development-modes",route:"/working-with-assets/development-modes"},{kind:"MdxPage",name:"project-configuration",route:"/working-with-assets/project-configuration"},{kind:"Folder",name:"selecting-assets-to-run",route:"/working-with-assets/selecting-assets-to-run",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"build-command-examples":"Build command examples","yaml-selectors":"YAML selectors"}},{kind:"MdxPage",name:"build-command-examples",route:"/working-with-assets/selecting-assets-to-run/build-command-examples"},{kind:"MdxPage",name:"yaml-selectors",route:"/working-with-assets/selecting-assets-to-run/yaml-selectors"}]},{kind:"MdxPage",name:"selecting-assets-to-run",route:"/working-with-assets/selecting-assets-to-run"},{kind:"MdxPage",name:"stateful-data-assets",route:"/working-with-assets/stateful-data-assets"}]},{kind:"MdxPage",name:"working-with-assets",route:"/working-with-assets"}],flexsearch:{codeblocks:!0},title:"MySQL",headings:g},pageNextRoute:"/airbyte-connectors/mysql",nextraLayout:s.ZP,themeConfig:o.Z};t.default=(0,i.j)(m)},93988:function(e,t,n){"use strict";n.d(t,{Z:function(){return o}});var a=n(52322),i=n(20337),s=n(56788),o={head:()=>{let{frontMatter:e}=(0,i.ZR)();return(0,a.jsxs)(a.Fragment,{children:[(0,a.jsx)("meta",{name:"viewport",content:"width=device-width, initial-scale=1.0"}),(0,a.jsx)("link",{rel:"apple-touch-icon",sizes:"180x180",href:"/docs/favicon/apple-touch-icon.png"}),(0,a.jsx)("link",{rel:"icon",type:"image/png",sizes:"32x32",href:"/docs/favicon/favicon-32x32.png"}),(0,a.jsx)("link",{rel:"icon",type:"image/png",sizes:"16x16",href:"/docs/favicon/favicon-16x16.png"}),(0,a.jsx)("link",{rel:"shortcut icon",href:"/docs/favicon/favicon.ico"}),(0,a.jsx)("meta",{name:"msapplication-TileColor",content:"#111111"}),(0,a.jsx)("meta",{property:"og:type",content:"website"}),(0,a.jsx)("meta",{property:"og:locale",content:"en_US"}),(0,a.jsx)("meta",{property:"og:site_name",content:"Y42 Docs"}),e.image?(0,a.jsx)("meta",{property:"og:image",content:e.image}):null,e.video?(0,a.jsx)("meta",{property:"og:video",content:e.video}):null]})},useNextSeoProps:()=>({titleTemplate:"%s | Y42 Docs"}),logo:(0,a.jsx)(e=>{let{height:t="22px",...n}=e;return(0,a.jsxs)("svg",{xmlns:"http://www.w3.org/2000/svg",fill:"none",viewBox:"0 0 230 26",height:t,...n,children:[(0,a.jsx)("path",{fill:"#742BF2",d:"M8.32 16.195a12.1 12.1 0 013.917 8.921h11.447c0-7.455-3.485-14.1-8.923-18.415L8.32 16.195zM11.826 4.71A23.681 23.681 0 000 1.57v11.38c1.935 0 3.766.447 5.393 1.243l6.433-9.482z"}),(0,a.jsx)("path",{fill:"#EB864D",d:"M18.947 4.71c0 2.6 2.121 4.709 4.737 4.709s4.737-2.109 4.737-4.71c0-2.6-2.12-4.709-4.737-4.709-2.616 0-4.737 2.108-4.737 4.71z"}),(0,a.jsx)("path",{fill:"#fff",d:"M97.105 1.57h16.579c3.488 0 6.316 2.811 6.316 6.279v1.57c0 3.467-2.828 6.279-6.316 6.279h-12.631v4.709H120v4.71H96.316v-7.85c0-3.467 2.828-6.279 6.316-6.279h12.631V6.28H97.105V1.57zM61.579 1.57h-4.737v9.418h-14.21V1.57h-4.737v7.849c0 3.467 2.827 6.279 6.316 6.279h3.157v9.418h4.737v-9.418h3.158c3.488 0 6.316-2.812 6.316-6.28V1.57zM90 1.57h-4.737v9.418h-14.21V1.57h-4.737v7.849c0 3.467 2.828 6.279 6.316 6.279h12.631v9.418H90v-9.418h3.158v-4.71H90V1.57z"}),(0,a.jsx)("path",{stroke:"#56555B",d:"M140.5 0L140.5 25.116"}),(0,a.jsx)("path",{fill:"#BEBDBF",d:"M168.83 22.558h-6.593V2.194h6.801c1.996 0 3.709.408 5.141 1.223 1.432.81 2.529 1.973 3.291 3.49.769 1.512 1.154 3.325 1.154 5.44 0 2.12-.388 3.944-1.164 5.468-.769 1.525-1.882 2.698-3.341 3.52-1.458.815-3.221 1.223-5.289 1.223zm-3.52-2.685h3.351c1.551 0 2.84-.291 3.867-.875 1.028-.59
11.797-1.441 2.307-2.555.511-1.12.766-2.486.766-4.097 0-1.597-.255-2.953-.766-4.066-.504-1.114-1.256-1.96-2.257-2.536-1.001-.577-2.244-.865-3.729-.865h-3.539v14.994zm23.889 2.993c-1.432 0-2.681-.328-3.749-.984-1.067-.656-1.896-1.574-2.486-2.754-.589-1.18-.884-2.559-.884-4.137 0-1.584.295-2.97.884-4.156.59-1.186 1.419-2.108 2.486-2.764 1.068-.656 2.317-.984 3.749-.984s2.681.328 3.748.984c1.068.656 1.896 1.578 2.486 2.764.59 1.187.885 2.572.885 4.156 0 1.578-.295 2.957-.885 4.137-.59 1.18-1.418 2.098-2.486 2.754-1.067.656-2.316.984-3.748.984zm.01-2.495c.928 0 1.697-.246 2.307-.736.609-.49 1.06-1.144 1.352-1.959.298-.815.447-1.713.447-2.695 0-.974-.149-1.869-.447-2.684-.292-.822-.743-1.482-1.352-1.979-.61-.497-1.379-.746-2.307-.746-.935 0-1.71.249-2.327.746-.61.497-1.064 1.157-1.362 1.979-.292.815-.438 1.71-.438 2.684 0 .982.146 1.88.438 2.695.298.815.752 1.468 1.362 1.959.617.49 1.392.736 2.327.736zm17.421 2.495c-1.478 0-2.751-.334-3.818-1.004-1.061-.676-1.876-1.607-2.446-2.794-.57-1.187-.855-2.545-.855-4.077 0-1.55.291-2.92.875-4.106.583-1.193 1.405-2.125 2.466-2.794 1.06-.67 2.31-1.004 3.748-1.004 1.16 0 2.194.215 3.102.646.909.424 1.641 1.02 2.198 1.79.563.768.898 1.667 1.004 2.694h-2.893a3.467 3.467 0 00-1.094-1.85c-.564-.516-1.319-.775-2.267-.775-.829 0-1.555.219-2.178.656-.616.431-1.097 1.048-1.441 1.85-.345.795-.518 1.737-.518 2.824 0 1.113.169 2.075.508 2.883.338.809.815 1.435 1.431 1.88.623.444 1.356.666 2.198.666.563 0 1.074-.103 1.531-.308a3.122 3.122 0 001.163-.905c.319-.391.541-.862.667-1.412h2.893a5.62 5.62 0 01-.964 2.645c-.537.775-1.257 1.385-2.158 1.83-.895.443-1.946.665-3.152.665zm21.458-11.852l-2.695.477a3.162 3.162 0 00-.537-.984 2.65 2.65 0 00-.974-.766c-.411-.199-.925-.298-1.541-.298-.842 0-1.545.189-2.108.567-.564.371-.845.852-.845 1.442 0 .51.189.921.567 1.232.377.312.987.567 1.829.766l2.426.557c1.405.325 2.453.825 3.142 1.501.69.677 1.034 1.555 1.034 2.635 0 .915-.265 1.73-.795 2.446-.524.71-1.256 1.267-2.198 1.67-.934.405-2.018.607-3.251.607-1.71 0-3.106-.364-4.186-1.093-1.081-.736-1.743-1.78-1.989-3.133l2.874-.437c.179.749.547 1.316 1.104 1.7.556.378 1.282.567 2.177.567.975 0 1.753-.202 2.337-.607.583-.41.875-.911.875-1.5a1.56 1.56 0 00-.537-1.204c-.351-.325-.892-.57-1.621-.736l-2.585-.567c-1.425-.324-2.479-.841-3.162-1.55-.676-.71-1.014-1.608-1.014-2.695 0-.902.252-1.69.755-2.367.504-.676 1.2-1.203 2.088-1.58.889-.385 1.906-.577 3.053-.577 1.651 0 2.95.357 3.898 1.073.948.71 1.574 1.66 1.879 2.854z"})]})},{height:20}),logoLink:"/",docsRepositoryBase:"https://github.com/goes-funky/y42-website-monorepo",footer:{component:(0,a.jsx)(a.Fragment,{})},primaryHue:269,sidebar:{defaultMenuCollapseLevel:1,autoCollapse:!0,toggleButton:!0},darkMode:!1,nextThemes:{defaultTheme:"dark",forcedTheme:"dark"},feedback:{content:null},editLink:{component:null},chat:{link:"https://discord.gg/bHkQVe9hrY",icon:(0,a.jsx)(s.D7,{width:22,height:22,className:"hover:fill-typography-primary"})}}},56788:function(e,t,n){"use strict";n.d(t,{D7:function(){return i},dv:function(){return s},LK:function(){return o}});var a=n(52322);let i=e=>(0,a.jsx)("svg",{width:16,height:16,viewBox:"0 0 127.14 96.36",fill:"#BEBDBF",xmlns:"http://www.w3.org/2000/svg",...e,children:(0,a.jsx)("path",{d:"M107.7 8.07A105.15 105.15 0 0 0 81.47 0a72.06 72.06 0 0 0-3.36 6.83 97.68 97.68 0 0 0-29.11 0A72.37 72.37 0 0 0 45.64 0a105.89 105.89 0 0 0-26.25 8.09C2.79 32.65-1.71 56.6.54 80.21a105.73 105.73 0 0 0 32.17 16.15 77.7 77.7 0 0 0 6.89-11.11 68.42 68.42 0 0 1-10.85-5.18c.91-.66 1.8-1.34 2.66-2a75.57 75.57 0 0 0 64.32 0c.87.71 1.76 1.39 2.66 2a68.68 68.68 0 0 1-10.87 5.19 77 77 0 0 0 6.89 11.1 105.25 105.25 0 0 0 32.19-16.14c2.64-27.38-4.51-51.11-18.9-72.15ZM42.45 65.69C36.18 65.69 31 60 31 53s5-12.74 11.43-12.74S54 46 53.89 53s-5.05 12.69-11.44 12.69Zm42.24 0C78.41 65.69 73.25 60 73.25 53s5-12.74 11.44-12.74S96.23 46 96.12 53s-5.04 12.69-11.43 12.69Z"})}),s=e=>(0,a.jsx)("svg",{width:"14",height:"16",viewBox:"0 0 14 16",fill:"#BEBDBF",...e,xmlns:"http://www.w3.org/2000/svg",children:(0,a.jsx)("path",{d:"M2.905 2.35377C2.905 3.19438 2.2575 3.87551 1.45833 3.87551C0.659167 3.87551 0.0116667 3.19438 0.0116667 2.35377C0.0116667 1.51377 0.659167 0.832031 1.45833 0.832031C2.2575 0.832031 2.905 1.51377 2.905 2.35377ZM2.91667 5.0929H0V14.832H2.91667V5.0929ZM7.57283 5.0929H4.67483V14.832H7.57342V9.7196C
17.57342 6.87699 11.0903 6.64447 11.0903 9.7196V14.832H14V8.66534C14 3.86881 8.7955 4.04351 7.57283 6.40464V5.0929Z",fill:"inherit"})}),o=e=>(0,a.jsx)("svg",{xmlns:"http://www.w3.org/2000/svg",width:24,height:24,viewBox:"0 0 24 24",...e,children:(0,a.jsx)("path",{d:"M19.615 3.184c-3.604-.246-11.631-.245-15.23 0-3.897.266-4.356 2.62-4.385 8.816.029 6.185.484 8.549 4.385 8.816 3.6.245 11.626.246 15.23 0 3.897-.266 4.356-2.62 4.385-8.816-.029-6.185-.484-8.549-4.385-8.816zm-10.615 12.816v-8l8 3.993-8 4.007z"})})}},function(e){e.O(0,[4996,9006,2493,2888,9774,179],function(){return e(e.s=98045)}),_N_E=e.O()}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.