by Stephane Combaudon | Oct 21, 2013 | MySQL, Webinars
On Wednesday I’ll be leading a webinar exploring MySQL 5.6’s new replication features. And yes, as usual I’ll deliver news on the good, the bad and the ugly (that is to say the benefits, limitations and challenges). The webinar, appropriately titled, “New...
by Alexander Rubin | Oct 21, 2013 | MySQL
Geo-enabled (or location-enabled) applications are very common nowadays and many of them use MySQL spatial functions. The common tasks for such applications are: Find all points of interests (i.e. coffee shops) around (i.e. a 10-mile radius) the given location...
by Przemysław Malkowski | Oct 14, 2013 | Insight for DBAs, MySQL, Percona Services
GUI monitoring tools for MySQL are not always suitable for all our needs or situations. Most of them are designed to provide historical views into what happens to our database over time rather then real-time insight into current MySQL server status. Excellent free...
by Peter Zaitsev | Sep 24, 2013 | Insight for DBAs, MySQL, Webinars
This Wednesday in our next webinar I’ll share how to configure a better-performing MySQL 5.6 server. You’ll lean a practical approach to generating a sensible configuration file that sets what is needed and omits what is not. Why dedicate an entire webinar...
by Stephane Combaudon | Sep 13, 2013 | Insight for DBAs, MySQL
Being able to configure slaves to be crash-safe is one of the major improvements of MySQL 5.6 with regards to replication. However we noticed confusion on how to enable this feature correctly, so let’s clarify how it should be done. In short 1. Stop MySQL on...
by Aurimas Mikalauskas | Sep 5, 2013 | MySQL
MySQL 5.6 has a great many new features, including, but certainly not limited to a number of performance improvements. However, besides the widely talked-about features such as InnoDB support for full text search, optimizer, performance schema improvements and GTID,...
by Ryan Lowe | Sep 4, 2013 | Cloud, MySQL, Webinars
Thanks to everyone who attended last week’s webinar, Q: Would you recommend Amazon RDS over manually setting up MySQL/Percona server on an EC2 instance? A: This depends on many factors including your data set size, workload, uptime requirements, what the rest of your...
by Ryan Lowe | Aug 21, 2013 | Cloud, MySQL, Webinars
One longstanding complaint I have heard for the past several years, and still hear today, is that Amazon’s Relational Database Service (RDS) does not allow the configuration flexibility as running MySQL in an ec2 instance. While true, this ignores the consistent...
by Peter Zaitsev | Aug 17, 2013 | MySQL
MySQL 5.6 surely changes the game when it comes to security vs ease of use. Before MySQL 5.6 we would get default MySQL installation being pretty insecure – the user “root” will be created with no password as well as anonymous user with limited...
by Jay Janssen | Aug 16, 2013 | Insight for DBAs, MySQL, Webinars
My colleague and teammate Ernie Souhrada will be presenting a webinar on Wednesday, August 21, 2013 at 10 a.m. PDT titled “MySQL Security: Armoring Your Dolphin.” This is a popular topic with news breaking routinely that yet another Internet company has...
by Stewart Smith | Aug 7, 2013 | MySQL, Webinars
Good news everyone! I recently presented a webinar: Percona Server 5.6: Enterprise Grade MySQL. It was also recorded so you can watch along or view the slide deck. As with all my talks, I am not simply reading the slides so it really is worth to listen to the audio...
by Ernie Souhrada | Jul 31, 2013 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
This is part 3 of a 3 part series covering the new InnoDB full-text search features in MySQL 5.6. To catch up on the previous parts, see part 1 or part 2 Some of you may recall a few months ago that I promised a third part in my InnoDB full-text search (FTS) series,...
by Stewart Smith | Jul 30, 2013 | Hardware and Storage, Insight for DBAs, MySQL, Percona Events, Percona Software, Webinars
The new Percona Server 5.6 is the most manageable, highest performance, and most scalable version of MySQL available. Percona Server 5.6 is the best open source MySQL choice for enterprise-grade applications because it combines new features with the best features of...
by Aleksandr Kuzminsky | Jul 16, 2013 | Insight for DBAs, MySQL
MySQL 5.6 introduces a new feature – microseconds resolution in some temporal types. As of 5.6.4 TIME, TIMESTAMP and DATETIME can have a fractional part. To create a field with subseconds you can specify precision in brackets: TIME(3), DATETIME(6) etc....
by Przemysław Malkowski | Jul 5, 2013 | Insight for DBAs, MySQL
Among many of the improvements you can enjoy in MySQL 5.6, there is one that addresses a huge operational problem that most DBAs and System Administrators encounter in their life: schema changes. While it is usually not a problem for small tables or those in early...
by Jaime Crespo | May 31, 2013 | Insight for DBAs, MySQL, Percona Software
Here at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer...
by Stephane Combaudon | May 21, 2013 | MySQL
Global Transactions Identifiers are one of the new features regarding replication in MySQL 5.6. They open up a lot of opportunities to make the life of DBAs much easier when having to maintain servers under a specific replication topology. However you should keep in...
by Peter Zaitsev | May 13, 2013 | MySQL, Webinars
This Wednesday, May 15 at 10 a.m. Pacific, I’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In this Webinar I will offer an overview of Performance Schema, focusing on new features...
by David Hildebrandt | Apr 12, 2013 | MySQL, Percona Events
If you are looking for a class that is designed to jump-start your knowledge on MySQL 5.6 features, a class that provides hands-on labs, and a class that shows various migration methods – look no further. We have been hard at work building a new class to ensure...
by Mike Benshoof | Mar 29, 2013 | MySQL
A common practice to offload traffic from MySQL 5.6 is to use a caching layer to store expensive result sets or objects. Some typical use cases include: Complicated query result set (search results, recent users, recent posts, etc) Full page output (relatively static...
