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 dilipkumar.par...@eds.com To: Jeetendra

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

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

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,

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

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;

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

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='adconsent'

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 dilipkumar.par...@eds.com To: Jeetendra Ranjan jeetendra.ran...@sampatti.com; mysql@lists.mysql.com Sent: Thursday, December 24, 2009 2:51 PM Subject: RE: Slave

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 '';

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

2009/12/23 Ryan Chan ryanchan...@gmail.com: 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: http://bugs.mysql.com/bug.php?id=16979

Re: mysql load balancing

El día 22 de diciembre de 2009 13:44, Miguel Angel Nieto cor...@miguelangelnieto.net 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

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

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,

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 meet is,