I recent visit with old Brisbane friend HiTCHO which I met at the Brisbane MySQL Users Group in 2005, has lead to this cool list of some hardware and software technologies he used that I am now considering or have already implemented or purchased.
Software
Early on in the MySQL 5.4 development we tried out the
impact of the Google SMP patch and the Google IO patch.
At first we wanted to see which of the patches that
made most of an impact. The Google patches in MySQL 5.4
have 3 components at least that impact the performance.
1) Replace InnoDB memory manager by a malloc variant
2) Replace InnoDB RW-lock implementation
3) Make InnoDB use more IO threads
When disabling the InnoDB one opens up for a whole array
of potential candidates for malloc. Our work concluded
that tcmalloc behaved best on Linux and mtmalloc was
best on Solaris, see blog posts on Solaris below.
Malloc on Solaris investigation
Battle of the …
This alliance is an excellent step, showing the maturity, breadth and depth of expertise for MySQL related services! Of course Open Query is an active early member, with our training and subscription services, and initiatives like the OurDelta builds project.
Kudos to MontyW and PeterZ for driving this further while at the MySQL Conference last month.
This is about the ending of the sponsorship of the mysql.meetup.com user groups by Sun/MySQL and their suggested move to Facebook.
If people want to move to Facebook, that’s fine. For those who want to stay but don’t have the local funding, I have an offer for you. Contact Open Query, and we’ll sponsor your group for the coming months. This is not open-ended, I think a more permanent solution is important (moving, sponsorship, whatever) but I want to make the effort for the community to prevent any groups from disappearing now just because of this.
I was the one who originally set up the agreement with meetup.com when they first started charging for meetups (and it turned out to be a very good business model for them!). When that change was announced, quite a few meetup organisers were going to quit. The …
[Read more]
Monty Program
Ab and Percona today launched the Open Database
Alliance.
You can find the press release about it here.
This may be one of the most important steps in the history of
MySQL and MariaDB.
Here follows my initial vision of the Open Database Alliance.
Note that things may change slightly when we start defining the
rules of the Alliance together with the Alliance members!
The Alliance will be a center and provide infrastructure for
companies and individuals to develop, collaborate and do business
around open source databases with MariaDB/MySQL as our initial …
Hi all,
Today I'll be write more about my experiences with Amazon Web Services. Before I continue, I'd like to provide some background information.
I signed up for Amazon Web Services. I used the Fedora LAMP AMI to create a server instance. The main reason for choosing this AMI was its inclusion of MySQL and Apache, a nice little package indeed. I ran into a few problems at first. Because I am based in Europe, I am allowed to use only the EU-West region, and the default in the US-East region. The drop down list is rather small, and i took a couple of unsuccessful instances to figure out that this was the problem. When I say "unsuccessful instances," I mean that the nothing appeared in the browser when I copied the public DNS to the browser's address bar. I attached an EBS volume to the server instance and it was OK.
Now for more on the command line.
I spent a lot of time messing around with the commands in the …
[Read more]Hi all,
Today I'll be write more about my experiences with Amazon Web Services. Before I continue, I'd like to provide some background information.
I signed up for Amazon Web Services. I used the Fedora LAMP AMI to create a server instance. The main reason for choosing this AMI was its inclusion of MySQL and Apache, a nice little package indeed. I ran into a few problems at first. Because I am based in Europe, I am allowed to use only the EU-West region, and the default in the US-East region. The drop down list is rather small, and i took a couple of unsuccessful instances to figure out that this was the problem. When I say "unsuccessful instances," I mean that the nothing appeared in the browser when I copied the public DNS to the browser's address bar. I attached an EBS volume to the server instance and it was OK.
Now for more on the command line.
I spent a lot of time messing around with the commands in the …
[Read more]By popular demand, we are now offering an on-line incarnation of our DRBD Total training sessions, normally taught in a 4-day on-site course. The next such training commences on May 18 (next Monday), and we still have a few seats left — so if you’re interested, grab one while you still can!
What’s covered in this course?
Here is an overview of the course highlights:
Every course attendee gets a virtual cluster to play with and practice on. It doesn’t get much more hands-on than this.
…[Read more]Last week we were busy to align XtraDB performance with 5.4, now we have some results. Currently it is available as "hacks" to XtraDB (available on Lauchpad lp:~percona-dev/percona-xtradb/hacks-porting-tune if you are interested). Basically we took improvements from 5.4 and backported ones performance related to XtraDB.
Here are results for tpcc-like workload, 100W (~10GB) ( raw
results and parameters are available here
http://spreadsheets.google.com/ccc?key=rxUEhM2dqbX0uAfq9j6WQ_w
). Box Dell PowerEdge R900 (Does Dell have referral program ? ),
with RAID10 (8 disks) on ext3, 32GB of RAM.
As you see there almost no difference and you may say what's the reason in XtraDB ? The most interesting reason is XtraDB based on InnoDB-plugin and contains its nice features like FAST INDEX CREATION and dynamic pages. And XtraDB has some …
[Read more]Well, it took us a little while (we’ve been busy !), but we’ve now posted our presentations on InnoDB from the MySQL Conference and Expo 2009. You can download these presentations by Heikki Tuuri, Ken Jacobs and Calvin Sun from the InnoDB website, as follows: