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

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

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

Check owner of the MySQL data directory. 2011/1/19 Pintér Tibor tib...@tibyke.hu 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

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

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 pengyu...@gmail.com wrote: Hi, I run the following command. But I got the following error. I'm not sure what causes the problem. I

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 bferr...@baywinds.orgwrote: 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.

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 bferr...@baywinds.orgwrote: How would you rewrite the following SQL so that is doesn't do a full

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

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 l...@afan.net 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

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 e...@pdtnetworks.net 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

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?