WordPress.org

• Extending WordPress
• Plugins
• Themes
• Mobile
• Ideas
• Kvetch!

WordPress + Cassandra

1. whitepixel
   Member

   Now that WordPress MU will be integrated into the WordPress code base, it would be nice to see Cassandra integration. This be huge for very large scale multi-site deployments of wordpress.

   With very large scale MU deployments, it puts a huge burden on MySQL and DBAs to backup, replicate, and maintain your 10,000+ MySQL tables. Cassandra is relatively much easier to maintain and it has no single point of failure.

   Of course, such a backend change is definitely not for everyone. Certain types of queries that a traditional RDMS like MySQL provides will not be possible with Cassandra; thus, prevent the migration over to Cassandra all together.

   Posted: 3 years ago #

2. DanYork
   Member

   12345

   Patomel,

   This is listed purely as an "idea" and I don't think there is ANY timeframe for this. It would involve a *substantial* amount of changes to make WP work on a NOSQL database, so it's definitely NOT a trivial task.

   I'd personally love to see a Cassandra-based option, as it would allow me to handle scaling of my site better than using MySQL master-slave relationships... but to get such an option requires some good developers who effectively want to fork WordPress to create a NOSQL option. Sadly, I don't have the time to contribute... and I haven't yet seen others in the community who do. We'll see.

   Dan

   Posted: 2 years ago #

3. ginecomastia
   Member

   The big problem i see is that to implement casandra, wordpress should work on a NOSQL database. I think that for now it will just remain as an idea

   Posted: 1 year ago #

4. Jesús Franco
   Member

   However, I'd like to see a plugin giving us the chance to link several sites through a common chat system, relying on a distributed NoSQL database, like CouchDB or OrientDB.

   I think I'm going to tackle this prototyping over an existent chat plugin, and trying to connecting it to a NoSQL database. Wait for updates abot this.

   Posted: 1 year ago #

5. Kynao
   Member

   If Nosql support were something possible, even in dream, then i would vote for OrientDB too.

   Posted: 10 months ago #

6. lamhud
   Member

   Here is a benchmark comparison mysql/cassandra provided by Apache:

   * Writing: MySQL: 300 ms. Cassandra: 0.12 ms.
   * Reading: MySQL: 350ms. Cassandra: 15 ms.

   Differences in features:

   * Number of columns: 4096. Cassandra: 2 billion.

   The fact that Twitter and Digg are replacing MySQL by Cassandra have become very popular.

   For example, there are questions to evaluate potential tool:

   * How will we add new machines?
   * Are their any single points of failure?
   * Do the writes scale as well?
   * How much administration will the system require?
   * If its open source, is there a healthy community?
   * How much time and effort would we have to expend to deploy and integrate it?
   * Does it use technology which we know we can work with?… and so on.

   Posted: 3 months ago #

RSS feed for this topic

Reply

You must log in to post.