Buy Percona ServicesBuy Now!

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

Tuning Autovacuum in PostgreSQL and Autovacuum Internals

and  | August 10, 2018 |  Posted In: Insight for DBAs, Performance Tuning, PostgreSQL

Tuning Autovacuum in PostgreSQL

The performance of a PostgreSQL database can be compromised by dead tuples, since they continue to occupy space and can lead to bloat. We provided an introduction to VACUUM and bloat in an earlier blog post. Now, though, it’s time to look at autovacuum for postgres, and the internals you to know to maintain a […]

Read More

This Week in Data with Colin Charles 48: Coinbase Powered by MongoDB and Prometheus Graduates in the CNCF

 | August 10, 2018 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL, PostgreSQL, ProxySQL

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. The call for submitting a talk to Percona Live Europe 2018 is closing today, and while there may be a short extension, have you already got your talk submitted? I suggest doing so ASAP! […]

Read More

Basic Understanding of Bloat and VACUUM in PostgreSQL

 | August 6, 2018 |  Posted In: Insight for DBAs, PostgreSQL

VACUUM and Bloat PostgreSQL

Implementation of MVCC (Multi-Version Concurrency Control) in PostgreSQL is different and special when compared with other RDBMS. MVCC in PostgreSQL controls which tuples can be visible to transactions via versioning. What is versioning in PostgreSQL? Let’s consider the case of an Oracle or a MySQL Database. What happens when you perform a DELETE or an […]

Read More

This Week in Data with Colin Charles 47: MySQL 8.0.12 and It’s Time To Submit!

 | August 3, 2018 |  Posted In: MariaDB, MyRocks, MySQL, MySQL 8.0, Percona Live, PostgreSQL

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Don’t wait, submit a talk for Percona Live Europe 2018 to be held in Frankfurt 5-7 November 2018. The call for proposals is ending soon, there is a committee being created, and it is a […]

Read More

This Week in Data with Colin Charles 44: MongoDB 4.0 and Facebook MyRocks

 | June 30, 2018 |  Posted In: MariaDB, MongoDB, MyRocks, MySQL, PostgreSQL

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. There have been two big pieces of news this week: the release of MongoDB 4.0 and the fact that Facebook has migrated the Messenger backend over to MyRocks. MongoDB 4.0 is stable, with support for […]

Read More

Scaling PostgreSQL with PgBouncer: You May Need a Connection Pooler Sooner Than You Expect

 | June 27, 2018 |  Posted In: Benchmarks, PostgreSQL

PostgreSQL connection pools

As PostgreSQL based applications scale, the need to implement connection pooling can become apparent sooner than you might expect. Since, PostgreSQL to date has no built-in connection pool handler, in this post I’ll explore some of the options for implementing connection pooling. In doing so, we’ll take a look at some of the implications for application […]

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

This Week in Data with Colin Charles 43: Polyglots, Security and DataOps.Barcelona

 | June 22, 2018 |  Posted In: MariaDB, MongoDB, MySQL, PostgreSQL

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. This is a short working week for me due to a family emergency. It caused me to skip speaking at DataOps.Barcelona and miss hanging out with the awesome of speakers and attendees. This is the […]

Read More