Migration

[Christopher Eugene]

I might be. No I am new very new to Redis and I have only one question. I have about 5000 contacts in a MYSQL DB and I need to some how export them to Redis DB is this probable, possible or Redis is not meant to manage such things? Yes you may be harsh but try not to.

[Dvir Volk]

Hi

Since redis doesn't have schemas, tables, relations, keys or SQL syntax, there is no automatic way to do that.

what you need to do is:

1. Decide how you are going to model the data on redis, which data structures to use and how.

2. Build the client side code to manage your database on redis.

3. when you have all that in place, create a program that migrates the data from mysql to redis.

On Thu, Oct 11, 2012 at 9:59 PM, Christopher Eugene <xrise...@gmail.com> wrote:

I might be. No I am new very new to Redis and I have only one question. I have about 5000 contacts in a MYSQL DB and I need to some how export them to Redis DB is this probable, possible or Redis is not meant to manage such things? Yes you may be harsh but try not to.

--
You received this message because you are subscribed to the Google Groups "Redis DB" group.
To view this discussion on the web visit https://groups.google.com/d/msg/redis-db/-/TLP3ONQAkXEJ.
To post to this group, send email to redi...@googlegroups.com.
To unsubscribe from this group, send email to redis-db+u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/redis-db?hl=en.

--

Dvir Volk

Chief Architect, Everything.me

http://everything.me 

[Christopher Eugene]

Thank you I just needed to know if it was possible. 

[Vijay]

Hi Christopher
Expanding on point 1 made by Dvir Volk.

Find out what are the query patterns you use in your application ?
Do you query only by the primary key ?
What other columns are queried ?
Are the columns indexed ?
Do you have a search facility ?
Do you do a joins with other table ?
Do you do self joins ?

You should design your redis model in such a way that 'for each query
in your existing app, there should be a way in redis to extract the
data. For this you should have understanding of the various
'datatypes' in redis. You should know when to use
keys/strings/hashes/lists to model your data.

If you can share the existing table schema and the various queries you
run, I can help model the data.

-- Vijay