On Wed, Jun 11, 2003 at 03:30:01PM -0500, Sam Jumper wrote: > Is it possible to have more than one binary log per master or is it > possible to start more than one thread to execute queries? > > I have 2 computers in a master and slave configuration. The slave is > running without error but it can't keep up with the volume of updates > being performed on the master. The slave is a dual processor box and > only one cpu is being utilized because the slave is reading the master's > binary log and running queries serially. The master and slave have > several databases and it would be great if each database could run it's > own thread to execute queries. It would stand a better chance of being > able to keep up. I'm not expecting real-time replication but after 24 > hours, the slave is already 5 hours behind.
You could run separate MySQL instances for the various databases. That's the only way to get any parallelism about of it. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 8 days, processed 276,889,335 queries (371/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
