Read the original article at Book Review – Effective MySQL
Effective MySQL: Optimizing SQL Statements by Ronald Bradford No Nonsense, Readable, Practical, and Compact I like that this book is small; 150 pages means you can carry it easily. It’s also very no nonsense. It does not dig too deeply into theory unless it directly relates to your day-to-day needs. And those needs probably cluster [...]
For more articles like these go to iHeavy, Inc +1-212-533-6828
Read the original article at 5 Tips to Cache Websites and Boost Speed
Often when we think about speeding up and scaling, we focus on the application layer itself. We look at the webserver tier, and database tier, and optimize the most resource intensive pages.
There's much more we can do to speed things up, if we only turn over the right stones. Whether you're using WordPress or not, many of these principals can be applied. However we'll use WordPress as our test case.
Test Your Website speed
There are web-based speed testing tools that will help with this step. Take a look at Webpagetest , …
[Read more]Recently at Surge 2011, the annual conference on scalability and performance, Google's CIO Ben Fried gave an illuminating keynote address. His main insight was that generalists are the people that will lead engineering teams in successfully scaling the web.
In a world where the badge of Specialist or Expert is prized, this was refreshing perspective from an industry bigwig. As tech professionals, or any professional for that matter, we don't welcome the label of generalist. The word suggests a jack-of-all-trades and master of none. But the generalist is no less an expert than the specialist. Generalists can get their hands greasy with the tools to fix bugs in the machine but they are especially good at mobilizing the …
[Read more]I’ve been seeing a few occasions where Neil J. Gunther’s Universal Scalability Law doesn’t seem to model all of the important factors in a system as it scales. Models are only models, and they’re not the whole truth, so they never match reality perfectly. But there appear to be a small number of cases where systems can actually scale a bit better than linearly over a portion of the domain, due to what I’ve been calling an “economy of scale.” I believe that the Universal Scalability Law might need a third factor (seriality, coherency, and the new factor, economy of scale). I don’t think that the results I’m seeing can be modeled adequately with only two parameters.
Here are two publicly available cases that appear to demonstrate this phenomenon: Robert Haas’s recent blog post on PostgreSQL, titled …
[Read more]This year’s Surge conference was a great sophomore event to follow up last year’s inaugural conference. A lot of very smart people were there, and the hallway track was great.
I presented on three things: a lightning talk about causes of MySQL downtime; I chaired a panel on Big Data and the Cloud; and I showed how to derive scalability and performance metrics from TCP traffic. I’ve sent my slides to the Surge organizers, and I understand that they will be posting them as well as integrating them into the video of my session. In the meanwhile you can download my slides from Percona’s presentations page.
Further Reading:
[Read more]Could pro-waitering serve up some lessons on web scalability? Observing peak hour dining at a New York restaurant gave us some insight.
I was dining at a restaurant the other day with friends. It was a warm and cozy place, nicely decorated with a long, narrow dining room. The food was scrumptious, yet we were getting increasingly frustrated by the service as the night went along.
With some waiting experience behind me, I could immediately see the problem. The waiters, probably through lack of experience, were making the mistake of doing one thing at a time. They would go to a table, respond to one customer's request, and go and fetch that item. Back and forth, back and forth they would dart, but always dealing with …
[Read more]Read the original article at Scale Quickly Like Birchbox – Startup Scalability 101
One of the great things about the Internet is how it has made it easier to put great ideas into practice. Whether the ideas are about improving people’s lives or a new way to sell and old-fashioned product, there’s nothing like a good little startup tale of creative disruption to deliver us from something old and tired.
We work with a lot of startup firms and we love being part of the atmosphere of optimism and ingenuity, peppered with a bit of youthful zeal - something very indie-rock-and-roll about it. But whether they are just starting out or already picking up pace every startup faces the same challenges to scale a business. Recently, we were reminded of this when we watched …
[Read more]
MySQL 5.5 GA and MySQL 5.6 Development Milestone Releases have
delivered many new compelling features to the MySQL users and
community for testing, feedback and use.
In addition, commercial customers have access to a number of
commercial extensions already included in MySQL
Enterprise Edition:
• MySQL Enterprise Monitor
• MySQL Enterprise Backup
Continuing the business model of MySQL, we are adding three new
commercial extensions to MySQL Enterprise Edition:
MySQL 5.5 GA and MySQL 5.6 Development Milestone Releases have
delivered many new compelling features to the MySQL users and
community for testing, feedback and use.
In addition, commercial customers have access to a number of
commercial extensions already included in MySQL
Enterprise Edition:
• MySQL Enterprise Monitor
• MySQL Enterprise Backup
Continuing the business model of MySQL, we are adding three new
commercial extensions to MySQL Enterprise Edition:
MySQL Cluster* is one of the most advanced and scalable databases
available today and, despite what its name might suggest, it is
also a brilliant NoSQL database**.
Let me discuss this statement!
First, let’s discuss the high level issues that NoSQL databases
try to address: - Scalability.
Traditional RDBMS technology was designed four decades ago, and
is not appropriate for today’s Big Data requirements. Database
systems today need to be able to scale horizontally over multiple
machines to handle millions of users. As the CAP
theorem states, it is not possible to achieve availability,
scalability and consistency in one system. Several NoSQL
databases sacrifice consistency for availability and scalability.
- RDBMS has a rigid data model. Once a
normalized data model has been defined in an RDBMS, it is …