MySQL

MySQL 8.0 Window Functions: A Quick Taste

In this post, we'll briefly look at window functions in MySQL 8.0.One of the major features coming to MySQL 8.0 is the support of window functions. …

DevOps

How to Reset WordPress Admin Password via MySQL Command Prompt

Sometimes, a <b>WordPress</b> user, with one of the following capabilities, such as administrator, editor, author, contributor or subscriber, forgets its …

Linux

Amazon Aurora with MySQL Compatibility Natively Supports Synchronous Invocation of AWS Lambda Functions

AWS Lambda lets you run code without provisioning or managing servers or worrying about scalability. Lambda integration allows you to extend the …

Cloud Computing

Amazon Aurora with MySQL Compatibility Speeds Query Processing with Hash Join and Batched Scans

Batched scans are also now supported, which can speed up in-memory queries by a factor of up to 1.8x.<p>These features are available in lab mode …

Manage your Cloud MySQL Instance from Anywhere — DatabaseJournal.com

Have you heard the expression "there's an app for that"? Well, it's true. Every day on the bus you can observe riders immersed in their phones. While …

Databases

From MySQL to PostgreSQL

In this article I will guide you through the steps I had to take to migrate Django projects from MySQL to PostgreSQL.<p>MySQL database has proven to be …

Databases

Comparing MongoDB & MySQL

Imagine finding a DBMS that aligns with tech goals of your organization. Pretty exciting, right?<p>Relational databases held the lead for quite a time. …

Databases

PHP MySQL - Novice to Ninja, 6th Edition ($29 Value FREE For a Limited Time)

Verify Your Email Address<p>We require that you verify your email address prior to updating your account. Simply click on the button below and we'll …

eBooks

12 MySQL/MariaDB Security Best Practices for Linux

<b>MySQL</b> is the world’s most popular open source database system and <b>MariaDB</b> (a fork of MySQL) is the world’s fastest growing open source database …

Linux

Docker Concepts for Oracle/MySQL DBAs and DevOps

Oracle Week 2017 Slides<p>Agenda:<p>Docker overview – why do we even need containers?<p>Installing Docker and getting started<p>Images and Containers<p>Docker Networks<p>Docker Storage and Volumes<p>Oracle and Docker<p>Docker tools, GUI and Swarm

Virtualization

MySQL and Linux Context Switches

In this blog post, I'll look at MySQL and Linux context switches and what is the normal number per second for a database environment.You might have …

Software Development

How to avoid duplicates when you insert hundreds of thousands of entries into the same MySQL table

let’s assume that you are working on an application that requires all entries on a table (lets call it entries) to be unique.<br>If we are writing our …

MySQL Performance Tuning Tips for the Shopping Season

With Halloween all but a distant memory, the time has come to turn our attention to the upcoming holiday season. First, Thanksgiving, then Black …

DevOps

How to Install Icinga 2 Monitoring Tool on Debian 9.2

In this guide we will discuss how to install and configure the latest version Icinga 2 web monitoring tool in Debian 9.2 release, in order to monitor …

Linux

Dbmgr

dbmgr is a command line tool for backing up and restoring databases. It's a useful tool for:<p>Backing up and restoring your development …

Databases

Moving from an RDM to a VVol

Migrating VMDKs or virtual mode RDMs to VVols is easy: Storage vMotion. No downtime, no pre-creating of volumes. Simple and fast. But physical mode …

Virtualization

Top 10 Rated Web Hosting Provider Companies

Individuals and organization need web hosting to have their website via World Wide Web. There are many web hosting service companies that allow you …

Web Design

Monitoring MySQL

<i>This article is featured in the new DZone Guide to Databases. Get your free copy for more insightful articles, industry statistics, and more!</i>The …

DevOps

Persistent Storage With OpenShift or Kubernetes

We know that containers in OpenShift or Kubernetes don’t persist data. Every time we start an application, it is started in a new container with an …

DevOps

Top Metrics to Monitor in Your MySQL Databases (Part 1)

As tables increase in size and more and more users come online, it becomes increasingly necessary to fine-tune your database server from time to …

DevOps

Amazon Aurora (MySQL) Speeds Join Queries by More than 10x with Asynchronous Key Prefetch

This feature applies to queries that require use of the Batched Key Access (BKA) join algorithm and Multi-Range Read (MRR) optimization, and improves …

Cloud Computing

Amazon Aurora (MySQL) Doubles Maximum Write Throughput with Support for R4 Instances

An R4.16xlarge instance, the largest in the family, has 64 cores and 488GiB of memory. Amazon Aurora (MySQL) can process up to 200,000 writes/second …

Cloud Computing

How to configure persistent storage with OpenShift or Kubernetes for development environment

• We know that containers in Openshift or Kubernetes don’t persist data. Every time we start an application, it is started in a new container with an …

Linux

Preventing race conditions in Docker

It’s easy to get race conditions with <b>Compose</b> & <b>Docker</b>. Take for example, if you have a common pattern when you have the application server depends on …

DevOps

How to set, change, and recover a MySQL root password

If you never set, forgot, or need to change your MySQL password, you're in luck. This article walks you through these steps, so you'll never be at a …

Linux

Difference between In memory databases and disk memory database

Recently i heard about the concept of In memory database.<p>In any type of database we are finally storing the data in the computer,from there our …

Big Data

PingCAP Launches TiDB 1.0

17 Oct 2017<p>PingCAP Launches TiDB 1.0, A Scalable Hybrid Database Solution<p>October 16, 2017 - PingCAP Inc., a cutting-edge distributed database …

Abraham Lincoln

Safely keeping MySQL connections alive

I'm working on a node.js application that connects to a MySQL server. The following likely isn't node.js-specific, though.<p>Currently, my code …

I'm planning on creating a website with NodeJS, What can I use to future proof it?

Basically, I'm wondering what technologies, node modules, etc I could use to either future proof it, or just make it easier to make.<p>My current …

Programming

Big Dataset: Analyzing All Reddit Comments With ClickHouse

In this blog, I'll use ClickHouse and Tabix to look at a new very large dataset for research.It is hard to come across interesting datasets, …

Reddit