Buy Percona ServicesBuy Now!

Webinar Thursday July 6, 2017: Security and Encryption in the MySQL World

Latest MySQL Performance Blog posts - July 5, 2017 - 9:25am

Join Percona’s Solutions Engineer, Dimitri Vanoverbeke as he presents Security and Encryption in the MySQL World on Thursday, July 6, 2017, at 7:00 am PDT / 10:00 am EDT (UTC-7).

Register Now

 

MySQL and MariaDB Server provide many new features that help with security and encryption, both of which are extremely important in today’s world. Learn how to use these features, from roles to at-rest-encryption, to increase security. At the end of the webinar, you should understand how to have a securely configured MySQL instance!

Register for the webinar here.

Dimitri Vanoverbeke, Solutions Engineer

At the age of 7, Dimitri received his first computer. Since then, he’s addicted to anything with a digital pulse. Dimitri has been active in IT professionally since 2003, when he took various roles from internal system engineering to consulting. Before joining Percona, Dimitri worked as an open source consultant for a leading open source software consulting firm in Belgium. During his career, Dimitri became familiar with a broad range of open source solutions and with the devops philosophy. When not glued to his computer screen, he enjoys traveling, cultural activities, basketball and the great outdoors.

ProxySQL 1.3.7-1.1.xenial breaks automatic startup

Lastest Forum Posts - July 5, 2017 - 6:46am
Hello,

I just install the upgrade to version 1.3.7-1.1.xenial on my Ubuntu machines. Now the service doesn't start automatically anymore. I tried to fix this by enabling, disabling and removing, readding it with update-rc.d but it didn't help. Also the systemd service doesn't work. To test it I removed the sysvinit scripts and enabled the proxysql service with systemctl.
As a temporary fix I've added a start command to my rc.local.
What's the problem here?

Regards
Ralph

Slow ALTER query when the database engine is InnoDb/xTradb?!

Lastest Forum Posts - July 5, 2017 - 2:36am
I have a table that is in InnoDB engine, quite a simple one with 25000 rows. When I do a simple ALTER, it runs for almost 10 minutes:

mysql> ALTER TABLE `quote_followups_istvan` ADD `customer_ip2` VARCHAR(20) NOT NULL DEFAULT '' AFTER `comment`;
Query OK, 0 rows affected (10 min 52.82 sec)
Records: 0 Duplicates: 0 Warnings: 0

But when I change it's engine to MyISAM, I get this:

mysql> alter table quote_followups_istvan engine="MyISAM";
Query OK, 25053 rows affected (0.56 sec)
Records: 25053 Duplicates: 0 Warnings: 0

mysql> ALTER TABLE `quote_followups_istvan` ADD `customer_ip3` VARCHAR(20) NOT NULL DEFAULT '' AFTER `comment`;
Query OK, 25053 rows affected (0.37 sec)
Records: 25053 Duplicates: 0 Warnings: 0

So 10minutes vs 0.37s....

What amd I missing here?

Edit:
In fact that speciffic ALTER query took a while (obviously), and I'm not sure why. For example, altering the engine was ok, so it's not the ALTER itself that is the issue

Install only qan packages

Lastest Forum Posts - July 4, 2017 - 6:59am
Hi,
i already use prometheus and mysql exporter with percona app plugin for grafana.
I don't want another prometheus shipped with PMM but I want to use qan too, so it is possible to install only QAN part of PMM ? how i can do this?

Thank you everyone

tokumx - opsmanager

Lastest Forum Posts - July 3, 2017 - 11:01pm
hi

