I really enjoyed being yesterday one of the keynote speakers at the virtual Cloud Computing Conference Greece. Thanks Grigoris for the invitation and looking forward to a future edition in Greece! Below the slides of my 25 minutes talk about the future of relational databases on the cloud. And my experience juggling MySQL on AWS.
In a week time I will be a keynote speaker at the Cloud Computing Conference organized by Boussias in Greece. I will be (virtually) on stage discussing one of my favourite topics, The Future of Relational Databases on the Cloud.
The major cloud providers offer different options to run a relational database on the cloud. A recent approach is to rely on so-called serverless databases that offer both traditional TCP connections and HTTP API access. In a short journey to databases on the cloud, we will compare different approaches and services, explore the main benefits and limitations of a serverless RDBMS versus a more traditional managed database.
Can we draw the New York City skyline with Aurora Serverless v2?
An exciting day being on stage at re:Invent talking about elasticity and relational databases on the cloud as part of the Community Track. The video of the session will be available soon!
A prerecording of the session is available now on YouTube. Note: this is not the on-site in Las Vegas.
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.