Zero-ETL integration With Amazon Aurora MySQL and Amazon Redshift

Swami Sivasubramanian, Vice President of Database, Analytics, and Machine Learning at Amazon Web Services, has said that “data is at the center of every application, process, and business decision

[{"selector":"#anim-4975da10-aea6-42ac-a528-a5b1f51d465c [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(36.069749131772724%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-77945ff5-3672-4dbf-a54d-63180906207a","keyframes":{"transform":["scale(1)","scale(1.5)","scale(0.95)","scale(1)"],"offset":[0,0.33,0.66,1]},"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}]

This integration will be available in public preview for the Amazon Aurora MySQL-Compatible Edition in June 2023

[{"selector":"#anim-33314ade-2e5a-4e51-a8c9-a319dced9275 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-35.21169345865223%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}]

Now available to the wider public: Amazon Redshift interaction with the Amazon Aurora MySQL zero-ETL system

[{"selector":"#anim-60acd203-d110-4fc7-bb4f-e2e3a9e8cae9 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(35.34967836769406%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-284f2c46-9c70-4468-aefa-68ee38b2af2b","keyframes":{"transform":["translate3d(-129.11877%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .8, 1)","fill":"both"}] [{"selector":"#anim-e100573b-edbe-4fee-a77a-7879fec1bc3c","keyframes":{"transform":["rotateZ(-180deg)","rotateZ(0deg)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .5, 1)","fill":"forwards"}]

AWS are pleased to announce today that the general availability of the Amazon Aurora MySQL zero-ETL integration with Amazon Redshift is now available

[{"selector":"#anim-6793cfa6-a558-4e01-8770-d689c6c115f2 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(35.937499914669296%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-2dbaaf06-ba90-4a0c-8cb6-72f677c9072d","keyframes":[{"offset":0,"transform":"translate3d(0, -143.18533%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.29,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.45,"transform":"translate3d(0, -40.263714796%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.61,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.71,"transform":"translate3d(0, -13.688517548%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.85,"transform":"translate3d(0, -5.140353347%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.96,"transform":"translate3d(0, -2.2336911479999997%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":600,"fill":"both"}]

This zero-ETL interface between Amazon Aurora and Amazon Redshift enables you to execute near real-time analytics and machine learning (ML)

[{"selector":"#anim-f29c314a-d9ba-4af1-9f68-5037326db477 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(35.34967836769406%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-d4ee44e0-fdeb-4e13-b713-5be8ebad5bd0","keyframes":{"transform":["translate3d(135.12397%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .8, 1)","fill":"both"}] [{"selector":"#anim-b5999e8a-bd40-424a-884e-b0ea95ed78e5","keyframes":{"transform":["rotateZ(180deg)","rotateZ(0deg)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .5, 1)","fill":"forwards"}]

analytics from numerous Aurora MySQL database clusters in Amazon Redshift, which will allow you to obtain holistic insights across a large number of apps or partitions

[{"selector":"#anim-83368af3-f984-441e-ae24-ff7b19e23fbc [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-34.249999904429615%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-ac88d19e-f1e7-453d-912a-4ff0a1ab6a49","keyframes":{"transform":["translate3d(128.73564%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .8, 1)","fill":"both"}] [{"selector":"#anim-d64c9b36-ecae-4683-a44b-5e3fcab6ef09","keyframes":{"transform":["rotateZ(180deg)","rotateZ(0deg)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .5, 1)","fill":"forwards"}]

Amazon Redshift’s analytics and built-in machine learning capabilities, such as materialized views, cross-Region data sharing, and federated access to different data stores and data lakes

[{"selector":"#anim-76cfb189-eb86-4ea0-b53d-b656103a4793 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(35.21169345865223%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-7576d115-622b-4554-9dde-e3b9f2b5abcd","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-79e8e555-d6fc-4120-9052-587e163ba06b","keyframes":{"transform":["translate3d(115.84158%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

MySQL-compatible versions of Amazon Aurora are presently supported by the Amazon Aurora zero-ETL Integration with Amazon Redshift For more details govindhtech.com

[{"selector":"#anim-414e1bf6-9dbe-48d1-9b87-8592f17f2ccc [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-c89ece71-1dd7-4a9c-9715-d0125c4aeafc","keyframes":[{"offset":0,"transform":"translate3d(0, -143.27136%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.29,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.45,"transform":"translate3d(0, -40.287906432%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.61,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.71,"transform":"translate3d(0, -13.696742016%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.85,"transform":"translate3d(0, -5.143441824%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.96,"transform":"translate3d(0, -2.2350332159999997%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":600,"fill":"both"}]