- discuss - lists.mariadb.org

[Maria-discuss] doubt about merge table (10000+) with same structure
by Roberto Spadim 23 Sep '15

23 Sep '15

Hi again guys :) i'm with a new problem i have MANY (10000+) tables with same struct, and i want to execute a select from "some" (100+) tables i was thinking about creating a view with all tables, something like: CREATE VIEW view_name AS SELECT * FROM table1 WHERE primary_key=<a value only at table1> UNION ALL SELECT * FROM table2 WHERE primary_key=<a value only at table2> UNION ALL SELECT * FROM table3 WHERE primary_key=<a value only at table3> UNION ALL SELECT * FROM table4 WHERE primary_key=<a value only at table4> UNION ALL ... SELECT * FROM tablen WHERE primary_key=<a value only at tablen> but i don't know if mysql optimizer will do a good job when i execute something like: SELECT * FROM view_name WHERE primary_key=<a value only located at table1> and just execute the query at table1 instead of alllllllll 10000+ tables i'm considering restruture database to a spider engine or any other method if i don't have other option any idea is well come -- Roberto Spadim

3 4

[Maria-discuss] WHY re TMM files never removed in 10.0.x
by Reindl Harald 20 Sep '15

20 Sep '15

i was flooded once again with mcron-mails "ERROR 144 (HY000) at line 1: Table './asterisk/cdr' is marked as crashed and last (automatic?) repair failed" well, because mariadb creates such temp files and don't remove them which makes myisam-recover-options = "FORCE" useless -rw-rw---- 1 mysql mysql 0 2015-08-21 13:47 cdr.TMM MariaDB [asterisk]> optimize table cdr; +--------------+----------+----------+------------------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +--------------+----------+----------+------------------------------------------------------------------------+ | asterisk.cdr | optimize | error | Can't create new tempfile: '/Volumes/dune/mysql_data/asterisk/cdr.TMM' | | asterisk.cdr | optimize | status | Operation failed | +--------------+----------+----------+------------------------------------------------------------------------+

2 5

[Maria-discuss] Cross compile issue
by Johnson Cheng 18 Sep '15

18 Sep '15

Hi, I have problem to do cross compile on mariadb-10.0.21. Where can I find the relative document? Best Regards, Johnson

2 17

[Maria-discuss] New Question: Which is the best solution to re-sync data if one of my mariadb servers was offline for few days?
by AskMonty KB 18 Sep '15

18 Sep '15

Hello, A new question has been asked in "MariaDB Community" by long_beo_g. Please answer it at http://mariadb.com/kb/en/which-is-the-best-solution-to-re-sync-data-if-one-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi all, In our system, we built only two Mariadb Galera servers. We use keepalived module to load balancing IP address . But we found out one of two servers offline for few days. When I start the offline server (server A), the online one (server B) take a long time to replicate to server A, run out of the server's resources. Could Mariadb masters tell me how to deal with this issue ? How could I sync online data to offline one, and make two servers run well online ? Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/which-is-the-best-solution-to-re-sync-data-if-one-…

1 0

[Maria-discuss] ODBC.NET DOWNLOAD
by Bruce Carlson 17 Sep '15

17 Sep '15

Hi, I'm trying to download the latest stable version of the MariaDB .net ODBC install MSI but every time I try I get directed to a log in page where I can't get any further unless I create some sort of personal information divulgence account. I have never had to do this before with any open source software. Where can I go to download the MSI without having to create an account that I have no intentions of ever doing. I have been using MySQL ever since the early days of version 3 something and have been using MariaDB ever since inception after the split with MySQL. I'm a dedicated and heavy user and supporter of MariaDB and have been for decades. If I am no longer able to download updates etc. without having to create some sort of GOOGLE account then I will not use MariaDB, I will find an alternative. Please advise. Bruce Carlson

3 3

Re: [Maria-discuss] ODBC.NET DOWNLOAD
by Bruce Carlson 17 Sep '15

