- discuss - lists.mariadb.org

[Maria-discuss] New Question: Range of values for INT
by AskMonty KB 17 Aug '16

17 Aug '16

Hello, A new question has been asked in "Data Types" by cay_mia_g. Please answer it at http://mariadb.com/kb/en/range-of-values-for-int/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I believe the note for INT above: Integer from -2147483648 to 2147483648 signed Should be corrected to: Integer from -2147483648 to 2147483647 signed -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/range-of-values-for-int/

1 0

[Maria-discuss] MariaDB Galera Cluster 5.5.51 & Connector/J 1.5.1 now available
by Daniel Bartholomew 17 Aug '16

17 Aug '16

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.51 Stable (GA), and MariaDB Connector/J 1.5.1 Release Candidate (RC). See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 5.5.51 Stable (GA) - Release Notes: https://mariadb.com/kb/en/mgc-5551-rn/ - Changelog: https://mariadb.com/kb/en/mgc-5551-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.51 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/J 1.5.1 RC - Release Notes: https://mariadb.com/kb/en/mcj-151-rn/ - Changelog: https://mariadb.com/kb/en/mcj-151-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.5.1/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] New Question: MONyog ssh authentication using key
by AskMonty KB 17 Aug '16

17 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-ssh-authentication-using-key/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have monyog installed on server a and mariadb on server b. When i give the key for ssh connection on a user on b it gives me error "Could not get private key:access denied. What is this error and why do we have to give private key?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-ssh-authentication-using-key/

1 0

Re: [Maria-discuss] Semi-sync replication hangs when changing binlog filename.
by Joseph Glanville 16 Aug '16

16 Aug '16

Hi Pavel. Yes, by "binlog filename changes" I mean the master begins writing to a new binlog file. Output of all the requested commands are in this gist: https://gist.github.com/josephglanville/7b96c34bb6e79ace33e56627672b98a5 Joseph Glanville Sent from Polymail<https://polymail.io/?utm_source=polymail&utm_medium=referral&utm_campaign=s…> On Fri, 29 Jul 2016 at 3:08 PM Pavel Ivanov <Pavel Ivanov <mailto:Pavel%20Ivanov%20<pivanof(a)google.com>> > wrote: By "binlog filename changes" you mean when master starts writing binlogs into a new file? Can you clarify how the replication stalls? What "show processlist" shows at that time on master and on slave? What does "show slave status" show on the slave? On Thu, Jul 28, 2016 at 10:03 PM, Will Fong wrote: > Hi Joseph, > > On Fri, Jul 29, 2016 at 10:11 AM, Joseph Glanville wrote: >> However whenever the binlog filename changes the replication stalls >> indefinitely. > > Interesting! I may have reproduced this, but it was only a quick test. > Let me (or someone else) dig into this more. > > Thanks for reporting this. > -will > > > -- > Will Fong, Senior Support Engineer > MariaDB Corporation > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss(a)lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp

4 16

Re: [Maria-discuss] can we use load data infile from moving a database to a 4 node cluster
by Guillaume Lefranc 16 Aug '16

16 Aug '16

unfortunately no, you can't do that. your cluster needs to be empty. Maybe have a look at mydumper/myloader that has parallel dump and restore capabilities? Regards GL On Tue, Aug 16, 2016 at 10:30 AM bbnlaccts acnts <bbnlaccts(a)gmail.com> wrote: > Thanks for the help Guillaume, > Can we take a snapshot of a standalone database and run against a cluster > which already has many other databases running on it ? > > Also an u please do point me to a link which talks about this methodology. > > Please do let me know > > Thanks in advance for helping out. > > Arun > > > On Tue, Aug 16, 2016 at 1:51 PM, Guillaume Lefranc < > guillaume.lefranc(a)mariadb.com> wrote: > >> Hi Arun, >> >> Galera requires only InnoDB tables, so the fastest way would be to take >> an Xtrabackup snapshot of your MariaDB 10 standalone database, restore it >> on one node of the Galera cluster and then turn on the 3 other nodes. >> >> Of course LOAD DATA INFILE is supported by Galera, but it would be slower. >> >> On Tue, Aug 16, 2016 at 9:55 AM bbnlaccts acnts <bbnlaccts(a)gmail.com> >> wrote: >> >>> Hi, >>> I am planning on moving a mariadb 10 database to a 4 node galera cluster. >>> Since the db is kind of big with around 40 gigs capacity and i am >>> getting very less maintenance window to complete this activity. >>> Hence planning on using load data infile on alll the big tables. >>> >>> Can anybody please do let me know if i am going to see any >>> drawbacks/bugs in this concept. >>> Are there any precautionary measures i need to take in order to >>> accomplish this task. >>> >>> Your help is greatly appreciated >>> >>> Thanks >>> Arun >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~maria-discuss >>> Post to : maria-discuss(a)lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~maria-discuss >>> More help : https://help.launchpad.net/ListHelp >>> >> -- >> Guillaume Lefranc >> Remote DBA Services Manager >> MariaDB Corporation >> > > -- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation

1 0

[Maria-discuss] can we use load data infile from moving a database to a 4 node cluster
by bbnlaccts acnts 16 Aug '16

