Mysql, SQLite, Scalability

Question

Could SQLite be an alternative to mysql in high traffic websites? Thanks

Answer 1

Short answer: SQLite is an embedded database. This assignment is different from stand-alone RBDMS. Keep in mind that with faster queries than MySQL, keep in mind that SQLite has:

• there is no good network support (the goal of SQLite is different), so replication is PITA
• coarse blocking (one record at a time)
• leading table statistics
• no query optimizer
• large memory consumption with large databases (each transaction will require 100 GB of database).

, SQLite , , , ( ), SQLite .

MySQL: MySQL - . :

• http://oreilly.com/catalog/9780596003067
• https://www.packtpub.com/high-availability-mysql-cookbook/book

Answer 2

SQLite , - ( , 99,9% -). -, SQLite , , , . , , 100K / SQLite. 100K/ , . SQLite 10 .

: http://www.sqlite.org/whentouse.html

Answer 3

. SQLLite concurrency. .

Answer 4

! !

Answer 5

Only if you push your data into the cache and read from the cache. SQLite can be used as persistence for the cache, but its really not recommended.