WordPress.org

Ready to get started?Download WordPress

Ideas

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: 4 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: 3 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: 2 years 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: 2 years ago #
  5. Kynao
    Member

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

    Posted: 1 year 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: 1 year ago #

RSS feed for this topic

Reply

You must log in to post.

  • Rating

    12345
    12 Votes
  • Status

    This idea is under consideration