Monthly Archives - October 2017

This Week in Data with Colin Charles 11: Velocity EU London and Open Source Summit Europe

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
I spent all of this week at O’Reilly Velocity EU London. I gave a tutorial, a talk and generally networked with attendees (besides my normal evangelical duties). I’ll write some thoughts on it later (probably […]

Read more

Percona Blog Poll: How Do You Currently Host Applications and Databases?

Host applications and databases

Percona latest blog poll asks how you currently host applications and databases. Select an option below, or leave a comment to clarify your deployment!
With the increased need for environments that respond more quickly to changing business demands, many enterprises are moving to the cloud and hosted deployments for applications and software in order to […]

Read more

How to Choose the MySQL innodb_log_file_size

innodb_log_file_size

In this blog post, I’ll provide some guidance on how to choose the MySQL innodb_log_file_size.
Like many database management systems, MySQL uses logs to achieve data durability (when using the default InnoDB storage engine). This ensures that when a transaction is committed, data is not lost in the event of crash or power loss.
MySQL’s InnoDB […]

Read more

Webinar Thursday, October 19, 2017: What You Need to Get the Most Out of Indexes – Part 2

Indexes

Join Percona’s Senior Architect, Matthew Boehm, as he presents What You Need to Get the Most Out of Indexes – Part 2 webinar on Thursday, October 19, 2017, at 11:00 am PDT / 2:00 pm EDT (UTC-7).
Register Now

Proper indexing is key to database performance. Finely tune your query writing and database performance with tips […]

Read more

Webinar Wednesday, October 18, 2017: How to Scale with MongoDB

Scale with MongoDB

Join Percona’s Senior Technical Services Engineer Adamo Tonete as he presents How To Scale with MongoDB on Wednesday, October 18, 2017, at 11:00 am PDT / 2:00 pm EDT (UTC-7).
Register Now

In this webinar, we will talk about how to scale with MongoDB, up to thousands of writes and reads per second. What are the […]

Read more

When Should I Enable MongoDB Sharding?

MongoDB Sharding

In this blog post, we will talk about MongoDB sharding and walk through the main reasons why you should start a cluster (independent of the approach you have chosen).
Note: I will cover this subject in my webinar How To Scale with MongoDB on Wednesday, October 18, 2017, at 11:00 am PDT / 2:00 pm EDT […]

Read more

This Week in Data with Colin Charles 10: MariaDB and Upcoming Appearances

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
Beyond spending time getting ready for Velocity and Open Source Summit Europe this week, there was some feature testing this week that compared MySQL and MariaDB. Naturally, a long report/blog is coming soon. Stay tuned.
Releases
I […]

Read more

A Mystery with open_files_limit

open_files_limit

In this blog, we’ll look at a mystery around setting the open_file_limit variable in MySQL and Percona Server for MySQL.
MySQL Server needs file descriptors to run. It uses them to open new connections, store tables in the cache, create temporary tables to resolve complicated queries and access persistent ones. If mysqld is not able […]

Read more

Percona Monitoring and Management 1.3.2 Is Now Available

Percona Monitoring and Management

Percona announces the release of Percona Monitoring and Management 1.3.2. This release only contains bug fixes related to usability.
For install and upgrade instructions, see Deploying Percona Monitoring and Management.
Bug fixes

PMM-1529: When the user selected “Today”, “This week”, “This month” or “This year” range in Metrics Monitor and clicked the Query Analytics button, the QAN page opened […]

Read more

Webinar Thursday, October 12, 2017: MongoDB Readiness from an SRE and Ops Viewpoint

MongoDB Readiness

Join Percona’s MongoDB Practice Manager David Murphy on Thursday, October 12, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7) as he discusses MongoDB Readiness from an SRE and Ops Viewpoint.
Register Now

Operations teams (SRE, PE, DevOps, etc.) are being asked to take a more active role in database provisioning and scaling. Much of […]

Read more