apavlo

16 ms·

121.
by apavlo 5y ago
Thanks! Word is bond.
122.
by apavlo 5y ago
Reach out to us and we'll make sure you get notified: https://ottertune.com/contact
123.
by apavlo 5y ago
> I see you can setup using CloudFormation. Any chance terraform is on the roadmap? Yes, we will be adding support for TerraForm by next month. > On a personal note, thanks for everything you do. You're welcome! But database rese
124.
by apavlo 5y ago
Alvaro! Good to hear from you. We really like the Ongres conf management tool. We just haven't come across anybody using it for on-prem DBs in the wild. As I said above, everyone that we've talked to rolls their conf management to
125.
by apavlo 5y ago
Lots to unpack here. > I'm a little curious why AWS is free/cheap, but anything other than AWS ends up in the "Enterprise, contact us for pricing" bucket. It might simply be based on your costs. I don't know if t
126.
by apavlo 5y ago
Good catch. Fixed!
127.
by apavlo 5y ago
Our expected usage for the current version of OtterTune is that you will enable tuning and then let the ML algorithms figure out your workload patterns. The models will then converge with an optimal config and then you switch it back into m
128.
by apavlo 5y ago
Yes. It's on our roadmap for next year.
129.
by apavlo 5y ago
We have had very few requests to support GCP. After AWS and on-prem, the next most requested platform is Azure. If you really want GCP, let us know here: https://ottertune.com/contact
130.
by apavlo 5y ago
It's play on the word "autotune". Otters are also vicious animals, which is an important trait to have if you are working with databases: https://youtu.be/J7f6s2g8C0I
131.
by apavlo 5y ago
We have deployed OtterTune for on-prem databases (baremetal, containers). But we are not offering that to everyone right now because organizations manage their configurations for these deployments in a bunch of different ways (Github action
132.
by apavlo 5y ago
It's true that for static workloads/databases, you don't need continuous tuning. But as you add new app features, grow database size, upgrade DBMS versions, and make other changes, OtterTune tracks your system to make sure yo
133.
by apavlo 5y ago
It depends on the workload (OLTP vs. OLAP, read-heavy vs. write-heavy). In our original research paper ( https://db.cs.cmu.edu/papers/2017/p1009-van-aken.pdf ), we came up with an automated way of determining which
134.
by apavlo 5y ago
Details about our new self-service offering using Fargate is available here: https://ottertune.com/blog/ottertune-2021-10-product-update
135.
by apavlo 5y ago
We have done two major deployments of OtterTune in Europe. One of them we published a VLDB paper about ( https://ottertune.com/blog/vldb-autonomous-database-tuning-i... ). Their infosec people looked at the data OtterTun
136.
Show HN: OtterTune – Automated Database Tuning Service for RDS MySQL/Postgres
164 points by apavlo 5y ago|63 comments
137.
by apavlo 5y ago
Yo. It's Andy@OtterTune here. OtterTune does not need to access user tables or view queries (nor do we want to). OtterTune only collects runtime metrics from the database (e.g., InnoDB stats, pg_stat_database) and CloudWatch. These p
138.
by apavlo 5y ago
> SQL survived the key/value fad SQL has survived every fad since the 1970s: Stonebraker "What Goes Around Comes Around" https://people.cs.umass.edu/~yanlei/courses/CS691LL-f06/pape...
139.
by apavlo 5y ago
OtterTune is something that we have been working on at Carnegie Mellon for several years now. Your overall assessment of our approach is correct. OtterTune uses Bayesian Optimization, either with a GP or DNN as the surrogate model to predic
140.
by apavlo 6y ago
Andy from Carnegie Mellon here. This is impressive work. My PhD student and I have looked into similar methods for autotuning config knobs for MySQL + Postgres: https://db.cs.cmu.edu/projects/ottertune/ One of the
141.
by apavlo 6y ago
Email me (pavlo@cs.cmu.edu). I don't think you ever had an account.
142.
by apavlo 6y ago
We have seen up to a 2x improvement in Postgres' throughput after tuning it with OtterTune over the default Amazon configuration. Here is an overview of how OtterTune's algorithms work: https://aws.amazon.com/blogs
143.
by apavlo 6y ago
> Does anybody know how you implement multiversion concurrency control? I have lectures available on Youtube: Intro DB Class: * https://15445.courses.cs.cmu.edu/fall2019/schedule.html#nov-... Advanced DB Class (with
144.
by apavlo 6y ago
> It seems like "Self-Driving" to the authors means simply that it has a query optimizer using ML. Nope. Please see this article for my definition of self-driving: http://www.cs.cmu.edu/~pavlo/blog/20
145.
by apavlo 6y ago
> This is using several buzzwords some database vendors are already using to promote their fully managed solutions, yet the "autonomy" of this dbms appears to be limited to SQL tuning. This is incorrect. Where did you get this