MySQL HA on cloud

Hi, I have cloud setup where MySQL servers are installed. Replication is applied in between mysql servers. Now I want to implemet HA for MySQL. Can any one help me how can I achieve MySQL failover? I looked DRBD, Linux Heartbeat, but I am not able to confirm which should I go for or is there any

Query on wait_timeout

Hi, Small doubt for wait_timeout. If my wait_timeout is set for 180 seconds and if any deadlock occures and both query are waiting to execute. What wil happen in that case? 1. Do the connection will wait till deadlock is removed or 2. Connection will close after 180 seconds as both queries are id

Re: Can't read dir of '.' (errno: 13)

Check owner of the MySQL data directory. 2011/1/19 Pintér Tibor > > mysql> show databases ; > > ERROR 1018 (HY000): Can't read dir of '.' (errno: 13) > > mysql> show databases; > > ERROR 1018 (HY000): Can't read dir of '.' (errno: 13) > > mysql> > > $ perror 13 > OS error code 13: Permission d

Query is not using Index

Hi, I am firing following query SELECT 'Sales' as transaction_type, CONCAT('$', SUM(CASE DATE(px_orders.sales_orders.order_completed_date) WHEN CURDATE() THEN px_orders.sales_order_products.paid_amount ELSE 0 END)) AS today, CONCAT('$', SUM(CASE WEEK(px_orders.sales_orders.order_c

Re: ERROR 1 (HY000): Can't create/write to file '/var/lib/mysql/#sql_9e1_0.MYI' (Errcode: 13)

May be db files are not as MySQL user. Check owner ship for the files of the table. It should be mysql user ownership. On Tue, Jan 18, 2011 at 6:36 AM, Peng Yu wrote: > Hi, > > I run the following command. But I got the following error. I'm not > sure what causes the problem. I have seen the sam

Re: Rewrite SQL to stop table scan

Hey, Try making `id` as primary key. That will keep data in sorted manner and scan will look only the data required in-spite of full table scan. On Fri, Jan 14, 2011 at 4:22 PM, Bruce Ferrell wrote: > How would you rewrite the following SQL so that is doesn't do a full > table scan. It does in

Re: Rewrite SQL to stop table scan

can you send DDL of the table? On Fri, Jan 14, 2011 at 4:22 PM, Bruce Ferrell wrote: > How would you rewrite the following SQL so that is doesn't do a full > table scan. It does in fact do a full scan in spite of the time > clause. It's been > making me nuts for months. > > select count(*) as

Re: Large table

What is the table type for Table? Firstly check with queries and index if required. Check if queries using this table can be fine tuned. Check if table getting locked. If size of table is problem and if the table type is innodb check for innodb_file_per_table options. Also have a look for portion

Re: export result from select statement

#mysql -username -p -e "select * from table_name where id=123" > '/home/me/test/test.txt' On Mon, Jan 10, 2011 at 8:15 AM, LAMP wrote: > maybe it's "clear" to other but it's pretty unclear. > #mysql -username -p "select * from table_name where id=123" > > '/home/me/test/test.txt' > actually do

Re: problem open a innodb table

Dont you have mysql dump file for those table? It is best way to restore InnoDB tables. 2011/1/7 Elim PDT > I messed up the ibdata1,ib_logfile1,0 files and encounter the problems of > openning innodb tables even after I copied the back-up files of few months > ago. I don't have many innodb tabl

unauthenticated user | while load testing

Hi, What is unauthenticated user seen in mysql processlist ? I am doing load testing and at a single time more than 1000 users are coming to mysql server. Do any one have idea about it?