… need to consider less direct impact like loss of corporate image and other marketing costs. If your downtime cost is under… the write operations. If the replication master is multi-cores servers and is heavily writing using multiple threads, the slaves will… management, an on site intervention with physical access to the servers is the preferred way, especially for the most complex solutions…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
Post: BoardReader - Forum Search Engine
November 29, 2006 By 13 Comments
… different forum sites mapped to different “table groups” with each server handling bunch of these. This would make it easier to… incoming links as they are scattered among many tables and servers. To target this problem we also store inbound links clustered… are getting normal links as well as domains which have images on them referenced. There are still a lot things to…
Post: MySQL Configuration Wizard Updated
January 26, 2012 By 5 Comments
… to help you generate my.cnf files based on your server‘s hardware and other characteristics. We’ve gotten really good… them anytime you like. From this page (click on the image for a fullsize view) you can do things like sharing… advisor, a query analysis tool, a way to register a server‘s essential characteristics and then get advice when there’s…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…’ve had some clients hitting performance limitations on standard EC2 servers with EBS volumes (see SSD versus EBS death match), and… the chart of rows inserted per minute (click on the image for a bigger view): We can deduce a few things… being able to explain exactly what was happening on the server. I will reproduce this test, capture more measurements about what…
Post: Pitfall of proxying HTTP requests through Lighttpd
November 22, 2007 By 12 Comments
… little bit. As I already mentioned it was about web servers. Each of them was running Lighttpd that handled the requests… was configured however only to serve static content, such as images. The requests asking for PHP files were passed down with… will need to buffer the entire response from the backend server before sending to the client. And indeed I started browsing…
Post: Choosing an appropriate benchmark length
March 21, 2011 By Leave a Comment
… dispersion challenges if run at that level long-term. Database servers are no different. Many components in the system have the… a lot of long-term benchmarks on MySQL and Percona Server. He is a very patient man. Mark Callaghan has run… the case in a recent benchmark I ran. The following image shows the system’s IO behavior: As you can see…
Post: Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
… the MySQL conference in April: mys11pkb. If you click the image to the left, or this special link, it will pre… comments: Diagnosing and Fixing MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa System Administrator’s Toolkit Percona Server and XtraBackup: painless operations Forecasting MySQL Performance and Scalability Summary…
Comment: Checking for a live database connection considered harmful
May 7, 2010 By 38 Comments
… am trying to image how this is can be implemented on the server side. In order to achieve this, server code will need…
Comment: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
…) it breaks transaction (2) large number of retires kill app server (3) platform dependent, in general developers hate to write apps… server not to test the connection. then the trade off is very likely you will see an increase of failed operations. imaging…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
…. Especially if you think about it as $/visitor or $revenue/server the difference for most enterprises vs most of web applications… custom architectures, they also may not enjoy running too many servers. For others it becomes space and power constraint. It is… streaming to make it possible store large blobs such as images in the database efficiently. The other Wave is appliances – you…
