Buy Percona ServicesBuy Now!

InnoDB Cluster in a Nutshell Part 3: MySQL Shell

 | July 20, 2018 |  Posted In: High-availability, InnoDB, Insight for DBAs, Insight for Developers, JSON, MySQL

MySQL InnoDB Cluster MySQL Shell

Welcome to the third part of this series. I’m glad you’re still reading, as hopefully this means you find this subject interesting at least. Previously we presented the first two components of MySQL InnoDB Cluster: Group Replication and MySQL Router and now we will discuss the last component, MySQL Shell. MySQL Shell This is the last […]

Read More

Webinar Wed 7/19: MongoDB Sharding

 | July 18, 2018 |  Posted In: High-availability, Insight for DBAs, Insight for Developers, MongoDB, open source databases, Percona Server for MongoDB, Technical Webinars

MongoDB shard zones

Please join Percona’s Senior Support Engineer, Adamo Tonete as he presents MongoDB Sharding 101 on July 19th, 2018, at 12:30 PM PDT (UTC-7) / 3:30 PM EDT (UTC-4). Register Now   This tutorial is a continuation of advanced topics for the DBA. In it, we will share best practices and tips on how to perform […]

Read More

Webinar Wed 7/18: MariaDB 10.3 vs. MySQL 8.0

 | July 18, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MariaDB, MySQL, MySQL 8.0, open source databases, Technical Webinars

MariaDB 10.3 vs MySQL 8.0

Please join Percona’s Chief Evangelist, Colin Charles as he presents as he presents MariaDB 10.3 vs. MySQL 8.0 on Wednesday, July 18th, 2018, at 9:00 AM PDT (UTC-7) / 12:00 PM EDT (UTC-4). Register Now   Technical considerations Are they syntactically similar? Where do these two databases differ? Why would I use one over the […]

Read More

Why Consumer SSD Reviews are Useless for Database Performance Use Case

 | July 18, 2018 |  Posted In: Benchmarks, Insight for DBAs, MySQL, open source databases, Percona Server for MySQL

Anandtech Table reviewing consumer SSD performance

If you’re reading consumer SSD reviews and using them to estimate SSD performance under database workloads, you’d better stop. Databases are not your typical consumer applications and they do not use IO in the same way. Let’s look, for example, at this excellent AnandTech review of Samsung 960 Pro –  a consumer NVMe device that […]

Read More

When Should I Use Amazon Aurora and When Should I use RDS MySQL?

 | July 17, 2018 |  Posted In: Amazon Aurora, Amazon RDS, AWS, Cloud and MySQL, Insight for DBAs, MySQL, MySQL DBaaS, ProxySQL

Now that Database-as-a-service (DBaaS) is in high demand, there is one question regarding AWS services that cannot always be answered easily : When should I use Aurora and when RDS MySQL? DBaaS cloud services allow users to use databases without configuring physical hardware and infrastructure, and without installing software. I’m not sure if there is […]

Read More

InnoDB Cluster in a Nutshell: Part 2 MySQL Router

 | July 16, 2018 |  Posted In: High-availability, InnoDB, Insight for DBAs, MySQL, open source databases

MySQL Router MySQL Cluster

MySQL InnoDB Cluster is an Oracle High Availability solution that can be easily installed over MySQL to provide high availability with multi-master capabilities and automatic failover. In the previous post we presented the first component of InnoDB Cluster, group replication. Now we will go through the second component, MySQL Router.  We will address MySQL Shell in a final instalment […]

Read More

How to Set Up Replication Between AWS Aurora and an External MySQL Instance

 | July 4, 2018 |  Posted In: Amazon Aurora, Amazon RDS, Insight for DBAs, MySQL, Replication

Amazon RDS Aurora replication to external server

Amazon RDS Aurora (MySQL) provides its own low latency replication. Nevertheless, there are cases where it can be beneficial to set up replication from Aurora to an external MySQL server, as Amazon RDS Aurora is based on MySQL and supports native MySQL replication. Here are some examples of when replicating from Amazon RDS Aurora to […]

Read More

Linux OS Tuning for MySQL Database Performance

 | July 3, 2018 |  Posted In: Insight for DBAs, MySQL, MySQL 8.0, Percona Server for MySQL, Percona XtraDB Cluster, XtraDB Cluster

Linux OS tuning for MySQL database performance

In this post we will review the most important Linux settings to adjust for performance tuning and optimization of a MySQL database server. We’ll note how some of the Linux parameter settings used OS tuning may vary according to different system types: physical, virtual or cloud. Other posts have addressed MySQL parameters, like Alexander’s blog MySQL 5.7 […]

Read More

Webinar 6/28: Securing Database Servers From External Attacks

 | June 27, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, PostgreSQL, Replication, Security, Technical Webinars

securing database servers

Please join Percona’s Chief Evangelist Colin Charles on Thursday, June 28th, 2018, as he presents Securing Database Servers From External attacks at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now   A critical piece of your infrastructure is the database tier, yet people don’t pay enough attention to it judging by how […]

Read More

Webinar 6/27: MySQL Troubleshooting Best Practices: Monitoring the Production Database Without Killing Performance

 | June 26, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MariaDB, MySQL, MySQL 101, Percona Server for MySQL, Performance Schema, Technical Webinars

performance troubleshooting MySQL monitoring tools

Please join Percona’s Principal Support Escalation Specialist Sveta Smirnova as she presents Troubleshooting Best Practices: Monitoring the Production Database Without Killing Performance on Wednesday, June 27th at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now   During the MySQL Troubleshooting webinar series, I covered many monitoring and logging tools such as: General, slow, […]

Read More