SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast keithclark's Avatar
    Join Date
    Jan 2011
    Posts
    89
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Using Cassandra and MYSQL?!

    I'm currently writing my website in MYSQL but I know I'm going to switch to Cassandra. Can I use both or should I just choose one over the other? How hard and how long did it take to switch from mysql to cassandra (less than 5 minutes or longer)?

  2. #2
    Twitter: @TimIgoe silver trophy TimIgoe's Avatar
    Join Date
    Feb 2005
    Location
    Blackpool, UK
    Posts
    1,058
    Mentioned
    27 Post(s)
    Tagged
    1 Thread(s)
    Dependant on your code logic, you could, and possibly should use both - using mysql where it suits and then jumping into Cassandra for the data storage?

    I've been considering a solution for one of my projects, balancing both mysql AND a nosql 'data store'.

    Depending on how you structure your application, it may be easier to start development with the final setup, but equally if you structure your code sensibly it'll be easy to switch from one to the other later.

  3. #3
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,649
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    You do know that cassandra is NOT a relational data store so if you are doing relational stuff it really doesn't map, right?


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •