Scalable Application Design
Posted by: varaha sridhar
Date: May 19, 2008 11:59PM

Hi,

I am new to MySQL but i have designed the databse architecture for scalable application. In my scenerio, data writes will be less and reads will be in millions.
1. There will be 1 write server (InnoDB) and 4 read servers (MyISAM).
2. Every one hour i will get the feed into database.

Now my question is:
1. When replication taking place, if multiple users access the database, MyISAM is ahving table locks so, it locks the table until it completes all inserts into table. Then application users will be in hold until the batch completes. Is it right way to do for my scenario.

2. If i use InnoDB for both Reads/writes, it will give effective performance? (I heard that MyISAM is faster for reads and InnodB is for Writes).

I have looked into so many posts in this forumn, but i didn't get any solution for my scenario. Can you please suggest me the best way to design the architecture for my scenerio.

Options: ReplyQuote


Subject
Written By
Posted
Scalable Application Design
May 19, 2008 11:59PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.