June 19, 2013

Post: Percona XtraDB Cluster Events

Cluster. I will give a talk on San Francisco MySQL Meetup, on March-21: Percona’s new HA solution for MySQL with XtraDB Cluster… PL MySQL Conference Percona XtraDB Cluster: New HA solution. Out book «High Performance MySQL, 3rd edition» has couple pages dedicated to Percona XtraDB Cluster So…

Post: My talks on PL MySQL Conference (+free book inside)

… two talks: Percona XtraDB Cluster: New HA solution. There I will cover XtraDB Cluster features and usage scenarios. MySQL and SSD: usage and… to MySQL, XtraBackup, XtraDB Cluster, etc. More interesting, by the time of conference we will have published our new book: High Performance MySQL: Optimization…

Post: Free ticket to MySQL User Conference on SF Meetup with talk "Percona XtraDB Cluster"

… I will be giving a talk “Percona XtraDB Cluster” on coming San Francisco MySQL Meetup, next Wednesday, March-21, 2012. Along with… + expo hall) to Percona Live MySQL User Conference 2012 and three copies our new book “High Performance MySQL, 3rd edition”. Well, I hope…

Post: Commodity Hardware, Commodity Software and Commodity People

…. Someone could be great MySQL Expert but have no experience with MySQL Cluster, other may be good with MySQL Cluster but have no idea how to write storage engines or optimize for Falcon storage engine. Relatively simple 1000 page book… area MySQL Cluster, which was always best isolated of MySQL source leads the pack – there are bunch of interfaces to talk to MySQL cluster as…

Post: Introducing our Percona Live speakers

…, think about using MySQL to find the top N most important rows per group of rows, distributed across a cluster of servers… things in MySQL — and that’s just for performing this task on a single server, not to mention a cluster of servers… mention that Sphinx’s author Andrew Aksyonoff just published a book on Sphinx with O’Reilly! Congratulations Andrew. It’s in…

Post: High-Performance Click Analysis with MySQL

… What does this have to do with InnoDB?  Data clustering. InnoDB’s primary keys define the physical order rows … that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing ….  I wrote a lot about this in our book, which is linked from the sidebar above. Don’t …

Post: Power of MySQL Storage Engines

…Plus there is Falcon storage engine being developed inside MySQL. All of these storage engines are however similar…they apply pressure on each other and as books says competition leads to customer winning. When …it in simple efficient and innovative way. NDB cluster is yet another example I’d put in …

Comment: Working on "High Performance MySQL, Second Edition", how you can help?

book. I feel the mysql manual doesn’t do a good enough job explaining the pro’s and cons of using various mysql features. Like when does it make sense to use merge tables, partitioning, federated tables, mysql cluster, circular replication and…

Post: Sphinx 0.9.8 is released just in time for OSCON 2008

…. It integrates with MySQL and scripting languages very well, it is simple, it performs well and it is easily clustered, allowing you…. Because of this we included Sphinx chapter in High Performance MySQL book – check out Appendix C. This should be the best printed… to do using Sphinx, compared to 7.5 seconds using MySQL with best covering index (so no temporary table or sorting…

Post: KISS KISS KISS

… super optimistic assumptions application will do just fine with single “cluster” even on the current hardware for several years. Replication Optimization… the availability of the application is only related to the MySQL redundancy for very high quality/high scale applications. I’ve… am I denying all MySQL industry practices (which we also covered in a great depth in our book) ? Not really. I’m…