Tag: Oracle

Feed: Planet MySQL; Author: Dave Stokes; DescriptionJoin this virtual meetup featuring WePay and Oracle MySQL! They will review three great talks on MySQL Compatibility Check, Running MySQL on Kubernetes and Scalable Bookkeeping.Talk 1: MySQL Compatibility CheckTalk 2: Running MySQL on KubernetesTalk 3: Scalable BookkeepingDate & Time Oct 1, 2020 10:00 AM in Pacific Time (US and Canada)Register here ... Read More

Feed: Planet PostgreSQL. I have previously written a blog post on the detailed steps involved in enabling PostgreSQL monitoring using PMM. In that post, you could see me talking about the role: pg_monitor that can be granted to monitoring users. The pg_monitor role restricts a monitoring user from accessing user data but only grants access to statistic views needed for monitoring. The following are the simple steps to create a monitoring user for using Percona Monitoring and Management (PMM). CREATE USER pmm_user WITH ENCRYPTED PASSWORD 'secret'; GRANT pg_monitor to pmm_user;CREATE USER pmm_user WITH ENCRYPTED PASSWORD 'secret'; GRANT pg_monitor to pmm_user;However, ... Read More

Feed: Planet PostgreSQL. Date: 21.09.2020 Tags:   postgresql    pgcon    freebsd    bsdcan    Category:   Interviews    Interviewed by: Andreas Scherbaum PostgreSQL is the World’s most advanced Open Source Relational Database. The interview series “PostgreSQL Person of the Week” presents the people who make the project what it is today. Read all interviews here. Please tell us about yourself, and where you are from. I am Canadian. Born in Nova Scotia and attended high school and university in Ottawa. I moved to New Zealand shortly after graduation. After 16 years in Wellington, NZ, where I got into Open ... Read More

Feed: Liquid Web. Author: Nick Campbell; Is your business protected from the next ransomware attack? There is danger in ransomware attacks, as well as in ransomware variants that keep emerging to target servers, websites, and specific organizations such as local municipalities. Ransomware maintains its position as one of the most profitable business models in cybercrime. Recent figures show that ransomware has filled hackers’ pockets with $11.5 billion in 2019, compared to $5 billion in 2017. In the first half of 2019 alone, Sodinokibi (REvil) ransomware strains claimed 23 municipal governments in Texas, while two small cities in Florida were scared ... Read More

Feed: Planet MySQL; Author: Aleks; When a table gets dropped, MySQL removes the respective .frm file. This post explains how to recover the table structure if the table was dropped. You need the table structure to recover a dropped table from the InnoDB tablespace. The B+tree structure of the InnoDB index doesn’t contain any information about field types. MySQL needs to know that in order to access records of the InnoDB table. Normally, MySQL gets the table structure from the .frm file. But when MySQL drops a table the respective frm file removed too. Fortunately, there’s one more place where ... Read More

Feed: Planet MySQL; Author: Joshua Otwell; I recently watched a fantastic Python Pandas library tutorial series on YouTube. Without a doubt, Pandas is great for all sorts of data stuff. On the same token, MySQL Shell in Python mode is quite powerful in the sense that Python and the MySQL Shell (version >= 8.0) are somewhat united in the same environment. Although Pandas is in a league all its own when it comes to data analysis, between the power of MySQL and Python, we can also perform some basic analysis easily in MySQL Shell Python mode. In this blog post, ... Read More

Feed: Clustrix Blog. Author: Peter Friedenbach. What we tested: Relative performance of MariaDB vs MySQLHow we tested: Multi-statement, transaction processing workload (Sysbench 90:10)Where we tested: Amazon AWS EC2 and RDS, large to 12xlarge instancesWhat we conclude: MariaDB provides superior performance on commodity cloud hardware for real business workloads. Looking back in MariaDB Server’s family tree, we find its ancestor, MySQL Server. MariaDB Community Server and MySQL Server Community Edition, both Open Source, have over the years been packaged for many of the same Linux distributions, powering application stacks behind hundreds of popular websites and applications. And both are available in ... Read More

Feed: Microsoft Azure Blog. Author: Rena Shah. Azure Files is a distributed cloud file system serving file system SMB and REST protocols generally available since 2015. Customers love how Azure Files enables them to easily lift and shift their legacy workloads to the cloud without any modifications or changes in technology. SMB works great on both Windows and UNIX operating systems for most use cases. However, because some applications are written for POSIX compliant file systems, our customers wanted to have the same great experience on a fully POSIX compatible NFS file system. Today, it’s our pleasure to announce Azure ... Read More

Feed: Blog – Hazelcast. Author: Enes Ozcan. Hazelcast is a swiss-knife for distributed computing. You can use it as cache, distributed lock, key-value store, pub/sub, computing platform, and many more. Hazelcast also has a rich array of integrations that allow you to deploy it in cloud environments, inside microservices, or connect with your Java EE applications. How to find yourself in this distributed ecosystem? Now, we are introducing Hazelcast Guides to help you get started! The guides are step-by-step, experiment focused, always up-to-date, and bite-sized samples where you can spend 10-15 minutes to gain experience with Hazelcast and various technologies ... Read More

Feed: Teradata Blog. It seems today that every industry is trying its best to comprehend and get an in-depth understanding of their customers’ needs. Indeed, banks and financial institutions are no excepetion and are leveraging data to derive insights about their business, and their customers. But today, insights are simply not enough – they need to be timely and actionable as well.  Yes, it’s not just about analytics now, but real-time analytics. Teradata’s work implementing real-time credit scoring for a reputed bank in Turkey is one such example of enabling real-time analytics to maximize revenue and minimize cost & time ... Read More