Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support (LEMP) On Ubuntu 12.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 12.10 server with PHP5 support (through PHP-FPM) and MySQL support (LEMP = Linux + nginx (pronounced "engine x") + MySQL + PHP).
With almost 40 member the MySQL User Group NL is already a success.
I've now scheduled the first meeting. It will be on Friday
November 16th in Amsterdam. Please signup using the
meetup.com
page.
Agenda (See meetup.com for latest updates)
18:00 Welcome
18:30 First presentation
19:30 Food
20:00 Second presentation
I'm looking for speakers, so feel free to suggest a speaker or to
volunteer to speak.
More resources for this user group:
A few weeks back, I was working on a customer issue wherein they were observing database performance that dropped through the floor (to the point of an outage) roughly every 4 weeks or so. Nothing special about the environment, the hardware, or the queries; really, the majority of the database was a single table with an auto-incrementing integer PK and a secondary UNIQUE KEY.
The queries being run against this table were almost exclusively INSERT … ON DUPLICATE KEY UPDATE (INSERT ODKU), with the columns from the INSERT part of the statement corresponding to the columns in the secondary index, and they were coming in at a rate of approximately 1500 to 2000 per second, sustained, 24h per day. The mathematically-astute among you may already be able to see where this is going.
For purposes of discussion, we can use the following table to illustrate the situation:
CREATE TABLE update_test ( id INT UNSIGNED NOT NULL …[Read more]
Percona is glad to announce the release of Percona Server 5.1.66-14.1 on October 26th, 2012 (Downloads are available here and from the Percona Software Repositories).
Based on MySQL 5.1.66, including all the bug fixes in it, Percona Server 5.1.66-14.1 is now the current stable release in the 5.1 series. All of Percona‘s software is open-source and free, all the details of the release can be found in the 5.1.66-14.1 milestone at Launchpad.
Bugs Fixed:
Percona is glad to announce the release of Percona Server 5.5.28-29.1 on October 26th, 2012 (Downloads are available here and from the Percona Software Repositories).
Based on MySQL 5.5.28, including all the bug fixes in it, Percona Server 5.5.28-29.1 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can be found in the 5.5.28-29.1 milestone at Launchpad.
New Features:
Learn tips and tricks from the database replication and clustering stars:
Future-Proofing MySQL for the World-Wide Data Revolution, by Robert Hodges Why, What, and How of Data Warehouses for MySQL, by Robert Hodges Multi-master. Multi-site MySQL Databases Made Easy with Continuent Tungsten, by Robert Hodges and Giuseppe Maxia MySQL High Availability: Power, Magic and Usability, by Giuseppe
This week was a great catch-up week. There is only one conference
I am doing for the rest of the year, CodeConnexx, though
submissions for conferences in the first quarter of 2013 are
happening, too. We have some great candidates we are interviewing
for our open Database Administrator position.
The database team has gotten a lot of great stuff done this week
(I know, I say that all the time, but it’s true!):
Who is Keyser Soze?
Some recall:
"...a rarely seen, nearly mythical kingpin... Most believe he is
not real, but rather boogeyman story or name-drop to intimidate
people."
Some people think of it as :
"Keyser Soze – DBA or developer who looks ordinary but has
insanely good skills, hardly anybody knows about it."
What does any of this have to do with MySQL ?
Well for this blog post, "Keyser Soze" is the nearly mythical
query that most believe is not real, but rather a "boogeyman sql
query" that wastes resources in a MySQL Database. Typically,
every application has at least one. Your developers blame the
database for being slow and they have caught the ear of the CEO.
It is time to resolve the boogeyman issue and find out. The
difference is we want a better agent than Dave
Kujan, so we have the …
This Log Buffer Edition is once again here, packed with rocking and rolling blogs from the database world. Log Buffer#292 comprises of select few posts from Oracle, MySQL and the SQL Server. Enjoy. Oracle: Pythian’s OCM Andrey Goryunov is attracted and enticed by the silent installation of EM Cloud Control 12c. Bobby Durrett is helping [...]