[Maria-discuss] GitHub morgo/mysql-compatibility-config - add MariaDB

[Lukas Lehner]

Hey

I really like https://github.com/morgo/mysql-compatibility-config

is there something similar for MariaDB?
Since the repo is owned by some Oracle guy, I guess he won't add MariaDB.

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.launchpad.net/ListHelp

[Maria-discuss] howto debug “Slave SQL: Error executing row event” and “Node consistency compromized, aborting…” and “Failed to apply trx: source”

[Lukas Lehner]

Hi

https://dba.stackexchange.com/questions/172230/howto-debug-slave-sql-error-executing-row-event-and-node-consistency-comprom

any idea?

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.launchpad.net/ListHelp

[Maria-discuss] M|17 MariaDB Conference 2017 videos

[Lukas Lehner]

Hi

where can I watch M|17 video recordings? Is this planned?
Will it be free or only for customers?

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.launchpad.net/ListHelp

[Maria-discuss] Galera backup failing with error “mysqldump: Error 1213: Deadlock found when trying to get lock; try restarting transaction when dumping table”

[Lukas Lehner]

Hi

please help

http://dba.stackexchange.com/questions/153263/galera-backup-failing-with-error-mysqldump-error-1213-deadlock-found-when-try?noredirect=1=1

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.launchpad.net/ListHelp

Re: [Maria-discuss] workaround for MDEV-9688

[Lukas Lehner]

Thanks Rhys.

Is there an other way? With your solution the customer can't use standard
SQL (they are forced to use our procedure), which means much more support
requests.

best regards
Lukas

On Mon, Oct 24, 2016 at 3:53 PM, <rhys.campb...@swisscom.com> wrote:

> Revoke the DROP permission from the user in question. Create a stored
> procedure that can drop the tables using the SQL SECURITY DEFINER clause so
> it's executed in the context of a user with the DROP permission.
>
>
>
> https://mariadb.com/kb/en/mariadb/create-procedure/
>
>
>
>
>
>
>
> *From:* Maria-discuss [mailto:maria-discuss-bounces+rhys.campbell=
> swisscom@lists.launchpad.net] *On Behalf Of *Lukas Lehner
> *Sent:* Monday, October 24, 2016 3:18 PM
> *To:* Maria Discuss <maria-discuss@lists.launchpad.net>
> *Subject:* [Maria-discuss] workaround for MDEV-9688
>
>
>
> Hi
>
>
>
> https://jira.mariadb.org/browse/MDEV-9688
>
>
>
> is there a workaround for this issue?
>
>
>
> We need it for DBaaS
>
>
>
> 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.launchpad.net/ListHelp

[Maria-discuss] workaround for MDEV-9688

[Lukas Lehner]

Hi

https://jira.mariadb.org/browse/MDEV-9688

is there a workaround for this issue?

We need it for DBaaS

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.launchpad.net/ListHelp

Re: [Maria-discuss] backup front end?

[Lukas Lehner]

is this SeveralNines tool something like MongoDB Ops Manger (hosted Cloud
Manager)?

anybody uses this?

On Mon, Sep 19, 2016 at 7:33 PM, Erik Mathis 
wrote:

> If your DBA hates the shell you might want to look at
> http://severalnines.com/
>
> This prolly wont be your first "make it easy for the DBA" task.
>
>
> -Erik-
>
>
> On 09/16/2016 04:56 PM, l vic wrote:
>
> Is there any open source front end tool for Xtrabackup?
> Thanks,
> -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
>
>
>
> ___
> 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
>
>
___
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] backup front end?

[Lukas Lehner]

why you need that?

what platform the GUI should run?

MySQL Enterprise Backup has a GUI, but you need to pay 

On Fri, Sep 16, 2016 at 10:56 PM, l vic  wrote:

> Is there any open source front end tool for Xtrabackup?
> Thanks,
> -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
>
>
___
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

[Maria-discuss] howto get MariaDB T-Shirts and Hoodies?

