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

[Karthick Subramanian]

Hi,

Anyone in this distribution mail list who actually uses .Net + Entity
Framework with Maria DB in their production environment, could you please
mail me separately. Would like to check with you on few clarification.
Thank you for being a community and helping each others.

Regards,
Karthick

On Wed, Oct 26, 2016 at 12:00 AM, Karthick Subramanian <
ksubraman...@paycommerce.com> wrote:

> All,
>
> Currently we are using below:
>
> .Net framework 4
> Entity Framework
> ODP .Net to Oracle DB
>
> New environment:
>
> .Net framework 4
> Entity Framework
> MariaDB 10.1.16
>
> We would like to know on how can we connect MariaDB for the above said
> framework .Net + Entity Framework. We are trying to find some sources
> online but couldn't figure it out. Can anyone share me on how can we
> establish connection between .Net Entity Framework to MariaDb and what
> connector we need to use and any sample code on how we connect. Your help
> will be highly appreciated.
>
> Regards,
> Karthick
>
___
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] .Net + Entity Framework

[Karthick Subramanian]

Hi GL,

Thanks for your assistance.

I am wondering whether this can be officially supported by Maria DB 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, there is plenty of documentation for
> it online.
> e.g. https://dev.mysql.com/doc/connector-net/en/
>
> GL
>
> On Tue, Oct 25, 2016 at 8:35 PM Karthick Subramanian <
> ksubraman...@paycommerce.com> wrote:
>
> All,
>
> Currently we are using below:
>
> .Net framework 4
> Entity Framework
> ODP .Net to Oracle DB
>
> New environment:
>
> .Net framework 4
> Entity Framework
> MariaDB 10.1.16
>
> We would like to know on how can we connect MariaDB for the above said
> framework .Net + Entity Framework. We are trying to find some sources
> online but couldn't figure it out. Can anyone share me on how can we
> establish connection between .Net Entity Framework to MariaDb and what
> connector we need to use and any sample code on how we connect. Your help
> will be highly appreciated.
>
> Regards,
> Karthick
> ___
> 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
>
___
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] wsrep-node-name vs. wsrep-node-address?

[Nirbhay Choubey]

Hi,

On Tue, Oct 25, 2016 at 10:26 AM, l vic  wrote:

>
> Do I need to use "--wsrep-node-name" option with dns names to identify the
> node in Galera cluster instead of "wsrep-node-address", or is the
> "--wsrep-node-address=" supposed to work?
>

You should set wsrep-node-address.
wsrep-node-name, OTOH, could be used to assign a name to the node.
It helps identify the node in the error logs and can be used in
wsrep-sst-donor.

- Nirbhay

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
>
>
___
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] wsrep-node-name vs. wsrep-node-address?

[l vic]

Do I need to use "--wsrep-node-name" option with dns names to identify the
node in Galera cluster instead of "wsrep-node-address", or is the
"--wsrep-node-address=" supposed to work?
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

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

[Justin Swanhart]

Use ProxySQL to rewrite DROP DATABASE to a call to a store proc.

Sent from my iPhone

> On Oct 25, 2016, at 3:43 AM, Lukas Lehner  wrote:
> 
> 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,  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 
>> 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
___
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

[yoku ts.]

I have a patch to be "DROP DATABASE need Super_priv"

https://gist.github.com/yoku0825/ec783f4f2b6350a860c4736ad4739d16


yoku0825,


2016-10-25 16:43 GMT+09:00 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,  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 
>> 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
>

___
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,  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 
> *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

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

[Guillaume Lefranc]

Hi,

On Tue, Oct 25, 2016 at 5:51 AM LinuXperia  wrote:

> Hi All!
>
> I am having a Problem with getting mariadb works flawless using a
> Master/Slave[1] <=> Master/Slave[2] <=> Master/Slave[3]
>
> If you want to have synchronous replication across all 3 servers I would
NOT recommend using this kind of setup. Please use Galera Cluster instead.

https://mariadb.com/kb/en/mariadb/getting-started-with-mariadb-galera-cluster/

The First Time i was able to insert a row on the Master[1] Server
> and the data was reproduced/replicated to all servers.
>
> At this Time i thinked everything is fine now.
>
> But then when i tryed to deleted the new Created Row on Master[1]
> the Data was only deleted on the Master[1] Server while
> the others Servers [2] and [3] still had the data!
>
Probably something in your settings is wrong and/or servers are not
replicating. For example you have: binlog_do_db= logedin_users
This means that statements will only replicate if you are connected to this
DB.


>
> I expected that the deleted row should be also deleted on all
> master/slave servers but it did not!
>
> How can i solve this Problem? And what is actually the Problem with
> MySQL/MariaDB? I am getting the impression that MariaDB is really bad
> when it comes to Replication/Sync of Data in a Distributed Architecture.
>

I recommend you read some more documentation and refer to the MariaDB KB
about use cases and replication configuration.

>
> As a Example let say on server has to reboot because of a Cloud
> maintenance. From what i see this MaraiDB server will be forever
> corrupted after the restart and never sync again as first it has to
> manually be adjusted to the master bin log position and second it has
> also be told to work as a slave after this.

You shouldn't have to do this if you've configured your servers and
replication correctly.
As mentioned before if you need a three server cluster setup I recommend
using MariaDB Galera Cluster. It is easy to set up in MariaDB 10.1.

Best regards
GL


>
Not really what i would expect from a autonomous replicating Master
> Slave Data Base Server after a restart!
>
> Hope somebody can tell me how to resolve all this Sync Problems so
> finally MariaDB Master/Slave Database Server work flawless without to
> worry that sooner or later a node or a few of them will get useless and
> corrupted!
>
> Thanks in advance for any helpful Tip and Answer!
>
> A example of my my.cnf Master/Slave[2] Server changes!
>
> server-id   = 2
> replicate-same-server-id = 0
> auto-increment-increment = 8
> auto-increment-offset = 1
> log_bin = /var/log/mysql/mariadb-bin
> log_bin_index   = /var/log/mysql/mariadb-bin.index
> # not fab for performance, but safer
> sync_binlog = 1
> expire_logs_days= 10
> max_binlog_size = 100M
> binlog_do_db= logedin_users
> binlog-format = ROW
> # slaves
> relay_log   = /var/log/mysql/relay-bin
> relay_log_index = /var/log/mysql/relay-bin.index
> relay_log_info_file = /var/log/mysql/relay-bin.info
> log_slave_updates = 1
> #read_only
>
> binlog-checksum = 1
> master_verify_checksum = 1
> relay_log_recovery = 1
> slave_compressed_protocol = 1
> slave_sql_verify_checksum = 1
> sync_master_info = 1
> sync_relay_log = 1
> sync_relay_log_info = 1
>
> ___
> 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
___
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