Author: Andrew Couch

What is MySQL vs. MariaDB vs. Percona

Andrew Couch October 7, 2015 by under VPS Hosting 0 Comments
Illustration by Walker Cahall

Illustration by Walker Cahall

Target Audience

This article assumes you have at least a passing familiarity with databases and some of the terminology around their features.

Introduction

Databases back every application, and there are many choices. MySQL has long been a popular open source choice; however, MariaDB and Percona are two major code forks that can replace MySQL with enhanced features. This article offers a broad comparison of the three.

Read More


How to: Troubleshoot WordPress Plugins by Disabling All of Them at Once

Andrew Couch September 25, 2015 by under VPS Hosting 0 Comments

Introduction

One of the aspects of WordPress that has made it so popular as a website framework is the vast number of plugins available to enhance and expand just about every aspect of the base install. Occasionally a plugin doesn’t play well with others. It can do so in such a spectacular way that it crashes your site. Other times a subtle bug can drive you mad looking for the source. In both of these cases, the common advice is to disable all of your plugins and re-enable them one by one to find the culprit. This article talks about how to disable all of your plugins at once even if you cannot get into your admin screen anymore.

Read More


How to: Using Basic SQL Syntax

Andrew Couch September 24, 2015 by under Dedicated Server Hosting 0 Comments

Introduction

Behind every great web application is a database of some kind. Many of the widely used database systems (e.g., MySQL, Percona, PostgressSQL, MariaDBMSSQL) use SQL (Structured Query Language) to pull data out and push data in. A lot of modern programming languages provide an ORM (Object-Relational Mapping) layer which loads data directly into code without needing to know SQL, but sometimes you just want to talk to the database directly. While SQL has a lot of keywords and can get very complex, this article goes through the basic CRUD (Create Read Update Delete) constructs.

Read More


New York, NY

100 Delawanna Ave, Suite 1

Clifton, NJ 07014

United States

San Francisco, CA

2820 Northwestern Pkwy,

Santa Clara, CA 95051

United States

Dallas, TX

2323 Bryan Street,

Dallas, Texas 75201

United States

Ashburn, VA

1807 Michael Faraday Ct,

Reston, VA 20190

United States

Orlando, FL

440 W Kennedy Blvd, Suite 3

Orlando, FL 32810

United States

Toronto, Canada

20 Pullman Ct, Scarborough,

Ontario M1X 1E4

Canada

London, UK

14 Liverpool Road, Slough,

Berkshire SL1 4QZ

United Kingdom

Resources