## November 6th, 2023 - Instalment #178
Welcome to #178 of the Amazon Web Services open source newsletter, the place for all your Amazon Web Services and open source needs. This week we feature more new open source projects for you to practice your four freedoms. We have a useful tool that helps you synchronise your Amazon Web Services Identity Centre users with the users you provision in your [Amazon RDS](https://aws.amazon.com/cn/rds/?trk=cndc-detail) databases, we share the Amazon Web Services data solutions framework that helps you build data solutions following opinionated best practices, a resource explorer for your Amazon Web Services accounts, a guardrails solution for your Amazon Web Services account, and a couple of demo repositories that take a look at Localstack and RSS. Also featured in this edition is reading material that should keep you busy on a number of open source technologies, including Spring Boot, [Amazon Corretto](https://aws.amazon.com/cn/corretto/?trk=cndc-detail), Rust, MySQL, PostgreSQL, Kubernetes, [Amazon EKS](https://aws.amazon.com/cn/eks/?trk=cndc-detail), Apache Airflow, OpenSearch, Amazon Neuron, Finch, LangChain, PyTorch, Drupal, Apache Spark, Apache Iceberg, Karpenter, JupyterHub, Amazon SAM, SnapStart, and more.
**Feedback**
Before you dive in however, I need your help! Please please please take 1 minute to [complete this short survey](https://www.pulse.aws/promotion/10NT4XZQ?trk=cndc-detail) and you will forever have my gratitude!
### Celebrating open source contributors
The articles and projects shared in this newsletter are only possible thanks to the many contributors in open source. I would like to shout out and thank those folks who really do power open source and enable us all to learn and build on top of what they have created.
So thank you to the following open source heroes: Vadym Kazulkin, Ryan Stebich, Jason Andrews, Andrii Melashchenko, Lucas Soriano Alves Duarte, Apoorva Kulkarni, Ravi Yadav, Vara Bonthu, Giacomo Tomolillo, Justin Garrison, Phile Estes, Matt Muller, Chirag Dave, Shagun Arora, David Nalley, Nithya Ruff , Arun Gupta, Trevor Sullivan, and many others!
### Latest open source projects
*The great thing about open source projects is that you can review the source code. If you like the look of these projects, make sure you that take a look at the code, and if it is useful to you, get in touch with the maintainer to provide feedback, suggestions or even submit a contribution. The projects mentioned here do not represent any formal recommendation or endorsement, I am just sharing for greater awareness as I think they look useful and interesting!*
#### Tools
**sso-sync-to-amazon-rds**
[sso-sync-to-amazon-rds](https://aws-oss.beachgeek.co.uk/3e2?trk=cndc-detail) This project sets up Amazon Lambda functions, [Amazon EventBridge](https://aws.amazon.com/cn/eventbridge/?trk=cndc-detail) rule, [Amazon VPC](https://aws.amazon.com/cn/vpc/?trk=cndc-detail) Endpoint for Amazon IAM Identity Center (successor to Amazon Single Sign-On), the related Security Groups and permissions necessary to automatically provision database users to the Amazon Relational Database Service ([Amazon RDS](https://aws.amazon.com/cn/rds/?trk=cndc-detail)) cluster using Amazon Web Services Cloud Development Kit (Amazon CDK). When a new user is created in IAM Identity Center and the user belongs to the group specified in a IAM_IDC_GROUP_NAME variable, EventBridge rule will trigger the Lambda function. The Lambda function will create a new user in a specified [Amazon RDS](https://aws.amazon.com/cn/rds/?trk=cndc-detail) cluster. The user will then be able to login to the database using their SSO username and IAM credentials. Adding a user to the configured group will trigger the Lambda function as well.
![image.png](https://dev-media.amazoncloud.cn/68fdf519be6947daa060243ef70d2a47_image.png "image.png")
**aws-data-solutions-framework**
[aws-data-solutions-framework](https://github.com/awslabs/aws-data-solutions-framework?trk=cndc-detail) is a framework for implementation and delivery of data solutions with built-in Amazon Web Services best practices. Amazon Web Services Data Solutions Framework (DSF) is an abstraction atop Amazon Web Services services based on Amazon Web Services Cloud Development Kit (CDK) L3 constructs, packaged as a library. You can leverage Amazon Web Services DSF to implement your data platform in weeks rather than in months. Amazon Web Services DSF is available in TypeScript and Python. Use the framework to build your data solutions instead of building cloud infrastructure from scratch. Compose data solutions using integrated building blocks via Infrastructure as Code (IaC), that allow you to benefit from smart defaults and built-in Amazon Web Services best practices. You can also customize or extend according to your requirements. Check out the dedicated documentation page, complete with examples to get you started.
**resource-explorer-with-organizations**
[resource-explorer-with-organizations](https://aws-oss.beachgeek.co.uk/3dy?trk=cndc-detail) you may have a use cases where you are eager to find lingering resources, or resources that were not at their optimal settings. By utilising Resource Explorer and Step Functions, you can gather all the necessary information from these accounts, and use them to create a report to gain a wider understanding of the state of your Amazon Web Services accounts. As of this release, the limitation of Resource Explorer is that it is done on a per account basis. However, the README provides details of a workaround to deploy this to all your accounts in our Amazon Web Services Organization using StackSets. The use case shown in the repo shows you how you can find resources in an multiple Amazon Web Services accounts over multiple regions, and generating an Excel Document displaying the Account it belongs to, Name, Resource Type, and ARN of the resource.
![image.png](https://dev-media.amazoncloud.cn/2b9a3d8e241343c882c6885617f111ce_image.png "image.png")
The repo provides details of how you can deploy this tool, so make sure you check that out too.
**garnet-framework**
[garnet-framework](https://aws-oss.beachgeek.co.uk/3e1?trk=cndc-detail) Garnet is an open-source framework for building scalable, reliable and interoperable platforms leveraging open standards, FIWARE open source technology and Amazon Cloud services. It supports the development and integration of smart and efficient solutions across multiple domains such as Smart Cities, Regions and Campuses, Energy and Utilities, Agriculture, Smart Building, Automotive and Manufacturing. The repo provides code and links to the dedicated documentation site to help you get started.
![image.png](https://dev-media.amazoncloud.cn/9666b38af3ae42c8a727c3ef9b685565_image.png "image.png")
**aws-control-tower-controls-cdk**
[aws-control-tower-controls-cdk](https://aws-oss.beachgeek.co.uk/3e3?trk=cndc-detail) This pattern describes how to use Amazon CloudFormation and Amazon Web Services Cloud Development Kit (Amazon CDK) to implement and administer preventive, detective, and proactive Amazon Control Tower controls as infrastructure as code (IaC). A control (also known as a guardrail) is a high-level rule that provides ongoing governance for your overall Amazon Control Tower environment. For example, you can use controls to require logging for your Amazon accounts and then configure automatic notifications if specific security-related events occur. Check out the REAMDE for more details on what you can do with this.
![image.png](https://dev-media.amazoncloud.cn/dc7140c518954179a7c7675f1182ffd7_image.png "image.png")
### Demos, Samples, Solutions and Workshops
**serverless-rss-filtered-feed-gen**
[serverless-rss-filtered-feed-gen](https://aws-oss.beachgeek.co.uk/3dz?trk=cndc-detail) This is a configurable serverless solution that generates filtered rss feeds and makes them public accessible. Defined RSS sources are read at a given interval and new filtered feeds are generated and stored. The architecture uses a minimum number of Amazon Web Services services to keep it easy to maintain and cost-effective.
![image.png](https://dev-media.amazoncloud.cn/056a998f735a454aae85790940e3cd8f_image.png "image.png")
**localstack-aws-cdk-example**
[localstack-aws-cdk-example](https://aws-oss.beachgeek.co.uk/3dw?trk=cndc-detail) This repo aims to showcase the usage of [Localstack](https://aws-oss.beachgeek.co.uk/3dx?trk=cndc-detail) and Amazon CDK to address specific integration challenges regarding local development where the end target is the Amazon Web Services platform. If you are unfamiliar with Localstack, it is an open source, fully functional local Amazon Web Services cloud stack that allows you to develop and test your cloud and Serverless apps offline.
**powertools-lambda-kotlin**
[powertools-lambda-kotlin](https://aws-oss.beachgeek.co.uk/3dv?trk=cndc-detail) This project demonstrates the Lambda for Powertools Kotlin module deployed using Serverless Application Model with Gradle running the build. This example is configured for Java 8 only; in order to use a newer version, check out the Gradle configuration guide in the main project README. You can also use sam init to create a new Gradle-powered Powertools application - choose to use the [Amazon Q](https://aws.amazon.com/cn/q/?trk=cndc-detail)uick Start Templates, and then Hello World Example with Powertools for Amazon Lambda, Java 17 runtime, and finally gradle.
### Amazon Web Services and Community blog posts
**Community round up**
This weeks community round up starts with a great post from Amazon Web Services Community Builder Vadym Kazulkin, who shares his deep expertise in Java and [Amazon Corretto](https://aws.amazon.com/cn/corretto/?trk=cndc-detail), and explores how he measured cold start times when using [Amazon Corretto](https://aws.amazon.com/cn/corretto/?trk=cndc-detail) 17 and SnapStart in his post, [Measuring Lambda cold starts with Amazon Web Services SnapStart - Part 8 Measuring with Java 17](https://aws-oss.beachgeek.co.uk/3dr?trk=cndc-detail). Make sure you check his previous posts too. Next we have a couple of posts on Kubernetes, starting with Ryan Stebich and his guide on how you can consume secrets within your Kubernetes workloads, in [Easily Consume Amazon Web Services Secrets Manager Secrets From Your Amazon EKS Workloads](https://aws-oss.beachgeek.co.uk/3ds?trk=cndc-detail). This is an excellent post, and man could I have used this a few months ago when I was trying to figure this stuff out. Following that we have a subject near and dear to my heart, multi-architecture systems. I have done many talks on this in the past, as well as blog posts and code examples, so was super excited to read [Multi-architecture Kubernetes clusters on Amazon EKS](https://aws-oss.beachgeek.co.uk/3dt)from Amazon Web Services Community Builder Jason Andrews. Great stuff! The final post this week comes from AWS Community Builder Andrii Melashchenko, who looks at at generating a CI/CD pipeline using [AWS Serverless Application Model](https://aws.amazon.com/cn/serverless/sam/?trk=cndc-detail) (SAM), Node.js, and GitHub Actions in his post, [An efficient way to build your serverless microservices. Part 3. CI/CD with AWS SAM.](https://aws-oss.beachgeek.co.uk/3du).
**Jupyter**
In [Building multi-tenant JupyterHub Platforms on Amazon EKS](https://aws-oss.beachgeek.co.uk/3do), Lucas Soriano Alves Duarte, Apoorva Kulkarni, Ravi Yadav, and Vara Bonthu collaborate to share information on the process of building, deploying, and harnessing the power of multi-tenant JupyterHub environments on [Amazon EKS](https://aws.amazon.com/cn/eks/?trk=cndc-detail) at scale. This is a must read post this week, with the level of depth as well as completeness that this solution provides should make it of interest to everyone. \[hands on]
![image.png](https://dev-media.amazoncloud.cn/87b90b3e7d4b49a5b24ea3c1fb16670f_image.png "image.png")
**Kubernetes**
A couple of updates this week.
First is news that Karpenter, a Kubernetes node lifecycle manager, that was donated to the Cloud Native Computing Foundation (CNCF) as part of Kubernetes Autoscaling Special Interest Group, has now progressed from alpha to beta. What does this mean? Well find out by reading the post, [Karpenter graduates to beta](https://aws.amazon.com/blogs/containers/karpenter-graduates-to-beta/?trk=cndc-detail), where Giacomo Tomolillo and Justin Garrison share all.
Following that we had a case study from Lacework, who shared some of their learnings from their experience in operating Kubernetes Batch jobs at scale in the post, [Lacework’s batch workloads on Amazon EKS: Lessons learned ](https://aws-oss.beachgeek.co.uk/3dq?trk=cndc-detail). Abhi Karode, Shane Corbett, Vara Bonthu, together with Derek Brown at Lacework go into details and leave with three key take aways for you to think about.
![image.png](https://dev-media.amazoncloud.cn/a5a482c91350475eb72991ba1908462b_image.png "image.png")
**Big Data and Analytics**
* [Impactful features in PostgreSQL 15](https://aws-oss.beachgeek.co.uk/3dg?trk=cndc-detail) is a must read post that looks at some of the most impactful features of PostgreSQL 15. We explore the MERGE statement, new WAL compression algorithms, enhancements to logical replication and PUBLIC schema permissions, improvements to partition tables, and some general performance improvements \[hands on]
![image.png](https://dev-media.amazoncloud.cn/0b2afa52987b435ab5e217a43a19c9ff_image.png "image.png")
* [Powering Amazon RDS with AWS Graviton3: Benchmarks](https://aws-oss.beachgeek.co.uk/3dd?trk=cndc-detail) compare the performances of AWS Graviton2 and Amazon Web Services Graviton3 instances on open-source engines supported by [Amazon RDS](https://aws.amazon.com/cn/rds/?trk=cndc-detail), to validate them from a db-centric perspective - a must read! \[hands on]
![image.png](https://dev-media.amazoncloud.cn/5085d063cb0547dab8a5b914a5ad5c76_image.png "image.png")
* [Use Amazon DynamoDB incremental export to update Apache Iceberg tables](https://aws-oss.beachgeek.co.uk/3de?trk=cndc-detail) explains how to bulk process a series of full and incremental exports using [Amazon EMR](https://aws.amazon.com/cn/emr/?trk=cndc-detail) Serverless with Apache Spark to produce a single Apache Iceberg table \[hands on]
![image.png](https://dev-media.amazoncloud.cn/c677d9ccfb4c43ee927e8de66e7c6f66_image.png "image.png")
* [Use Snowflake with Amazon MWAA to orchestrate data pipelines](https://aws-oss.beachgeek.co.uk/3df?trk=cndc-detail) provides an overview of orchestrating your data pipeline using Snowflake operators in your Amazon MWAA environment \[hands on]
![image.png](https://dev-media.amazoncloud.cn/e0eb81543bbf440c9b1e60854804ebf1_image.png "image.png")
* [Enable cost-efficient operational analytics with Amazon OpenSearch Ingestion](https://aws-oss.beachgeek.co.uk/3dj?trk=cndc-detail) demonstrates how to use OpenSearch Ingestion pipelines to build a cost-optimized infrastructure for log analytics and observability events \[hands on]
![image.png](https://dev-media.amazoncloud.cn/4e688443ba844c6da52cd59d8d57b86f_image.png "image.png")
* [An automated approach to perform an in-place engine upgrade in Amazon OpenSearch Service](https://aws-oss.beachgeek.co.uk/3dk?trk=cndc-detail) discusses what to consider when planning to upgrade your existing Elasticsearch engine in your OpenSearch Service domain to the OpenSearch engine
* [Spark on Amazon Lambda: An Apache Spark runtime for Amazon Lambda](https://aws-oss.beachgeek.co.uk/3dl?trk=cndc-detail)highlights the Spark on [AWS Lambda](https://aws.amazon.com/cn/lambda/?trk=cndc-detail) (SoAL) architecture, provides infrastructure as code (IaC), offers step-by-step instructions for setting up the SoAL framework in your Amazon Web Services account, and outlines SoAL architectural patterns for enterprises \[hands on]
![image.png](https://dev-media.amazoncloud.cn/d5848785c1ee457eb613238a357ccc00_image.png "image.png")
**Other posts and quick reads**
* [Intelligently search Drupal content using Amazon Kendra](https://aws-oss.beachgeek.co.uk/3dh?trk=cndc-detail) shows you how to use the [Amazon Kendra](https://aws.amazon.com/cn/kendra/?trk=cndc-detail) Drupal connector to configure the connector as a data source for your [Amazon Kendra](https://aws.amazon.com/cn/kendra/?trk=cndc-detail) index and search your Drupal documents \[hands on]
* [Intelligent document processing with Amazon Textract, Amazon Bedrock, and LangChain](https://aws-oss.beachgeek.co.uk/3di?trk=cndc-detail) looks at the various mechanisms of augmenting an intelligent document processing (IDP) workflow with LLMs via [Amazon Bedrock](https://aws.amazon.com/cn/bedrock/?trk=cndc-detail), [Amazon Textract](https://aws.amazon.com/cn/textract/?trk=cndc-detail), and the popular open source LangChain framework \[hands on]
![image.png](https://dev-media.amazoncloud.cn/b48db0e8b8d743bf95cbfd75c9ee8076_image.png "image.png")
* [Intuitivo achieves higher throughput while saving on AI/ML costs using Amazon Inferentia and PyTorch](https://aws-oss.beachgeek.co.uk/3dn?trk=cndc-detail) provides an interesting case study on how this customer was able to see a five times increase in processing speed and a 95 percent reduction in inference costs compared to our previous solution
### Quick updates
**NodeJS**
If you are a NodeJS developer, then make sure you read [Announcing the end of support for Node.js 14.x in the Amazon Web Services SDK for JavaScript (v3)](https://aws-oss.beachgeek.co.uk/3da?trk=cndc-detail), that looks at important news around end of life support and options you can consider.
**Ruby**
Along similar lines to the previous update, we also saw the end of life announcement for users of the Ruby 2.3 and 2.4 runtimes in the Amazon Web Services SDK for Ruby. Check out the details in Matt Muller's post, [Announcing the end of support for Ruby runtimes 2.3 and 2.4 for the Amazon Web Services SDK For Ruby](https://aws.amazon.com/blogs/developer/announcing-the-end-of-support-for-ruby-runtimes-2-3-and-2-4-for-the-aws-sdk-for-ruby/?trk=cndc-detail)
**Finch**
Great news for folks looking for a great tool to work with container. Last week we announced the general availability of Finch, an open source command line tool that allows developers to build, run, and publish Linux containers on macOS. With this release, we are also launching a website that should help you find all the Finch-related information, tutorials, and other resources to get started with Finch.
Since we first announced Finch in November 2022, we have launched capabilities that enhance the developer experience when working with containers locally and interacting with container registries. We introduced container image signing, and support for both creating and running images using Seekable OCI (SOCI), an Amazon Web Services open-source technology for faster container launches by lazily loading the container image. We addressed key papercuts including persistent disk support and VM initialisation time reduction, and created a benchmark tool to continually measure and improve Finch performance.
Check out the official blog post, [Ready for Flight: Announcing Finch 1.0 GA!](https://aws-oss.beachgeek.co.uk/3d7?trk=cndc-detail)where Phil Estes provides a detailed recap of progress made since the announcement, and what you can expect going forward.
**Amazon Neuron**
[Amazon Neuron](https://aws-oss.beachgeek.co.uk/3d8?trk=cndc-detail) is a software development kit (SDK) enabling high-performance deep learning acceleration using Amazon Inferentia and Trainium, Amazon Web Services's custom designed machine learning accelerators. Neuron includes a compiler, runtime driver, as well as debug and profiling utilities with a TensorBoard plugin for visualisation, and is pre-integrated into popular machine learning frameworks like Pytorch, TensorFlow and MXNet, to provide a seamless machine learning acceleration workflow. Last week saw the release of Neuron 2.15, which now adds support for Llama-2 70b model training as well as PyTorch 2.0 support.
**OpenSearch**
A few updates this week for OpenSearch fans.
Users can now benefit from more efficient query filtering with OpenSearch’s k-NN FAISS engine by using OpenSearch 2.9 on the [Amazon OpenSearch Service](https://aws.amazon.com/cn/opensearch-service/?trk=cndc-detail). Previously exclusive to OpenSearch’s Lucene k-NN engine, OpenSearch’s efficient vector query filters capability intelligently evaluates optimal filtering strategies—like pre-filtering with approximate nearest neighbor (ANN) or filtering with exact k-nearest neighbor (k-NN)—to determine the best strategy to deliver accurate and low latency vector search queries. In earlier OpenSearch versions, vector queries on the FAISS engine used post-filtering techniques, which enabled filtered queries at scale, but it potentially returns less than the requested “k” number of results. Efficient vector query filters have demonstrated the ability to deliver low latency and accurate results enabling customers to create more responsive vector search applications such as semantic or visual search experiences. Vector query filters is a key enabler for hybrid search empowering users to perform vector search while filtering on metadata to retrieve more relevant information using both vector and lexical techniques. This new feature enhances OpenSearch’s existing query filtering capability by providing improved accuracy and speed.
Following that is news that [Amazon OpenSearch Service](https://aws.amazon.com/cn/opensearch-service/?trk=cndc-detail) now offers customers the option to use Internet Protocol version 6 (IPv6) addresses for their new and existing domains. Customers moving to IPv6 can simplify their network stack by running their OpenSearch Service domains on a network that supports both IPv4 and IPv6.
**PostgreSQL**
We had a flurry of updates this week covering all things PostgreSQL.
First up is news that [Amazon Aurora](https://aws.amazon.com/cn/rds/aurora/?trk=cndc-detail) PostgreSQL-Compatible Edition now supports the mysql_fdw extension which allows your PostgreSQL database to connect and retrieve data stored in [Amazon Aurora](https://aws.amazon.com/cn/rds/aurora/?trk=cndc-detail) MySQL-compatible, RDS MySQL, and self-managed MySQL and MariaDB databases. Foreign Data Wrappers are libraries for PostgreSQL databases that can communicate with an external data source, abstracting the details of connecting to the data source and obtaining data from it. The mysql_fdw PostgreSQL extension provides a Foreign Data Wrapper for easy and efficient federated query access to MySQL and MariaDB compatible databases. To get started, see Working with MySQL databases by using the mysql_fdw extension. The mysql_fdw extension is available on Aurora PostgreSQL 15.4, 14.9, 13.12, 12.16 and higher.
Next up is an update to the [Amazon Aurora](https://aws.amazon.com/cn/rds/aurora/?trk=cndc-detail) PostgreSQL query plan management supported by the apg_plan_mgmt extension, that now includes the ability to capture query plans on read-only replica instances. Query plan management (QPM) includes other improvements in this version such as limiting the capture of query plans based on the estimated cost. The PostgreSQL query optimiser creates a query execution plan for a SQL statement at a specific point in time. As conditions change, the optimiser might pick a different plan which changes performance. QPM provides you with capabilities such as: limiting the optimiser to a small number of known good plans, assess the impact of creating or dropping an index, and automatically detect lower cost plans. By using the new extension function create_replica_plan_capture, you can now capture query plans generated from all your replicas and store the captured plans in the apg_plan_mgmt schema tables using the postgres_fdw extension. QPM can then apply the approved plans that you identify across all your replicas including [Amazon Aurora](https://aws.amazon.com/cn/rds/aurora/?trk=cndc-detail) global databases. The apg_plan_mgmt extension version 2.5 is available on Aurora PostgreSQL 15.4, 14.9, 13.12, 12.16 and higher.
The final update this week looked at an update to Amazon Relational Database Service ([Amazon RDS](https://aws.amazon.com/cn/rds/?trk=cndc-detail)) Blue/Green Deployments. This now supports safer, simpler, and faster updates to your [Amazon Aurora](https://aws.amazon.com/cn/rds/aurora/?trk=cndc-detail) PostgreSQL-Compatible Edition and [Amazon RDS](https://aws.amazon.com/cn/rds/?trk=cndc-detail) for PostgreSQL databases. Blue/Green Deployments create a fully managed staging environment using PostgreSQL community logical replication, that allows you to deploy and test production changes, keeping your current production database safer. With a few clicks, you can promote the staging environment to be the new production system in as fast as a minute, with no data loss and no changes to your application to switch database endpoints. Use [Amazon RDS](https://aws.amazon.com/cn/rds/?trk=cndc-detail) Blue/Green Deployments for deploying changes to production, such as major version database engine upgrades, schema changes, maintenance updates, and scaling instances. Blue/Green Deployments use built-in switchover guardrails that will time-out promotion of the staging environment if it exceeds your maximum tolerable downtime, detects replication errors, or identifies instance health check errors.
Chirag Dave dives deeper on this topic in the post, [New – Fully managed Blue/Green Deployment in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL](https://aws-oss.beachgeek.co.uk/3db?trk=cndc-detail)
**MySQL**
A few updates this week for MySQL users.
The most important one which you should know about is starting last week, long-term support (LTS) will be provided on [Amazon Aurora](https://aws.amazon.com/cn/rds/aurora/?trk=cndc-detail) MySQL-Compatible Edition 3 (with MySQL 8.0 compatibility) on the Aurora MySQL 3.04 (compatible with MySQL 8.0.28) minor version. Database clusters that use LTS releases can stay on the same minor version for at least three years. During the lifetime of an Aurora MySQL LTS release, new patches introduce fixes to critical matters such as security issues. These patches don't include any new features.
Making MySQL restarts quicker is the focus of the next update. [Amazon Aurora](https://aws.amazon.com/cn/rds/aurora/?trk=cndc-detail) MySQL now includes optimisations that reduce the database restart time by up to 65% versus without optimisations. These improvements are achieved by deferring portions of the buffer pool initialisation and validation process to occur after the database is already online and accepting connections. These optimisations will improve database availability for unplanned events such as unexpected database restarts and planned operations such as minor version upgrades. To learn more about availability benefits, you can refer to our blog titled ‘Reduce downtime with [Amazon Aurora](https://aws.amazon.com/cn/rds/aurora/?trk=cndc-detail) MySQL database restart time optimisations’. These optimisations are enabled by default on Aurora MySQL versions 3.05 and higher.
You can dive deeper by reading[ Reduce downtime with Amazon Aurora MySQL database restart time optimizations](https://aws-oss.beachgeek.co.uk/3d9?trk=cndc-detail), where Shagun Arora looks at the new Aurora MySQL optimisations introduced in Aurora MySQL version 3 that allow for reduced downtime and fewer disruptions to your workloads after a restart.
The final MySQL update was news from last week, where we announced news that [Amazon Aurora](https://aws.amazon.com/cn/rds/aurora/?trk=cndc-detail) MySQL-Compatible Edition 3 (with MySQL 8.0 compatibility) will support MySQL 8.0.32. In addition to several security enhancements and bug fixes, MySQL 8.0.32 includes several improvements, such as Instant DDL support for drop column operations, support for new language-specific collations, Generated Invisible Primary Keys (GIPKs), and performance schema monitoring enhancements. For more details, refer to the Aurora MySQL 3 and MySQL 8.0.32 release notes. This release includes optimisations that reduce the database restart time by up to 65% versus without optimisations.
### Videos of the week
**Open Source at Amazon**
If you missed this last week, my colleagues David Nalley and Nithya Ruff joined Arun Gupta for a fire side chat about why Amazon cares about and contributes to open source.
https://youtu.be/dzvKxlc3pQg?trk=cndc-detail
**Rust Programming Tutorial for Developers**
Join Trevor Sullivan as he takes a look at the preview version of their Software Development Kit (SDK) for Rust developers. You can use the Rust SDK to interact with nearly any service in the Amazon Web Services portfolio. In the video, you will explore the Rust SDK for Amazon Web Services, and learn how it's designed, and spend some hands-on time with the [Amazon S3](https://aws.amazon.com/cn/s3/?trk=cndc-detail) service. You will also learn how to research calling APIs including the CreateBucket and PutObject operations, which are among the most common in the S3 service.
https://youtu.be/rXL8i4nGY6s?trk=cndc-detail
**CI CD Pipeline with Spring Boot and Amazon Web Services**
In this extended video, you will see how you can set up a CI CD Pipeline with Spring Boot and Amazon Web Services.
https://youtu.be/Ut-yDePowbY?trk=cndc-detail
# Events for your diary
If you are planning any events in 2023, either virtual, in person, or hybrid, get in touch as I would love to share details of your event with readers.
**Amazon Web Services User Group, Palma**\
**November, 14th, 5pm-9pm Parc Bit - Fundació IBIT**
I am happy to join Miguel Salvà at the PAWS (Amazon Web Services User Group in Palma) for an evening of open source talks, covering a broad range of topics from OSPO's, working with open source communities, and open source at Aamzon. Going to be great. You can find out more by checking out the user groups page, [PAWS User Group](https://aws-oss.beachgeek.co.uk/3b6?trk=cndc-detail)
**Big Data Europe**\
**21st-24th November, Online/Vilnius, Lithuania**
I will be speaking at the Big Data Europe event, talking about how you can shift left and apply modern developer approaches to manage your Apache Airflow workflows. This builds upon a lot of the other work I have done in this space, so am really looking forward to doing this talk.
Check out the[ event page ](https://labsoflatvia.com/en/events/big-data-conference-europe-2023?trk=cndc-detail)for registration details, as well as to check out all the other sessions - many of which feature open source projects and technologies.
**re:Invent**\
**November, 27th-1st December, Las Vegas, USA**
The annual must attend conference for all Amazon Web Services developers is back, and with another strong line up of open source sessions, chalk talks, builder sessions, workshops and more. There will be a super cool open source booth, with a line up of great demos - I have taken a sneak look and so make sure you check out the demo schedule on the booth.
Find out more by checking out the event page, [re:Invent 2023](https://reinvent.awsevents.com/?trk=cndc-detail)
**Cortex**\
**Every other Thursday, next one 16th February**
The Cortex community call happens every two weeks on Thursday, alternating at 1200 UTC and 1700 UTC. You can check out the GitHub project for more details, go to the [Community Meetings](https://aws-oss.beachgeek.co.uk/2h5?trk=cndc-detail) section. The community calls keep a rolling doc of previous meetings, so you can catch up on the previous discussions. Check the [Cortex Community Meetings Notes](https://aws-oss.beachgeek.co.uk/2h6?trk=cndc-detail) for more info.
**OpenSearch**\
**Every other Tuesday, 3pm GMT**
This regular meet-up is for anyone interested in OpenSearch & Open Distro. All skill levels are welcome and they cover and welcome talks on topics including: search, logging, log analytics, and data visualisation.
Sign up to the next session, [OpenSearch Community Meeting](https://aws-oss.beachgeek.co.uk/1az?trk=cndc-detail)
### Stay in touch with open source at Amazon Web Services
Remember to check out the [Open Source homepage](https://aws.amazon.com/opensource/?opensource-all.sort-by=item.additionalFields.startDate\\&opensource-all.sort-order=asc?trk=cndc-detail) to keep up to date with all our activity in open source by following us on [@AWSOpen](https://twitter.com/AWSOpen?trk=cndc-detail)