Press J to jump to the feed. Press question mark to learn the rest of the keyboard shortcuts

Found the internet!

Create an account to follow your favorite communities and start taking part in conversations.

MariaDB

r/mariadb

Hot New Top Rising

Hot New Top

Rising

0

Posted by1 day ago

unable to login to Mariadb

unable to login to Mysql

R 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@ ~]#
[root@~]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@ ~]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@ ~]# cat /etc/passwd
root:x:0:0:root:/root:/bin/bash

can anyone assist much thanks

0

2 comments

2

Posted by5 days ago

understand pro/cons haproxy vs proxysql loadbalancing galera

good morning,

i am studying mariadb and galera, and i see someone uses haproxy, other proxysql, and i would like to understand if there is a real design reason to choose one or another (beside they are not exacty the same thing, one is general tcp lb, other more specific understand sql, it is obvious :)

thank you very much

2

3 comments

1

Posted by5 days ago

mariabackup backup and prepare phase

Hi all,

For mariabackup physical backups, just seeking some clarity on whats standard practice.Say for example, I take a full backup and a few hourly incrementals.

Full backup  @/Midnight
Incr1 backup @/1AM
Incr2 backup @/1AM
Incr3 backup @/3AM

e.g.

$ mariabackup --backup --target-dir=/dir1/fullbackup/ --user=bkup --password=pw
$ mariabackup --backup --target-dir=/dir1/incr1/ --incremental-basedir=/dir1/fullbackup/ --user=bkup --password=pw
$ mariabackup --backup --target-dir=/dir1/incr2/ --incremental-basedir=/dir1/fullbackup/ --user=bkup --password=pw
$ mariabackup --backup --target-dir=/dir1/incr3/ --incremental-basedir=/dir1/fullbackup/ --user=bkup --password=pw

So, then using the 'prepare' command, I chain these backups together, by preparing the Full and then each subsequent incremental in turn.

$ mariabackup --prepare    --target-dir=/dir1/fullbackup
$ mariabackup --prepare    --target-dir=/dir1/fullbackup    --incremental-dir=/dir1/incr1

1

0 comments

0

Posted by7 days ago

(newbie) galera 3 nodes ha doubt

good afternoon,

i have installed a 3 nodes ubuntu 22 mariadb galera cluster, so fine so good.

tried to create a demo db, and do some select, ok.

then shutdown 2 of 3 nodes, then i connected to last node and tried to edit the db or create a new one /do some select, and i CAN do it...but with only 1 of 3 nodes shouldn't galera be readonly/offline?

am i missing how galera works?

thank you

ps:

this is last online node...i dont understand why is synced..is fine?

MariaDB [(none)]> show status like 'wsrep_cluster_size';
+--------------------+-------+
| Variable_name | Value |

0

17 comments

5

Posted by10 days ago

multiple row insert in sql

youtube.com/watch?...

5

0 comments

2

Posted by18 days ago

10.3 -> 10.6 View Performance Issues

I recently upgraded a mariaDB instance from 10.3 to 10.6 and am having an issue with the performance of queries against views that use joins.

For instance, I have a reports and customers table that have a company_id field. I've created views of these based on the company id to create pseudo partitioning.

In 10.3, I could run something like :

select * FROM report_view LEFT JOIN client_view LIMIT 50

The resulting explain would have 100 rows for the report_view table, which is the same as if I didn't use the view and just used the base table.

Now in 10.6 when I run the same above query, it is running a full table scan against report instead of 100 rows. It seems to be an issue with JOINING on multiple views.

Is there a way to fix or explain this behavior?

2

5 comments

2

Posted by20 days ago

Cannot bootstrap galera cluster

Hello, I have recently set up a new cluster based from an existing one, I did the following steps to create the new cluster:

Created a 4th node to sync up with my currently 3-node cluster
Disconnected the 4th node and updated the galera configuration to a new wsrep_cluster_address and wsrep_cluster_name, I also updated the config on my 3-node cluster to remove the 4th node completely
Removed the ib_log files and updated grastate.dat config to safe_to_bootstrap: 1
run sudo galera_new_cluster

But after running the command it fails on creating a new cluster. Here are the last logs on the server:

mariadbd[23069]: 2023-01-04 14:16:33 0 [Note] WSREP: Start replication
mariadbd[23069]: 2023-01-04 14:16:33 0 [Note] WSREP: Connecting with bootstrap option: 0
mariadbd[23069]: 2023-01-04 14:16:33 0 [Note] WSREP: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1
mariadbd[23069]: 2023-01-04 14:16:33 0 [Note] WSREP: protonet asio version 0
mariadbd[23069]: 2023-01-04 14:16:33 0 [Note] WSREP: Using CRC-32C for message checksums.
mariadbd[23069]: 2023-01-04 14:16:33 0 [Note] WSREP: backend: asio
mariadbd[23069]: 2023-01-04 14:16:33 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
mariadbd[23069]: 2023-01-04 14:16:33 0 [Note] WSREP: access file(/mdb/mysql-data//gvwstate.dat) failed(No such file or directory)
mariadbd[23069]: 2023-01-04 14:16:33 0 [Note] WSREP: restore pc from disk failed
mariadbd[23069]: 2023-01-04 14:16:33 0 [Note] WSREP: GMCast version 0
mariadbd[23069]: 2023-01-04 14:16:33 0 [Note] WSREP: (564456ef-afa1, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567

2

2 comments

About Community

MariaDB Server is an open source relational database

Created Mar 17, 2013

1.9k

Members

1

Online

Moderators

Moderator list hidden. Learn More

User Agreement Privacy policy

Content policy Moderator Code of Conduct