Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On Ubuntu 11.10
Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on an Ubuntu 11.10 server with PHP5 support (through PHP-FPM) and MySQL support.
Percona Live: London was a rousing success for PalominoDB. I was sad that I could not attend, but I got a few people who sent "hellos" to me via my coworkers. But on to the most important stuff -- slides from our presentations are online!
René Cannao spoke about MySQL Backup and Recovery Tools and Techniques (description) - slides (PDF)
Jonathan delivered a 3-hour tutorial about Advanced MySQL Scaling Strategies for
Developers (description) - …
A number of blogs have been written with the intent of describing
how
the thread pool manages to solve the requirements of the thread
pool.
These blogs are:
MySQL Thread Pool: Problem Definition
MySQL Thread Pool: Scalability Solution
MySQL Thread Pool: Limiting number of concurrent
statement executions
Automated benchmark tool for DBT2, Sysbench and
flexAsynch
…
I was asked for help in optimizing a MySQL query where flags are stored in a database and references should be counted based on the flag value. Sounds not complicated at first, but there are several flags that should be counted and also just once per reference. A lot of food for GROUP BY you may think. Having said this, search and group for flags in this table would be really slow due to a very poor cardinality. But let's start with the actual problem. The example is fictitious, but I did my best to find a general use case for this problem.
I was asked for help in optimizing a MySQL query where flags are stored in a database and references should be counted based on the flag value. Sounds not complicated at first, but there are several flags that should be counted and also just once per reference. A lot of food for GROUP BY you may think. Having said this, search and group for flags in this table would be really slow due to a very poor cardinality. But let's start with the actual problem. The example is fictitious, but I did my best to find a general use case for this problem.
The release 1.0 completes a development "sprint", which lasted quite precisely exactly 4 years. However, this is actually due to the fact that our release numbering scheme is very modest and follows the general Linux community traditions. In fact, Galera installations have been in production use ever since the 0.7.2 release.
The 1.0 release contains major new functionality over the 0.8 series, where the biggest addition is that we now support both MySQL 5.1 and 5.5 versions: the release contains MySQL 5.1.58 and 5.5.15 options.
Check out the downloads!
The 1.0 release is accompanied by a magnificent new extension by Severalnines: ClusterControl Configurator makes the installing and configuring a Galera Cluster a dream come true.
Last time I wrote about MongoDB for MySQL DBAs I described some of the
basics of MongoDB querying, and this time I'll follow that up
with some more on querying.
As we saw last time, the basic format of a MongoDB query
is:
db.find(,)
Note that you do NOT replace db with the name of the database you
want to query here, you just make the database you want to use
the current one and issue the query, such as:
> use test
> db.mycoll.find()
The example above will find all objects in the mycoll collection,
and will include all the object attributes and also the key
(_id), like this:
{ "_id" : ObjectId("4eb0634807b16556bf46b214"), "c1" : 1 }
{ "_id" : ObjectId("4eb0634a07b16556bf46b215"), "c2" : 1 }
{ "_id" : ObjectId("4eb0635607b16556bf46b216"), "c1" : 2, "c2" :
2 } …
We just wrapped up the 7th ZendCon event last week in Santa
Clara, and the enthusiasm of the PHP community was inspiring. PHP
is gaining momentum across industries and geographies, powering
the web, helping people build amazing apps with ease, proficiency
and creativity. In so many ways, PHP is making a difference, from
legacy modernization to mobile app development and cloud
deployments. And PHP is the basis for Drupal CMS, Magento
e-commerce, Joomla and Wordpress, platforms used by millions of
people. It is gratifying to see the innovation in our community,
which is now about 5 million developers strong, and Zend is proud
to be part of it, with the introduction of phpcloud.com – which is
like a triple play in the cloud.
First up is Zend Developer Cloud, a sandbox where PHP
developers can get started and develop great …
Fall is being coy this year in the Northeast. We've been having on and off spells of very mild, almost summer-like weather over the last few weeks. That trend seems to be finally ending, alas, as there is possible snow forecasted for the weekend in New Hampshire. As the old joke goes, if you don't like the weather here, just wait five minutes.
The fall also brings hunting to the area. The annual moose season just concluded (you need to enter a special lottery to get a moose permit), but deer season is just about to open. My son and I won't be participating this year, but we recently purchased the appropriate tools of the trade, a shotgun to hunt in southern NH (where you can't hunt deer with a rifle) and a Mosin Nagant 91/30 for the rest of the state. The later is probably overkill, but my son saved up his pennies to buy it, being a student of both WWII and all things …
[Read more]I’ve been working with Clustrix team for long time on the evaluation of Clustrix product, and this is the report on performance characteristics of Clustrix under tpcc-mysql workload.
I tested tpcc 5000W (~500GB of data in InnoDB) on
Clustrix systems with 3, 6, 9-nodes and also, to
have base for comparison, ran the same workload on HP ProLiant
DL380 G6 powered by Fusion-io card, and on SuperMicro server
powered by 7 Intel SSD 320 cards (this server is equal to
hardware that Clustrix uses for its nodes).
The full report is available on our page with whitepapers, and in this post I would like to highlight the most interesting points.
The chart with comparison of all systems ( results in throughput per 10 sec, more is …
[Read more]