[Maria-discuss] AUTO_COMMIT=0 for a session - READ inconsistencyi - ssue or no issue

Observation: If we set the AUTOCOMMIT=0 in a session, then in that session, I noticed a data inconsistency. Whatever data committed in other sessions, when we select in this session showing until we start any new transaction in this session. The moement we sstart any new transaction in this sessio

Re: [Maria-discuss] AUTO_COMMIT=0 for a session - READ inconsistencyi - ssue or no issue

- Peter > - Webyog > > On Thu, Jun 9, 2016 at 12:46 PM, Karthick Subramanian < > ksubraman...@paycommerce.com> wrote: > >> Observation: >> >> If we set the AUTOCOMMIT=0 in a session, then in that session, I noticed >> a data inconsistency. Whatever data comm

[Maria-discuss] Reg .Net with Entity Framework (ORM)

Hi All, We would like to check whether any of you using .Net with Entity Framework to access Maria DB. If yes, 1. What connector is being used 2. What challenges are facing 3. Any other points that I need to take care while workign with .Net Entity Framework with MariaDB Regards, Kar

[Maria-discuss] Help on ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Dear Experts, I almost tried all sort of combinations that I think of very difficult to crack, but repeatedly failed to satisfy MariaDB not throw this error. Can anyone guide me on what is the specific needs for successful password. Warning message: +-+--+---

[Maria-discuss] Regarding DR site set-up

Dear Experts, I have a question on Max Scale requirement: In prod - we have two DB server as Primary(Master) and Secondary(Slave). Both being controlled via MaxScale. Do we need to really set it up similar way in DR site also? I meant - Do we need to keep Max Scale set it up in DR as well. Anywa

Re: [Maria-discuss] Regarding DR site set-up

ar >> way as your product site, i.e. MaxScale in both locations. >> >> Regards, >> Dipti >> >> On Tue, Jul 5, 2016 at 12:02 AM, Karthick Subramanian < >> ksubraman...@paycommerce.com> wrote: >> >>> Dear Experts, >>> >>> I have a q

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

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] MariaDB Knowledge base - 500 error

Did anyone facing this 500 error while accessing the Maria DB Knowledge Base. Thank you. Don't know to whom we need to report this, so sending to this mail ID. Sorry if it cause any inconvenient for others. When we click the Support in MariaDb website, getting below error: Database Error: *The

Re: [Maria-discuss] Help on ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

y Thank you all for your time on helping me to resolve this. On Sat, Aug 6, 2016 at 11:48 PM, Sergei Golubchik wrote: > Hi, Karthick! > > On Jul 03, Karthick Subramanian wrote: > > Dear Experts, > > > > I almost tried all sort of combinations that I think of very diff

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

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:/

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

ale will pick up the server which has > read_only=0 as master. > > You can also use MRM to manage the failover part. For more instructions > please visit https://github.com/mariadb-corporation/replication-manager > > Regards > Guillaume > > On Tue, Aug 16, 2016 at 9:28 AM

Re: [Maria-discuss] geo replication?

I am planning to try this out for our DR set-up: Hope you can also achieve the same using below. MaxScale for replication using binlogrouter option. https://github.com/mariadb-corporation/MaxScale/blob/2.0/Documentation/Tutorials/Replication-Proxy-Binlog-Router-Tutorial.md On Tue, Aug 23, 201

[Maria-discuss] Reg custom port for maxscale binlog router

Hi all, When I try to configure maxscale for binlogrouter, I noticed that documentation examples using port as 5308. When I try to configure similarly, it says, 111 connection refused or unable to connect master from maxscale. I have enabled the port in centOs7 using firewalld on both master serv

Re: [Maria-discuss] Reg custom port for maxscale binlog router

T SLAVE > > Is that what your are doing ? > > Thanks, > Dipti > > > > On Mon, Aug 29, 2016 at 7:11 AM, Karthick Subramanian < > ksubraman...@paycommerce.com> wrote: > >> Hi all, >> >> When I try to configure maxscale for binlogrouter, I not

[Maria-discuss] Reg Audit Trail Implementation

All, Before I reinvent a wheel again, thought of checking with you experts whether any recommendation or suggestion for implementing audit trail feature for your database. I am looking for any open source product/tool for this purpose. I thought of exploring audit plugin, but I am not sure whethe

[Maria-discuss] Regarding ROLE

All, When I GRANT ROLE to a USER, its throwing error: ERROR 1819 (HY000): Your password does not satisfy the current policy requirements +-+--++ | Level | Code | Message | +-+--+-

