RE: mysql cluster and auto shard

[Andrew Morgan]

 -Original Message-
 From: Mike Franon [mailto:kongfra...@gmail.com]
 Sent: 18 March 2013 13:34
 To: mysql@lists.mysql.com
 Subject: mysql cluster and auto shard
 
 I am looking at  the best way to scale writes.
 
 Either using sharding with our existing infrastructure, or moving to
 mysql cluster.
 
 Does anyone have any pros/cons to using mysql cluster?  I am trying to
 find a much better understanding on how the auto sharding works?  Is it
 true we do not need to change code much on application level?

As a starting point, I think it's worth taking a look at this white paper... 
http://www.mysql.com/why-mysql/white-papers/mysql-cluster-evaluation-guide/ 

Most things will continue to work when migrating to MySQL Cluster but of course 
(as with any storage engine) to get the best performance you'll probably need 
to make some changes; this second paper explains how to optimize for MySQL 
Cluster - hopefully that will give a good feeling for the types of changes that 
you might need/want to make... 
http://www.mysql.com/why-mysql/white-papers/guide-to-optimizing-performance-of-the-mysql-cluster/


 
 
 Thanks
 
 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/mysql
 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

RE: mysql cluster and auto shard

[Rick James]

Clustrix now has a software version of their auto-sharding system.  (It used to 
be that they only sold an 'appliance'.)

 -Original Message-
 From: Andrew Morgan [mailto:andrew.mor...@oracle.com]
 Sent: Monday, March 18, 2013 6:51 AM
 To: Mike Franon
 Cc: mysql@lists.mysql.com
 Subject: RE: mysql cluster and auto shard
 
 
 
  -Original Message-
  From: Mike Franon [mailto:kongfra...@gmail.com]
  Sent: 18 March 2013 13:34
  To: mysql@lists.mysql.com
  Subject: mysql cluster and auto shard
 
  I am looking at  the best way to scale writes.
 
  Either using sharding with our existing infrastructure, or moving to
  mysql cluster.
 
  Does anyone have any pros/cons to using mysql cluster?  I am trying
 to
  find a much better understanding on how the auto sharding works?  Is
  it true we do not need to change code much on application level?
 
 As a starting point, I think it's worth taking a look at this white
 paper... http://www.mysql.com/why-mysql/white-papers/mysql-cluster-
 evaluation-guide/
 
 Most things will continue to work when migrating to MySQL Cluster but
 of course (as with any storage engine) to get the best performance
 you'll probably need to make some changes; this second paper explains
 how to optimize for MySQL Cluster - hopefully that will give a good
 feeling for the types of changes that you might need/want to make...
 http://www.mysql.com/why-mysql/white-papers/guide-to-optimizing-
 performance-of-the-mysql-cluster/
 
 
 
 
  Thanks
 
  --
  MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:http://lists.mysql.com/mysql
 
 
 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/mysql


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql