by Baron Schwartz | Nov 1, 2010 | MySQL, Percona Events
There’s an interview with Baron Schwartz (that’s me) on WebPulp.tv. Topics include the history of Percona’s software such as Percona Server (our version of the MySQL database server) and XtraBackup, what we do at Percona, what tools we use to do it,...
by Fred Linhoss | Oct 28, 2010 | MySQL, Percona Software
Percona Community, Percona Server version 5.1.51-rel11.5 is now available for download. The main purpose of this release is to update the current Percona stable release to the latest version of MySQL 5.1. Functionality Added or Changed  Percona Server 5.1.51-rel11.5...
by Baron Schwartz | Oct 27, 2010 | Insight for Developers, MySQL
This is the third in a series on what’s seriously limiting MySQL in core use cases (links: part 1, 2, 3). This post is about the way MySQL handles connections, allocating one thread per connection to the server. MySQL Limitations: Connections MySQL is a single...
by Morgan Tocker | Oct 26, 2010 | Benchmarks, Insight for Developers, MySQL
A couple of weeks ago I blogged about Sharing an auto_increment value across multiple MySQL tables. In the comments, a few people wrote in to suggest alternative ways of implementing this. I just got around to benchmarking those alternatives today across two large...
by Baron Schwartz | Oct 25, 2010 | Insight for Developers, MySQL
This is the third in a series on what’s seriously limiting MySQL in certain circumstances (links: part 1, 2). This post is about subqueries, which in some cases execute outside-in instead of inside-out as users expect. It’s easy to pick on subqueries in MySQL,...
by Yves Trudeau | Oct 25, 2010 | Benchmarks, MySQL
The parameter sort_buffer_size is one the MySQL parameters that is far from obvious to adjust. It is a per session buffer that is allocated every time it is needed. The problem with the sort buffer comes from the way Linux allocates memory. Monty Taylor (here) have...
by Baron Schwartz | Oct 23, 2010 | Insight for Developers, MySQL
This is the second in a series on what’s seriously limiting MySQL in certain circumstances (links: part 1). In the first part, I wrote about single-threaded replication. Upstream from the replicas is the primary, which enables replication by writing a so-called...
by Yves Trudeau | Oct 22, 2010 | Cloud, Insight for DBAs, MySQL
This post is the fifth of a series that started here. From the previous posts of this series, we now have an instance restart script that can restart the database node in case of failure and automatically reconfigure Pacemaker and the other servers that needs to...
by Baron Schwartz | Oct 21, 2010 | MySQL, Percona Events
We’ve published our first case study. The customer, ideeli, had a database that was struggling on standard MySQL and InnoDB. The big win was the upgrade to XtraDB. The business continued to grow quickly, and months later under much more traffic, the database is...
by Baron Schwartz | Oct 20, 2010 | Percona Events
I’ve just added two categories to our forum, so you can post your job listings if you’re looking for someone to help you, and you can post your qualifications if you are available for hire.
by Baron Schwartz | Oct 20, 2010 | Insight for Developers, MySQL
I recently mentioned a few of the big “non-starter” limitations Postgres has overcome for specific use cases. I decided to write a series of blog posts on MySQL’s unsolved severe limitations. I mean limitations that really hobble it for major,...
by Peter Zaitsev | Oct 15, 2010 | Insight for DBAs, MySQL
Some Applications need to store some transient data which is frequently regenerated and MEMORY table look like a very good match for this sort of tasks. Unfortunately this will bite when you will be looking to add Replication to your environment as MEMORY tables do...
by Fred Linhoss | Oct 14, 2010 | MySQL, Percona Software
Dear Community, Percona Server version 5.1.50-rel12.1 RC is now available for download. Functionality Added or Changed Percona Server 5.1.50-rel12.1 is now based on MySQL 5.1.50. New Features Added: innodb_lru_dump_restore – Implemented automatic dumping of the...
by Baron Schwartz | Oct 11, 2010 | MySQL, Percona Events
Vadim and I have just published a new technical white paper. It shows how Percona Server with XtraDB can make large-scale multi-tenant databases easier to build with MySQL. Our experiences working with SaaS and shared-hosting companies influenced the features we...
by Peter Zaitsev | Oct 8, 2010 | Insight for DBAs, MySQL
I recently worked on upgrading MySQL from one of very early MySQL 5.0 versions to Percona Server 5.1. This was a classical upgrade scenario which can cause surprises. Master and few slaves need to be upgraded. It is a shared database used by tons of applications...
by Morgan Tocker | Oct 6, 2010 | MySQL, Percona Events
My colleague Aleksandr Kuzminsky will be speaking at WebConf Riga 2010 next month on XtraBackup: Hot Backups and More and Recovery of Lost or Corrupted InnoDB Tables. WebConf is the first big conference of its kind in the Baltic states (Estonia, Latvia, Lithuania) and...
by Baron Schwartz | Oct 5, 2010 | MySQL, Percona Events
We’ve just announced a new support offering for MySQL. There’s a press release here, and product information page here. But what does this new service really mean for you, in practical terms? This is actually important — it will open up a range of...
by Peter Zaitsev | Oct 5, 2010 | MySQL, Percona Events
I have my schedule pretty busy during a trip to Russia this year. In addition to giving a master class and Sphinx Conference I’m going to speak at HighLoad++. I’ll also have a user meeting presentations in Samara on October 17 and Minsk on October 22 This...
by Morgan Tocker | Oct 4, 2010 | Benchmarks, Insight for Developers, MySQL
The title is SEO bait – you can’t do it. We’ve seen a few recurring patterns trying to achieve similar – and I thought I would share with you my favorite two: Option #1: Use a table to insert into, and grab the insert_id: CREATE TABLE option1...
by Vadim Tkachenko | Sep 29, 2010 | Benchmarks, MySQL
We now have hardware in our test lab that represents the next generation of commodity servers for databases. It’s a Cisco UCS C250 server, powered by two Intel Westmere CPUs (X5670 @ 2.93GHz). Each CPU has 6 cores and 12 threads. The most amazing part is the...
