WordPress + Cassandra

  1. whitepixel

    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: 10 years ago #
  2. DanYork



    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.


    Posted: 9 years ago #
  3. ginecomastia

    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: 9 years ago #
  4. tzkmx

    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: 8 years ago #
  5. Kynao

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

    Posted: 8 years ago #
  6. lamhud

    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: 7 years ago #
  7. May-Fly

    Interesting idea, I'm gonna keep an eye on developments and see what happens.

    Posted: 5 years ago #
  8. ConcertPass

    Apache Cassandra database is currently used by Apple, CERN, eBay, GitHub, Instagram, Reddit, Netflix and many other big companies. Its integration in WordPress would be a great addon specially for large scale multi-site deployments of wordpress. Cassandra's data model offers the convenience of column indexes with the performance of log-structured updates, strong support for denormalization and powerful built-in caching. Keep our finger crossed for the future.

    Posted: 5 years ago #
  9. zorrobyte

    Sounds like a ton of work.

    What about a better NoSQL replacement with a full SQL query language such as OrientDB? http://orientdb.com/docs/last/

    Posted: 5 years ago #
  10. Vovodroid

    Despite being NOSQL actually Cassandra has syntax and capabilities quite close to SQL:

    SELECT * from Users;
    INSERT INTO Hollywood.NerdMovies (user_uuid, fan) VALUES (cfd66ccc, 'johndoe')


    So connect WP to Cassandra can be much easier than to other NOSQL DB.

    Posted: 5 years ago #

RSS feed for this topic

Reply »

You must log in to post.

  • Rating

    16 Votes
  • Status

    This idea is under consideration