版权声明：本文为Buddy Yuan原创文章，未经允许不得转载。原文地址：http://www.dboracl […]
查看执行计划的时候，发现一个有意思的问题，这里Note显示dynamic sampling used for […]
High availability (HA) and database replication is a major topic of discussion for database technologists. There are a number of informed choices to be made to optimize PostgreSQL replication so that you achieve HA. In this post we introduce an overview of the topic, and cover some options available to achieve high availability in PostgreSQL. […]
The post High Availability for Enterprise-Grade PostgreSQL environments appeared first on Percona Database Performance Blog.
New Available for Download here MySQL 5.7 Database Administrator Study Guide!
MySQL is the world’s most popular open source database
MySQL boasts a customer list of top companies like Facebook, PayPal, YouTube, Netflix, and more. Customer industries span telecom and ecommerce to government, health care, manufacturing, and areospace to name a few. You can see where up-to-date skills and knowledge are a must for MySQL Database Administrators!
Having the knowledge and skills to be flexible and quickly adapt to new business trends is important. Being able to lead these business trends is even more crucial.
“MySQL 5.7 delivers a wide range of innovations allowing developers, database administrators and DevOps teams to build and manage next-generation Web and cloud-based applications capable of processing ever increasing volumes of data,” said Tomas Ulin, vice president, MySQL Engineering, Oracle.
Whether you’re certified in an earlier version of MySQL Database Administration or this is your first foray into certification, the MySQL 5.7 Database Administrator certification will solidify your expertise and enhance your career.
Here’s Three Reasons MySQL Certification Should Be On Your Radar
- Earning certification gives top companies reason to trust you to administer their databases and keep their businesses running smoothly.
- Work faster and more efficiently to be a more effective database administrator using My SQL 5.7. It’s 3 times faster than MySQL 5.6 in benchmark tests.
- Deliver greater performance, scalability and manageability, plus enhanced NoSQL capabilities with JSON support and MySQL Router, which makes it easy to connect applications to multiple MySQL databases.
Key enhancements in MySQL 5.7
- Performance Schema
- SYS Schema
- Improved security
Review the exam topics and then purchase a voucher to save your spot in this exam.
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. I consider this to be the biggest news for the week: Alpha Build of Percona Server for MySQL 8.0. Experiment with it in a Docker container. It is missing column compression with dictionary support, native partitioning […]
The post This Week in Data with Colin Charles #54: Percona Server for MySQL is Alpha appeared first on Percona Database Performance Blog.
Starting with PMM 1.13, PMM uses Prometheus 2 for metrics storage, which tends to be heaviest resource consumer of CPU and RAM. With Prometheus 2 Performance Improvements, PMM can scale to more than 1000 monitored nodes per instance in default configuration. In this blog post we will look into PMM scaling and capacity planning—how to […]
Alpha Build of Percona Server 8.0 released An alpha version of Percona Server 8.0 is now available in the Percona experimental software repositories. This is a 64-bit release only. You may experiment with this alpha release by running it in a Docker container: $ docker run -d -e MYSQL_ROOT_PASSWORD=password -p 3306:3306 perconalab/percona-server:8.0.12.alpha When the container […]
Percona announces the release of Percona Server for MongoDB 3.4.17-2.15 on September 27, 2018. Download the latest version from the Percona website or the Percona Software Repositories. Percona Server for MongoDB 3.4 is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 3.4 Community Edition. It supports MongoDB 3.4 protocols and drivers. Percona Server for MongoDB extends […]
The post Percona Server for MongoDB 3.4.17-2.15 Is Now Available appeared first on Percona Database Performance Blog.
In this blog post, we will look at how to do MongoDB® log rotation in the right—and simplest—way. Log writing is important for any application to track history. But when the log file size grows larger, it can cause disk space issues. For database servers especially, it may cause performance issues as the database needs to write […]