#maria Log v0.1

logs Catalogue

This page loads from the db, refresh as and when. It displays 24 hrs
For older data http://marialog.archivist.info/previous.php, logs go back to 2009-01-18
Some user stats
Table logs
date_time
user
message
2017-01-16 01:31:43
grknight
created https://jira.mariadb.org/browse/MDEV-11809 for my issue
2017-01-16 09:42:17
sehh
hey there
2017-01-16 09:42:58
sehh
anyone has experience with Galera? Once every few days, my "write" node returns the error: WSREP has not yet prepared node for application use
2017-01-16 09:43:44
sehh
then its wsrep_cluster_conf_id remains at something low, like 43, when the rest of the nodes are at 70
2017-01-16 09:43:59
sehh
not sure how to force it to synchronize
2017-01-16 09:44:22
sehh
weird thing is, its still says that wsrep_cluster_status is Primary
2017-01-16 09:44:43
sehh
I'd appreciate any help
2017-01-16 15:10:04
catphish
i have 3 hosts running maria and i'd like to replicate writes to any host to the rest of the cluster, what setup makes the most sense to achieve this?
2017-01-16 15:10:41
catphish
as far as i can see, the options are circular replication, full mesh replication, or a central server with one either side of it
2017-01-16 15:11:22
catphish
i am currently considering the full mesh setup (with each server receiving from 2 masters), is there a particular reason why i would not want to do that?
2017-01-16 15:43:32
catphish
it seems that the mesh replication should work well, annoyingly i need to disable log_slave_updates which is read-only :(
2017-01-16 15:44:18
catphish
i'd still be interested to know if there's any major downside to this setup
2017-01-16 15:58:33
Beeblebrox-BSD
Hello, question re columnstore: Is this engine included in core starting 10.1, or does it need to be compiled in with flags? FreeBSD port is 10.1.20_1.
2017-01-16 15:58:33
Beeblebrox-BSD
Also, I assume I can create column-DB is the syntax engine==columnstore?
2017-01-16 15:59:22
LinuxJedi
Beeblebrox-BSD: no, it requires a special build of 10.1 at the moment. We have separate packages for it. Yes, you use engine=columnstore.
2017-01-16 15:59:37
LinuxJedi
I doubt it will compile for FreeBSD at the moment
2017-01-16 15:59:55
Beeblebrox-BSD
LinuxJedi, :(( Is there an ETA for this?
2017-01-16 16:00:29
LinuxJedi
for FreeBSD? We haven't had any requests yet that I'm aware of so it isn't high up in the priority list right now
2017-01-16 16:00:46
Beeblebrox-BSD
Thanks for the input. Regards.
2017-01-16 17:49:56
jb2cool
hopefully a simple question. A while back i updated my maria/galera cluster using a simple yum update command, now i have to start mariadb manually after reboot. Any tips where to start looking?
2017-01-16 18:26:09
sibiria
jb2cool: systemctl enable mariadb?
2017-01-16 21:35:23
sehh
anyone experienced with Galera, please?
2017-01-16 21:36:21
sehh
I've got a 3-node cluster and one node returns "WSREP has not yet prepared node for application use" about every day at random.