two processes update the same column in short time

Hello, I have a table, say its stru is like: domain ip noticed The column "noticed" is an enum value (eigher 0 or 1). When process one update "ip", it will set "noticed" to 0. Then process two know the status changed, it will do something and set "noticed" to 1. What the problem I me

Best Solution /more Tables or all in one?/

Hi i am on to create a database with a lot of entries. each user may have Records like: data1 (textfield) data2 (textfield) data3 (char [300]) and more like that Now I am thinking about what is better a: to create for each field an own Table like: table_user_data1 (records: userid,

Re: mysql load balancing

Hi, I've had quite a bit of success deploying mysql-proxy in my clients infrastructure. The standard read/write splitting is quite easy to achieve - but I also add some custom code to match with specific case (connection pooling, x second to the same master after a write/update, specific command

Re: mysql load balancing

El día 22 de diciembre de 2009 13:44, Miguel Angel Nieto escribió: >> It depends a lot on how you plan to coordinate the db servers >> (sharding, replication, ndb), the kind of applications you are going >> to deploy and how much scability you need. > > Thank you. I have read about LVS and keepali

Re: Table level locking when inserting auto-increment PK to InnoDB

2009/12/23 Ryan Chan : > Hey. > > Back to few years ago, InnoDB require table level locking when > inserting auto-increment PK to the table, and Heikki said there will > be a fix. > > Is this problem still exist now? If you refer to this bug: there is a m

Re: Slave is not updated

who is 'adconsent' ??. what is your replication user -naga On Thu, Dec 24, 2009 at 3:01 PM, Jeetendra Ranjan < jeetendra.ran...@sampatti.com> wrote: > Here is the action i performed: > > mysql> GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO > 'xx'@'xx.xx.xx.xx' > IDENTIFIED BY 'xxx

Re: Slave is not updated

Please ignore the user name and ip. i am passing the right information here - Original Message - From: "Parikh, Dilip Kumar" To: "Jeetendra Ranjan" ; Sent: Thursday, December 24, 2009 2:51 PM Subject: RE: Slave is not updated User is not the replication it is 'root' (or) mysqladm

Re: Slave is not updated

Here is the action i performed: mysql> GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'xx'@'xx.xx.xx.xx' IDENTIFIED BY ''; Query OK, 0 rows affected (0.00 sec) mysql> Flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> select * from mysql.user where user='adconsen

RE: Slave is not updated

Jeetendra, just update the username as root on the below query select * from mysql.user where user='replication'\G; =D -Original Message- From: Parikh, Dilip Kumar [mailto:dilipkumar.par...@eds.com] Sent: Thursday, December 24, 2009 2:52 PM To: Jeetendra Ranjan; mysql@lists.mysql.com

RE: Slave is not updated

User is not the replication it is 'root' (or) mysqladm Thanks, Dilipkumar Database Engineering  mailto: dilipkumar.par...@eds.com Pager mail:9884430...@nma.vodafone.in -Original Message- From: Shanmugam, Dhandapani Sent: Thursday, December 24, 2009 2:48 PM To: Parikh, Dilip Kumar; Je

RE: Slave is not updated

by the way did you flush the privileges on the master? What is the output you get, when you log in as root user on the mysql master server and issue the below command: select * from mysql.user where user='replication'\G; -D -Original Message- From: Parikh, Dilip Kumar [mailto:dilipkumar

RE: Slave is not updated

You can see in the logs, access denied So give trying for hostname or with full domain or Grant replication slave on *.* to 'mysqladm'@'95.%' identified by 'xx'; Grant replication slave on *.* to 'mysqladm'@'hostname identified by 'xx'; Flush privileges; it should work. Thanks, Dilipkum

Re: Slave is not updated

091223 5:55:22 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/lib/mysql/mysql-relay-bin.01' position: 4 091223 5:55:22 [ERROR] Slave I/O thread: error connecting to master 'r...@201.107.236.77:3306': Error: 'Access denied for user '

RE: Slave is not updated

Jeetendra, Can you paste the error log here. -D -Original Message- From: Jeetendra Ranjan [mailto:jeetendra.ran...@sampatti.com] Sent: Thursday, December 24, 2009 1:49 PM To: Parikh, Dilip Kumar; mysql@lists.mysql.com Subject: Re: Slave is not updated Hi Dilip, Thanks for your resp

Re: Slave is not updated

Hi Dilip, Thanks for your response I already run the below command at master: grant replication slave on *.* to 'mysqladm'@'95.84.86.41' identified by 'admmysql'; Thanks Jeetendra Ranjan - Original Message - From: "Parikh, Dilip Kumar" To: "Jeetendra Ranjan" ; Sent: Thursday,