#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
2016-05-30 06:15:31
jak2000
anyone here working with replication?
2016-05-30 06:23:52
dragonheart
jak2000: its probably better to ask about a direction or problem you are having.
2016-05-30 06:41:19
jak2000
i want know wich replication model is the best
2016-05-30 06:41:24
jak2000
master to master?
2016-05-30 06:51:46
dragonheart
jak2000: gtid vs non-gtid - depends on what failover mechnism is most compatible.
2016-05-30 06:52:59
dragonheart
rbr vs statement - do row if you have all PKs on table and don't do very large number of row changes in SQL.
2016-05-30 06:58:55
jak2000
dragonheart exactly
2016-05-30 06:59:13
jak2000
my probem is the Pks i have auto_increment fields.... then? fail, right?
2016-05-30 06:59:34
dragonheart
auto inc PKs are fine.
2016-05-30 07:00:00
dragonheart
it just gets ugly doing RBR if there are no PK and even worse if there are no unique keys
2016-05-30 07:21:03
jak2000
yes but what happend
2016-05-30 07:21:49
jak2000
if in database 1 i have 100 records the next is 101 and in the database 2 receibe other record same time? autoinc is 101, what happend when made the replication?
2016-05-30 07:24:16
dragonheart
jak2000: don't use async replication if you plan on writing to both nodes. Don't use async replication if you plan on writing to a node that hasn't caught up 100% in its replication before being written too.
2016-05-30 07:25:51
dragonheart
auto increment increment|offset can help some accidental failure modes however the above is still the general rule that needs to be adheared too.
2016-05-30 09:24:36
sachin_setiya
hello everyone
2016-05-30 11:18:11
drilorin
Hi guys, has anyone tried installing galera cluster from the official tarball?
2016-05-30 11:18:49
drilorin
I was under the impression that the wsrep plugin was compiled into the code, if that is so, how do I activate it?
2016-05-30 11:21:18
jkavalik
I did not, but afaik it is "galera-enabled", so it can talk to wsrep library but does not include it - you can compile and run the same MariaDB version in Windows where wsrep is not supported at all
2016-05-30 11:23:37
drilorin
ah right, well I can see that wsrep is present i "show plugins" but if I try wsrep_on=ON it complains about the provider library
2016-05-30 11:25:07
drilorin
It's MariaDB Enterprise 1.1.14 tarball
2016-05-30 11:25:10
jkavalik
yes, the library is a separate download, the plugin is a part of server which can connect it to the library - https://mariadb.com/kb/en/mariadb/getting-started-with-mariadb-galera-cluster/
2016-05-30 11:26:32
drilorin
oh right, and if it's installed with yum / apt this will be installed separately, excellent, thanks for your help :)
2016-05-30 12:12:31
Marbug
I have a table I'm going to move to another db, may I just update the information_schema.KEY_COLUMN_USAGE table to point the foreign keys to another database ?
2016-05-30 12:14:41
jkavalik
Marbug, as I understand it, the I_S database is not a real writable one, it is only an "interface" to internal dictionaries
2016-05-30 12:15:05
jkavalik
Marbug, and how do you want to "move" the table in the first place?
2016-05-30 12:15:19
Marbug
aww, so I need to drop and change all the foreign keys manually?
2016-05-30 12:15:34
Marbug
just a whole set of create table, then INSERT INTO SELECT statements
2016-05-30 12:15:59
Marbug
then I thought to update the information schema to change all the foreign keys
2016-05-30 12:16:23
Marbug
it's a set of 30 tables that will be split off of the database, but there are a LOT of foreign keys that needs to be changed
2016-05-30 12:16:30
Marbug
if you see the struggle I'm facing :)
2016-05-30 12:17:07
jkavalik
Marbug, you can use I_S to select the FKs and generate the alter statements quickly ;)
2016-05-30 12:18:03
jkavalik
Marbug, and there is RENAME TABLE which might be used instead of create/insert-select if you really want to *move* it, but the "problem" with FKs stays and is even noted in the manual
2016-05-30 12:18:11
jkavalik
!t Marbug rename table
2016-05-30 12:18:14
jkavalik
!m Marbug rename table
2016-05-30 12:18:23
jkavalik
hm
2016-05-30 12:18:25
jkavalik
!m Marbug rename
2016-05-30 12:18:30
jkavalik
ok - http://dev.mysql.com/doc/refman/5.7/en/rename-table.html
2016-05-30 12:19:27
Marbug
I think I once used it, it works on out production, but I thought it one failed on our production servers
2016-05-30 12:19:32
Marbug
I can try it out tho :)
2016-05-30 12:19:45
Marbug
and it'll be easier for some parts to do the rename indeed
2016-05-30 12:20:34
Marbug
but maybe it was something else that failed at that moment
2016-05-30 13:09:02
Marbug
jkavalik, RENAME TABLE and then CREATE VIEW works perfect as expected, even with update queries :)
2016-05-30 16:47:04
montywi
rasmusj: ping
2016-05-30 21:08:01
bjsnider
i'm getting an error 1064 on this: mysql -u root -e "GRANT ALL PRIVILEGES ON `database`.* TO 'root'@'localhost';"
2016-05-30 21:08:26
thumbs
bjsnider: by all means, don't show the full error.
2016-05-30 21:08:39
thumbs
bjsnider: also, you're missing -p
2016-05-30 21:12:54
bjsnider
no root password for the time being
2016-05-30 21:14:33
bjsnider
the database name is being executed as a bash command and not passwed as part of the mysql command
2016-05-30 21:14:46
thumbs
bjsnider: so what is the full error?
2016-05-30 21:15:25
bjsnider
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '* TO 'root'@'localhost'' at line 1
2016-05-30 21:15:38
bjsnider
but that's just because there's no db name
2016-05-30 21:15:44
thumbs
bjsnider: your shell is expanding the `'s
2016-05-30 21:16:03
bjsnider
yes, can i use an ordinary tick instead?
2016-05-30 21:16:44
bjsnider
or maybe escape them
2016-05-30 23:46:02
jak2013
hi all
2016-05-30 23:46:07
jak2013
why not work: create temporary table ta show tables;
2016-05-30 23:53:39
Lazylegs
Just a guess but what I've experienced that kind of query is not really a query. Mean show tables;
2016-05-30 23:54:07
Lazylegs
You need to query information_schema.tables where schema = 'your_database_name'
2016-05-30 23:54:17
Lazylegs
or is it table_schema
2016-05-30 23:55:43
Lazylegs
It is tables
2016-05-30 23:56:45
Lazylegs
So 'select * from information_schema.tables where table_schema = 'your_database'; ^ jak2000
2016-05-30 23:56:57
Lazylegs
01:58 < Lazylegs> Just a guess but what I've experienced that kind of query is not really a query. Mean show tables;
2016-05-30 23:59:19
jak2000
Lazylegs ok
2016-05-30 23:59:21
jak2000
thanks
2016-05-31 00:49:04
dmilith
can I get a "FreeBSD" magic
2016-05-31 00:49:14
dmilith
to get a mysql binary building 10.1.14 under fbsd?
2016-05-31 00:49:27
dmilith
cause i have every binary except "mysql"
2016-05-31 00:49:47
dmilith
http://óÅ.pl/70d0f1e104ac3f24bd979166ca134caf.png
2016-05-31 00:49:53
dmilith
this is after build dir
2016-05-31 00:56:54
dragonheart
dmilith: try showing the full build log in a text pastie.org
2016-05-31 00:57:23
dragonheart
are you doing ; mkdir build; cd build ; cmake ../source ; make -j 9 ; make install ?
2016-05-31 01:06:24
dmilith
i'm doing exactly same build exactly same script way
2016-05-31 01:06:30
dmilith
as for Linux
2016-05-31 01:07:09
dmilith
and mysql binary is there
2016-05-31 01:07:17
dmilith
for FreeBSD it's not even created
2016-05-31 01:07:20
dmilith
on build time
2016-05-31 01:07:53
dragonheart
show details. an image with no context pointing at a cache directory means nothing to me
2016-05-31 01:25:58
dmilith
is there any option passed with -D to cmake build process that can turn off building bin/mysql ?
2016-05-31 01:27:05
dragonheart
possibly. I'm not going to answer lots of questions around a topic btw.
2016-05-31 02:06:43
dmilith
no mysql
2016-05-31 02:06:45
dmilith
no mysqlclient
2016-05-31 02:06:48
dmilith
no mysqldump
2016-05-31 02:06:53
dmilith
but "everything" is fucking "ok"
2016-05-31 02:09:33
dragonheart
no information
2016-05-31 02:09:34
dragonheart
no details
2016-05-31 02:09:36
dragonheart
no help
2016-05-31 02:09:39
dragonheart
don't care
2016-05-31 02:19:17
dmilith
yea, no information. exactly
2016-05-31 02:20:06
thumbs
looks like dmilith decided on giving up.
2016-05-31 02:20:36
dmilith
i never thought that standard compilation can make binaries in 10.1.13 and in 10.1.14 it's totally broken
2016-05-31 02:20:38
dmilith
GOOD JOB
2016-05-31 02:22:07
thumbs
dmilith: can you please provide more details on your actual process? That way we can help you.
2016-05-31 02:22:50
thumbs
dmilith: the exact commands you ran, and complete errors you encountered?
2016-05-31 02:23:46
dmilith
same process
2016-05-31 02:23:47
dmilith
https://github.com/VerKnowSys/sofin-definitions/blob/stable/definitions/mariadb.def
2016-05-31 02:23:54
dmilith
just ordinary automation script
2016-05-31 02:24:04
dmilith
same since mysql 5.1
2016-05-31 02:24:12
dmilith
but now moved to cmake-thing
2016-05-31 02:24:23
dmilith
and i did builds mostly for linux
2016-05-31 02:24:44
dmilith
and didn't even thought that it's possible to build successfully whole bundle without mysql, mysqlcheck, mysqldump....
2016-05-31 02:24:51
dmilith
that's just insane for me
2016-05-31 04:16:07
jak2000
Lazylegs how to compare 2 databases ons ame server isnt important the records, import for me the structure of tables, number of tables, indexes, etc... how to?