I personally like PCIe based Flash, but from a pricing point our customers are looking for cheaper alternatives. SATA SSD is an options. There is many products based on MLC technology, and Intel 320 I would say is the most popular. I do not particularly like its write performance – I wrote about it before, that’s why I am looking for comparable alternatives. Samsung 830 256GB looked like a good product, that’s why I decided to test it.
I don’t think there is a single good-quality MySQL init script for a Unix-like operating system. On Windows, there is the service facility, and I used to write Windows services. Based on that, I believe Windows has a pretty good claim to better reliability for start/stop services with MySQL.
What’s wrong with the init scripts? Well, let me count the reasons! Wait, I’m out of fingers and toes.
Working on customer case today I ran into interesting problem – query joining about 20 tables (thank you ORM by joining all tables connected with foreign keys just in case) which would take 5 seconds even though in the read less than 1000 rows and doing it completely in memory. The plan optimizer picked was very good one, yet you could notice EXPLAIN itself was taking same 5 seconds, which points to problem with optimizer performance. Note though if you have subqueries these might need to be executed during EXPLAIN phase yet making it unusable to check the optimizer performance.
We are running internally a lot of benchmarks on our recently announced Percona XtraDB Cluster, and I am going to publish these results soon.
But before that I wanted to mention that proper benchmark of distributed system comes with a lot of challenges.
I am saying that not to complain, but to make sure, if you are going to benchmark XtraDB Cluster yourself, there is a lot of things to take into account.
Collaborate is in Las Vegas next and the MySQL Community Team will be there promoting MySQL. Keith Larson and I are presenting two sessions on MySQL for Oracle DBAs or How to Speak MySQL for Beginners. More and more Oracle DBAs are discovering MySQL among their corporate infrastructure and need a little guidance to walk them through some of the differences between Oracle 11g and MySQL. Several years ago, the IOUG said 70% of their members use MySQL and it should be much higher by now.
The slides and accompanying document of the High availability deep dive tutorial have all been uploaded and can be downloaded from the link below:
For the slides, you’ll find a PDF and a pptx version, the gdocs animations works somewhat OK with pptx. Also, the VMs will stay available from a at least few months from here:
Xen and VMWare: http://ubuntuone.com/3nikxumH483slq8rfP73iZ
Percona has 2 talks lined up at OSDC in Nuremberg, Germany:
- Taking hot backups with XtraBackup by Alexey Kopytov
- Expert Troubleshooting: Resolving MySQL Problems Quickly by Kenny Gryp
Feel free to come and say Hi!