17 Sep '15

Hi Jan, Appreciate your comments however the issue is not the availability of the source or my ability to compile my own binaries from the source and I would even be glad to pay a fee for the convenience of downloading a pre built MSI when installing on windows machines and I am reasonably happy with the occasional donations to open source I've been able to extract from my clients. (Although, I admit, we could all possibly do more in the area of digging up donations and raising funds is a constant issue for all open source organisations). My complaint is I object to being SPECIFICALLY targeted by advertising. The only benefit derived from insisting on this type of "account" is to directly target advertising. THERE IS NO OTHER BENEFIT. I do not object to advertising. When I'm browsing MariaDB I expect to get advertising from MariaDB and maybe some affiliates. And MariaDB has some excellent affiliates. I'm on the mailing lists and forums of several open source communities. They constantly send me advertising matter. I contribute. I donate. I do OBJECT to DIRECT TARGETING. Here is just one example of how this works :- Every time I use a web browser to search for any subject, the search engine will target me with advertising from those businesses that have specified my credentials with the search provider thereby denying me access to alternatives. And that is a very real concern and in my opinion is totally contrary to the principles of open source. It's at least contrary to my principles. Now you may think this is trivial and I'm over reacting but I want to be the person in charge of what information I'm fed. No matter how trivial that sounds to you. In the end, if the only way I can get hold of the binaries is to download the source and build my own, I will or find an alternative product. On a completely separate note, Whilst I disagree with you on the subject of direct targeting I completely agree with your attitude to renewables. And I feel just as strongly about both subjects. Regards, Bruce Carlson -----Original Message----- From: Jan Steinman [mailto:Jan@EcoReality.org] Sent: Thursday, 17 September 2015 12:26 PM To: Bruce Carlson Cc: Rasmus Johansson; Maria Discuss (maria-discuss(a)lists.launchpad.net) Subject: Re: [Maria-discuss] ODBC.NET DOWNLOAD On 2015-09-16, at 18:13, Bruce Carlson wrote: > the openness of open SOURCE [emphasis mine] Do you think you may be over-reacting just a bit? My understanding -- correct me if I'm wrong -- is that the SOURCE is freely downloadable, and that the extra content you vociferously object to is only presented if you choose to download a BINARY. Compiling, maintaining, and debugging binaries is NOT part of the "open source" agreement! Rather, it is a service for which one might expect to be compensated. If you want to compile and maintain and debug the SOURCE and provide binaries without advertising, YOU CAN! NO ONE IS STOPPING YOU! Again, my apology if I'm misunderstanding something, but I used Homebrew to download and compile the SOURCE for MariaDB, and I don't recall seeing ANY advertising of any sort. :::: We are like tenant farmers chopping down the fence around our house for fuel when we should be using nature's inexhaustible sources of energy - sun, wind and tide. I'd put my money on the sun and solar energy. What a source of power! I hope we don't have to wait until oil and coal run out before we tackle that. -- Thomas Alva Edison :::: Jan Steinman, EcoReality Co-op ::::

1 0

[Maria-discuss] New Question: Galera mysqld_multi - possible bug
by AskMonty KB 16 Sep '15

16 Sep '15

