Re: Free load balancing and sharding
Am 02.09.2015 um 09:55 schrieb S.Mohammad Emami Razavi: I want to cluster MySQL to several servers and have no idea to start. Some questions have stuck to my mind such as How to balance connections and How to make mesh of shards and ... Can you show me a way to do these tasks correctly? https://mariadb.com/products/mariadb-maxscale signature.asc Description: OpenPGP digital signature
Free load balancing and sharding
I want to cluster MySQL to several servers and have no idea to start. Some questions have stuck to my mind such as How to balance connections and How to make mesh of shards and ... Can you show me a way to do these tasks correctly? Many Thanks,
Re: Sharding
Thanks a lot. On Fri, Jan 29, 2010 at 8:50 AM, Carlos Proal carlos.pr...@gmail.comwrote: Krishna I dont have any benchmark but you can take a look on the Cafepress presentation that includes some data (or ask the authors for deep reference) http://assets.en.oreilly.com/1/event/2/Horizontal%20Scaling%20with%20HiveDB%20Presentation.pdf Carlos On 1/22/2010 11:44 PM, Krishna Chandra Prajapati wrote: Hi Carlos, Have you tried and benchmark hivedb. any body reviewed hivedb. Please share the experience. Krishna On Fri, Jan 22, 2010 at 11:47 PM, Carlos Proal carlos.pr...@gmail.commailto: carlos.pr...@gmail.com wrote: Hi Krishna Depending on your programming language, you can use http://www.hivedb.org/ Also you can try the new Spider Storage Engine http://spiderformysql.com/ I have not tried this one but seems interesting and there are a couple reviews by Giuseppe Maxia that can help you: http://datacharmer.blogspot.com/2009/04/test-driving-spider-storage-engine.html http://datacharmer.blogspot.com/2009/07/sharding-for-masses-spider-storage.html Carlos On 1/22/2010 4:47 AM, Krishna Chandra Prajapati wrote: Hi List, I am looking opensource tool for mysql sharding. One is mysql-proxy, but it is in alpha stage. Another one is spock proxy. Any one benchmark spock proxy. Is there other tools also. Please share views with mysql sharding Any response is highly appreciated. Thanks, Krishna --MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com
Re: Sharding
Krishna I dont have any benchmark but you can take a look on the Cafepress presentation that includes some data (or ask the authors for deep reference) http://assets.en.oreilly.com/1/event/2/Horizontal%20Scaling%20with%20HiveDB%20Presentation.pdf Carlos On 1/22/2010 11:44 PM, Krishna Chandra Prajapati wrote: Hi Carlos, Have you tried and benchmark hivedb. any body reviewed hivedb. Please share the experience. Krishna On Fri, Jan 22, 2010 at 11:47 PM, Carlos Proal carlos.pr...@gmail.com mailto:carlos.pr...@gmail.com wrote: Hi Krishna Depending on your programming language, you can use http://www.hivedb.org/ Also you can try the new Spider Storage Engine http://spiderformysql.com/ I have not tried this one but seems interesting and there are a couple reviews by Giuseppe Maxia that can help you: http://datacharmer.blogspot.com/2009/04/test-driving-spider-storage-engine.html http://datacharmer.blogspot.com/2009/07/sharding-for-masses-spider-storage.html Carlos On 1/22/2010 4:47 AM, Krishna Chandra Prajapati wrote: Hi List, I am looking opensource tool for mysql sharding. One is mysql-proxy, but it is in alpha stage. Another one is spock proxy. Any one benchmark spock proxy. Is there other tools also. Please share views with mysql sharding Any response is highly appreciated. Thanks, Krishna -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com
Sharding
Hi List, I am looking opensource tool for mysql sharding. One is mysql-proxy, but it is in alpha stage. Another one is spock proxy. Any one benchmark spock proxy. Is there other tools also. Please share views with mysql sharding Any response is highly appreciated. Thanks, Krishna
Re: Sharding
Hi Krishna Depending on your programming language, you can use http://www.hivedb.org/ Also you can try the new Spider Storage Engine http://spiderformysql.com/ I have not tried this one but seems interesting and there are a couple reviews by Giuseppe Maxia that can help you: http://datacharmer.blogspot.com/2009/04/test-driving-spider-storage-engine.html http://datacharmer.blogspot.com/2009/07/sharding-for-masses-spider-storage.html Carlos On 1/22/2010 4:47 AM, Krishna Chandra Prajapati wrote: Hi List, I am looking opensource tool for mysql sharding. One is mysql-proxy, but it is in alpha stage. Another one is spock proxy. Any one benchmark spock proxy. Is there other tools also. Please share views with mysql sharding Any response is highly appreciated. Thanks, Krishna -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Sharding
Hi Carlos, Have you tried and benchmark hivedb. any body reviewed hivedb. Please share the experience. Krishna On Fri, Jan 22, 2010 at 11:47 PM, Carlos Proal carlos.pr...@gmail.comwrote: Hi Krishna Depending on your programming language, you can use http://www.hivedb.org/ Also you can try the new Spider Storage Engine http://spiderformysql.com/ I have not tried this one but seems interesting and there are a couple reviews by Giuseppe Maxia that can help you: http://datacharmer.blogspot.com/2009/04/test-driving-spider-storage-engine.html http://datacharmer.blogspot.com/2009/07/sharding-for-masses-spider-storage.html Carlos On 1/22/2010 4:47 AM, Krishna Chandra Prajapati wrote: Hi List, I am looking opensource tool for mysql sharding. One is mysql-proxy, but it is in alpha stage. Another one is spock proxy. Any one benchmark spock proxy. Is there other tools also. Please share views with mysql sharding Any response is highly appreciated. Thanks, Krishna -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com