All Blogs / Technology / Programming / Database Development / Popular


MongoDB 3.6 Change Streams: A Nest Temperature and Fan Control Use Case

In this post, I’ll look at what MongoDB 3.6 change streams are, in a creative way. Just in time for the holidays! What is a change stream? Change streams in MongoDB provide a cross-platform unified API that can be supported with sharding. It has an option for talking to secondaries, and even allows for security […]

Sudoku Recursive Common Table Expression Solver

In this blog post, we’ll look at a solving Sudoku using MySQL 8.0 recursive common table expression. Vadim was recently having a little Saturday morning fun solving Sudoku using MySQL 8. The whole idea comes from SQLite, where Richard Hipp has come up with some outlandish recursive query examples — WITH clause. The SQLite query: […]

Sponsored Post: Symbiont, Loupe, Etleap, Aerospike, Stream, Scalyr, VividCortex, Domino Data Lab, MemSQL, Zohocorp

Who's Hiring? Symbiont is a New York-based financial technology company building new kinds of computer networks to connect independent financial institutions together and allow them to share business logic and data in real time. This...Show More Summary

Percona Toolkit 3.0.5 is Now Available

Percona announces the release of Percona Toolkit 3.0.5 on November 21, 2017. Percona Toolkit is a collection of advanced command-line tools that perform a variety of MySQL and MongoDB server and system tasks too difficult or complex for DBAs to perform manually. Show More Summary

InnoDB Page Compression: the Good, the Bad and the Ugly

In this blog post, we’ll look at some of the facets of InnoDB page compression. Somebody recently asked me about the best way to handle JSON data compression in MySQL. I took a quick look at InnoDB page compression and wanted to share my findings. There is also some great material on this topic that was prepared […]

Understanding how an IST donor is selected

In a clustering environment, we often see a node that needs to be taken down for maintenance. For a node to rejoin, it should re-sync with the cluster state. In PXC (Percona XtraDB Cluster), there are 2 ways for the rejoining node to re-sync: State Snapshot Transfer (SST) and Incremental State Transfer (IST). SST involves […]

Stuff The Internet Says On Scalability For November 17th, 2017

Hey, it's HighScalability time: The BOSS Great Wall. The largest structure yet found in the universe. Contains 830 galaxies. A billion light years across. 10,000 times the mass of the Milky Way. If you like this sort of Stuff then please support me on Patreon. Show More Summary

This Week in Data with Colin Charles 15: Percona Live 2018 Call for Papers and Best Practices for Observability

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. So we have announced the call for presentations for Percona Live Santa Clara 2018. Please send your submissions in! As you probably already know, we have been expanding the content to be more than just […]

ZFS from a MySQL perspective

Since the purpose of a database system is to store data, there is close relationship with the filesystem. As MySQL consultants, we always look at the filesystems for performance tuning opportunities. The most common choices in term of filesystems are XFS and EXT4, on Linux it is exceptional to encounter another filesystem. Both XFS and […]

Webinars on Wednesday November 15, 2017: Proxy Wars and Percona Software Update for Q4

Do you need to get to grips with MySQL proxies? Or maybe you could do with discovering the latest developments and plans for Percona’s software? Well, wait no more because … on Wednesday November 15, 2017, we bring you a webinar double bill. Join Percona’s Chief Evangelist, Colin Charles as he presents “The Proxy Wars […]

Common MongoDB Topologies

In this blog post, we’ll look at some common MongoDB topologies used in database deployments. The question of the best architecture for MongoDB will arise in your conversations between developers and architects. In this blog, we wanted to go over the main sharded and unsharded designs, with their pros and cons. We will first look […]

Percona Live Open Source Database Conference 2018 Call for Papers Is Now Open!

Announcing the opening of the Percona Live Open Source Database Conference 2018 in Santa Clara, CA, call for papers. It will be open from now until December  22, 2017. Our theme is “Championing Open Source Databases,” with topics of MySQL, MongoDB and other open source databases, including PostgreSQL, time series databases and RocksDB. Show More Summary

This Week in Data with Colin Charles 14: A Meetup in Korea and The Magic Quadrant

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. We’re close to opening up the call for papers for Percona Live Santa Clara 2018 and I expect this to happen next week. We also have a committee all lined up and ready to vote on submissions. […]

Cassandra NoSQL Data Model Design

We at Instaclustr recently published a blog post on the most common data modelling mistakes that we see with Cassandra. This post was very popular and led me to think about what advice we could provide on how to approach designing your...Show More Summary

Stuff The Internet Says On Scalability For November 10th, 2017

Hey, it's HighScalability time: Ah, the good old days. This is how the FBI stored finger prints in 1944. (Alex Wellerstein). How much data? Estimates range from 30GB to 2TB. If you like this sort of Stuff then please support me on Patreon. Show More Summary

MySQL and Linux Context Switches

In this blog post, I’ll look at MySQL and Linux context switches and what is the normal number per second for a database environment. You might have heard many times about the importance of looking at the number of context switches to indicate if MySQL is suffering from the internal contention issues. I often get […]

Sponsored Post: Loupe, Etleap, Aerospike, Stream, Scalyr, VividCortex, Domino Data Lab, MemSQL, Zohocorp

Who's Hiring? Need excellent people? Advertise your job here! Fun and Informative Events On-demand Webinar. Fast & Frictionless - The Decision Engine for Seamless Digital Business. In this session, guest speakers Michele Goetz, Principal...Show More Summary

Using Prometheus to Check for auto_increment Value Exhaustion

In this blog post, we’ll look at how to use Prometheus to check for auto_increment value exhaustion. One of the proactive tasks DBAs perform is checking if a field defined as auto_increment is about to reach the maximum allowed value of the int definition. For example, if a field is defined as smallint unsigned and […]

Upcoming MongoDB Security Webinar November 8, 2017: Enhanced Security Using LDAP Authentication

Join Percona’s Senior Technical Services Engineer Adamo Tonete as he presents MongoDB Security Webinars: Enhanced Security Using LDAP Authentication on Wednesday, November 8, 2017 at 11:00 am PST / 2:00 pm EST (UTC-8). Experience: Intermediate Tags: SysAdmin, DBAs In this webinar, we are going to demonstrate how to configure Percona Server for MongoDB in a […]

MongoDB Security: Using LDAP Authentication

In this blog post, we’ll focus on MongoDB security and discuss how to configure Percona Server for MongoDB to authenticate a user with an LDAP server. It is important to mention that Percona Server for MongoDB features LDAP authentication free of charge for everyone in all our versions. This feature is not available in the MongoDB Community versions. […]

Copyright © 2015 Regator, LLC