Just over two weeks to go to re:Invent in Las Vegas and I am already looking forward to the Monday Community Track.
If you are attending the event in person, there are still some reserved seats available for my session where we will play around with serverless databases on AWS. Join me! COM202 Drawing the New York City skyline with Amazon Aurora Serverless v2 Monday, November 29, 2:30 PM – 3:30 PM
The session will be available as well virtually during the main re:Invent week.
I am looking forward to be back at Codemotion DevCast on June 24th. This time we will discuss relational databases in the serverless world, with (hopefully) a demo of Aurora Serverless v2. See you soon online! The event is free and in Italian, registration required.
During the latest re:Invent, AWS announced the preview of next version of Amazon Aurora Serverless that scales in fraction of a second and will introduce multi-AZ support, global databases, and read replicas to the serverless world.
In my talk at Percona Live 2021, today I tried to answer the following questions:
What are the differences between v1 and v2?
Why did AWS introduced an entirely new product?
Is Aurora Serverless v1 a service to be already forgotten?
A simple test on Serverless v1 versus Serverless v2: any surprise?
Below are my slides, video will be available online soon. Thanks to all the ones who attended the talk!
One of the key system variables you have to deal with MySQL is innodb_buffer_pool_size, the size of the buffer pool, the memory area where InnoDB caches table and index data. You try to learn how to set a sensible value and you usually hope you do not need to change it too often.
One day you start to play with serverless databases and everything changes: you can see the value of innodb_buffer_pool_size changing real time, every few seconds. According to the load of your database cluster.
Next month I will dig deeper at Percona Live: looking at a direct correlation in the metrics between the capacity, the value of innodb_buffer_pool_size and the load of the database is just an interesting start.