16 Aug '16

Hi, I am planning on moving a mariadb 10 database to a 4 node galera cluster. Since the db is kind of big with around 40 gigs capacity and i am getting very less maintenance window to complete this activity. Hence planning on using load data infile on alll the big tables. Can anybody please do let me know if i am going to see any drawbacks/bugs in this concept. Are there any precautionary measures i need to take in order to accomplish this task. Your help is greatly appreciated Thanks Arun

2 1

[Maria-discuss] Regarding Automatic fail-over - Maxscale
by Karthick Subramanian 16 Aug '16

16 Aug '16

Hi All, Can anyone help me to figure out this. I am planning to use Binlogrouter for replication (single master and single slave topology). I read from google forums for maxscale that with binlog router, it'snot possible to use automatic failover. Did anyone try this. >From google forum ( https://groups.google.com/forum/#!msg/maxscale/DnFT4eb0BbQ/cHQ3TLEfBAAJ;con… ) "With the 1.3.0 version of MaxScale, the binlogrouter accepts STOP SLAVE, START SLAVE and CHANGE MASTER TO ... commands. These can be used to change the master server but automating this process with the repmgr is not currently possible. Since the binlogrouter supports the normal slave management commands, using something like MHA could be possible: https://code.google.com/p/mysql-master-ha/ " Could anyone help me to understand whether I can use binlog router along with automatic failover feature using maxscale. I have read this blog using shell script we can achieve, but not sure whether with binlog router, it ll work? ( https://mariadb.com/blog/mariadb-automatic-failover-maxscale-and-mariadb-re… ) Regards, Karth

2 2

[Maria-discuss] replication failing to recover due to HA_ERR_KEY_NOT_FOUND
by bbnlaccts acnts 16 Aug '16

16 Aug '16

Hi, I am trying to set up a master slave replication between 2 servers running mariadb 10 on centos 6.7 In the initial setup itself i keep getting HA_ERR_KEY_NOT_FOUND. I have tried all methodology based on my novice knowledge ro rectify but in vain. i am new to this env. Any help will be greatly appreciated. - Server version 10.0.23-MariaDB-log - Protocol version 10 - UNIX socket /var/lib/mysql/mysql.sock. The scenario I have followed is this: 1. Shut the prod (mc1), took a cold backup and restored on slave (mc2). 2. On master ran show master status; prodarchivedlogs-bin.000001 and the pos as 582240 3. Set these info in slave. 4. Started the slave, it started throwing up error: 160812 3:31:50 [ERROR] Slave SQL: Could not execute Update_rows_v1 event on table radius1.radacct; Can't find record in 'radacct', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log prodarchivedlogs-bin.000001, end_log_pos 587695, Gtid 0-1-79, Internal MariaDB error code: 1032 160812 3:17:18 [Warning] Slave: Can't find record in 'radacct' Error_code: 1032 160812 3:17:18 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'prodarchivedlogs-bin.000001' position 587072 I have tried all methods based on my knowledge, but it is just not functioning. I tried using mysqlbinlog tool to extract to a file and then tried inserting, even then it is failing. Any help will be greatly appreciated. The prod my.cnf is as follows symbolic-links=0 innodb_buffer_pool_size=10G innodb_data_home_dir= /var/lib/mysql/data2 innodb_data_file_path=ibdata1:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/redologs innodb_log_file_size = 256M innodb_buffer_pool_size = 10000M innodb_flush_method = O_DIRECT thread_stack = 256K max_connections=100000 expire_logs_days = 5 max_binlog_size = 100M log-bin=/backup/archivedlogs/prodarchivedlogs-bin binlog_format=row server-id=1 The slave my.cnf is as follows skip-name-resolve skip-slave-start datadir=/var/lib/mysql/data1 socket=/var/lib/mysql/mysql.sockuser=mysql symbolic-links=0 innodb_buffer_pool_size=10G innodb_data_home_dir= /var/lib/mysql/data2 innodb_data_file_path=ibdata1:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/redologs innodb_log_file_size = 256M innodb_buffer_pool_size = 10000M innodb_flush_method = O_DIRECT thread_stack = 256K max_connections=100000 expire_logs_days = 5 max_binlog_size = 100M log-bin=/backup/archivedlogs/prodarchivedlogs-bin binlog_format=row server-id=2

1 0

[Maria-discuss] New Question: ST_AsGeoJSON
by AskMonty KB 12 Aug '16

12 Aug '16

Hello, A new question has been asked in "Geographic Functions" by dbauszus. Please answer it at http://mariadb.com/kb/en/st_asgeojson/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Are there plans to implement ST_AsGeoJSON in MariaDB? This is by far the most widely use format to present data in web mapping applications. It will be a large overhead if we need to format records in the client prior to rendering the data on a web map. Best, Dennis -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/st_asgeojson/

1 0

[Maria-discuss] New Question: Percona XtraBackup Trigger Restore
by AskMonty KB 11 Aug '16

11 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/percona-xtrabackup-trigger-restore/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How do i restore the triggers using percona xtrabackup?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/percona-xtrabackup-trigger-restore/

1 0