Hello, A new question has been asked in "MariaDB Community" by cisaksen. Please answer it at http://mariadb.com/kb/en/galera-mysqld_multi-possible-bug/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Not sure where to post this but I've come across this on a SLES 12 system. Running Galera 25.3.9-1 / MariaDB 10.1.6-1. Using the Mysqld_multi init.d script to start and stop multiple mysql instances through service or systemd commands I have found that the starting works just fine but stopping them doesn't. It will stop all the instances but the last one. Just for clarification cmd is : service mysqld_multi stop or systemctl stop mysqld_multi. I tried this with 2 and 3 mysql instances. With 2 instances, #1 would stop but #2 wouldn't. With 3 instances #1 & #2 would stop and #3 wouldn't. I have verified that the mysqladmin command works to shut the DB down with the multi_admin account I use. Now running mysqld_multi directly works just fine. Whether it's one specific instance or all of them. That is running the script directly /etc/init.d/mysqd_multi or the actual /usr/bin/mysqld_multi command directly. Both work as expected. I honestly don't know if this is a script problem or a systemd problem. I do know that in SLES 12, SUSE rewrote the mysql init.d script to include mysqld_multi if multiple instances were discovered in the my.cnf file. And this work great using systemd. Anyway there it is, if anyone has come across this on other systems it might be worth noting. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/galera-mysqld_multi-possible-bug/

1 0

[Maria-discuss] New Question: Connecting Issue
by AskMonty KB 13 Sep '15

13 Sep '15

Hello, A new question has been asked in "Development" by isyed. Please answer it at http://mariadb.com/kb/en/connecting-issue/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello. I've just downloaded and started using the C/C++ connector library (v.2.1.0), libmariadb.dll. I had simply dropped it in as a direct replacement for the MySQL C connector library (v.6.1.6 x64), libmysql.dll. While it works as expected, there is an unduly long lapse during mysql_real_connect(), lasting for about fifteen seconds, before the connection is established. With libmysql.dll, the connection is almost immediate. Might there be any additional setting that I may have missed to prevent this lapse? Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connecting-issue/

1 0

[Maria-discuss] mycli
by Otto Kekäläinen 11 Sep '15

11 Sep '15

Hello! Have you seen this before http://mycli.net/ ? Has anybody used it, do you have an opinion if it is of good quality or not? This kind of autocomplete definitely helps newbies in remembering the correct SQL terms and I think the idea is great. - Otto

2 1

[Maria-discuss] New Question: Hybrid replication - issue
by AskMonty KB 11 Sep '15

11 Sep '15

