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

Production ready HS MariaDB docker compose file

I have a bare metal server where I want to run HA (HAProxy? load balanced with at least 2 writer nodes) MariaDB deployment. I was hoping someone could point me to a production ready docker compose file to stand up a 2 (split brain still an issue?) / 3 node cluster. I have found many resources using MariaDB Galera and VMs, but wanted something simpler if possible just using docker compose. The database at most see hundreds of transaction per min and will be used to hold transient data which will deleted after few hours.

0

0 comments

1

Posted by3 days ago

Default values

Hey People!
Is it possible to have a column with a default value that is another column?

Like I have id as an auto_increment primary key and I want column called parent to be the id of the parent row or default to it's own id

Can I have something like this?
CREATE TABLE comment ( id MEDIUMINT NOT NULL AUTO_INCREMENT, parent MEDIUMINT NOT NULL DEFAULT id, PRIMARY KEY (id) );

I'm thinking this would allow me to get all the children under the parent with a single sort of the parent column.

1

2 comments

1

Posted by5 days ago

Looking for help changing the data directory for Mariadb 10.2.39

I have a server running centos 7. It is running Mariadb 10.2.39.

I would like to change the data directory from the root partition to the home partition.

I have tried a couple of tutorials like:

https://www.digitalocean.com/community/tutorials/how-to-change-a-mariadb-data-directory-to-a-new-location-on-centos-7

but have been unsuccessful finding existing variable described in the tutorial. My /etc/my.cnf file doesn't have an existing data directory entry. I see

## This group is read both by the client and the server

# use it for options that affect everything

#

[client-server]

1

7 comments

1

Posted by5 days ago

[REGEXP] What am I doing wrong?

Hello,

This is the first time I need to use a regex to 1) read a colum, 2) save the Epoch it contains in memory and use it next to update this and other columns.

The following SELECT works:

select post_subject from forum_posts where post_subject LIKE "1092856273%";

| 1092856273#Some subject |

But those return an empty set:

MariaDB [forum]> select post_subject from forum_posts where post_subject REGEXP '^\d+#';

Empty set (0.001 sec)

MariaDB [forum]> select post_subject from forum_posts where post_subject REGEXP '^\d+\#';

Empty set (0.001 sec)

MariaDB [forum]> select post_subject from forum_posts where post_subject REGEXP '^\d+\#.+$';

Empty set (0.001 sec)

1

1 comment

1

Posted by17 days ago

TDE - File Key Management: Problem changing the default key location.

I have been able to successfully enable TDE using the File Key Management plugin by following this guide https://mariadb.com/resources/blog/mariadb-encryption-tde-using-mariadbs-file-key-management-encryption-plugin/

I would like to store my key on a mounted drive. When I copy the key and change the paths in my.cnf the server fails to start. I can change the file paths back and it will start. I've ruled out mounting and permissions by using a different local folder.

my.cnf encryption section

plugin_load_add = file_key_management
file_key_management_filename = /home/testuser/mysql/encryption/keyfile.enc
file_key_management_filekey = FILE:/home/testuser/mysql/encryption/keyfile.key
file_key_management_encryption_algorithm = AES_CTR

innodb_encrypt_tables = FORCE
innodb_encrypt_log = ON
innodb_encrypt_temporary_tables = ON

encrypt_tmp_disk_tables = ON
encrypt_tmp_files = ON
encrypt_binlog = ON
aria_encrypt_tables = ON

innodb_encryption_threads = 4

1

2 comments

2

Posted by23 days ago

MariaBackup Restore to Second 'test' database

I have a backup created with mariabackup...

I would like to restore a specific database, "DB1" into a new test database "DB2"

I can't seem to see an option for this on the maria docs, and --help... didn't.

I even asked ChatGPT lol, it mentioned an argument "--new-data-dir"

But this Arg isn't mentioned in the docs or --help.

How do I accomplish my goal without jacking up "DB1"s directory?

It isn't a prod box, but the data is valuable for testing, and I am unable to match the other variables in my personal lab...

2

6 comments

4

Posted by24 days ago

[Question] Activate Python script after new entry

Hello,

I have been trying to set up a Trigger that activates a python script when a new entry into my table is created. This trigger tries to get a piece of data from the new entry and uses that in the Python script, but I get the following error: "mysql.connector.errors.NotSupportedError: 1415 (0A000): Not allowed to return a result set from a trigger"

I just can't seem to get around this error and was wondering if someone here could give my advice on how to do this. Is what I'm trying even possible?

The following is the code for my stored procedure and trigger:

``

DELIMITER $$

CREATE PROCEDURE run_nmap(IN ip_address VARCHAR(15))

BEGIN

4

1 comment

About Community

MariaDB Server is an open source relational database

Created Mar 17, 2013

1.9k

Members

6

Online

Moderators

Moderator list hidden. Learn More

User Agreement Privacy policy

Content policy Moderator Code of Conduct