Blog - Page 2 of 5 - Vettabase

Automating interactive programs execution with Expect

Posted on 13 July 2021 by Federico Razzoli — No Comments ↓

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

How we automated the creation of immudb users and databases with the help of the Expect language. Continue reading Automating interactive programs execution with Expect→

Cassandra login error: Cannot achieve consistency level LOCAL_ONE

Posted on 9 July 2021 by Federico Razzoli — No Comments ↓

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

Cassandra login fails with: “Cannot achieve consistency level LOCAL_ONE”? Let’s see why it happens, and how to solve the problem Continue reading Cassandra login error: Cannot achieve consistency level LOCAL_ONE→

Populating tables faster in PostgreSQL

Posted on 9 July 2021 by Michael Aboagye — No Comments ↓

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

Fast-loading rows into a PostgreSQL table using the COPY FROM command. Continue reading Populating tables faster in PostgreSQL→

A summary of MariaDB 10.6

Posted on 7 July 2021 by Federico Razzoli — No Comments ↓

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

MariaDB 10.6 is now Generally Available! Let’s see what’s new and if it’s worth an upgrade. Continue reading A summary of MariaDB 10.6→

Tuning Linux kernel for PostgreSQL

Posted on 19 June 2021 by Michael Aboagye — No Comments ↓

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

Learn how to tune Linux parameters to improve PostgreSQL performance and reliability. Continue reading Tuning Linux kernel for PostgreSQL→

MariaDB Ignored Indexes

Posted on 12 June 2021 by Federico Razzoli — No Comments ↓

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

Ignored Index are a MariaDB 10.6 feature that allows us to drop an index in production reducing the risks. Continue reading MariaDB Ignored Indexes→

Row-level Security Policy in PostgreSQL

Posted on 11 June 2021 by Michael Aboagye — No Comments ↓

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

Learn how to grant or revoke rows privileges in PostgreSQL. Continue reading Row-level Security Policy in PostgreSQL→

Finding Duplicate Indexes and Unused Indexes in MariaDB/MySQL

Posted on 8 June 2021 by Federico Razzoli — No Comments ↓

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

Having many indexes in our databases comes with a cost. It is good to periodically eliminate duplicate and unused indexes. Continue reading Finding Duplicate Indexes and Unused Indexes in MariaDB/MySQL→

First impressions about immudb, the immutable database

Posted on 31 May 2021 by Federico Razzoli — No Comments ↓

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

Experiments and first impressions about immudb, the immutable SQL and K/V DBMS. Continue reading First impressions about immudb, the immutable database→

The risks of replication filters in MariaDB and MySQL

Posted on 23 April 2021 by Federico Razzoli — No Comments ↓

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

MariaDB/MySQL replication filters may be useful, but they come with some risks that Database Administrators should be aware of. Continue reading The risks of replication filters in MariaDB and MySQL→