Re: [Maria-discuss] Regarding ROLE

Kindly ignore this subject mail. Sorry for this. Its my mistake that I have used wrong username to GRANT ROLE. Thank you. On Thu, Sep 29, 2016 at 7:26 PM, Karthick Subramanian < ksubraman...@paycommerce.com> wrote: > All, > > When I GRANT ROLE to a USER, its throwing error: > &

[Maria-discuss] Reg Maria DB + .Net Combination

All, Can anyone share your experience or reference on below: 1. Production system with Maria DB and .Net environment 2. Transaction throughput, performance issues 3. Any challenges in terms of connectors etc. Thank you. Regards, Karthick ___

Re: [Maria-discuss] sharding with mariadb?

Instead of using Vitess, can't we use maxscale? Can anyone provide me comparision of Vitess Vs Maxscale. Thank you. On Wed, Oct 5, 2016 at 11:21 PM, l vic wrote: > I wonder how to use sharding with symmetric replication... Does that mean > I have to partition every database instance? Does it wo

Re: [Maria-discuss] sharding with mariadb?

xscale a loadbalancer? Failed to see how you'd use it for db > sharding. > > On Wed, Oct 5, 2016 at 3:19 PM, Karthick Subramanian < > ksubraman...@paycommerce.com> wrote: > >> Instead of using Vitess, can't we use maxscale? >> >> Can anyone provide me compar

Re: [Maria-discuss] sharding with mariadb?

All, sorry for late reply to this thread. My outlook didn't refreshed properly with new messages. On Thu, Oct 6, 2016 at 9:43 AM, Karthick Subramanian < ksubraman...@paycommerce.com> wrote: > Hi, > > Not sure, whether this sharding you are looking for or more complicated &g

[Maria-discuss] Reg replication and commit

Hi All, I have the below topology: Master -> Slave (using GTID replication) Master -> Maxscale (Binlog Router) Maxscale -> DR Site (via binlog router) my.cnf is same across all sites: lower-case-table-names=1 autocommit=0 #replication variables log-bin=binlog binlog-format=ROW replicate_ann

Re: [Maria-discuss] Reg replication and commit

nding correct? Without mentioning in my.cnf file, is there a way we can handle this behavior during start of the server, like mysqld --auto-commit=ON/OFF. Thank you. On Fri, Oct 14, 2016 at 5:11 PM, Karthick Subramanian < ksubraman...@paycommerce.com> wrote: > Hi All, > > I hav

[Maria-discuss] .Net + Entity Framework

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 sou

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

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..

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

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 Framew

Re: [Maria-discuss] Flashback (MDEV-10459) bikeshedding a name

Just a thought: If we try to use same name/term across different DB platform avoid confusions for folks who actually uses down the line. For example: PARTITION is more or less same across all DB Platforms, so anyone moving from one DB platform to another, easily they adopt to the terms and concept

[Maria-discuss] ROLE and DEFAULT DATABASE

Hi, Can anyone assist me on this below: I have a database called appdb. I need to grant access to this db to different users say: api_user, app_user, portal_user. So I created a ROLE as APP_ROLE and GRANT as below: GRANT SELECT, INSERT, UPDATE, DELETE ON APPDB.* TO APP_ROLE; Later I assign the

[Maria-discuss] mysqldump 10.1.16

All, I got a replciation problem and planned to take master server dump using below command and tried to restore in slave server: mysqldump --skip-lock-tables --single-transaction --flush-logs --hex-blob --master-data=1 -A --routines > ~/dump.sql I got into this error: https://jira.mariadb.org/b

[Maria-discuss] LOAD DATA LOCAL INFILE

HI All, Even after enabling --local-infile=1 at mysql user login, I couldn't load the file locally. mysql -u root --local-infile=1 LOAD DATA LOCAL INFILE ERROR 1148 (42000): The used command is not allowed with this MariaDB version show variables like '%local%'; +---+---+ | Var

Re: [Maria-discuss] LOAD DATA LOCAL INFILE

am Files\MariaDB 10.2\bin>mysql -u root -p local-infile=1 > Enter password: > ERROR 1049 (42000): Unknown database 'local-infile=1' > > Is it possible to specify a server variable on the commandline at all? I > don't think so. At least I never heard about it. &

Re: [Maria-discuss] LOAD DATA LOCAL INFILE

ufficient privileges, you can enable this > dynamically by running: > > mysql -e "SET GLOBAL local_infile = on" > > ~Andrew > > On Wed, Feb 15, 2017 at 8:05 AM, Karthick Subramanian > wrote: > > Typo: > > > > mysql -u root --local-infile=1 > &g

