Category: MySQL & MariaDB

Feed: AWS Public Sector Blog. Author: Rafael Cordon. At the beginning of the COVID-19 pandemic, Ministerio de Educación de Guatemala (the Guatemala Ministry of Education) made the decision to close public schools to mitigate the spread of the virus. The closing of schools gave the Ministry’s authorities the opportunity to implement new solutions to enable students, teachers, and parents to continue with the education experience. Amazon Web Services (AWS) Partner ITZ Data (AWS Advanced Consulting Partner / Government Competency), with support from UNICEF and the Canadian Embassy in Guatemala, helped the Ministry launch Mineduc Digital—the country’s first online platform where ... Read More

Feed: AWS Public Sector Blog. Author: Farhad Jahangirov. Applications running on LAMP (Linux, Apache, MySQL, and PHP) stack are ubiquitous—WordPress alone represents 38% of all content management systems. Other popular CMS applications such as Drupal and Joomla also run on LAMP as well as Moodle, a widely used learning management system (LMS). Because of the popularity of these applications, public sector organisations such as educational institutions should protect their business continuity by implementing disaster recovery (DR) solutions: policies, tools, and procedures to help the recovery or continuation of technology infrastructure and systems following a disaster. Amazon Web Services (AWS) Professional ... Read More

Feed: Planet MySQL; Author: Dave Stokes;  Is MySQL going invisible?  Invisible Indexes were included in MySQL 8.0 and now with version 8.0.23 we have Invisible Columns.Indexes You Can Not See!The value of the invisible index is that it allows you to make an index disappear from the view of the optimizer.  In the distant days before 8.0, you would often delete an index you were pretty much definitively positive nobody or no query was using.  And then you would find out that yes, not only was that index you just deleted necessary to everyone in the galaxy (but maybe you)  ... Read More

Feed: Clustrix Blog. Author: Ivan Zlatoustov. MariaDB SkySQL is a database-as-a-service (DBaaS) that delivers unmatched flexibility and massive scalability in the cloud. SkySQL offers a dedicated observability portal, SkySQL Monitoring, which serves as a single pane of glass for the customer’s performance metrics across all clouds. In this blog, we’ll provide a walkthrough of our new “Alerts and Notifications” feature, which is in Technical Preview. Alerts and Notifications Outsourcing the tedious task of watching NOC screens to intelligent, reliable automated assistants is not new.  It can transform all the anomalies into notifications that remind us when something abnormal happens. This ... Read More

Feed: Planet MySQL; Author: Ronald Bradford; When you work with AWS Aurora you have limited admin privileges. There are some different grants for MySQL including SELECT INTO S3 and LOAD FROM S3 that replace the loss of functionality to SELECT INTO OUTFILE and mysqldump/mysqlimport using a delimited format. While I know and use lambda capabilities, I have never executed anything with INVOKE LAMDBA directly from the database.This week I found out about INVOKE COMPREHEND (had to look that product up), and INVOKE SAGEMAKER (which I used independently). These are machine learning capabilities that enable you to build custom integrations using ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; HeatWave is designed to enable customers to run analytics on data which is stored in MySQL databases without the need for ETL. This service is built on an innovative, in-memory analytics engine which is architected for scalability and performance and is optimized for Oracle Cloud Infrastructure (OCI) Gen 2 hardware. This results in a very performant solution for SQL analytics at a fraction of the cost compared to other cloud services including AWS Aurora, Redshift, Google Big Query, RDS.  The amount of acceleration an application would observe with HeatWave depends upon a number ... Read More

Feed: Clustrix Blog. Author: Saravana Krishnamurthy. We’re happy to announce the General Availability of MariaDB SkySQL for Transactions on AWS. As part of this release, SkySQL customers can easily deploy production grade transactional database services, including single node and multi-node for high availability. Deploy a transactional service in SkySQL on GCP or AWS. Customers login to the SkySQL portal and pick their public cloud provider, GCP or AWS, all from a single interface. SkySQL on AWS supports three AWS cloud regions: us-east-2, eu-central-1 and ap-southeast-1, essentially covering the entire planet for our AWS customers. As with GCP, users have access ... Read More

Feed: Planet PostgreSQL. Date: 01.03.2021 Tags:   postgresql    pgxn    sqitch    pgtap    citext    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’m a long-time open-source hacker in his early fifties. I’ve lived and worked in San Francisco, Portland OR, and now New York City. David E Wheeler How do you spend your free ... Read More

Feed: Planet MySQL; Author: Saroj Tripathy; This blog is about table partitioning in NDB Cluster. We will see how this feature has been enhanced from version to version. Also we will see which partitioning user should use under which scenario. Here I will assume that the user has some knowledge on NDB cluster.Data distribution and table partitioning are usually coupled together. In NDB, when we talk about table partitioning, we mean ‘data distribution’ mainly as NDB doesn’t fully support RANGE, HASH or LIST partitioning. Most of the enhancements made to partitioning over the years are about ‘data distribution’ rather than ... Read More

Feed: Blog – Hazelcast. Author: Neil Stevenson. In a previous blog post, Designing an Evergreen Cache with Change Data Capture, Nicolas describes “one-way” change data capture (CDC). It is a one-way process. In Nicolas’ post, the database copy can change and CDC pushes the change to Hazelcast to align the two copies of the data. Let’s take this a stage further, with “two-way” CDC. Now data in Hazelcast can change as well, and we need to push those changes back to the database. In terms of coding, this seems really easy, but it actually brings a lot of significant problems. Let’s ... Read More