Re: [Maria-discuss] problems getting MariaDB to start after install

f > 'sudo systemctl start mariadb.service' but it has to be restarted if > authentication fails. > so the rest of the KB you sent does no good since I still can't access > the DB, or even view what was created by the installer command. > > -- > Tim McConnell >

Re: [Maria-discuss] problems getting MariaDB to start after install

Hi Tim, It seems you haven't initialized the system tables like explained here: https://mariadb.com/kb/en/mysql_install_db/ Regards -GL Le ven. 30 déc. 2022, 03:32, Tim McConnell a écrit : > Hello list, > I have installed and re-installed MariaDB trying to get prelude to work > and I'm at a lo

Re: [Maria-discuss] Performance tuning sought for MariaDB

I will definitely try to understand to details > of what you are suggesting. > > > > > > > > On Mon, Oct 7, 2019 at 7:13 PM JCA <1.41...@gmail.com> wrote: > > Thanks for your feedback. Please see my comments interspersed below. > > > > On Mon, Oct

Re: [Maria-discuss] Performance tuning sought for MariaDB

Hello, thread-handling=pool-of-threads > max_connections = 1000 > table_open_cache = 800 > query_cache_type = 0 > innodb_buffer_pool_size = 512M > innodb_buffer_pool_instances = 10 > innodb_adaptive_hash_index_partitions = 20 > innodb_lock_wait_timeout = 5000 > No need to use buffer pool instances

Re: [Maria-discuss] New backup procedure plan

Le ven. 10 mai 2019 à 19:21, Tom Worster a écrit : > I'm thinking of changing this because I don't really like how the Galera > rx queue on the third machine climbs for two minutes every hour > How is this a problem? The RX queue climbing is completely normal. If you (correctly) desync your node

Re: [Maria-discuss] strange "increment" values on primary keys

> > By the way, is there any way to make sure the loadbalancer is working fine > without „killing“ the first node (mariadb-galera-mdb-galera-0)? > > We just want to make sure, the auto increment will not cause any problems, > when scaling nodes up / down. > > > All the

Re: [Maria-discuss] strange "increment" values on primary keys

PK values are hard coded in your application, provide the PK > value in the INSERT statement instead of using generated values. > > On May 1, 2019, at 4:11 AM, Guillaume Lefranc > wrote: > > This feature is well known and documented: > > https://mariadb.org/auto-increments-in-ga

Re: [Maria-discuss] strange "increment" values on primary keys

This feature is well known and documented: https://mariadb.org/auto-increments-in-galera/ Regards, GL Le mer. 1 mai 2019 à 08:46, Janis Heller a écrit : > Hey community, > > I’m running Server version: 10.3.13-MariaDB-1:10.3.13+maria~bionic-log > mariadb.org binary distribution of mariaDB (gal

Re: [Maria-discuss] Modify Global Variable "open_files_limit" not working

Hi, Since you are using LXC, you have to pass an option to change the limit. For docker: docker run --name mariadb --ulimit nofile=65535:65535 mariadb:10.1.35 In LXC: lxc config set mariadb limits.kernel.nofile 65535 -GL Le ven. 2 nov. 2018 à 12:07, a écrit : > Hi, > I have installed > Ma

Re: [Maria-discuss] Replication Problem

Hi Thomas, Could you please show the output of SHOW SLAVE STATUS and SHOW VARIABLES LIKE 'gtid%' ? Thanks Guillaume Lefranc signal18.io consulting Le mer. 4 juil. 2018 à 12:31, Thomas Plant a écrit : > Hello, > > I'd have a question about MariaDB 10.1 rep

Re: [Maria-discuss] Chewing Through Swap - Swappiness = 0

2260 ( 0.01 GB) > mapmax: 221 ( 0.00 GB) > mapped:83267 ( 0.32 GB) > swapcache :2 ( 0.00 GB) > > > I am going to be trying his "numactl --interleave all command" solution to > see how that addresses the issue. > > &

Re: [Maria-discuss] Chewing Through Swap - Swappiness = 0

or more. > > Thanks, > > Mike > > > > > On 2018-06-15 11:38 AM, Guillaume Lefranc wrote: > > Rhys.Campbell, 0 means off since kernel version 3.5. > See reference here: > https://community.hortonworks.com/questions/71095/why-not-set-swappiness-to-zero.html > That

