… past MySQL conferences from people who have built systems like yours, and there’s a fair chance they will talk about how hard… point is to think outside the box, even to think of things that seem “less advanced” than using a database. Sharding and Partitioning Sharding is inevitable…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… as a node from here on out. Shard-Query is very flexible in it’s configuration, so you can use this sample database to… important to examine the differences in size. This will give us some interesting information about how Shard-Query will perform on each database. To do…-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set up a cluster from 1 to 20 nodes for…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
…MySQL to using MySQL + Memcached, and then to other solutions like Tokyo Tyrant or Cassandra. My Application does the following: A.) read a row from a database…sharding systems, the discussions on cluster, more memcached. We need to cover up the databases inefficiencies to…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
…to write a series of blog posts on MySQL…sharding. It’s too bad that “the replica can’t keep up with the write workload” becomes the reason to shard…a thread for each database we see in the binary log, and simply pass the replication events to the appropriate thread. A…
Comment: Why you don't want to shard.
August 14, 2009 By 34 Comments
…sharding. In fact we help a lot of people how to shard properly. The problem is now it is such a… to shard because there is no interdependencies. The large data also indeed causes operational concerns – databases in TB range are often not fun in MySQL due to challenges with …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…mysql.com/bug.php?id=29560 Concerning a switch to Oracle’s main database, I believe different applications work best on different database…to get large data manageable. MySQL Master Master Manager can help you to automate it a bit. I also like to keep tables small enough, “sharding” to…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…a lot of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding…to other database systems. MySQL has to do more than one fsync() for the log because it internally implements XA to…
Post: Percona Server Scales Vertically with Virident tachIOn Drives
February 28, 2011 By Leave a Comment
We’ve published a new white paper that explains how to stop sharding and start scaling vertically with PCI-E flash drives, specifically …. “Scaling up” is once again a viable and economical strategy for MySQL, and “scaling out” need no longer be the default database architecture.
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
…how various system components could be a bottleneck for MySQL: CPU, disks, memory, network; and how to use diagnostic tools in Linux. Investigate database…
Comment: Another ingenious piece of Sun Marketing
March 24, 2009 By 20 Comments
…. Second, it shows great throughput on a workload when you shard a database. That is not a good reason to shard a database. The focus of the article should… consolidation, then this isn’t a solution yet. How are we expected to manage this? Running ‘/etc/init.d/mysql start’ separately for each…