im using tokumx (TokuMX mongo shell v2.0.2-mongodb-2.4.10) on AWS EC2 env.
can i use opsmanager docker container (https://docs.opsmanager.mongodb.com/...t/application/) for toku backup, restore, monitoring etc.

thanks.






Webinar Wednesday July 5, 2017: Indexes – What You Need to Know to Get the Most Out of Them

Latest MySQL Performance Blog posts - July 3, 2017 - 10:00am

Join Percona’s Senior Architect, Matthew Boehm, as he presents Indexes – What You Need to Know to Get the Most Out of Them on Wednesday, July 5, 2017 at 8:00 am PDT / 11:00 am EDT (UTC-7).

Register Now

Proper indexing is key to database performance. Find out how MySQL uses indexes for query execution, and then how to come up with an optimal index strategy. In this session, you’ll also learn how to know when you need an index, and also how to get rid of indexes that you don’t need to speed up queries.

Register for the webinar here.

Matthew Boehm, Architect

Matthew joined Percona in the fall of 2012 as a MySQL consultant. He quickly rose to Architect and became one of Percona’s training instructors. His areas of knowledge include the traditional Linux/Apache/MySQL/PHP stack, memcached, MySQL Cluster (NDB), massive sharding topologies, PHP development and a bit of MySQL-C-API development.

Percona XtraDB Cluster Node restart

Lastest Forum Posts - July 3, 2017 - 6:06am
Hi everyone,

I have a question. Sometimes, I have to restart a node. Is it normal that the node then always completely synced the data from the master?

I see that the logs are scanned and then a sync is performed. With a relatively large DB, this may take time.

Thanks for help.

Problem with Percona 5.7 and MHA 0.57

Lastest Forum Posts - July 3, 2017 - 4:38am
Hello, I've been having problems with Percona 5.7 (Server version: 5.7.18-15-log Percona Server (GPL), Release '15', Revision 'bff2cd9') and MHA 0.57. I setup MHA and everything looks right, but when I start the MHA Manager, I get connection errors:

root@db-perc-02:~# masterha_check_repl --conf=/etc/mha/app1.cnf
[...]
MySQL Replication Health is OK.

root@db-perc-02:~# masterha_manager --conf=/etc/mha/app1.cnf
[...]
Tue Jun 27 16:15:17 2017 - [info] Starting ping health check on db-perc-01.antevenio.local(172.16.11.225:3306)..
Tue Jun 27 16:15:17 2017 - [info] Ping(SELECT) succeeded, waiting until MySQL doesn't respond..
Tue Jun 27 16:15:22 2017 - [warning] Got error on MySQL select ping: 2013 (Lost connection to MySQL server during query)
Tue Jun 27 16:15:22 2017 - [info] Executing SSH check script: exit 0
Tue Jun 27 16:15:22 2017 - [info] HealthCheck: SSH to db-perc-01.antevenio.local is reachable.
Tue Jun 27 16:15:27 2017 - [info] Ping(SELECT) succeeded, waiting until MySQL doesn't respond..
Tue Jun 27 16:15:32 2017 - [warning] Got error on MySQL select ping: 2013 (Lost connection to MySQL server during query)
Tue Jun 27 16:15:32 2017 - [info] Executing SSH check script: exit 0
Tue Jun 27 16:15:32 2017 - [info] HealthCheck: SSH to db-perc-01.antevenio.local is reachable.
Tue Jun 27 16:15:37 2017 - [info] Ping(SELECT) succeeded, waiting until MySQL doesn't respond..
Tue Jun 27 16:15:42 2017 - [warning] Got error on MySQL select ping: 2013 (Lost connection to MySQL server during query)
Tue Jun 27 16:15:42 2017 - [info] Executing SSH check script: exit 0

So it loses the connection to the other server, but the ping is ok. On the other server there are some errors:
2017-06-27T14:16:22.598621Z 16 [Note] Aborted connection 16 to db: 'unconnected' user: 'mhauser' host: '172.16.11.226' (Got an error reading communication packets)
2017-06-27T14:16:32.599012Z 17 [Note] Aborted connection 17 to db: 'unconnected' user: 'mhauser' host: '172.16.11.226' (Got an error reading communication packets)
2017-06-27T14:16:42.599332Z 18 [Note] Aborted connection 18 to db: 'unconnected' user: 'mhauser' host: '172.16.11.226' (Got an error reading communication packets)
2017-06-27T14:16:52.599987Z 19 [Note] Aborted connection 19 to db: 'unconnected' user: 'mhauser' host: '172.16.11.226' (Got an error reading communication packets)
2017-06-27T14:17:02.601149Z 20 [Note] Aborted connection 20 to db: 'unconnected' user: 'mhauser' host: '172.16.11.226' (Got an error reading communication packets)
2017-06-27T14:17:12.601341Z 21 [Note] Aborted connection 21 to db: 'unconnected' user: 'mhauser' host: '172.16.11.226' (Got an error reading communication packets)
[...]

But the strange thing is that if I just change Percona server, for MySQL Server 5.7 and run the exact same configuration, MHA works perfectly. Any ideas?

Regards


Industry Recognition of Percona: Great Products, Great Team

Latest MySQL Performance Blog posts - June 30, 2017 - 3:07pm

Percona’s focus on customer success pushes us to deliver the very best products, services and support. Three recent industry awards reflect our continued success in achieving these goals.

We recently garnered a Bronze Stevie Award “Company of the Year – Computer Software – Medium.” Stevies are some of the most coveted awards in the tech industry. Each year, more than 10,000 organizations in more than 60 nations compete for Stevies. It’s a huge honor to come away with a win.

Percona was also included in Database Trends and Applications’ (DBTA) annual DBTA 100 list of the companies that matter most in data. The directory was compiled by the editorial staff of DBTA and spotlights the companies that deal with evolving market demands through innovation in software, services, and hardware.

Zippia, a new website dedicated to helping recent grads with their career choices, ranked Percona in the top 10 of the “20 Best Companies To Work For In Raleigh, NC.” To compile the ranking, Zippia chose companies in a 25-mile radius that consistently get high reviews from career resource websites.  

Finally, Percona co-founder and CEO Peter Zaitsev was honored as one of the Top Rated CEOs in Raleigh, North Carolina, by Owler. Owler looked at 167,000 leaders across 50 cities and 25 industries worldwide and identified the top 1,000. This is a huge honor for Peter!

Driven by Peter’s vision, all of us at Percona remain committed to building an excellent organization that is the champion of unbiased open source database solutions. Our continued success, growth and recognition from organizations like the above lead us to believe that the best is yet to come. Stay tuned!

How Does Percona Software Compare: the Value of Percona Software and Services

Latest MySQL Performance Blog posts - June 29, 2017 - 3:22pm

In this blog post, I’ll discuss my experience as a Solutions Engineer in explaining the value of Percona software and services to customers.

The inspiration for this blog post was a recent conversation with a prospective client. They were exploring open source software solutions and professional services for the first time. This is a fairly common and recurring conversation with individuals and enterprises exploring open source for the first time. They generally find Percona through recommendations from colleagues, or organic Google searches. One of the most common questions Percona gets when engaging at this level is, “How does Percona’s software compare with << Insert Closed-source Enterprise DB Here >>?”

We’re glad you asked. Percona’s position on this question is to explain the value of Percona in the open source space. Percona does not push a particular flavor of open source software. We recommend an appropriate solution given each of our client’s unique business and application requirements. A client coming from this space is likely to have a lengthy list of compliance, performance and scalability requirements. We love these conversations. Our focus is always on providing our customers with the best services, support, and open-source technology solutions possible.

If there were a silver bullet for every database, Percona would not have been as successful over the past 10 (almost 11!) years. We know that MongoDB, MariaDB, MySQL Enterprise, MySQL Community, Percona Server for MySQL, etc., is never the right answer 100% of the time. Our competitors in this space will most likely disagree with this assessment – because they have an incentive to sell their own software. The quality of all of these offerings is extremely high, and our customers use each of them to great success. Using the wrong database software for a particular use-case is like using a butter knife to cut a steak. You can probably make it work, but it will be a frustrating and unrewarding experience.

Usually, there are more efficient alternatives.

There is a better question to ask instead of software vs. software, which basically turns into an apples vs. oranges conversation. It’s: “Why should we partner with Percona as our business adopts more open-source software?” This is where Percona’s experience and expertise in the open-source database space shine.

Percona is invested in ensuring you are making the right decisions based on your needs. Choosing the wrong database solution or architecture can be catastrophic. A recent Ponemon study (https://planetaklimata.com.ua/instr/Liebert_Hiross/Cost_of_Data_Center_Outages_2016_Eng.pdf) estimates the average cost of downtime can be up to $8,800 per minute. Not only is downtime costly, but re-architecting your environment due to an errant choice in database solutions can be costly as well. Uber experienced these pains when using Postgres as their database solution and wrote an interesting blog post about their decision to switch back to MySQL (https://eng.uber.com/mysql-migration/). Postgres has, in turn, responded to Uber recently (http://thebuild.com/presentations/uber-perconalive-2017.pdf). The point of bringing up this high-profile switch is not to take sides, but to highlight the breadth of knowledge necessary to navigate the open source database environment. Given its complexity, the necessity of a trusted business partner with unbiased recommendations should be apparent.

This is where Percona’s experience and expertise in the open source database space shines. Percona’s only investors are its customers, and our only customers are those using our services. Because of this, our core values are intertwined with customer success and satisfaction. This strategy trickles down through support, to professional services and all the way to the engineering team, where efforts are focused on developing software and features that provide the most value to customers as a whole.

Focusing on a business partner in the open source space is a much more important and worthwhile effort than focusing on a software provider. Percona has hands-on, practical experience with a varying array of open-source technologies in the MySQL, MariaDB, and MongoDB ecosystems. We’ve tracked our ability to assist our customer’s efficiencies in their databases and see a 30% efficiency improvement on average with some cases seeing a 10x boost in performance of their database. (https://www.percona.com/blog/2016/07/20/value-database-support/). The open source software itself has proven itself time and again to be the choice of billion dollar industries. Again, there is not one universal choice among companies. There are success stories that run the gamut of open source software solutions.

To summarize, there’s a reason we redirect the software vs. software question. It’s not because we don’t like talking about how great our software is (it is great, and holds it own with other open source offerings). It’s because the question does not highlight Percona’s value. Percona doesn’t profit from its software. Supporting the open-source ecosystem is our goal. We are heavily invested in providing our customers with the right open source software solution for their situation regardless of whether it is ours or not. Our experience and expertise in this space make us the ideal partner for businesses adopting more open source technology in place of enterprise-licensed models.

Percona replication controlled by Pacemaker

Lastest Forum Posts - June 29, 2017 - 5:41am
rpm -qa | grep -i pacemaker
percona-pacemaker-agent-1.0.0-1.x86_64
pacemaker-libs-1.1.15-11.el7.x86_64
pacemaker-cluster-libs-1.1.15-11.el7.x86_64
pacemaker-cli-1.1.15-11.el7.x86_64
pacemaker-1.1.15-11.el7.x86_64

rpm -qa | grep -i corosync
corosync-2.4.0-4.el7.x86_64
corosynclib-2.4.0-4.el7.x86_64

rpm -qa | grep -i percona
percona-pacemaker-agent-1.0.0-1.x86_64
Percona-Server-client-56-5.6.36-rel82.0.el7.x86_64
Percona-Server-shared-56-5.6.36-rel82.0.el7.x86_64
percona-xtrabackup-2.3.8-1.el7.x86_64
Percona-Server-server-56-5.6.36-rel82.0.el7.x86_64

uname -r
3.10.0-514.10.2.el7.x86_64

2 node Pacemaker cluster Master, Slave setup with STONITH enabled.
Apache resource - Web service
DRBD resource - Magento flat files for web service
MySQL resource - Database with replication

Failover happens as it should between the servers. But we recently had an
incident where database replication had broken and then the Master node
failed over to the Slave (loss of data).

I have found a setting in the cib for
<nvpair id="p_mysql-instance_attributes-max_slave_lag" name="max_slave_lag" value="60"/>
<nvpair id="p_mysql-instance_attributes-evict_outdated_slaves" name="evict_outdated_slaves" value="false"/>

If I set this to "true" then it works as intended and won't fail over to
the Slave if the Slave replication falls 60 seconds behind the Master.
However if I then need to rebuild the Slave from a backup of the Master, I
will have to set the time so that I am able to rebuild the Slave before it
fails due to the "max_slave_lag" value.

Does someone know of a better way of performing this? We need to perform
patching on a monthly basis, so require failing over in the pacemaker
cluster from Master to Slave.

Percona XtraDB Cluster

Lastest Forum Posts - June 29, 2017 - 1:49am
Hello, sorry for my English, there is such a problem, I configured Percona XtraDB Cluster on 3 servers, everything is working fine now, but how do I look at the time delay of the slave from the master? If I'm watching now Code: mysql -e "show slave status\G" then I get nothing from this documentation https://www.percona.com/blog/2014/05/02/how-to-identify-and-cure-mysql-replication-slave-lag/ swears at Code: Detected value is empty; something failed? Trigger exit status: 0 Seconds_Behind_Master parameter is not defined.
How can I see the delay?
Visit Percona Store


General Inquiries

For general inquiries, please send us your question and someone will contact you.