Re: [Maria-discuss] Chewing Through Swap - Swappiness = 0

Rhys.Campbell, 0 means off since kernel version 3.5. See reference here: https://community.hortonworks.com/questions/71095/why-not-set-swappiness-to-zero.html That's why most people use 1 (safe value) Michael Caplan: please look at the size of your mysqld process in "ps aux" command output. Due to

Re: [Maria-discuss] Upgrade paths through more major versions

Thanks for the valuable information, Marko. Of course it's always worth doing a full innodb shutdown before an in-place upgrade, so there isn't any transactions to replay. GL Le mer. 6 juin 2018 à 18:21, Marko Mäkelä a écrit : > 2018-06-06 15:20 GMT+03:00 Guillaume Lefranc :

Re: [Maria-discuss] Upgrade paths through more major versions

27;t need mysqldump when restoring your data. And presumably, you won't use an older mysqldump binary to dump your MariaDB 10.3 data, right? Regards GL Le mer. 6 juin 2018 à 14:48, Michal Schorm a écrit : > Thanks for the reply, > > > On Wed, Jun 6, 2018 at 2:20 PM, Guillaume

Re: [Maria-discuss] Upgrade paths through more major versions

ed for upgrade to 10.3, which is IMHO frequently > used. > Where have you seen that claim? I've imported dumps to 10.3 without particular issues. -- Guillaume Lefranc Signal 18 Consulting ___ Mailing list: https://launchpad.net/~mar

Re: [Maria-discuss] Is this normal behaviour?

Hi, it might be because of socket authentication plugin: https://mariadb.com/kb/en/library/authentication-plugin-unix-socket/ In other words if you use "root" unix account you don't need password. Best regards Guillaume Lefranc Signal 18 Le jeu. 4 janv. 2018 à 09:20, Karth

Re: [Maria-discuss] Building 10.2 from source issues

Hi Sergei! There was no difference at all between the two generated files. The plot thickens -GL Le mer. 1 nov. 2017 à 00:30, Sergei Golubchik a écrit : > Hi, Guillaume! > > On Oct 31, Guillaume Lefranc wrote: > > Hi Sergei, > > > > I have no doubts about tha

Re: [Maria-discuss] Async replication between two Galera clusters, GTIDs on non slave node in "slave cluster" don't match

Hi Paul, I don't think that will work across clusters. Your best bet is usually not to rely on GTID for cross-cluster replication. Regards GL Le jeu. 2 nov. 2017 à 06:30, Warner, Paul a écrit : > Hi! > > > I have two Galera clusters of three nodes each, let's call them cluster A > and cluster

Re: [Maria-discuss] Building 10.2 from source issues

2017 à 14:55, Sergei Golubchik a écrit : > Hi, Guillaume! > > On Oct 31, Guillaume Lefranc wrote: > > Hi, > > > > I am trying to build 10.2 from sources while disabling some plugins > > (building with all plugins works without issues). > > > > e.g. >

[Maria-discuss] Building 10.2 from source issues

Hi, I am trying to build 10.2 from sources while disabling some plugins (building with all plugins works without issues). e.g. $ cmake . -DPLUGIN_MROONGA=NO -DPLUGIN_TOKUDB=NO -DPLUGIN_SPHINX=NO -DPLUGIN_ROCKSDB=NO $ make This fails with the following errors: [ 98%] Building CXX object extra/ma

Re: [Maria-discuss] Mariadb cluster on windows

You can also use docker to run mariadb galera cluster on Windows. Le sam. 26 août 2017 à 21:15, Bertrand Caplet a écrit : > Hi Vino, > in MariaDB 10.1 I think it's not possible to use galera cluster feature. > But I don't know in 10.2 > > > Le 26/08/2017 à 20:32, vv2599 a écrit : > > Hello Guys

Re: [Maria-discuss] question about fast path for TRUNCATE TABLE