[Lukas Lehner]

Hi

I have lots (> 10) of MongoDB T-Shirts, but I prefer to run MariaDB. Howto
get cool MariaDB Shirts and Hoodies?

Witch a search engine I found only "Support MariaDB" products (CafePress).
That's not my taste :-(

thanks
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.launchpad.net/ListHelp

[Maria-discuss] systemctl startup script gives “WSREP: Failed to recover position” - manual startup works

[Lukas Lehner]

Hi

please post your ideas

http://dba.stackexchange.com/questions/134762/systemctl-startup-script-gives-wsrep-failed-to-recover-position-manual-star

best

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.launchpad.net/ListHelp

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

[Lukas Lehner]

thanks for the hint. But is it normal that the hole cluster crashes when
user makes an error in table definition?

I googled this error, but never saw that there is a crash

Lukas

On Wed, Feb 24, 2016 at 2:03 PM, <rhys.campb...@swisscom.com> wrote:

> There’s a foreign key on this table you’re trying to create. There’s
> something up with the definition of that, different engines or perhaps a
> data type.
>
>
>
> Rhys
>
>
>
> *From:* Maria-discuss [mailto:maria-discuss-bounces+rhys.campbell=
> swisscom@lists.launchpad.net] *On Behalf Of *Lukas Lehner
> *Sent:* Wednesday, February 24, 2016 1:50 PM
> *To:* Maria Discuss <maria-discuss@lists.launchpad.net>
> *Subject:* [Maria-discuss] Galera crash - [ERROR] Slave SQL: Error 'Can't
> create table (errno: 150)' on query. Default database: . Query: 'CREATE
> TABLE'
>
>
>
> Hi
>
>
>
>
> http://dba.stackexchange.com/questions/130307/galera-crash-error-slave-sql-error-cant-create-table-errno-150-on-que
>
>
>
> any idea?
>
>
>
> howto debug future crashes better?
>
>
>
> 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.launchpad.net/ListHelp

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

[Lukas Lehner]

Hi

http://dba.stackexchange.com/questions/130307/galera-crash-error-slave-sql-error-cant-create-table-errno-150-on-que

any idea?

howto debug future crashes better?

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.launchpad.net/ListHelp

[Maria-discuss] MariaDB/Galera Cluster with 3 nodes - Change ENGINE from MyISAM to InnoDB without crash

[Lukas Lehner]

Hi

http://dba.stackexchange.com/questions/128715/mariadb-galera-cluster-with-3-nodes-change-engine-from-myisam-to-innodb-withou

thanks
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.launchpad.net/ListHelp

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

[Lukas Lehner]

Hi

https://aws.amazon.com/rds/aurora/

Did Amazon write everything on their own?
Is it based on MySQL or MariaDB?

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.launchpad.net/ListHelp

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

[Lukas Lehner]

Hi

we run DBaaS (Galera Cluster) with growing customer base. We also offer
MongoDB, where we have commercial support from MongoDB (we can recommend
it).

MariaDB is included in RHEL, so Red Hat offers support. We anyway pay for
Redhat support.

So it means we don't need to buy support from MariaDB? Does Redhat employs
MariaDB developers and have DBA/Expert know how?

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.launchpad.net/ListHelp

[Maria-discuss] MySQL for Database Administrators Ed 3.1

[Lukas Lehner]

Hi

I will attend MySQL for Database Administrators Ed 3.1 from Oracle
University. I will take 1Z0-883 OCP MySQL 5.6 Database Administrator
exam. I choose Oracle University because of their high quality education
(did quite a lot of courses at them).

On my job I will work mainly with MariaDB and Galera Cluster. Is this exam
and Oracle University course helpful for me? I have a background with
classic Oracle RDBMs.

cheers
___
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

[Maria-discuss] [Certification] Oracle MySQL exams horribly outdated. Are there MariaDB exams in planning?

[Lukas Lehner]

Oracle MySQL exams are horribly outdated. Are there MariaDB exams in planning?

___
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