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.
Looking forward to be a speaker on March 11th at TheCloudFirst, the cloud native conference, and talk about one of my favorite topics, serverless databases on AWS.
For the first time, I will cover the preview of Aurora Serverless v2, the new serverless MySQL compatible database announced by AWS at re:Invent 2020.
Is Serverless the Future of Relational Databases?
From AWS to Google Cloud, the major cloud providers offer different options to run a relational database on the cloud. You can spin up virtual machines and configure your own cluster or rely on managed services. But the new trend is serverless (relational) databases that offer both traditional interfaces and HTTP API access. This talk is personal journey on AWS moving from a managed MySQL to a serverless Aurora. Can serverless really be the future for the enterprise databases?
“Serverless Databases: The Good, the Bad, and the Ugly” is the topic of my talk at Percona Live Online. After a lightning talk at Percona Live Europe in Dublin and a few posts for the Percona Community Blog, I am looking forward to be (virtually) on stage at Percona Live Online!
The conference will run for 28 hours on 20-21 October 2020 and will cover topics on Open Source Databases and Applications using MySQL, PostgreSQL, MongoDB, and MariaDB. You can find the full agenda online and register for free.
Is serverless the future of relational databases? Looking forward to be part of DeveloperWeek Global: Cloud Conference, one of the world’s largest virtual software developer event series, and discuss relational databases on the cloud. See you online at the end of September!
AWS has recently made AWS Wavelength zones in San Francisco and Boston available to provide a subset of their computing services on Verizon datacenters. The new zones will allow developers to build applications that can benefit from the ultra-low latency of the mobile carriers.
HashiCorp, the company behind the software tool Terraform, introduces a platform to run their products on AWS, Azure, and GCP as managed services. This will extend their enterprise offer with a focus on multi-cloud environments.