hi , and thanks for your answer, > On Mon, Oct 20, 2003 at 07:03:37PM +0200, Benjamin KRIEF wrote: >> the problem is that it's quite impossible to fine tune the load between >> the servers , and my slave is a bit too busy , so the replication thread >> is becoming very slow , and sometimes , i can see that the slave is more >> than 2 hours behind the master in terms of replication , and this really >> is a pb for me. > > Two hours?!? Wow. >
as you say =) >> i looked everywhere for a "high-priority-updates" option, but i can't >> find >> it.tell me if i'm wrong but i deduced that i can't ask the slave to wait >> until it reached the master before answering selects. > > Is your bottleneck CPU, I/O, or lock contention? > > Is your slave running on worse hardware than your master? my bottleneck is CPU , definitely. the load can go up to 35 in peak hours. no swapping occurs , my key efficiency is at 99,89 . and yes , my slave hardware is worse than my master : master= 2xPIII 1Ghz , 1 Go ram slave = 1 PIV 2,4Ghz, 1Go ram i also have to admit that the webserver is on the slave :( >> so i've started using more regexps to redirect the queries , but >> it's quite awful to my eyes. i would really like to input the ratio >> of "select" queries i'd like to send on the slave . > > Ouch. That's clearly not a good solution. > >> what about , instead of round robin dns , writing a small perl script , >> including a socket listening on the port 3306 , this small script would >> have to redirect the sql requests on the slave or on the master , but >> this >> time , i could fine tune it , and input for instance 0,3 for the slave >> , >> so that 3 requests out of 10 would go to the slave. > > Have you looked at SQL Relay? thanks for that one . it appears to me that it's exactly what i was looking for. bye ***************************************************** Benjamin KRIEF * Directeur Technique * IGUANE Studio Tel:01.56.55.54.20 * 5-7-9 passage des Cloys Fax:01.56.55.54.24 * 75018 PARIS Gsm:06.12.56.50.41 * mailto:[EMAIL PROTECTED] ***************************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