Hello, A new question has been asked in "Replication, Cluster, & Multi-Master" by truptimali. Please answer it at http://mariadb.com/kb/en/hybrid-replication-issue/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I have been trying to implement a Hybrid replication. There is Async replication configured between two galera clusters. To begin with I have been trying this out on two datacenters dc1 and dc2. dc1 has two node galera cluster -- node1_dc1 , node2_dc1 dc2 has one node - just one primary galera node . node1_dc2 I have configured async replication between node1_dc1 and node1_dc2. But I am facing strange problem here. I could see replication happening nicely on all the three nodes involved. But When i tried to restart node2_dc1 ,(the secondary node from dc1's galera cluster) - i am not able to login to this node's mysql with root user. Or any user for that matter. Upon investigation using skip grant, found that the mysql.user table is emptied. (You can refer to the attached logs of node2_dc1 where I have highlighted removal messages in log). My doubts/concerns - 1) I am not sure what could have triggered this mysql table's removal in first place. 2) Inspite of this - I could get this node join the cluster. (Atleast as per the wsrep_cluster_size attribute on primary node) sharing my configurations on all the three nodes - 1) node1_dc1 (Primary Node) galera_cnf : [mysqld] #mysql settings binlog_format=ROW default-storage-engine=innodb innodb_autoinc_lock_mode=2 query_cache_size=0 query_cache_type=0 bind-address=0.0.0.0 log_slave_updates=1 #galera settings wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_cluster_name=london_galera_cluster wsrep_cluster_address=gcomm:// wsrep_sst_method=xtrabackup-v2 wsrep_sst_auth="root:XXX" wsrep_restart_slave=1 # Galera Node Configuration wsrep_node_address="192.168.XXX.YYY" wsrep_node_name="192.168.XXX.YYY" ************************************ wan.cnf: [mysqld] server-id=101 gtid-domain-id=1 binlog-format=ROW log-slave-updates=1 log-bin=binlog wsrep-restart-slave=1 slave-skip-errors=1396 2) node2_dc1 (Secondary node): galera.cnf: [mysqld] #mysql settings binlog_format=ROW default-storage-engine=innodb innodb_autoinc_lock_mode=2 query_cache_size=0 query_cache_type=0 bind-address=0.0.0.0 log_slave_updates=1 #galera settings wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_cluster_name=london_galera_cluster wsrep_cluster_address=gcomm://192.168.XXX.YYY,192.168.YYY.ZZ wsrep_sst_method=xtrabackup-v2 wsrep_sst_auth="root:XXX" wsrep_restart_slave=1 # Galera Node Configuration wsrep_node_address="192.168.YYY.ZZ" wsrep_node_name="192.168.YYY.ZZ" wan.cnf: [mysqld] server-id=102 gtid-domain-id=1 binlog-format=ROW log-slave-updates=1 log-bin=binlog wsrep-restart-slave=1 slave-skip-errors=1396 Node1_dc2 - Single node on datacenter-2 : galera.cnf: [mysqld] #mysql settings binlog_format=ROW default-storage-engine=innodb innodb_autoinc_lock_mode=2 query_cache_size=0 query_cache_type=0 bind-address=0.0.0.0 log_slave_updates=1 #galera settings wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_cluster_name=calif_galera_cluster wsrep_cluster_address=gcomm:// wsrep_sst_method=xtrabackup-v2 wsrep_sst_auth="root:XXX wsrep_restart_slave=1 # Galera Node Configuration wsrep_node_address="192.168.ZZZ.XXX" wsrep_node_name="192.168.ZZZ.XXX" wan_repl.cnf: [mysqld] server-id=201 gtid-domain-id=1 binlog-format=ROW log-slave-updates=1 log-bin=binlog wsrep-restart-slave=1 slave-skip-errors=1396 ~ Note unique server-ids and common gtid-domain-id. Attaching logs of both the nodes in galera cluster in datacenter 1. lines to look for in node2.txt - file *********** Sep 10 21:06:21 localhost mysqld: 150910 21:06:21 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 0) Sep 10 21:06:21 localhost mysqld: 150910 21:06:21 [Note] WSREP: Requesting state transfer: success, donor: 0 Sep 10 21:06:22 localhost mysqld: WSREP_SST: [INFO] Proceeding with SST (20150910 21:06:22.394) Sep 10 21:06:22 localhost mysqld: WSREP_SST: [INFO] Cleaning the existing datadir (20150910 21:06:22.400) Sep 10 21:06:22 localhost mysqld: removed ?~@~X/var/lib/mysql/mysql_upgrade_info?~@~Y Sep 10 21:06:22 localhost mysqld: removed ?~@~X/var/lib/mysql/multi-master.info?~@~Y Sep 10 21:06:22 localhost mysqld: removed ?~@~X/var/lib/mysql/mysql/procs_priv.MYI?~@~Y Sep 10 21:06:22 localhost mysqld: removed ?~@~X/var/lib/mysql/mysql/user.MYI?~@~Y ***************** Sep 10 21:25:51 localhost /etc/mysql/debian-start[16787]: Triggering myisam-recover for all MyISAM tables Sep 10 21:25:53 localhost mysqld: 150910 21:25:53 [Note] WSREP: (81dce617, 'tcp://0.0.0.0:4567') turning message relay requesting off Sep 10 21:32:01 localhost mysqld: 150910 21:32:01 [ERROR] Slave SQL: Error 'Can't find any matching row in the user table' on query. Default database: 'mysql'. Query: 'SET PASSWORD FOR 'root'@'localhost'='*FD9D25929BE2AE3A18896D5D93AB9A7DD78D22E4'', Internal MariaDB error code: 1133 Sep 10 21:32:01 localhost mysqld: 150910 21:32:01 [Warning] WSREP: RBR event 1 Query apply warning: 1, 19504 ****************** -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/hybrid-replication-issue/

1 0