Blog - Vettabase

Deploying an Ansible role on a Vagrant machine

Pubblicato il 21 Giugno 2022 da Aldo Junior — 3 commenti ↓

<img width="640" height="318" src="https://vettabase.com/blog/wp-content/uploads/2022/06/deploy_ansible_roles_on_vagrant-640x318.jpg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2022/06/deploy_ansible_roles_on_vagrant-640x318.jpg 640w, https://vettabase.com/blog/wp-content/uploads/2022/06/deploy_ansible_roles_on_vagrant-16x8.jpg 16w" sizes="(max-width: 640px) 100vw, 640px" />

Learn how to deploy Ansible roles on a Vagrant machine, possibly using the same roles that are used in production. Continua a leggere Deploying an Ansible role on a Vagrant machine→

A summary of MariaDB 10.8: key performance improvements

Pubblicato il 14 Giugno 2022 da Federico Razzoli — 4 commenti ↓

<img width="640" height="318" src="https://vettabase.com/blog/wp-content/uploads/2022/06/mariadb_10_8_review-1-640x318.jpg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" loading="lazy" srcset="https://vettabase.com/blog/wp-content/uploads/2022/06/mariadb_10_8_review-1-640x318.jpg 640w, https://vettabase.com/blog/wp-content/uploads/2022/06/mariadb_10_8_review-1-16x8.jpg 16w" sizes="(max-width: 640px) 100vw, 640px" />

New features and performance optimisations in MariaDB 10.8 short term support release. Continua a leggere A summary of MariaDB 10.8: key performance improvements→

3.6 millions MySQL servers accessible from the web. Hints to keep yours secure

Pubblicato il 9 Giugno 2022 da Federico Razzoli — Nessun commento ↓

<img width="640" height="318" src="https://vettabase.com/blog/wp-content/uploads/2022/06/3_millions_mysql_exposed_small-640x318.jpg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" loading="lazy" srcset="https://vettabase.com/blog/wp-content/uploads/2022/06/3_millions_mysql_exposed_small-640x318.jpg 640w, https://vettabase.com/blog/wp-content/uploads/2022/06/3_millions_mysql_exposed_small-16x8.jpg 16w" sizes="(max-width: 640px) 100vw, 640px" />

Shadowserver has announced that they found over 3.6 million MySQL servers exposed to the web, following their Accessible MySQL Server Report. Continua a leggere 3.6 millions MySQL servers accessible from the web. Hints to keep yours secure→

Tuning PostgreSQL Auto-vacuum

Pubblicato il 28 Aprile 2022 da Michael Aboagye — 3 commenti ↓

<img width="287" height="200" src="https://vettabase.com/blog/wp-content/uploads/2021/04/health_check_postgresql_smaller.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="Vettabase PostgreSQL Health Check" loading="lazy" srcset="https://vettabase.com/blog/wp-content/uploads/2021/04/health_check_postgresql_smaller.jpeg 287w, https://vettabase.com/blog/wp-content/uploads/2021/04/health_check_postgresql_smaller-16x12.jpeg 16w" sizes="(max-width: 287px) 100vw, 287px" />

Vettabase PostgreSQL Health Check

Why autovacuum is important in PostgreSQL and how to configure it properly. Continua a leggere Tuning PostgreSQL Auto-vacuum→

How to fix git mistakes

Pubblicato il 19 Aprile 2022 da Federico Razzoli — Nessun commento ↓

<img width="400" height="211" src="https://vettabase.com/blog/wp-content/uploads/2022/02/automation-1.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" loading="lazy" srcset="https://vettabase.com/blog/wp-content/uploads/2022/02/automation-1.jpeg 400w, https://vettabase.com/blog/wp-content/uploads/2022/02/automation-1-300x158.jpeg 300w, https://vettabase.com/blog/wp-content/uploads/2022/02/automation-1-16x8.jpeg 16w" sizes="(max-width: 400px) 100vw, 400px" />

Code or configuration versioning comes with a potential problem: fixing mistakes can be tricky. Here are some solutions for the most common problems. Continua a leggere How to fix git mistakes→

MariaDB/MySQL: Working with MD5 or other hashes

Pubblicato il 17 Febbraio 2022 da Federico Razzoli — 2 commenti ↓

<img width="283" height="200" alt="" loading="lazy" data-srcset="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg 283w, https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small-16x12.jpeg 16w" data-src="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg" data-sizes="(max-width: 283px) 100vw, 283px" class="attachment-featured-slider size-featured-slider wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="283" height="200" alt="" loading="lazy" data-srcset="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg 283w, https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small-16x12.jpeg 16w" data-src="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg" data-sizes="(max-width: 283px) 100vw, 283px" class="attachment-featured-slider size-featured-slider wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="283" height="200" src="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" loading="lazy" srcset="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg 283w, https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small-16x12.jpeg 16w" sizes="(max-width: 283px) 100vw, 283px" />

