I think the easiest solution here is to use mysqlslap, here's some info on its use: <a href="http://www.jameslittle.me.uk/mysqlslap-for-mysql-50/">http://www.jameslittle.me.uk/mysqlslap-for-mysql-50/</a>. You tell it how many iterations, how many connections to make, and what SQL to submit (or it can generate some of its own). <br>
<br>But... 200 daemons entirely depends on what SQL they're submitting to the server and the hardware you're running it on. If they're doing lots of INSERTS and some simple SELECTS, I think it would probably be fine on relatively modern hardware. If they're all submitting complicated JOINS then you might have a problem. Also, your DB engine comes into some play here. If you're willing to sacrifice transactionalness you can go with MyISAM which is very, very fast and you might see some performance gains using it. It's not crash-safe. Maria is an engine written by Monty (former CEO of MySQL AB) which is MyISAM but crash-safe but I haven't used it.<br>
<br>Also, if the end result is that 1 MySQL server just isn't going to be able to handle your load, then there are options. Master-master (dual or more) mysql servers is a possibility, depending on the consistency of data you need (can you handle retrieving data that might be a few minutes old)? Also, MySQL Cluster is an option in limited circumstances -- it doesn't handle complicated stuff well, but it does handle LOTS and writes and LOTS of reads as long as you're not using FK's or JOINs. And finally, commercial solutions like uni/cluster are available.<br>
<br><br>- Steve<br><br><br><div class="gmail_quote">On Thu, Jun 18, 2009 at 9:20 AM, Atlanta Geek <span dir="ltr"><<a href="mailto:atlantageek@gmail.com">atlantageek@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
We have an application that has about 20 daemons on a single server<br>
writing data to a mysql database.<br>
A new requirement has popped up that suggests we need 200 daemons on<br>
multiple servers writing data to a mysql database.<br>
<br>
Does anyone know if there is a client limit to mysql. Currently these<br>
daemons will be writing to the same tables. Any suggestions. This<br>
situation is difficult to simulate in the lab unless we write<br>
speciallized code. Any suggestions from experience would be<br>
appreciated.<br>
<font color="#888888"><br>
<br>
--<br>
<a href="http://www.atlantageek.com" target="_blank">http://www.atlantageek.com</a><br>
_______________________________________________<br>
Ale mailing list<br>
<a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
<a href="http://mail.ale.org/mailman/listinfo/ale" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
</font></blockquote></div><br>