Write error while importing database on MariaDB Cluster

sushantpuri 2019-10-17 22:06:40 UTC #1

Keywords: MariaDB - Google Cloud Platform - Technical issue - Permissions
Description:
Not able to import database on mariadb cluster, getting the following error
write error (disk full?). Continue? (y/n/^C) y

Need to know what would be the workaround for the same as we need to try mariadb cluster

jota 2019-10-18 07:00:21 UTC #2

Hi @sushantpuri,

Can you run this command to check if you have enough space in the disk of your instance?

df -h

Thanks

sushantpuri 2019-10-18 10:39:49 UTC #3

Tried all these commands, but somehow the database is not getting unzipped.

It throws the following error write error (disk full?). Continue? (y/n/^C) y

jota 2019-10-21 06:29:23 UTC #4

Hi @sushantpuri,

We need the output of the command I shared above, can you share the output with us so we confirm that the disk is full?

Thanks

sushantpuri 2019-10-22 19:34:47 UTC #5

Hey Jota,

Please find below the results

Filesystem      Size  Used Avail Use% Mounted on
udev            7.4G     0  7.4G   0% /dev
tmpfs           1.5G   19M  1.5G   2% /run
/dev/sda1       9.8G  1.8G  7.6G  19% /
tmpfs           7.4G     0  7.4G   0% /dev/shm
tmpfs           5.0M     0  5.0M   0% /run/lock
tmpfs           7.4G     0  7.4G   0% /sys/fs/cgroup
/dev/sdb        492G  194M  466G   1% /bitnami

jota 2019-10-23 12:12:42 UTC #6

mmmm @sushantpuri,

it seems that there are free space in the disk? Can you run the same command in the slave nodes? And can you also run this command in all the nodes?

sudo df -ih

Thanks

sushantpuri 2019-12-03 11:54:20 UTC #7

Hi Joti,

This got solved, was on some other directory hence the issue was popping up.

Another help I wanted from you, the connection is done with the primary node, but how do I ensure that there is a LB (Load Balancer) which consumes all the clusters?

How does the Multi Tier MariaDB works? Just wanted to get a sense.

Thanks
Sushant

miguelaeh 2019-12-04 11:09:15 UTC #8

Hi @sushantpuri,
As far as I know there is no a load balancer in the MariaDB multi-tier. The slaves replicate the master node, and the only node that can write into the database is the master. The slaves only do read operations. And also, in case the master fails it can recover the information from an slave.
I hope this information is useful for you.

sushantpuri 2019-12-09 08:49:22 UTC #9

Thanks for the quick revert. Appreciate the help

One quick question:
When I run the following two commands I do not see any requests going on Slave nodes, why is that happening?

SHOW SLAVE STATUS;

SHOW FULL PROCESSLIST

All select queries are going on Master instead of slave nodes, is there a config level change which we need to do or does the multi tier db do it on its own.

Thanks

jota 2019-12-09 11:49:06 UTC #10

Hi @sushantpuri,

You can learn more about those commands in the official documentation:

https://mariadb.com/kb/en/library/show-slave-status/
https://mariadb.com/kb/en/library/show-processlist/

You can learn more about how the replication works in the MariaDB's configuration as well

https://mariadb.com/kb/en/library/replication-overview/

If you have any specific question about the database, please contact the MariaDB community

https://mariadb.com/kb/en/library/community/

Thanks

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!