2. PHPRunner General questions
  3. Multiple Databases
This topic is locked

Multiple Databases

 		9/15/2009 9:32:21 AM
PHPRunner General questions
H
 horsey_kim author

Using Mysql Database and PHPrunner 5.1 -
I am currently working on a network of websites that consist of allowing website owners (only sites I host) to be able to update their websites via their browser. (Mysql Database) Each website will have a database for their website pages. However each of these websites have something in common and they sell similar things.
I am also working on about 5 other major classified ad websites, which are all hosted with me too. My goal is that when a website owner updates items for sale on their website that it automatically updates the classified ad websites.
The classified ad websites will all share the same database.
With PHPRUNNER 5.1 is there a way to connect more that one database together?
If not what would be the best option for approaching this?
Kim <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=12735&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
I prefer that each website user have their own database and the classified ads share one. This way I can customize the other needs of my website owners with out effecting the classified ad portion of the network.
Any ideas?
S
 		swanside 9/15/2009

Could you not have one database, but different tables for each user and a common on for ads?
H
 		horsey_kim author 9/15/2009



Could you not have one database, but different tables for each user and a common on for ads?


Swanside - Thank you - That's an idea, I might try.
***
Does anyone know if there would be issues if I have say 50 different phprunner files accessing the same databases?
Since they are all hosted on the same server, I imagine that sharing the database would not be an issue between websites.
Do you think by adding more tables to cover the other website owners to the main database will slow everything down? We are talking atleast 40 website owners. Besides my various classified ad websites. It is going to be a huge project and I don't want to have to redesign it later. So any input I can get be greatly appreciated <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=44058&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
Kim <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=44058&image=2&table=forumreplies' class='bbc_emoticon' alt=':)' />
Sergey Kornilov admin 9/15/2009

Kim,
it doesn't really matter how many tables in your database. You can either assign a separate database to each website or share one database between all of them.
More important metric is the number of simultaneous users that will be accessing your website or websites.
H
 		horsey_kim author 9/15/2009



Kim,
it doesn't really matter how many tables in your database. You can either assign a separate database to each website or share one database between all of them.
More important metric is the number of simultaneous users that will be accessing your website or websites.


Thanks for the info. I am building this with PHPrunner - do you see any restrictions that might happen if I have too many simultaneous users. Is there some kind of number that you know of? Most likely when I am done it could be in the 1000 of users. It is a pretty big project.
Thanks for any info or suggestions you might have,
Kim
Sergey Kornilov admin 9/16/2009

Kim,
it's not about the tool you use to build your website. It's more about how your database is designed, do you have all required indexes in place, amount of data typical users consumes, physical parameters of your web server etc.
H
 		horsey_kim author 9/16/2009



Kim,
it's not about the tool you use to build your website. It's more about how your database is designed, do you have all required indexes in place, amount of data typical users consumes, physical parameters of your web server etc.


I am working on that now. I did read an article about making sure that you have queary_cache_size to about 20M. So I checked mine and it was set to 0, they went in and increased it. Hopefully that will help also.
Another thing I read was that when you set up the layout of your tables to have the more active ones in searches up front. I don't know if that is true, but I figure it would not hurt to try so. I am scaling down all the field sizes to be what is only needed.