Hi Sergey, Yes, it was partitioned as mentioned in the other issue (Actually same structure as the one described for the LOAD DATA) -GL Le dim. 6 août 2017 à 20:39, Sergey Petrunia a écrit : > On Fri, Aug 04, 2017 at 01:41:42PM +0000, Guillaume Lefranc wrote: > > I might be able to

Re: [Maria-discuss] question about fast path for TRUNCATE TABLE

Hi Sergey, I might be able to try again, though I moved to a different database at this point. But the phenomenon I observed was very high IO for several hours, and the table was still not dropped and recreated. if TRUNCATE TABLE just unlinks the data files we shouldn't observe that behavior. Tha

Re: [Maria-discuss] TRIGGERing on new users

arly", were you thinking of a cron job or > some similar cron-like functionaility in MariaDB/MySQL, or something else? > Can you elaborate? > > On Fri, 2017 Jul 07, 10:22:28 (+0200), Guillaume Lefranc wrote: > > Hi Curtis, > > > > two different solutions come to m

Re: [Maria-discuss] TRIGGERing on new users

Hi Curtis, two different solutions come to mind. You could wrap your user creation in a stored procedure that does all the heavy lifting: create the user and perform the additional functions Or, you could set up an event which runs regularly, checks if new users have been added, and if that is t

Re: [Maria-discuss] Broken MariaDB client ARGGG!!!

Hi Jon, This is 2017, and you should use mysqlnd. libmysqlclient is not needed for PHP mysql extensions anymore, hence the error. apt-get php5-mysqlnd should fix the issue. And btw, Deb9 is out :) Best -GL Le lun. 3 juil. 2017 à 22:51, Jon Foster a écrit : > I'm constantly astounded at the ex

Re: [Maria-discuss] Can't open shared library '/usr/lib64/mysql/plugin/auth_socket.so'

You can remove it, auth_socket isn't needed by WSREP. Le lun. 3 juil. 2017 à 14:14, Jonathan Gazeley < jonathan.gaze...@bristol.ac.uk> a écrit : > Hi folks, > > I did a routine reboot on one of my database nodes and it was unable to > start up wsrep afterwards. I'm running MariaDB 10.1.24 with Ga

Re: [Maria-discuss] MySQL Workbench Fork?

> In the 21st century GUI's for any software are the difference between > amateur systems run by geeks and professional systems used by business. > Seriously, NO. That's the same kind of predicate that led some people to believe that only Microsoft software is "Professional"... ___

Re: [Maria-discuss] MySQL Workbench Fork?

If you really need a GUI to manage MariaDB, why not get real and purchase a license for Navicat, DBForge or SQLyog, just to quote a few of those that support MariaDB. I'm sure your boss has $100 to spend on a lifetime license for one of those products. Le ven. 21 avr. 2017 à 03:13, Zach Lym a écr

Re: [Maria-discuss] Partition a Huge table

Use pt-online-schema-change. Best regards GL Le mar. 14 mars 2017 à 08:35, Suresh Rajagopal a écrit : > Hi, > > What is the fastest approach to partition a huge table with 2 additional > columns? How safe its to alter table on slave and promote slave as master? > It takes 25 hours to alter the

Re: [Maria-discuss] Maria db read/write configuration issues

If your application uses transactions, e.g. Java/Hibernate, Python connector... it will route to master by default. -GL Le jeu. 9 mars 2017 à 18:43, Karthick Subramanian < ksubraman...@paycommerce.com> a écrit : > Follow these below 3 links (especially 3rd link): > > > https://github.com/mariadb

Re: [Maria-discuss] Replication-manager + Maxscale

Hi Karthick, (disclaimer: I am one of the authors of Replication Manager for MariaDB) you seem to be using outdated instructions. Please grab the 1.0.2 release for your distribution there: https://github.com/tanji/replication-manager/releases Replication Manager works best when used independentl

Re: [Maria-discuss] question about generating logs on MariaDB 10.1.21

launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > -- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation __

Re: [Maria-discuss] limiting memory use by mariadb?

ess around with temp tables, you should usually be fine with those. On Wed, Dec 28, 2016 at 8:16 PM l vic wrote: > You mean innodb_buffer_pool_size to use 60% of RAM, correct? > > On Wed, Dec 28, 2016 at 2:12 PM, Guillaume Lefranc < > guillaume.lefr...@mariadb.com> wrote: > >