The optimal way to store a MD5 hashes in MariaDB, and how to work with them. Continua a leggere MariaDB/MySQL: Working with MD5 or other hashes→

How to test database backups

Pubblicato il 14 Febbraio 2022 da Federico Razzoli — Nessun commento ↓

<img width="400" height="211" alt="Vettabase can help you implement Database Automation" loading="lazy" data-srcset="https://vettabase.com/blog/wp-content/uploads/2021/06/automation.jpeg 400w, https://vettabase.com/blog/wp-content/uploads/2021/06/automation-300x158.jpeg 300w, https://vettabase.com/blog/wp-content/uploads/2021/06/automation-16x8.jpeg 16w" data-src="https://vettabase.com/blog/wp-content/uploads/2021/06/automation.jpeg" data-sizes="(max-width: 400px) 100vw, 400px" class="attachment-featured-slider size-featured-slider wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="400" height="211" src="https://vettabase.com/blog/wp-content/uploads/2021/06/automation.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="Vettabase can help you implement Database Automation" loading="lazy" srcset="https://vettabase.com/blog/wp-content/uploads/2021/06/automation.jpeg 400w, https://vettabase.com/blog/wp-content/uploads/2021/06/automation-300x158.jpeg 300w, https://vettabase.com/blog/wp-content/uploads/2021/06/automation-16x8.jpeg 16w" sizes="(max-width: 400px) 100vw, 400px" />

Vettabase can help you implement Database Automation

Testing backups is often considered too expensive. But it is not, if the tests are adequately designed. Continua a leggere How to test database backups→

MariaDB: The regexp + LIKE optimisation

Pubblicato il 27 Gennaio 2022 da Federico Razzoli — Nessun commento ↓

<img width="283" height="200" alt="" loading="lazy" data-srcset="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg 283w, https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small-16x12.jpeg 16w" data-src="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg" data-sizes="(max-width: 283px) 100vw, 283px" class="attachment-featured-slider size-featured-slider wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="283" height="200" alt="" loading="lazy" data-srcset="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg 283w, https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small-16x12.jpeg 16w" data-src="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg" data-sizes="(max-width: 283px) 100vw, 283px" class="attachment-featured-slider size-featured-slider wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="283" height="200" src="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" loading="lazy" srcset="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg 283w, https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small-16x12.jpeg 16w" sizes="(max-width: 283px) 100vw, 283px" />

MariaDB supports regular expressions, but regexps won’t use indexes. Here’s a workaround that can be used in some cases. Continua a leggere MariaDB: The regexp + LIKE optimisation→

A checklist for Database backup automation

Pubblicato il 6 Gennaio 2022 da Federico Razzoli — Nessun commento ↓

<img width="400" height="211" alt="Vettabase can help you implement Database Automation" loading="lazy" data-srcset="https://vettabase.com/blog/wp-content/uploads/2021/06/automation.jpeg 400w, https://vettabase.com/blog/wp-content/uploads/2021/06/automation-300x158.jpeg 300w, https://vettabase.com/blog/wp-content/uploads/2021/06/automation-16x8.jpeg 16w" data-src="https://vettabase.com/blog/wp-content/uploads/2021/06/automation.jpeg" data-sizes="(max-width: 400px) 100vw, 400px" class="attachment-featured-slider size-featured-slider wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="400" height="211" src="https://vettabase.com/blog/wp-content/uploads/2021/06/automation.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="Vettabase can help you implement Database Automation" loading="lazy" srcset="https://vettabase.com/blog/wp-content/uploads/2021/06/automation.jpeg 400w, https://vettabase.com/blog/wp-content/uploads/2021/06/automation-300x158.jpeg 300w, https://vettabase.com/blog/wp-content/uploads/2021/06/automation-16x8.jpeg 16w" sizes="(max-width: 400px) 100vw, 400px" />

Vettabase can help you implement Database Automation

Databases and technical debts: here’s a list of requirements your database infrastructure should have. Continua a leggere A checklist for Database backup automation→

MariaDB: WITH TIES syntax

Pubblicato il 13 Dicembre 2021 da Federico Razzoli — Nessun commento ↓

<img width="283" height="200" alt="" loading="lazy" data-srcset="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg 283w, https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small-16x12.jpeg 16w" data-src="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg" data-sizes="(max-width: 283px) 100vw, 283px" class="attachment-featured-slider size-featured-slider wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="283" height="200" alt="" loading="lazy" data-srcset="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg 283w, https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small-16x12.jpeg 16w" data-src="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg" data-sizes="(max-width: 283px) 100vw, 283px" class="attachment-featured-slider size-featured-slider wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="283" height="200" src="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" loading="lazy" srcset="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg 283w, https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small-16x12.jpeg 16w" sizes="(max-width: 283px) 100vw, 283px" />

Semantics and use cases of the WITH TIES syntax. Continua a leggere MariaDB: WITH TIES syntax→