…For smaller single system web site with no caching the overhead may well be insignificant – as you run update for…you choose replication (rather than partitioning) as your scaling path -…with such semantics and it will handle real-time counters very efficiently pushing few updates back to MySQL server…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
This week I helped dealing with performance problems (part MySQL related and part related to LAMP in general) of system …. Simple solution is use noatime mount option for your static content partition. Some web servers also support for O_NOATIME file open flag on newer…
Post: Site was down today, support and web hosting.
August 31, 2007 By 27 Comments
…a half year we had pretty good track record with MySQL Performance Blog – there were times when site was slow… he tells me to run “fdisk -l” (which lists partitions) I ask him to spell that to me … returned web site back to old server which happily was still available. Now I will wait just for sake …
Post: MySQL, AIX5L and malloc()
November 3, 2008 By 11 Comments
… IBM POWER6 server as the replacement for “old” P5 used to host Oracle database. Because we planed to use advanced virtualization with VIOS… one spare partition for MySQL tests. Because I had no past experience with it and there is not much documentation all around the web, I…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
…with MySQL Cluster, other may be good with MySQL Cluster but have no idea how to write storage engines or optimize for…web servers as well, such as lighttpd. In fact in this area MySQL Cluster, which was always best isolated of MySQL…
Comment: Thoughts on MySQL Replication
July 16, 2006 By 18 Comments
…with much of it comming from anonymous users which can be served by caching proxies not even hitting web servers. Language provide very good partitioning as there is very limited dependence between them. Working set for…
Post: Sphinx: Going Beyond full text search
July 23, 2007 By 18 Comments
…with MySQL for scalable Full Text Search applications. For…for “dev.mysql.com/download”" will only match dev.mysql.com domain and files within /download/ directory. Initially we implemented it in MySQL using partitioning…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
…should have done sharding functional partitioning or something else. Complex Replication… The story heard is typically – Web applications often have significantly prevailing…for years on single MySQL server (which just does not crash) as well as complex no single point of failure database backend with…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…partition with quorum Version: 1.0.8-042548a451fce8400660f6031f4da6f0223dd5dd 2 Nodes configured, unknown expected votes 1 Resources configured. ============ Online: [ monitor hamysql ] Install MySQL For…
Post: BoardReader - Forum Search Engine
November 29, 2006 By 12 Comments
…partitioning” scheme with different forum sites mapped to different “table groups” with each server…MySQL Forums Notice simple link structure – you can replace mysql.com in it with any other domain to search forums from that domain. For…