Re: [Maria-discuss] limiting memory use by mariadb?

f memory use by mysqld exceeds limit allocated to mesos > task, we have oom and mesos kills container > > > On Wed, Dec 28, 2016 at 1:51 PM, Guillaume Lefranc < > guillaume.lefr...@mariadb.com> wrote: > > Use linux control groups, or even simpler, run MariaDB with Docker (whi

Re: [Maria-discuss] limiting memory use by mariadb?

, > -V > ___ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > -- Guillaume Lefranc

Re: [Maria-discuss] galera replication specs?

as specs/RFC? > Thanks, > ___ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp &g

Re: [Maria-discuss] Download speeds on archive.mariadb.org

Hi Sergei! I am not sure where the mirror is. I needed a specific release of MariaDB (10.1.16) and the downloads page redirected me to this server. I'm just imagining what other, less informed users will experience themselves. Agreed that the limit is too slow to make it useful. I've resorted to

[Maria-discuss] Download speeds on archive.mariadb.org

Hi everyone, Download speeds on archive.mariadb.org have reached an abysmal level - 6kb/s today. Honestly, what is the foundation waiting for to solve this issue that has been lasting for years? I am ready to donate server space and bandwidth myself if needed. _

Re: [Maria-discuss] Problem with Master/Slave <=> Master/Slave <=> Master/Slave Replication

re versions if needed. > > ___ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > -- Guillaume Lefranc Remot

Re: [Maria-discuss] .Net + Entity Framework

; support for enterprise customers in case if we face any issues wrt .net > connector (Ex: performance issues or similar) to connect to Maria DB. > > On Wed, Oct 26, 2016 at 12:35 AM, Guillaume Lefranc < > guillaume.lefr...@mariadb.com> wrote: > > You may use the MySQL Connector/NET,

Re: [Maria-discuss] .Net + Entity Framework

ria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp -- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation ___ Mailing

Re: [Maria-discuss] Problem with Master/Slave <=> Master/Slave <=> Master/Slave Replication

__ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > -- Guillaume Lefranc Remote DBA Services M

Re: [Maria-discuss] MariaDB and TLB misses / Large Pages

The MySQL Manual gives good pointers about TLB settings that should apply to MariaDB as well: https://dev.mysql.com/doc/refman/5.6/en/large-page-support.html Le jeu. 20 oct. 2016 à 20:33, J. Cassidy a écrit : > Hello all, > > is there a reliable cookbook / checklist to implement Large Tables on

Re: [Maria-discuss] MariaDB Knowledge base - 500 error

Thanks for bringing it up, I fixed it. Le ven. 21 oct. 2016 à 14:35, Pantelis Theodosiou a écrit : > The About MariaDB page > has outdated info: > > Current Versions & Release Schedule > >- The current stable MariaDB release is MariaDB 10.0

Re: [Maria-discuss] can we use load data infile from moving a database to a 4 node cluster

ted >>> >>> Thanks >>> Arun >>> _______ >>> Mailing list: https://launchpad.net/~maria-discuss >>> Post to : maria-discuss@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~

Re: [Maria-discuss] can we use load data infile from moving a database to a 4 node cluster

reatly appreciated > > Thanks > Arun > ___ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/

Re: [Maria-discuss] Regarding Automatic fail-over - Maxscale

ss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > -- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation ___ M

Re: [Maria-discuss] replicate to multimaster

ss > More help : https://help.launchpad.net/ListHelp > -- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad

Re: [Maria-discuss] Designated donor.

> ___ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/L

Re: [Maria-discuss] Expanding Galera cluster

ocedures. I found much > more help from Percona but descriptions don't match sometimes. > > Please help. > > Regards, > TH > ___ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launc

Re: [Maria-discuss] bootstrap okay but wsrep_cluster_size 0

Galera needs to be explicitely enabled in MariaDB 10.1: wsrep_on=ON Guillaume Lefranc RemoteDBA Services Manager - MariaDB Corporation Ab On Mon, Jul 4, 2016 at 4:28 AM, Umarzuki Mochlis wrote: > mariadb-server 10.1.15 > ubuntu 16.04 > > Using the same config that was successful

Re: [Maria-discuss] Galera Cluster on FreeBSD

Hi Niklaas, in MariaDB 10.1, Galera replicator needs to be explicitely enabled. Try adding this to your configuration file: wsrep_on=ON Kind regards GL Le jeu. 2 juin 2016 à 08:56, Niklaas Baudet von Gersdorff a écrit : > Hello, > > I'm trying to setup a galera cluster on FreeBSD. I followed

Re: [Maria-discuss] Backing up tables with data at rest encryption

: maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > -- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation ___ Mailing list: https://launchpad.net/~mar

Re: [Maria-discuss] MariaDB 10.1.13 sysbench and Fusion-IO PCIE card lock question ?

Hi, have you reported your issue in Codership google group? https://groups.google.com/forum/#!forum/codership-team Does Galera report any locking issue in the MariaDB error.log file? 2016-05-02 13:38 GMT+02:00 Ljr Yang : > Hi, All > Recently, We use Sysbench Test MariaDB 10.1.13. In Tes

Re: [Maria-discuss] GTID replication and SST method

with no issues? > > > > If so it looks like I need to look into whether or not I can upgrade 10.1.x > > > > Thanks, > > Craig > > > > > > > > *From:* Guillaume Lefranc [mailto:guillaume.lefr...@mariadb.com] > *Sent:* 22 April 2016 13:3

Re: [Maria-discuss] GTID replication and SST method

gapore and has its > registered office at One Marina Boulevard, #28-00. Singapore 018989. > ___ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss

Re: [Maria-discuss] Dynamically rewrite query

You can use MaxScale : https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale/maxscale-regex-filter-overview/ 2016-04-20 16:09 GMT+02:00 Erik Cederstrand : > Hello list, > > I'm administering a MariaDB (10.0.23) backend used by some proprietary > software. I'm having trouble with one speci

Re: [Maria-discuss] Monitoring InnoDB tables?

; Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > -- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation

Re: [Maria-discuss] AUTO_INCREMENT and partitioning

scuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > -- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation __

[Maria-discuss] MariaDB replication-manager 0.6.0 release

Hi, I just released the latest version of my replication manager utility for MariaDB. It has some tremendous improvements over the last version, so if you are using it please upgrade, or check it out at https://github.com/mariadb-corporation/replication-manager Main features: - Agentless utility

Re: [Maria-discuss] Galera crash - [ERROR] Slave SQL: Error 'Can't create table (errno: 150)' on query. Default database: . Query: 'CREATE TABLE'

tter? >> >> >> >> Lukas >> > > ___ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpa

Re: [Maria-discuss] Help to size: Best configuration for a lot read and write

Hi Tristan, > I have some basics about SQL. But I need your help. > I must set up a SQL servers for a new web application. This web > application will make a lot of write and some reads the night and > enormously read and some writing on the day. > This is a complex case, as pure write workloads

Re: [Maria-discuss] Performance issues after upgrading to 10.0

> Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > > __

Re: [Maria-discuss] Performance issues after upgrading to 10.0

ce in the explain > command? > > Thank you. > > azur > > > > ___ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss

Re: [Maria-discuss] Weighted Quorum for Three Nodes

___ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > -- Guillaume Lefranc Remote DBA Services Manager MariaDB C

Re: [Maria-discuss] Amazon Aurora: based on MySQL or MariaDB?

~maria-discuss > More help : https://help.launchpad.net/ListHelp > -- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe :

Re: [Maria-discuss] MariaDB Performance and Diagnostic Tools

> > ___ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > -- Guillaume Lefra

Re: [Maria-discuss] Galera Cluster: Cluster Blocked, when one node down?

arf, London E14 5LQ, UK | Tel: +44 > 207 015 9200 | NetNames Limited, Registered in England and Wales, Company > number: 3169594, VAT Number: GB 739633893 > ___ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@l

Re: [Maria-discuss] Queries Not Completing After Backup

arialog.archivist.info/2015-04-03.txt > https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1149755 > > ___ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscrib

Re: [Maria-discuss] SST xtrabackup-v2 and 10.1.9-MariaDB-1~trusty-log' (InnoDB version: '5.6.26-74.0')

ons = "gcache.size=512M;pc.recovery=TRUE" > wsrep_cluster_address = "gcomm://10.1.234.222 > ,10.1.234.223,10.1.234.224,10.1.234.225" > wsrep_cluster_name = dba > wsrep_sst_method = "xtrabackup-v2" > #wsrep_sst_method = "rsync" > wsrep_sst_auth

Re: [Maria-discuss] Most reliable SST (or IST ?) method for MariaDB Cluster

b=thefsb@lists.launchpad.net> on behalf of > Guillaume Lefranc > Date: Saturday, December 5, 2015 at 10:23 AM > To: Bertrand Caplet , maria-discuss email > list > Subject: Re: [Maria-discuss] Most reliable SST (or IST ?) method for > MariaDB Cluster > > Hi Bertrand, >

Re: [Maria-discuss] Most reliable SST (or IST ?) method for MariaDB Cluster

/launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > -- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation _

Re: [Maria-discuss] MariaDB and Galera Support from Redhat (instead of MariaDB corp)

Hi, if you are a Red Hat customer, please read the following: https://access.redhat.com/articles/183263 Best regards, Le mer. 25 nov. 2015 à 11:09, Lukas Lehner a écrit : > Hi > > we run DBaaS (Galera Cluster) with growing customer base. We also offer > MongoDB, where we have commercial suppor

Re: [Maria-discuss] Connect Engine with ODBC

t/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > -- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation ___

Re: [Maria-discuss] MariaDB Galera Cluster Wrsep not ready

Hi Bertrand, you should always have an odd number of servers (3, 5, 7) - even number is a risk of split brain, or use weights so you give priority to specific servers. You should also use a load balancer which redirects query to an available node, ex: HAProxy, MaxScale, GLBD... Does the split bra

Re: [Maria-discuss] writing plugin with .net language (C#)

Hi Roberto, you could have a try at it with Golang, it can wrap C code easily https://golang.org/cmd/cgo/ Best regards, Guillaume Lefranc RemoteDBA Services Manager - MariaDB Corporation Ab On Sun, Oct 4, 2015 at 3:26 AM, Roberto Spadim wrote: > hummm, it's like creating a ".dll

Re: [Maria-discuss] why stdout? -> [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096

ou if you adopt such a smug tone e) Suit yourself and have a nice day On Thu, Aug 6, 2015 at 12:59 PM, Reindl Harald wrote: > > > Am 06.08.2015 um 12:53 schrieb Guillaume Lefranc: > >> You don't give any meaningful context at all to solve this issue. >> > > re

Re: [Maria-discuss] why stdout? -> [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096

You don't give any meaningful context at all to solve this issue. What's the distribution you using? What commands do you use to start mariadb? Where do you see this message? 2015-08-06 12:27 GMT+02:00 Reindl Harald : > Aug 6 12:24:24 testserver mysqld: 150806 12:24:24 [Note] > /usr/libexec/mys

Re: [Maria-discuss] Numa linux

If you use InnoDB, make sure to set innodb_buffer_pool_populate to 1. This will do a real allocation of all the buffer pool size to avoid further imbalance. -GL 2015-08-05 4:12 GMT+02:00 Jean Weisbuch : > You might want to enable "numa interleave" for Maria (if your instance > will use more than

Re: [Maria-discuss] mysqlbinlog

I will, thanks for the info; I'll ping Colin too. On Thu, Jul 9, 2015 at 7:05 PM, Guillaume Lefranc < guillaume.lefr...@mariadb.com> wrote: > Justin do you have a bug case open? If yes can you reference the #? > > On Thu, Jul 9, 2015 at 7:04 PM, Justin Swanhart > wrote:

Re: [Maria-discuss] mysqlbinlog

IMAL. It is silly and stupid and sad. > > Sent from my iPhone > > On Jul 9, 2015, at 9:40 AM, Guillaume Lefranc < > guillaume.lefr...@mariadb.com> wrote: > > Thinking of something else, would the MaxScale Binlog Server module > satisfy your use case? I'm not 100% su

Re: [Maria-discuss] mysqlbinlog

lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > > > ___ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@list

Re: [Maria-discuss] mysqlbinlog

Rhys, Just saying, but your request would probably have more traction if you opened a FR in our Jira. -GL Le 9 juil. 2015 18:29, a écrit : > Thanks but it's not going to work for my use case. > > Rhys > > > > Sent from my Samsung Galaxy smartphone. > > > Original message >

Re: [Maria-discuss] New Question: backup

I'm sure you have been told already but this question is on the KB, he can't see your answer. 2015-07-08 16:53 GMT+02:00 Reindl Harald : > > > Am 08.07.2015 um 16:40 schrieb AskMonty KB: > >> A new question has been asked in "MariaDB Documentation" by gtrymore. >> Please answer it at http://maria

Re: [Maria-discuss] Can't connect to local MySQL server through socket

> On 25/06/2015 13:40, Guillaume Lefranc wrote: > > Just a suggestion, you can try adding "set -x" to > > /usr/bin/wsrep_sst_rsync, so the script will dump its output in the > > log. You should be able to know where it hangs precisely then. > > It gives me the fol

Re: [Maria-discuss] Can't connect to local MySQL server through socket

| ON | > +--+-+ > > and on nodes #2 and #3: > ERROR 2002 (HY000): Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (111 "Connection refused") > > If I start mariadb outside a cluster on nodes #2 and #3

Re: [Maria-discuss] Can't connect to local MySQL server through socket

Hello Sylvain, the last lines of the error log of nodes 2 and 3 would be more helpful. Also how do you start your cluster? Do you bootstrap the first node correctly then start the two other nodes? Thanks Guillaume 2015-06-24 14:04 GMT+02:00 Sylvain Raybaud < sylvain.rayb...@green-communications.

Re: [Maria-discuss] FedereratedX ODBC Source

Hi Darin, Just curious, why didn't you consider the CONNECT engine? 2015-06-18 22:34 GMT+02:00 Darin Keever : > This is regarding: > https://mariadb.com/kb/en/mariadb/about-federatedx/ > > Specifically, the last section bullet > >- Support for other RDBMS vendors using ODBC > > > My employer

Re: [Maria-discuss] Upgrading mariadb-galera-server

Yes. http://galeracluster.com/documentation-webpages/upgrading.html 2015-06-19 18:55 GMT+02:00 Tom Worster : > Can I upgrade a production cluster from 10.0.15 to 10.0.19 while the > cluster remains in service, upgrading one node at a time? > > ___ > Mai

Re: [Maria-discuss] Bug in MAX() function?

Hi Benoit, MAX() is an aggregate function, you have to use GROUP BY for it to work as expected. e.g. select MAX(mail_out_anon+mail_out_auth) FROM domaincounters GROUP BY timefunction; Hope this helps -Guillaume 2015-06-19 10:59 GMT+02:00 Benoit Panizzon : > Hi all > > I stumbled over that probl

Re: [Maria-discuss] Question about Galera "pc.recovery" feature

Hello, pc.recovery does not support graceful shutdowns yet. please check the following issue: https://github.com/codership/galera/issues/283 2015-06-05 2:45 GMT+02:00 Marco Nicosia : > Hi all! > > We recently discovered the configuration > wsrep_provider_options="pc.recovery=TRUE" and set about

Re: [Maria-discuss] mysqldump Spider tables

Hello Nicolas, Stephane has opened a task for this: https://mariadb.atlassian.net/browse/MDEV-8183 It's being reviewed and may be added in future releases. Thanks for your feature request. Regards, Guillaume 2015-05-18 16:35 GMT+02:00 Nicolas Payart : > Hi list, > > I am using Spider Storage

Re: [Maria-discuss] SHOW GRANTS change?

Can't confirm that the password does not show up on 10.0.17. This works as described below. Any chance that you were executing SHOW GRANTS on a user without password? Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 10 Server version: 10.0.17-MariaDB MariaD

Re: [Maria-discuss] Default privileges for anon. user.

Hello! Running mysql_secure_installation will take care of that and other issues. -GL 2015-02-26 7:47 GMT+01:00 dE : > On 02/26/15 09:46, dE wrote: > >> Hi! >> >> I've realized that by default MariaDB allow full access to a database for >> anon. users. >> >> $ mysql --user asdfasdf test >> >> Ma