Re: [Maria-discuss] New Question: InnoDB/XtraDB Configuration for optimum performance (MySQL 5.1 to MariaDB 10.1)

2016-07-21 Thread Karthick Subramanian
I am not sure about the specific needs. If its OLTP system (assumption made based on - InnoDB usage), you can refer the below link: http://www.tocker.ca/2013/09/17/what-to-tune-in-mysql-56-after-installation.html Its specific to MySQL5.6, but I believe we can make sure its applicable settings for M

[Maria-discuss] New Question: Upgrade (10.1.16+maria-1~jessie) broke system

2016-07-21 Thread AskMonty KB
Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by olliblum_59359. Please answer it at http://mariadb.com/kb/en/upgrade-10116maria-1jessie-broke-system/ as the person asking the question may not be subscribed to the mailing list. ---

[Maria-discuss] New Question: data base issue

2016-07-21 Thread AskMonty KB
Hello, A new question has been asked in "MariaDB Community" by annamae_moreno_g. Please answer it at http://mariadb.com/kb/en/data-base-issue/ as the person asking the question may not be subscribed to the mailing list. hello im using xampp because im doing some

[Maria-discuss] New Question: InnoDB/XtraDB Configuration for optimum performance (MySQL 5.1 to MariaDB 10.1)

2016-07-21 Thread AskMonty KB
Hello, A new question has been asked in "Moving to MariaDB" by rajeev_joshi_g. Please answer it at http://mariadb.com/kb/en/innodbxtradb-configuration-for-optimum-performance-mysql-51-to-mariadb-101/ as the person asking the question may not be subscribed to the mailing list. -

Re: [Maria-discuss] MariaDB 10.1.14 failure to initiate SST after RSU schema upgrade

2016-07-21 Thread Mark Wadham
On 21 Jul 2016, at 9:39, Mark Wadham wrote: Confirmed this Oh wait, it seems that if we do: SET wsrep_OSU_method='RSU'; (with GLOBAL omitted) then it sort of works. The node doesn't desync immediately but as soon as we execute some DDL it does desync, and then immediately re-syncs as soon

Re: [Maria-discuss] Creating Custom Storage Engine

2016-07-21 Thread Sergei Golubchik
Hi, Jonathan! On Jul 20, Jonathan Ellithorpe wrote: > > Hmm... thanks for pointing that out about system metadata caching. I'll > have the solve the problem of MariaDB thinking something exists > (table/index/...) when it doesn't, or thinking that something doesn't exist > when it does We ha

Re: [Maria-discuss] MariaDB 10.1.14 failure to initiate SST after RSU schema upgrade

2016-07-21 Thread Mark Wadham
On 21 Jul 2016, at 9:05, Mark Wadham wrote: I don't think this was the case during our testing, but I'll test it again anyway. If I understand RSU mode correctly all it does is ensure that DDL statements aren't replicated to the other nodes. AFAIK it won't stop the write events from the other

Re: [Maria-discuss] MariaDB 10.1.14 failure to initiate SST after RSU schema upgrade

2016-07-21 Thread Mark Wadham
Hi Nirbhay, As discussed on IRC #mariadb, you do not really need to take the node off cluster (3). Just set wsrep_osu_method's session value to RSU and perform the schema change. With RSU mode enabled, the node automatically desyncs itself from the cluster before executing any DDL,and thus ot