Category: Oracle Database

Feed: Planet MySQL; Author: Oracle MySQL Group; Our pleasure to announce the MySQL Day which will be hold on September 26, 2020. Please find more details below and at the Oracle India User Group website. Name: MySQL Day Date: September 26, 2020 Agenda:  11:00 to 11:20 - Welcome: MySQL Day Agenda by Sanjay Manwani, the MySQL India Dev. Sr. Director, Oracle.  11:30 to 12:00 - Keynote: State of MySQL by Tomas Ulin, the Vice President, Oracle 12:15 to 13:15 - Hands-On: Introduction to MySQL Database Service (MDS) by Jothir Ganesan, the Software Development Manager, Oracle   13:15 to 14:15 - Lunch Break     ... Read More

Feed: Planet MySQL; Author: Airton Lastori; The MySQL team is thrilled to invite customers to use the new MySQL Database Service also in OCI Japan East (Tokyo) Region. This is an addition to the Regions where the Service is already available: US East (Ashburn), United Kingdom (London), Germany (Frankfurt), Brazil (Sao Paulo), and the US West (Phoenix). If you want to test for free, go to oracle.com/cloud/free and get access to a wide range of Oracle Cloud services for 30 days, including MySQL Database Service in Ashburn, Frankfurt, London, Phoenix, and Tokyo Regions. Check the documentation for the quick steps ... Read More

Feed: AWS Architecture Blog. When you want to optimize your Java application on AWS Lambda for performance and cost the general steps are: Build, measure, then optimize! To accomplish this, you need a solid monitoring mechanism. Amazon CloudWatch and AWS X-Ray are well suited for this task since they already provide lots of data about your AWS Lambda function. This includes overall memory consumption, initialization time, and duration of your invocations. To examine the Java Virtual Machine (JVM) memory you require garbage collection logs from your functions. Instances of an AWS Lambda function have a short lifecycle compared to a ... Read More

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