Re: [Maria-discuss] mysqldump 10.1.16

> On 15/02/17 19:02, Karthick Subramanian wrote: > > All, > > > > I got a replciation problem and planned to take master server dump using > > below command and tried to restore in slave server: > > > > mysqldump --skip-lock-tables --single-transaction --

[Maria-discuss] timestamp with time zone support mariaDB 10.1.14

Hi Experts, I got this error, not sure whether maria db supports time zone: MariaDB [devdb]> create table ts (dt datetime, tz timestamp with time zone); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax

Re: [Maria-discuss] timestamp with time zone support mariaDB 10.1.14

Brian Evans wrote: > On 2/23/2017 9:11 AM, Karthick Subramanian wrote: > > Hi Experts, > > I got this error, not sure whether maria db supports time zone: > > MariaDB [devdb]> create table ts (dt datetime, tz timestamp with time zone > ); > ERROR 1064 (42000): Y

[Maria-discuss] Replication-manager + Maxscale

Hi Experts, I have a 2 db server with one as master and another one as slave. Maxscale implemented with below monitor config: *[MySQL Monitor]* *type=monitor* *module=mysqlmon* *servers=master1,slave1* *monitor_interval=500* *script=/usr/bin/replication-manager --user root:password --rpluser rep

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

tructions. Please grab the 1.0.2 release > for your distribution there: > https://github.com/tanji/replication-manager/releases > > Replication Manager works best when used independently from MaxScale. > Please read our documentation at https://github.com/tanji/ > replication-manag

Re: [Maria-discuss] Change to innodb_large_prefix with respect to creating long indexes

Hi, I come across similar situation today: server version: 10.1.21-MariaDB character_set_database | utf8 character_set_filesystem | binary Initially when I tried to create Unique Index on below columns, I got error as max key length 762 bytes error: col_1 varchar(500) col_2 varchar(250) col_

Re: [Maria-discuss] MariaDB 10.0.30 now available

Sorry if this question seems silly: Why we need to use 10.0.30 when we already have 10.1. Series with GA. Why don't we upgrade from 10.0 series to 10.1 GA series. Is there anything that fixed in 10.0.30 which yet to fix in 10.1.21 GA. Thank you for helping me to understand these different vers

Re: [Maria-discuss] MariaDB 10.0.30 now available

12:43 AM, Reindl Harald wrote: > > > >> Am 08.03.2017 um 19:44 schrieb Karthick Subramanian: >> Sorry if this question seems silly: >> >> Why we need to use 10.0.30 when we already have 10.1. Series with GA. > > because 10.x is still supported and the wh

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

Follow these below 3 links (especially 3rd link): https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Tutorials/MySQL-Replication-Read-Write-Splitting-Tutorial.md https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Routers/ReadWriteSplit.md https://git

Re: [Maria-discuss] Partition a Huge table

