#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
2015-04-24 05:51:32
PixelPaul
hi all
2015-04-24 05:51:56
PixelPaul
i have a few questions about mariaDB if anyone is available to help :-)
2015-04-24 05:52:55
danblack
ask. answers will come if known and person responding has time.
2015-04-24 05:53:31
PixelPaul
do i need to uninstall mariaDB to setup Galera?
2015-04-24 05:53:32
danblack
i am going to assume you've read up on the basics
2015-04-24 05:53:54
danblack
there is a separate mariadb-galera package so yes.
2015-04-24 05:54:06
PixelPaul
cheers.
2015-04-24 05:54:31
danblack
in 10.1 they will be the same package. its still in development however
2015-04-24 05:54:42
PixelPaul
would you say having a married cluster on a global scale is not a good idea. one node in USA, one in Australia, one in UK etc
2015-04-24 05:55:04
PixelPaul
darn auto correct changing mariaDB to married. lol
2015-04-24 05:55:24
danblack
make sure you have gone through https://mariadb.com/kb/en/mariadb/mariadb-galera-cluster-known-limitations/
2015-04-24 05:56:22
danblack
provided you can handle write latency of the distributed it should be ok. Its a single RTT that is the latency. I don't know if that's parallelised
2015-04-24 05:58:55
PixelPaul
cheers
2015-04-24 06:00:30
PixelPaul
one last questions. would relations between to tables still work. when i do a insert and the primary key on that row is used in a relation to a another insert with it's primary key
2015-04-24 06:00:55
PixelPaul
from what i read they are always going to have the same primary keys on each node always.
2015-04-24 06:02:41
PixelPaul
with those relations. i will have a delete cascade. so when a DELETE query is done on one of the nodes. and it also deleted the rows it has the relation with. then those will happen on all nodes.
2015-04-24 06:05:39
danblack
yes.
2015-04-24 06:06:13
PixelPaul
sounds goofed
2015-04-24 06:06:37
danblack
let me re-read that...
2015-04-24 06:07:33
danblack
yes, all nodes have the same data. why do you think its goofed?
2015-04-24 06:08:45
danblack
auto_increment_{increment,offset} are auto set by the cluster in default to minimise duplicate keys conflicts. the reset is just Row based replication except it has feedback to throw deadlock errors (in the commit).
2015-04-24 06:09:20
danblack
so fk contraints work the same as ordinary replication.
2015-04-24 06:10:53
PixelPaul
the row relations was my biggest concern with the cascade on change or delete. but i'lll just boot up some nodes and give it a test
2015-04-24 06:12:05
PixelPaul
i guess people just setup a HAproxy then to distribute the traffic to all the nodes in the cluster. or specify in the software accessing them which is closest and use that with the other cluster nodes as backups
2015-04-24 06:12:07
danblack
well it should cascade/delete.
2015-04-24 06:12:15
PixelPaul
good to know
2015-04-24 06:12:26
danblack
yes. node choice is independent of galera.
2015-04-24 06:13:05
danblack
note there are notify scripts in galera than can hint LBs etc in the right direction before they indicate a failure.
2015-04-24 06:16:41
PixelPaul
i don't think i will have LBs, i'll just specify the clostes cluster node per location
2015-04-24 06:16:45
PixelPaul
well thanks for you help mate
2015-04-24 06:16:51
PixelPaul
helped cleared some things up for me
2015-04-24 06:17:11
PixelPaul
now i just need to find a good centos install guide :-)
2015-04-24 06:23:26
danblack
https://downloads.mariadb.org/mariadb/repositories/#mirror=uberglobal&distro=CentOS&distro_release=centos7-amd64--centos7&version=10.0
2015-04-24 06:24:13
danblack
mariadb-galera-server seems to be the package name
2015-04-24 07:03:59
crabmeat
mysqlcheck --analyze, does this provide a report..
2015-04-24 07:07:18
danblack
with what? pie charts? power point reresentations? - the analyzsis if for mariadb internal eyes only, however you can sneek a preview at the mysql.*stats* tables.
2015-04-24 07:07:51
danblack
:-)
2015-04-24 07:08:06
crabmeat
lol
2015-04-24 07:08:09
crabmeat
oh for sure
2015-04-24 07:08:53
crabmeat
I had someone from one of the teams tell they have run the optimize command on a db 's tables
2015-04-24 07:08:59
crabmeat
I wished to confirm it
2015-04-24 07:09:17
crabmeat
in an effort solve the fragmentation on a db
2015-04-24 07:12:24
danblack
crabmeat: read though https://mariadb.com/kb/en/mariadb/optimize-table/ and see if it applies
2015-04-24 07:13:00
danblack
it will probably lock the table.
2015-04-24 09:36:02
tech2
Hi all, I'm trying to work out a performance problem, possibly planner-related between SELECT and UPDATE where the WHERE clause is the same between both queries but the plan appears totally different - http://pastie.org/10109345
2015-04-24 09:36:09
tech2
I was hoping someone with dev experience in these areas could give me an idea as to why this difference exists and what, if anything, I can do to retain the select performance but still make an atomic UPDATE?
2015-04-24 09:40:12
tech2
And I guess I should prefix this with "This is really about mysql 5.6, but I hear there might actually be some devs here on both projects". My apologies if this is the wrong forum.
2015-04-24 12:50:08
danblack
knielsen: thanks for merging. 7864 is another easy one
2015-04-24 12:50:37
knielsen
danblack: right, I'll take a look ...
2015-04-24 12:50:40
knielsen
tnx
2015-04-24 12:52:04
danblack
note todo on it 'Need to skip check of warnings in error log.' i didn't look up how to fix that.
2015-04-24 15:08:59
tarator
Hello I jsut install mariadb 10.0 on my Kubuntu 15.04 box (from the package-repository). But now I can only connect to the server when I run the mysql-client as user root (sudo mysql -uroot -p) without sudo it doesn't work (mysql -uroot -p). It asks me for the password, but then I get "ERROR 1698 (28000): Access denied for user 'root'@'localhost'"
2015-04-24 15:09:17
tarator
(sorry for typos :-))
2015-04-24 15:11:16
lawrin
tarator: what if remove -p?
2015-04-24 15:14:10
grknight
tarator: mysql "users" have nothing to do with system users. the only difference may be there is a preset password in /root/.my.cnf
2015-04-24 15:18:50
MTecknology
I'm having an interesting issue. I have a table that I'm trying to do a simple query on. "select netPay, ytdNetPay, rate1, rate2 from tbl_CheckStub where employeeNo=1234 order by checkNo limit 1;" There's an index on employeeNo and checkNo. The query ends up timing out because it takes so long to complete. There's only 5,062,262 rows in this database. I'm struggling to understand why this query
2015-04-24 15:18:56
MTecknology
is so slow.
2015-04-24 15:19:26
danblack
!t MTecknology idfk
2015-04-24 15:19:54
danblack

