Tag: Database

Feed: Featured Blog Posts - Big Data News. Author: Jay Caissie. Every business depends on data. For both the teen who mows lawns at the weekend and globe-spanning internet giants like Google, data is vital. It might be addresses written on a piece of paper or petabytes of information stored on thousands of powerful servers. If it’s lost, the business loses money, time, and the respect of its customers. Most business leaders understand how valuable data is. They take backups to keep their data safe, but the backups are often inadequate to the data’s value and the consequences of data ... Read More

Feed: Planet MySQL; Author: Keith Larson; So when it comes to routing your MySQL traffic several options exist.HAproxy MariaDB MaxScale NGINX MySQL Router ProxySQL You can even still get MySQL Proxy if you wanted it but it is EOF.  Now I have seen HAproxy used more often with clients, it is pretty straight forward to set up. Percona has an example for those interested:  https://www.percona.com/doc/percona-xtradb-cluster/LATEST/howtos/haproxy.html Personally I like ProxySQL. Percona also has  few blogs on this as well https://github.com/sysown/proxysql/wiki/ProxySQL-Configuration https://www.percona.com/blog/2017/01/19/setup-proxysql-for-high-availability-not-single-point-failure/ https://www.percona.com/blog/2017/01/25/proxysql-admin-configuration/ https://www.percona.com/blog/2016/09/15/proxysql-percona-cluster-galera-integration/ Percona also has ProxySQL version available  https://www.percona.com/downloads/proxysql/ I was thinking I would write up some examples but overall ... Read More

Feed: Planet MySQL; Author: MariaDB; When we are talking about a database auditing concept, what we are focused on is tracking the use of database records, and the monitoring of each operation on the data. The auditing activities goal is to provide a clear and reliable answer to the typical 4 W questions: Who accessed the database, When did this happen, What was touched, Where this access came from. Auditing should also help the security team answer the 5th W: Why this happened? Auditing is also a very important task when we want to monitor the database activity to collect ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Alexa Alley. The AWS Service Delivery Program is a global program that highlights top AWS Partner Network (APN) Consulting Partners who have demonstrated expertise and technical proficiency delivering AWS services.As part of the onboarding process when joining the AWS Service Delivery Program, APN Partners must go through a technical audit of their experience delivering Amazon Web Services (AWS) to end customers. This audit is conducted by internal technical experts who validate the APN Partner’s knowledge and capabilities for a specific AWS service. To help APN Partners better understand this process and our designation requirements, we are ... Read More

Feed: Blog. Author: Peter V.; A business-critical third-party application for Microsoft SQL Server configured the database with generic settings, including general indexes. Such generic parameters are likely going to lead to suboptimal performance and may even lead to poor performance. Use Precise to investigate the impact of such generic index on the performance of the application. Most database performance monitoring products show SQL activity. Precise also indicates busy tables. Precise ranks the most active tables in SQL Server and how SQL Server uses these tables. The ‘Overview’ pane’ at the top of the ‘Explore Objects’ tab of the “Objects” workspace ... Read More

Feed: What's New. As of version 10, PostgreSQL no longer uses three-part version numbers, and is shifting to two-part version numbers. This release includes all patches from the PostgreSQL 10.1 minor version. It also includes all extensions that are supported in Amazon RDS for PostgreSQL 9.6 release, and supports major version upgrades from PostgreSQL 9.6 to PostgreSQL 10. The tsearch2 extension is supported at this time, but will be deprecated in a future release; we therefore strongly encourage customers to migrate to the equivalent functionality which now exists in the core database engine. To use the new versions, you can ... Read More

Feed: Microsoft Azure Blog. Author: Matias Quaranta. There were lots of announcements at the Microsoft Build 2018 conference, but one that caught my eye was the preview release of Azure SignalR, a Platform-as-a-Service (PaaS) offering that lets you implement real-time messages and notifications quite easily, without worrying about instances or hosts. So it made me wonder, could I build something using my favorite globally-distributed and serverless database, Azure Cosmos DB, and Azure’s serverless compute offering, Azure Functions? It turns out others were interested in this topic too. Real-time, really? For those of you that do not know, SignalR is a ... Read More

Feed: Planet PostgreSQL. Modern databases store all kinds of data. From trivial to highly sensitive. The restaurants we frequent, our map locations, our identity credentials, (e.g., Social Security Numbers, Addresses, Medical Records, Banking info, etc...), and everything in between is more than likely stored in a database somewhere. No wonder data is so valuable. Database technologies advance at a breakneck pace. Innovation, progression, integrity, and enhancements abound are at the forefront as a direct result of the labors of intelligent and devoted engineers, developers, and robust communities supporting those vendors. Yet there is another side to the coin. That, unfortunately, ... Read More

Feed: What's New. Many Oracle-based workloads are not CPU-bound, so you can reduce the number of vCPUs in your deployment. A lower vCPU count can save you money in two ways: you may reduce your AWS bill by using a lower-cost instance, and you may maximize Oracle license utilization by increasing memory without increasing processor license counts. X1e instances are Powered by quad socket 2.3 GHz Intel® Xeon® E7 8880 v3 processors, and enable instance configurations from 4 vCPUs and 122 GiB memory up to 128 vCPUs and 3,904 GiB of memory. The new X1e instance sizes offer 10 Gbps ... Read More

Feed: Planet MySQL; Author: Dave Stokes; There was an interesting question on Stackoverflow.com on extracting values from a JSON data type column in a MySQL database.  What caught my eye was the the keys for the key/value pairs were numeric. In particular the author of the question only wanted values for the key named 74.  The sample data was fairly simple.{ "70" : "Apple", "71" : "Peach", "74" : "Kiwi" }I thought SELECT JSON_EXTRACT(column, '$.74') FROM table; should work but it did not. There was a complaint about an invalid path expression.It turns out that you need to make the ... Read More