Hi Suresh, - If the DML activities are not on the historical data (hot dataset and cold dataset), then shall we create a empty partitioned table and start populating the historical datasets into this new partitioned table using LOAD DATA INFILE method. {*Preferably we can do this acti

Re: [Maria-discuss] restore db from dump?

That's the work around though. But what OP asks is also a valid scenario in real life scenario. If we have such options like selective load, remapping databases then its really a wonderful. On Thu, Apr 6, 2017 at 12:27 AM, Reindl Harald wrote: > > > Am 05.04.2017 um 20:43 schrieb l vic: > >> H

Re: [Maria-discuss] Ubuntu 16.04, Accidentally installed mariadb-server on top of mysql-server

If you currently log into Maria DB, execute *show variables like '%dir%'; *and it ll show you a different value than your existing mysql's data dir. In your MySQL conf file (usually server.conf in rhel for me), mention the data dir as your old MySQL data dir (your dozen dbs location). Then restart

[Maria-discuss] Time Zone help

All, I am facing some strange issue, I believe its due to my ignorant, would appreciate if you can help me out on this: DB Server system OS CentOS. I have loaded the timezone tables in mysql using: mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql After loading, I have restrated

Re: [Maria-discuss] Time Zone help

file I guess. > > > > Rhys > > > > *From:* Maria-discuss [mailto:maria-discuss-bounces+rhys.campbell= > swisscom@lists.launchpad.net] *On Behalf Of *Karthick Subramanian > *Sent:* 07 June 2017 11:09 > *To:* Maria Discuss > *Subject:* [Maria-discuss] Time Zone help

[Maria-discuss] MariaDb 10.2 in RHEL 5.3

Did anyone install the Maria DB 10.2 in RHEL Red Hat Enterprise Linux Server release 5.3 (Tikanga). I am planning to install this in Dev env, its not prod, Shall I try this. Regards, Karthick ___ Mailing list: https://launchpad.net/~maria-discuss Post to

[Maria-discuss] MariaDB upgrade 10.1 to 10.2 CentOS7

All, Did anyone face issues after upgrading the mariadb from 10.1 to 10.2 to login to root user as shown below: mysql -u root I got the error - unix_socket not loaded. I noticed that the unix_socket authentication is required after the upgrade for root login from localhost. Can anyone confirm w

Re: [Maria-discuss] MariaDB upgrade 10.1 to 10.2 CentOS7

Reindl Harald wrote: > > > Am 13.11.2017 um 10:11 schrieb Karthick Subramanian: > >> All, >> >> Did anyone face issues after upgrading the mariadb from 10.1 to 10.2 to >> login to root user as shown below >> > > did you run mysql_upgrade? > > __

Re: [Maria-discuss] MariaDB upgrade 10.1 to 10.2 CentOS7

3, 2017 at 4:49 PM, Elena Stepanova wrote: > Hi Karthick, > > On 11/13/2017 11:11 AM, Karthick Subramanian wrote: > >> All, >> >> Did anyone face issues after upgrading the mariadb from 10.1 to 10.2 to >> login to root user as shown below: >> >> mysq

Re: [Maria-discuss] MariaDB upgrade 10.1 to 10.2 CentOS7

wrote: > > > Am 13.11.2017 um 12:43 schrieb Karthick Subramanian: > >> set-up repo: >> >> curl -sShttps://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo >> bash >> > don't get me wrong but nobody right in his mind pipes a URL to sudo ba

Re: [Maria-discuss] MariaDB upgrade 10.1 to 10.2 CentOS7

Hi Elena, Do you think the yum update causing issue instead of yum remove and yum install in the first place. Please advise. On Nov 13, 2017 5:13 PM, "Karthick Subramanian" < ksubraman...@paycommerce.com> wrote: > Hi Elena, > > [root@one server ~]# rpm -qa | grep -iE

Re: [Maria-discuss] Install MariaDB repo official Centos-7

Can you check whether *systemctl start mysql* is working for you. On Tue, Nov 28, 2017 at 4:27 AM, Wilmer Arambula < tecnologiaterab...@gmail.com> wrote: > Hi, install MariaDB from the official repository [mariadb.org] for > Centos-7: > > 1.- yum install MariaDB-server MariaDB-client > > When ex

[Maria-discuss] Is this normal behaviour?

All, When I tried to connect in centos 7 mariadb 10.2.11 server using root user, by mistake I gave wrong user name, but it connected successfully. I am not sure why. When I check show databases, it didnt list all DBs, but when I connect with root again, I can see all valid Dbs. Is this normal tha

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

s > a pattern, and rot@localhost matches. > When running SHOW DATABASES you see only the databases which you have some > permissions. > > Federico > > > > ------ > *Da:* Karthick Subramanian > *A:* Maria Discuss > *Inviato:* Giovedì 4

Re: [Maria-discuss] procedure to change database encryption with file_key_management plugin?

Hi Obsa, Thank you for sharing this link, sounds interesting. In case you succeed with this Vault implementation, kindly share us your experience (may be a blog post on this). I am also looking for implementing something similar without AWS KMS option. Thank you. On Tue, Feb 27, 2018 at 5:59 A

Re: [Maria-discuss] SQL_MODE=ORACLE documentation

IMHO, putting pointers each others will help instead of putting Oracle Syntax in the mainline pages. This may cause confusion for the people who never used oracle in firsthand. On Mon, Mar 5, 2018 at 2:11 PM, Alexander Barkov wrote: > Hello Federico, > > On 03/02/2018 07:12 PM, Federico Razzoli

Re: [Maria-discuss] Query ambiguity

I think the OP needs to try a lot of googling and stackoverflow etc first and break the heads first and then post it here if it's really required. IMHO, if people start asking the SQL problems (mainly most of the sql issues are knowledge gap related) here, then I think the quality of this forum wil

Re: [Maria-discuss] Query ambiguity

Check whether you really need a comma here: *metrics_5.id ,* *(SELECT * Also in your screen shot, AS 'LT CPC`, there is no comma and you use derived table in SELECT and trying to use JOIN in the FROM using this. Sorry to say this, I think you can either break this logic int