I will be presenting at Percona Live 2014 and I’m excited to share and discuss the latest and greatest features and improvements that we have made to MySQL/InnoDB in 5.7. Great performance improvements, there are some new exciting compression features that we are working on,  GIS support,  temporary table performance etc.. There is a long list. Also, we are always interested to hear about user issues and priorities so that we can address them and/or work them into our plan. Your feedback is very important for us, if you want to influence the direction of InnoDB development then you need to talk to me .

Why this article

The more I have to interact with customers asking about MySQL/Galera, the most I have to answer over and over to the same question about what kind of network conditions Galera can manage efficiently.

One of the most frequent myths I have to cover at the start of any conversation that involve the network is PING.

Most of the customers use PING to validate the generic network conditions, and as direct consequence they apply that approach also when in need to have information on more complex and heavy use like in the Galera replication.

To have a better understanding why I consider the use of PING, not wrong but inefficient, let us review some basic networking concepts.

Frame

At the beginning stay the physical layer, but I am going to skip it otherwise article will be too long, what I want only to say is that unless you are able to afford a leased line to …

I will be speaking about High Performance Rails with MySQL on RubyConfPH. If you use Ruby on Rails with MySQL and in Manila on March 28-29, you should register for the event!

Background

Eventual consistency is a consistency model used in many large distributed databases which requires that all changes to a replicated piece of data eventually reach all affected replicas; conflict resolution is not handled and responsibility is pushed up to the application author in the event of conflicting updates [13].

Eventual consistency is a specific form of weak consistency; the storage system guarantees that if no new updates are made to the object, eventually all accesses will return the last updated value [14]. If no failures occur, the maximum size of the inconsistency window can be determined based on factors such as communication delays, the load on the system, and the number of replicas involved in the replication scheme [3].

A few examples of eventually consistent systems:

• DNS
• Asynchronous master/slave replication on an RDBMS e.g. MariaDB
• memcached in front …

While installing mysql-workbench-community-6.0.9 on Ubuntu 13.04 if you get below error.

root@Dell-XPS:/home/nilnandan/Downloads# dpkg -i mysql-workbench-community-6.0.9-1ubu1204-amd64.deb
Selecting previously unselected package mysql-workbench-community.
(Reading database … 203112 files and directories currently installed.)
Unpacking mysql-workbench-community (from mysql-workbench-community-6.0.9-1ubu1204-amd64.deb) …
dpkg: dependency problems prevent configuration of mysql-workbench-community:
 mysql-workbench-community depends on libctemplate0; however:
  Package libctemplate0 is not installed.
 mysql-workbench-community depends on libgtkmm-2.4-1c2a (>= 1:2.24.0); however:
  Package libgtkmm-2.4-1c2a is not installed.
…

Percona is glad to announce the release of Percona Monitoring Plugins 1.1.3.

Changelog:

* Introduced more secure location of PHP script configs to harden a Cacti setup
* Addressed CVE-2014-2569

We have introduced a more secure location /etc/cacti/ for PHP script configs. Earlier, the only way was to keep .php.cnf configs inside of scripts/ folder which falls under the web directory of Cacti setup, thus provides a potential security vulnerability. We strongly recommend to move all .php.cnf files from /usr/share/cacti/scripts/ to /etc/cacti/ and also harden your Cacti setup.

A new tarball is available from …

Percona Toolkit has a great tool, pt-query-digest, that can use tcpdump data. Capturing raw tcp data can be taxing on a server, however, when you see the following message:

64000 packets received by filter
12000 packets dropped by kernel

When there is a significant amount of user cpu% being used, the kernel will drop packets you are trying to capture, leading to a partial picture and missing data. I’ve found that if you write it using the native tcpdump format, it’s more efficient and you drop less. There are also recommendations on Stack Overflow on how to help prevent this.

To perform a capture for a specific length of time, here’s the trick I …

The MySQL 5.6 certification exams (Developer and DBA) are now GA!  A big thanks to all those who sat for the extended length beta exams – and subsequently waited for several months for your results.  Your feedback and the data collected from many beta testers helped ensure the final exams are high quality. A huge thanks also goes to the MySQL staff at Oracle who produced, edited and verified exam questions, in addition to their normal job responsibilities.  In particular, these exams would have never materialized …

March 20, 2014 By Severalnines

SugarCRM is the leader in open source CRM systems, and has been adopted by some of the largest firms, including IBM. The CRM software includes all sales, marketing and support tools out of the box, and can also be extended to integrate social media sources. For those depending on SugarCRM, especially when deploying in cloud environments with lower SLAs, having a high availability architecture can make a lot of sense. 

In this blog post, we will show you how to cluster SugarCRM Community Edition with MySQL Galera Cluster. For simplicity, we will use NFS as the shared storage system (storage1) but keep in mind that storage1 is a single point of failure. Have a look at our previous blogs on how to deploy other shared file systems like …

Buongiorno is known in the worldwide mobile ecosystem for developing and managing paid applications and content that help consumers get greater enjoyment from their mobile devices.

Buongiorno’s strategic goal is to deliver directly to consumers around the world a broad portfolio of content & services on all their personal devices, exploiting social and location based propositions, and letting telecom operators be in control of the billing. With direct connections to more than 130 telecom operators in 25 countries, over 10 years’ experience and a team of 600 professionals, Buongiorno makes the mobile internet experience happen for consumers globally. Buongiorno’s web apps brands include Gamifive, MuchGossip, Fingerbooks, Appsfuel HTML5 Marketplace, Winga, Play.me and the mobile payments solution Cashlog.

…