Buy Percona ServicesBuy Now!

Foreign Data Wrappers in PostgreSQL and a closer look at postgres_fdw

 | August 21, 2018 |  Posted In: open source databases, PostgreSQL

Foreign data wrapper FDWs with PostgreSQL postgres_fdw

There are a few features in PostgreSQL that are very compelling, and that I rarely see in other RDBMSs. Some of these features are the driving force behind the growing popularity of PostgreSQL. This blog post is about one of my favourite features: FDW (Foreign Data Wrapper). As the name indicates, this feature allows a PostgreSQL […]

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

Webinar Tues 8/21: MariaDB 10.3 vs. MySQL 8.0

 | August 20, 2018 |  Posted In: Events and Announcements, MariaDB, MySQL, MySQL 8.0, Technical Webinars

MariaDB 10.3 vs MySQL 8.0

Please join Percona’s Chief Evangelist, Colin Charles on Tuesday, August 21st, 2018, as he presents MariaDB 10.3 vs. MySQL 8.0 at 7:00 AM PDT (UTC-7) / 10:00 PM EDT (UTC-4). Register Now Are they syntactically similar? Where do these two languages differ? Why would I use one over the other? MariaDB 10.3 is on the […]

Read More

Percona Server for MySQL 5.6.41-84.1 Is Now Available

 | August 17, 2018 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software

Percona Server for MySQL 5.6

Percona announces the release of Percona Server for MySQL 5.6.41-84.1 on August 17, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.6.41, including all the bug fixes in it. Percona Server for MySQL 5.6.41-84.1 is now the current GA release in the 5.6 series. All of Percona’s software is […]

Read More

Percona Server for MySQL 5.5.61-38.13 Is Now Available

 | August 17, 2018 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software

Percona Server for MySQL 5.6

Percona announces the release of Percona Server for MySQL 5.5.61-38.13 on August 17, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.5.61, including all the bug fixes in it. Percona Server for MySQL 5.5.61-38.13 is now the current GA release in the 5.5 series. All of Percona’s software is […]

Read More

Replication from Percona Server for MySQL to PostgreSQL using pg_chameleon

 | August 17, 2018 |  Posted In: High-availability, MySQL, PostgreSQL, Replication

postgres mysql replication using pg_chameleon

Replication is one of the well-known features that allows us to build an identical copy of a database. It is supported in almost every RDBMS. The advantages of replication may be huge, especially HA (High Availability) and load balancing. But what if we need to build replication between 2 heterogeneous databases like MySQL and PostgreSQL? […]

Read More

This Week in Data with Colin Charles 49: MongoDB Conference Opportunities and Serverless Aurora MySQL

 | August 17, 2018 |  Posted In: Amazon Aurora, Events and Announcements, MariaDB, MongoDB, MySQL

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Beyond the MongoDB content that will be at Percona Live Europe 2018, there is also a bit of an agenda for MongoDB Europe 2018, happening on November 8 in London—a day after Percona Live in […]

Read More

MongoDB: how to use the JSON Schema Validator

 | August 16, 2018 |  Posted In: Insight for Developers, MongoDB, open source databases, Percona Server for MongoDB

JSON Schema Validator for MongoDB

The flexibility of MongoDB as a schemaless database is one of its strengths. In early versions, it was left to application developers to ensure that any necessary data validation is implemented. With the introduction of JSON Schema Validator there are new techniques to enforce data integrity for MongoDB. In this article, we use examples to show you how […]

Read More

Webinar Thurs 16/8: Developing an App on MongoDB: Tips and Tricks

 | August 15, 2018 |  Posted In: Events and Announcements, Insight for DBAs, Insight for Developers, MongoDB, Percona Server for MongoDB, Technical Webinars

Please join Percona’s Sr. Technical Operations Architect Tim Vaillancourt as he presents Developing an App on MongoDB: Tips and Tricks on Thursday, August 16th, 2018, at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Register Now A lot of developers prefer using MongoDB to other open source databases when developing applications. But why? How do […]

Read More

Open Source Database Community Blog: The Story So Far

 | August 14, 2018 |  Posted In: Events and Announcements, Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, open source databases

open source database community blog

Recently, we initiated a new project, the Open Source Database Community Blog. One way to think of this is as an online, year round version of the Percona Live conferences. If you have a story to tell, an experience to share, or a lesson to be learned send it along. As long as it’s related […]

Read More

Percona’s widely read Percona Database Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.