Blog - Vettabase

A checklist for Database backup automation

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

<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" 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="" 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="" 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→

How to delete duplicate rows in MariaDB

Pubblicato il 28 Novembre 2021 da Federico Razzoli — Nessun commento ↓

<img width="283" height="200" alt="" 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="" 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" />

How to remote duplicate values from a table to add a UNIQUE index, in MariaDB. Continua a leggere How to delete duplicate rows in MariaDB→

The importance of maintenance windows

Pubblicato il 25 Ottobre 2021 da Federico Razzoli — Nessun commento ↓

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

Periodical maintenance windows can be healthy both for your team and your infrastructure. Business won’t be damaged. Continua a leggere The importance of maintenance windows→

The costs of using multiple database technologies

Pubblicato il 3 Ottobre 2021 da Federico Razzoli — Nessun commento ↓

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

Before introducing a new database technology in your organisation, consider the drawbacks. Continua a leggere The costs of using multiple database technologies→

How slow is SELECT * ?

Pubblicato il 18 Settembre 2021 da Federico Razzoli — 4 commenti ↓

<img width="600" height="311" src="https://vettabase.com/blog/wp-content/uploads/2021/09/select_star.png" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2021/09/select_star.png 600w, https://vettabase.com/blog/wp-content/uploads/2021/09/select_star-300x156.png 300w, https://vettabase.com/blog/wp-content/uploads/2021/09/select_star-16x8.png 16w" sizes="(max-width: 600px) 100vw, 600px" />

The most widely known query optimisation rule is that developers should always avoid SELECT *. Even when all columns are needed, they should list their names, because more columns could be created in the future. But developers find this really Continua a leggere How slow is SELECT * ?→

Identify useless queries in MariaDB/MySQL

Pubblicato il 7 Settembre 2021 da Federico Razzoli — Nessun commento ↓

<img width="600" height="237" src="https://vettabase.com/blog/wp-content/uploads/2021/09/identify_useless_queries.png" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2021/09/identify_useless_queries.png 600w, https://vettabase.com/blog/wp-content/uploads/2021/09/identify_useless_queries-300x119.png 300w, https://vettabase.com/blog/wp-content/uploads/2021/09/identify_useless_queries-16x6.png 16w" sizes="(max-width: 600px) 100vw, 600px" />

Some queries always fail or never return rows. They should be eliminated to improve database performance. Continua a leggere Identify useless queries in MariaDB/MySQL→

NULL comparisons in MariaDB, PostgreSQL, and SQLite

Pubblicato il 6 Settembre 2021 da Federico Razzoli — Nessun commento ↓

<img width="600" height="311" src="https://vettabase.com/blog/wp-content/uploads/2021/09/null_comparisons-1.png" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2021/09/null_comparisons-1.png 600w, https://vettabase.com/blog/wp-content/uploads/2021/09/null_comparisons-1-300x156.png 300w, https://vettabase.com/blog/wp-content/uploads/2021/09/null_comparisons-1-16x8.png 16w" sizes="(max-width: 600px) 100vw, 600px" />

Comparisons are tricky when NULL values are involved. But some databases offer some special, handy syntax to solve the problem. Continua a leggere NULL comparisons in MariaDB, PostgreSQL, and SQLite→

Choosing Cassandra consistency levels

Pubblicato il 9 Agosto 2021 da Federico Razzoli — 2 commenti ↓

<img width="600" height="311" src="https://vettabase.com/blog/wp-content/uploads/2021/08/cassandra_choose_consistency_level.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2021/08/cassandra_choose_consistency_level.jpeg 600w, https://vettabase.com/blog/wp-content/uploads/2021/08/cassandra_choose_consistency_level-300x156.jpeg 300w, https://vettabase.com/blog/wp-content/uploads/2021/08/cassandra_choose_consistency_level-16x8.jpeg 16w" sizes="(max-width: 600px) 100vw, 600px" />

Choose the best balance between speed and consistency by setting proper consistency levels. Continua a leggere Choosing Cassandra consistency levels→

ALERT: Many Cassandra users may need an urgent upgrade

Pubblicato il 28 Luglio 2021 da Federico Razzoli — Nessun commento ↓

<img width="446" height="300" src="https://vettabase.com/blog/wp-content/uploads/2021/06/hours_smaller.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="Vettabase Monthly Time" srcset="https://vettabase.com/blog/wp-content/uploads/2021/06/hours_smaller.jpeg 446w, https://vettabase.com/blog/wp-content/uploads/2021/06/hours_smaller-300x202.jpeg 300w, https://vettabase.com/blog/wp-content/uploads/2021/06/hours_smaller-16x12.jpeg 16w" sizes="(max-width: 446px) 100vw, 446px" />

Vettabase Monthly Time

Cassandra 4.0 GA was released on 26th July 2021. Older versions users need to upgrade quickly. Continua a leggere ALERT: Many Cassandra users may need an urgent upgrade→