Database Development Help

m92g11

I have a MySQL cluster... and my database schematics calls for a new database to be created for every new registered user. I'm trying to write this code where every db will be named after the users ID. I've got this far... but I'm needing help in creating the code that will grab the last registered user's ID and create a database one up from the last registered user. For example:

Last registered users id: 1
the code will take this and one up it:
Next registered users id: 2

how do i write the code that will decide what the last registered users id is.

Any help?

Thanks in advance!
- Mike

dagon

when you add your user retrieve the new user id used with mysql_insert_id() then use that for the db name.

There's not many cases where a new db per user is a good idea, but i assume you know what you are doing :-)

m92g11

Its been what 2 years sense my last post... Ive learned allot sense then. I'm actually building a social networking site and i thought it would be a good idea as far as security is concerned to use a new database per user. lets say i have one database that stores all the chatting sessions from all users. if my site gets really big thats allot of data that could be leaked very easily if someone where to hack the site. how would you go about doing this? Encrypting everything seems a little crazy too.

And what are the drawbacks/advantages of using a database per user?

ive also done allot of research as to how facebook approaches this, but in the end ive came up empty handed

dagon

depending on how the site is hacked multi db's are no more secure than one. Do you really think you will get any where near the number of users of facebook?

m92g11

you never know my friend... how would you develop your database? I've spent a while trying to figure this part out. Security is one of my core principles.

dagon

i would have the user id in any db i need to to identify the user. I'll give you a months pay if you get 10% of the number of facebook users in the next year

m92g11

lol thats a bet.. though i dont think ill even be done with the site in a year... im a very slow coder. but if we where to say once i get it up and running... then ill take that bet up

sneakyimp

For starters, I would not be creating one database per user. Like Dagon says, it doesn't really provide you with any additional security and you'll probably run into trouble when you want to create functionality that deals with connections between users.

m92g11

advice taken 🙂

sneakyimp

Also, if you are really shooting for something to support bazillions of users, a MySQL cluster might seem like a good start, but you might consider something like Amazon SimpleDB or Amazon RDS or something like that.

m92g11

yeah.... I think if my site gets to be large i can always redesign. and ill always be improving the code if i can finish it. so i think im good on the security stand point. thanks man... ill probably setup several clusters in my bedroom once i get ready to launch too. though i haven't considered Amazon's hosting capabilities. ive looked into it before and it seemed like a very good idea. Plus you can setup virtual networks on there service. so ill be set. because ill be able to provide all the things i wanna offer