2015-04-24 15:20:11
danblack
Please paste your query, the EXPLAIN select.., and the relevant SHOW CREATE TABLE/s in one pastebin with the sql formatted so it is readable
2015-04-24 15:21:01
danblack
actually ask in #mysql - they seem a little board - same info required :-)
2015-04-24 15:21:33
tarator
lawrin: ok, I just figured out, that I can connect with 'sudo mysql' without user and password (since plugin auth_socket.so is loaded)
2015-04-24 15:21:51
danblack
MTecknology: but i'd suggest that an index on (employeeNo,checkNo) would help
2015-04-24 15:21:56
MTecknology
man... sooo many rows, just 'show create table' is massive
2015-04-24 15:22:44
danblack
omit the columns taht aren't part of the query then. definately keep indexed related to the fields in the query.
2015-04-24 15:23:15
tarator
I think there are some wrong grants on my root user. How can I grant "all" rights to my root-user. grknight: I'm aware of the difference between linux and mysql-user....
2015-04-24 15:23:20
danblack
really only employeeNo and checkNO are relevant
2015-04-24 15:23:56
MTecknology
I assumed an index on them separately would be enough. I didn't consider one on them combined
2015-04-24 15:24:18
grknight
tarator: "GRANT ALL ON *.* to 'root'@'localhost' WITH GRANT OPTION;" iirc
2015-04-24 15:24:46
danblack
MTecknology: yeh, most time you only operate on a single index at at time.
2015-04-24 15:26:04
tarator
grknight: didn't help. (flush priv.. executed)
2015-04-24 15:26:45
tarator
Is it possible, that this is because of the upgrade from MySQL to MariaDB? Can I purge the whole mysql database and let it be recreated?
2015-04-24 15:26:47
grknight
please explain the problem instead of asking for a possible way to a solution
2015-04-24 15:28:42
tarator
grknight: the problem is, that I can't connect to the database-server with "mysql -uroot -p"
2015-04-24 15:29:21
grknight
tarator: then you need to disable the auth_socket plugin identification afaik
2015-04-24 15:29:58
grknight
or simply create another user with full privileges
2015-04-24 15:35:42
tarator
ok. I dropped the db mysql and ran command mysql_install_db. Now I can't connect at all to the database.
2015-04-24 15:41:18
grknight
by default, root has no password with mysql_install_db
2015-04-24 15:41:19
tarator
Can anybody tell me, why I can't login with user root after running mysql_install_db?
2015-04-24 15:41:47
tarator
grknight: Access denied for user 'root'@'localhost' (using password: NO)
2015-04-24 15:42:21
tarator
also tried with auth_socket plugin disabled...
2015-04-24 15:43:24
grknight
i've never done anything like drop the mysql database on a working server
2015-04-24 15:45:12
tarator
grknight: I renamed the whole mysql-home-dir (/var/lib/mysql) and then used the command. which should be the same like a fresh install....
2015-04-24 15:45:52
tarator
grknight: I also did something like this before, but to be honest, I had never troubles to log into a running DB-Server....
2015-04-24 15:51:22
tarator
grknight: ok there was a mysql process still up and running. after a restart of my machine MariaDB fixed the privileges! Everything works now! Thanks for your help! :)
2015-04-24 16:12:38
paul_uk
hey, is anyone running OLAP with very large databases with mariadb/mysql ?
2015-04-24 19:11:45
William|i7
anyone have a tutorial on how to setup ssl for mariadb galera?
2015-04-24 19:11:58
William|i7
less its just like setting it up for non galera
2015-04-24 19:20:05
spookah
If I am adding a yum repo with the baseurl of http://yum.mariadb.org/10.0/centos6-amd64.. will that install the latest revision of 10.0.X ?
2015-04-24 19:20:28
serg
yes
2015-04-24 19:21:44
spookah
danke
2015-04-24 19:24:15
Geoff_Montee
William|i7: if you want SSL to be used for WSREP traffic, you'll have to configure socket.ssl_cert and socket.ssl_key in wsrep_provider_options
2015-04-24 19:35:13
William|i7
thank you Geoff_Montee
2015-04-24 19:35:37
William|i7
http://galeracluster.com/documentation-webpages/ssl.html
2015-04-24 19:35:40
William|i7
seems simple :D
2015-04-24 19:54:13
William|i7
Geoff_Montee any wany to indicate it is actually using the ssl?
2015-04-24 19:54:31
William|i7
Assign initial position for certification: 9072, protocol version: 3
2015-04-24 19:54:34
William|i7
maybe?>
2015-04-24 19:56:41
William|i7
SHOW VARIABLES LIKE 'have_ssl';
2015-04-24 19:57:38
William|i7
show status like 'Ssl_cipher'; hm..
2015-04-24 19:58:29
Geoff_Montee
William|i7: i don't think either of those will give you info on galera. i think the only way right now is to read back wsrep_provider options: SHOW GLOBAL VARIABLES LIKE 'wsrep_provider_options';
2015-04-24 19:59:42
Geoff_Montee
William|i7: https://github.com/codership/galera/issues/165
2015-04-24 20:00:36
William|i7
ok great
2015-04-24 20:09:03
William|i7
WSREP: (2dde0577, 'ssl://0.0.0.0:4567')
2015-04-24 20:09:08
William|i7
awesome, thanks again Geoff_Montee
2015-04-24 20:09:28
Geoff_Montee
William|i7: no prob
2015-04-24 20:28:47
William|i7
State transfer to 2.0 (***) failed: -255 (Unknown error 255)
2015-04-24 20:28:53
William|i7
ah why im scared of doing things :D
2015-04-24 21:09:36
William|i7
awesome everything i did before to fix this doesnt work :(
2015-04-24 21:09:37
William|i7
[ERROR] WSREP: gcs/src/gcs_group.cpp:int gcs_group_handle_join_msg(gcs_group_t*, const gcs_recv_msg_t*)():731: Will never receive state. Need to abort.
2015-04-24 21:16:13
William|i7
awesome sauce, wsrep_node_address
2015-04-24 21:16:17
William|i7
more settings :D
2015-04-24 21:24:55
rharwood
hey all, I'd like to add another method for connection encryption to mariadb. Is there somewhere I can read more about how this would be done?
2015-04-24 21:35:20
mgriffin
rharwood: maybe sql/sql_connect.cc not sure (not a programmer)
2015-04-24 21:35:44
serg
rharwood: what do you have in mind?
2015-04-24 21:35:47
mgriffin
rharwood: what would you add, out of curiosity?
2015-04-24 21:36:40
rharwood
serg: gssapi connection encryption
2015-04-24 21:37:22
rharwood
there's the auth_kerberos plugin which I've been doing some small things to, but I'd like to get encryption as well as auth
2015-04-24 21:39:19
serg
talk to georg richter (when he's on the channel), I vaguely remember he was doing that or something similar
2015-04-24 21:40:00
rharwood
willdo, thanks. What's his nick?
2015-04-24 21:40:52
serg
georg
2015-04-24 21:41:49
serg
rharwood: and please ping me afterwards, still. this is related what I wanted to do when I was introducing pluggable auth (because we kind of authenticate with ssl certificates, I wanted that to be in a plugin. and that means that connection encryption needed to be controlled from a plugin). so I'm very interested
2015-04-24 21:42:31
rharwood
serg: sure thing! Glad you're interested in this too
2015-04-24 21:44:56
x86iac
you would only need ssl if the mariadb server is not on the computer with the cgi? you don't want to be accessing databases directrly over the internet ,.. do you?
2015-04-24 21:46:49
serg
x86iac: sometimes people do that. or replicate over the internet.
2015-04-24 21:47:09
Thermi
Use IPsec tunnels for that. Or OpenVPN, if you have to.
2015-04-24 21:47:18
Thermi
SSL is snakeoil.
2015-04-24 21:47:40
rharwood
or gssapi/kerberos!
2015-04-24 21:47:43
rharwood
:)
2015-04-24 21:48:00
Thermi
... which does not help, because it's authentication only.
2015-04-24 21:48:13
rharwood
that's not true
2015-04-24 21:48:19
rharwood
gssapi can provide encryption if you ask for it
2015-04-24 21:49:13
mgriffin
<Thermi> SSL is snakeoil. why's that?
2015-04-24 21:49:28
Thermi
mgriffin: Did you ever see a TLS version, that is NOT broken?
2015-04-24 21:49:36
rharwood
rharwood not taking a position on SSL
2015-04-24 21:49:58
Thermi
Or without major design flaws?