Thu, 2015-04-09 21:22julienfritsch

When we first announced MariaDB Enterprise last year in March of 2014, our goal was to deliver superior performance and customer experience in addition to a hardened and certified version of open source MariaDB Server. In the first release we delivered hardened and certified binaries, and with the second release in December 2014 we raised the bar in performance. At that time, we announced MariaDB Enterprise for the IBM POWER8 platform, with a 2.2x performance gain over the x86 platform.

Now, with the Spring 2015 release of MariaDB Enterprise, we have optimized the binaries to boost performance, particularly for SaaS and web applications. Our performance benchmarks have shown a 15 to 20% performance gain with these binaries. MariaDB Enterprise customers can download these optimized binaries by logging into our customer …

In April and May, Percona will hold and participate in two OpenStack events: OpenStack Live and the OpenStack Summit. Join our talks at these events in Santa Clara and Vancouver for new insights into the MySQL operations of the core of OpenStack as well as the latest information on MySQL guest instances.

Next week (April 13-14), Percona will host OpenStack Live at the Santa Clara Convention Center. Conveniently located for those in the Bay Area, this two day, user-focused event will cover many core aspects of OpenStack including Nova, Swift, Neutron, and Trove as well as related technologies like Ceph and Docker. (OpenStack Live passes include access to keynotes and the expo hall at the …

You can improve the performance of a MySQL Database by using partitioning, that is assigning specific table rows into subsets of rows. Partitioning can help in many different situations including improving the efficiency of large tables by:

• Breaking data into smaller groups for more efficient queries
• Adhering to file-system file size limits
• Speeding up runtimes for maintenance and deleting rows

To learn much more about partitioning and other key topics, take the very popular MySQL for Database Administrators training course.

You can take this 5-day instructor-led course through the following formats:

• Training-on-Demand: Start training within 24 hours of registration, following lecture material …

Tine to test MySQL Fabric’s High Availability fail over. Last entry I set up a three node Fabric HA farm. This time I am going to ‘pull the plug’ on the servers in the farm and see if Fabric will sense the loss of the server and gracefully keep working.

To sum up the setup, I am using a laptop as the Fabric Controller and three virtual servers for the farm. The virtual servers are Vagrant instancesMySQL Fabric HA Diagram — Nice illustration of tested environment creatively named db1 at 10.10.13.10, db2 at 10.10.13.20, and db3 at 10.10.13.30. All the MySQL instances are 5.6.23 and the MySQL Utilities are 1.6.1-alpha. See the last blog entry for details.

The MySQL Fabric HA farm has been started.
mysqlfabric group lookup_servers …

We would like to inform you about upcoming MySQL User Group Meetup, Hyderabad on April 10, 2015.

There will be two sessions around MySQL New Features and MySQL Replication, to be presented by MySQL Consultants at Oracle followed by open networking session and snacks!

Details:

• Day: April 10, 2015 
• Time: 2:30 pm – 5:30 pm 
• Place: Oracle India Pvt Ltd, Conf room: 3D007, Cyber Park, Salarpuria, Plot No : 67 Hitech city, Madhapur, Hyderabad – 500081 
• Tel: 040- 67244474 (Oracle reception) 
• Meetup Page

So explore this opportunity to get more knowledge about MySQL and increase your network with other MySQLers.

For registration please send an email to mysql.india.ug@gmail.com (so we can arrange enough snacks …

On Thursday I’ll be hosting a webinar introducing MySQL Cluster and then looking into what’s new in the latest version (MySQL Cluster 7.4) in some more detail. As always the webinar is free but please register here. I’ll be answering on-line Q&A during the presentation.

Even if you can’t join the live webinar, it’s worth registering as you’ll be emailed a link to the replay as soon as it’s available.

Abstract

MySQL Cluster powers the subscriber databases of major communication services providers as well as next generation web, cloud, social and mobile applications. It is designed to deliver:

• Real-time, in-memory performance for both OLTP and analytics workloads …

Last week I hosted a webinar explaining how you can get the best from the NoSQL world while still getting all of the benefits of a proven RDBMS. The webinar replay is now available to view here.

Abstract

There’s a lot of excitement about NoSQL data stores, with the promise of simple access patterns, flexible schemas, scalability, and high availability. The downside comes in the form of losing ACID transactions, consistency, flexible queries, and data integrity checks. What if you could have the best of both worlds? Join this webinar to learn how MySQL Cluster provides simultaneous SQL and native NoSQL access to your data—whether it’s in a simple key-value API (memcached) or REST, JavaScript, …

Back to MySQL Fabric! Travel, conferences, and other work have kept me away for too long. So lets start by setting up a new High Availability MySQL Fabric farm and query it for some data. I started with a new install to make sure I was getting everything covered so that one day I will wrap all this up in a comprehensive ‘cookbook’ style article so that anyone can go from Zero to Fabric Hero.

So the first step was to set up my test system with a fresh install of Ubuntu 14.04. Next was the setup of three ‘guest’ Unbuntu 14.04 virtual servers with Vagrant that will comprise the actual HA farm. Next came the installation of MySQL 5.6.23 from the MySQL Apt Repository on the Fabric Controller and the virtual servers. Next comes the installation of the MySQL Utilities on the Fabric Controller system along with the Python Connector. And this time I went with the MySQL …

Percona is glad to announce the release of Percona XtraBackup 2.2.10 on March 31, 2015. Downloads are available from our download site or Percona Software Repositories.

Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, Percona XtraBackup drives down backup costs while providing unique features for MySQL backups.

Bugs …

Tue, 2015-03-31 14:20juergengiesel

Last week we continued the MariaDB Roadshow in Europe - we visited Paris, Brussels and Amsterdam. We have now completed 5 out of 10 events from this series. The interest in this roadshow is overwhelming - in Amsterdam we even needed to put extra chairs into the room! So far attendees of the 2015 tour especially liked topics around MariaDB MaxScale, security features in MariaDB as well as the MariaDB roadmap session. Michael "Monty" Widenius was among the speakers in Helsinki and Amsterdam. But of course all the other speakers did a great job as well, including the MariaDB products and engineering staff as well as the people from Codership (Galera Cluster 4.0 new features) and IBM (Turbo LAMP stack with Linux on Power and POWER8).

We are now looking forward to the 2nd round of events. We have scheduled for you:

• …