Tag: Cache

Feed: Planet MySQL; Author: Severalnines; Migrating from Oracle to MySQL/Percona Server is not a trivial task. Although it is getting easier, especially with the arrival of MySQL 8.0 and Percona announced Percona Server for MySQL 8.0 GA. Aside from planning for your migration from Oracle to Percona Server, you must ensure that you understand the purpose and functionality for why it has to be Percona Server. This blog will focus on Migrating from Oracle to Percona Server as its specific target database of choice. There's a page in the Oracle website about SQL Developer Supplementary Information for MySQL Migrations which ... Read More

Feed: R-bloggers. Author: Rstats on pi: predict/infer. While developing your R package, you will want to make sure the code it contains is as clean as possible and that your package build and testing times are as efficient as you can make them. There are a number of tricks and tools at your disposal to accomplish these aims. This post, the third in a series that covers R package development, will introduce a few of those and demonstrate how they can improve your package development process. We’ll continue with the chifishr example repo we created in part 1 and part ... Read More

Feed: Cloudwards. Author: Brian Murray; Every time you type a website address into the URL bar of your browser, it triggers a complex series of events that connect your computer with the website. Part of the process is for your computer to retrieve the IP address of that website’s server. This information is given to your computer by a DNS, or domain name system. It’s a “middleman” reminiscent of an operator on old-timey phone exchange. Your computer contacts the DNS and tells it the URL for the website you are trying to reach. The DNS then provides the address of ... Read More

Feed: What's New. DAX provides a fully managed, highly available, in-memory cache for DynamoDB that can accelerate reads from DynamoDB tables by up to 10 times, even at millions of requests per second. With the added transactions support for Python and .NET, DAX support for transactions is available in all DAX SDKs—Java, Node.js, Go, Python, and .NET ... Read More

Feed: Cloudera Engineering Blog. Author: Tom Wheeler. Key Takeaways We have significantly improved Impala in CDH 5.15.0 to address some of the scalability bottlenecks in query execution. 64 concurrent streams of TPC-DS queries at 10TB scale in a 135-node cluster now run at 6x query throughput compared to previous releases. In addition to running faster, the query success rate also improved from 73% to 100%. Overall, Impala in CDH 5.15.0 provides massive improvements in throughput and reliability while reducing the resource usage significantly. It can now reliably handle concurrent complex queries on large data sets that were not possible before ... Read More

Feed: Cloudera Engineering Blog. Author: Tom Wheeler. In the last few years, IT security threats to enterprise systems have increased, which has necessitated installing log ingestion and analysis solutions in any enterprise network. This blog post illustrates how Cloudera built its own scalable solution for log ingestion and analytics using Apache Spot and Cloudera Altus. By leveraging transient workloads in the cloud, Cloudera reduced the solution’s operational costs by 50% when compared to traditional, persistent cluster approaches. At Cloudera, the Infosec team needed to build a centralized log ingestion and analytical solution to monitor all key systems in the company ... Read More

Feed: Planet MySQL; Author: Severalnines; How to Monitor MySQL Databases? Operational visibility is a must in any production environment. It is crucial to be able to identify any issues as soon as possible, otherwise you may end up in serious troubles as an undetected issue can cause serious service disruption or downtime. MySQL Enterprise Monitor is one of the oldest monitoring products for MySQL on the market, and is available as part of an commercial enterprise subscription agreement from Oracle.In this blog post we will take a look at MySQL Enterprise Monitor and the kind of insight it provides into ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST While implementing ClickHouse for query executions statistics storage in Percona Monitoring and Management (PMM),  we were faced with a question of choosing the data type for metrics we store. It came down to this question: what is the difference in performance and space usage between Uint32, Uint64, Float32, and Float64 column types? To test this, I created a test table with an abbreviated and simplified version of the main table in our ClickHouse Schema. The “number of queries” is stored four times in four different columns to be able to benchmark ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; In a previous blog post, we discussed how the initialization and restart of the MySQL server has changed between versions 5.6, 5.7 and 8.0. Now, we will take a closer look at MySQL 8.0 to explain in more detail how the transactional data dictionary is bootstrapped. This happens whenever the MySQL server process starts, and we often distinguish between the first time start and the subsequent restarts or upgrades.  The chicken and egg problem When something depends on itself, we commonly refer to it as the chicken and egg problem. Bootstrapping the ... Read More

Feed: Redis Labs. Author: Dave Provenza. In my experience, certain applications are easier to build and maintain when they are broken down into smaller, loosely coupled, self-contained pieces of logical business services that work together. Each of these services (a.k.a. microservices) manages its own technology stack that is easy to develop and deploy independently of other services. There are countless well-documented benefits of using this architecture design that have already been covered by others at length. That said, there is one aspect of this design that I always pay careful attention to because when I haven’t it’s led to some ... Read More