Buy Percona ServicesBuy Now!

Upcoming Webinar Thurs 9/27: Best Practices Using Indexes in MongoDB

 | September 25, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB, Technical Webinars

Best Practices Using Indexes in MongoDB

Please join Percona’s Principal Architect Alex Rubin as he presents Best Practices Using Indexes in MongoDB on Thursday, September 27th at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now   Indexes support the efficient execution of queries in MongoDB. Without indexes, MongoDB must perform a collection scan, i.e. scan every document in […]

Read More

Using AWS EC2 instance store vs EBS for MySQL: how to increase performance and decrease cost

 | August 20, 2018 |  Posted In: AWS, Cloud and MySQL, Insight for DBAs, MySQL, Solutions Engineering

AWS EC2 MySQL cost savings

If you are using large EBS GP2 volumes for MySQL (i.e. 10TB+) on AWS EC2, you can increase performance and save a significant amount of money by moving to local SSD (NVMe) instance storage. Interested? Then read on for a more detailed examination of how to achieve cost-benefits and increase performance from this implementation. EBS […]

Read More

Why MySQL Stored Procedures, Functions and Triggers Are Bad For Performance

 | July 12, 2018 |  Posted In: Benchmarks, MySQL, MySQL 8.0

Execution map for func1()

MySQL stored procedures, functions and triggers are tempting constructs for application developers. However, as I discovered, there can be an impact on database performance when using MySQL stored routines. Not being entirely sure of what I was seeing during a customer visit, I set out to create some simple tests to measure the impact of […]

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

MongoDB Transactions: Your Very First Transaction with MongoDB 4.0

and  | June 25, 2018 |  Posted In: Cloud and NoSQL, MongoDB, open source databases

MongoDB 4.0 transactions

MongoDB 4.0 is just around the corner and with rc0 we can get a good idea of what we can expect in the GA version. MongoDB 4.0 will allow transactions to run in a replica set and, in a future release, the MongoDB transaction will work for sharded clusters. This is a really big change! Multi-statement […]

Read More

Webinar Tues, 5/29: MySQL, Percona XtraDB Cluster, ProxySQL, Kubernetes: How they work together

 | May 25, 2018 |  Posted In: Containers, High-availability, Insight for DBAs, Insight for Developers, MySQL, Percona Server for MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL, Technical Webinars, XtraDB Cluster

Please join Percona’s Principal Architect Alex Rubin as he presents MySQL, Percona XtraDB Cluster, ProxySQL, Kubernetes: How they work together to give you a highly available cluster database environment on Tuesday, May 29th at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now   In this webinar, Alex will discuss how to deploy […]

Read More