Loading...

Follow MariaDB | Reddit on Feedspot

Continue with Google
Continue with Facebook
or

Valid
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

What's the best value for swappiness value the mariadb configuration. How important the swappiness for the DB config in os level ?

submitted by /u/ramesh4f
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
MariaDB | Reddit by /u/dforjohn - 1M ago

Hi, I am doing a presentation om MariaDB Galera Cluster. I was asked to show what happens in the background when I setup a new node and join it to the cluster. I was thinking about running tcpdump om the new node, but i dont know. Does anyone know how I can show the joining on a packet basis? And is tcpdump the way to go?

submitted by /u/DforJohn
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

I’m trying to set up replication for my server with my local machine as a slave so I can have real data for testing (and also because one of my read-only scripts was not originally designed for use on a remote server and uses pyperclip.

However, I cannot copy all the data over cleanly with mariabackup because it insists on getting terminated with signal SYSSEGV.

I could do something with a simple mysqldump except for two issues:

  1. Previous experience with MySQL dump has shown that views don’t get copied over properly: they get copied as empty tables
  2. I’m not sure how trustworthy a dump from MySQL would be as an initial seed for replication (I trust the data and table structures will all be copied over, but I’m less certain of things like foreign key restrictions or positions of log files)

What would be a reasonable path forward?

submitted by /u/757DrDuck
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

I have a situation.

Replication topology: master => slave.

I have the failover method: maxscale.

Question::

In case of master fails, the slave has been promoted as a new master. But how to make the application reads to the new master ?

Any ways to make the application to know the connection should be in live node ?

Please suggest the good method

submitted by /u/ramesh4f
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Hi,

I have mariadb galera cluster version 10.1.35 contains 3 nodes (two DB + on arbitrator).

First node works fine (not swapping), but second one is getting out of memory and starting to swapping.

Configuration is the same on both nodes. I'm sure.

My Hardware is 16G RAM and CPU 4 cores

Config on the second node:

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

slow_query_log = 1

slow_query_log_file = /var/log/mariadb/slow_query.log

log-error=/var/log/mariadb/mariadb.log

symbolic-links=0

bind-address=10.0.0.12

port=3305

skip-external-locking

binlog_format=row

expire_logs_days=2

max_binlog_size=13107200

default_storage_engine=InnoDB

innodb_file_per_table

innodb_flush_method=O_DIRECT

innodb_log_file_size=1G

innodb_buffer_pool_size=8G

innodb_buffer_pool_instances=10

innodb_flush_log_at_trx_commit=2

innodb_lock_wait_timeout=50

innodb_autoinc_lock_mode=2

# SAFETY #

max-allowed-packet = 16M

max-connect-errors = 1000000

# CACHES AND LIMITS #

tmp-table-size = 32M

max-heap-table-size = 32M

query-cache-type = 0

query-cache-size = 0

max-connections = 250

thread-cache-size = 50

open-files-limit = 65535

table-definition-cache = 4096

table-open-cache = 4096

#thread_concurrency = 8

wait_timeout = 60

[galera]

# Mandatory settings

wsrep_on=ON

wsrep_provider=/usr/lib64/galera/libgalera_smm.so

wsrep_cluster_address='gcomm://10.0.0.11,10.0.0.12'

wsrep_cluster_name='galera'

wsrep_node_address='10.0.0.12'

wsrep_node_name='db2'

wsrep_sst_method=xtrabackup-v2

wsrep_sst_auth = "root:xxxxxxx"

wsrep_provider_options="gcache.size=500M"

wsrep_provider_options="gcs.fc_limit= 40"

wsrep_provider_options="gcs.fc_factor=0.8"

wsrep_slave_threads = 8

Maybe there is som bug on this release?

Coul you help?

submitted by /u/scooniatch
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

I am trying to write an application in c++ that uses mariadb for data storage. I have built the connector from source on my Linux Mint machine. However I am unable to find any documentation for the connector api. Does anyone know of any examples, perhaps on github, that uses mariadb and c++? Or better yet maybe some documentation hiding from the search engines? How similar is Mariadb connector/c to mysql connector/c? Would the (very minimal) mysql connector/c documentaion translate well to the mariadb version?

submitted by /u/Rimann
[visit reddit] [comments]
Read Full Article

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview