Configure replica for history mode (optional) link If yours doesn't, follow MariaDB's instructions to create one. Most production deployments already have a read replica. Because we use the same internal system as a read replica, we have the same load impact. Using a read replica allows Fivetran to integrate your data without putting extra strain on your primary database. If you'd like, create a read replica for Fivetran's exclusive use. Learn more in AWS’ PrivateLink documentation.įollow our AWS PrivateLink setup guide to configure PrivateLink for your database. PrivateLink is the most secure connection method. IMPORTANT: You must have a Business Critical plan to use AWS PrivateLink.ĪWS PrivateLink allows VPCs and AWS-hosted or on-premises services to communicate with one another without exposing traffic to the public internet. Learn how in the Security section of the MariaDB reference manual for your database version. If you want Fivetran to tunnel SSH over TLS, you must first enable TLS on your database. To connect using SSH, configure your firewall and/or other access control systems to allow incoming connections from your SSH tunnel server's IP address to your port (usually 3306).īefore you proceed to the next step, you must follow our SSH connection instructions. You must connect through SSH if your database is in an inaccessible subnet. How you do this will vary based on how your MariaDB database is hosted (cloud platform, on-premises, etc.) Connect using SSH (TLS optional) linkįivetran connects to a separate server in your network that provides an SSH tunnel to your database. If you connect directly, configure your firewall and/or other access control systems to allow incoming connections to your MariaDB port (usually 3306) from Fivetran's IPs for your database's region. Learn how to enable TLS on your database in the Security section of the MariaDB reference manual for your database version.įivetran connects directly to your MariaDB database. IMPORTANT: You must have TLS enabled on your database to connect directly to Fivetran. NOTE: We do not support connecting to a load balancer. Choose connection method linkįirst, decide whether to connect Fivetran to your MariaDB database directly, using an SSH tunnel, or using AWS PrivateLink. To learn the differences between the two mechanisms, see our incremental update documentation. To keep your data up to date after the initial sync, we use one of the following incremental sync methods:Įach of these methods keeps a record of recent data changes, which allows Fivetran to update only the data that has changed since our last sync. Setup instructions link Choose incremental sync mechanism link Prior to version 10.1.2, fractional seconds were stored differently, which causes problems with our incremental updates. * MariaDB versions earlier than 10.1.2 may function correctly with the exception of fractional seconds in TIME, TIMESTAMP, and DATETIME columns. (If you're using TLS) Your server must support at least TLSv1.0, but we recommend TLSv1.2 or above. NOTE: The replica ID is a unique ID within the MariaDB replica set. We provide a random replica ID in your setup form, but you can provide your own if you'd prefer or if the form's replica ID conflicts with one of your existing replica IDs. We need this ID because we connect to your database as a replica.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |