Data in a MySQL/MariaDB database is stored in tables. A simple way of thinking about indexes is to imagine an extensive spreadsheet. This type of system is not always conducive to quick searching; that’s where an index becomes essential. If there is no index, then the database engine has to start at row one and browse through all the rows looking for the corresponding values. If this is a small table, then it is no big deal, but in larger tables and applications where there can be tables with millions and even billions of rows, it becomes problematic. As you can imagine, searching through those rows one by one will be time-consuming, even on the latest hardware. The solution is to create an INDEX (or more than one) for your data.Continue reading “MySQL Performance: MySQL/MariaDB Indexes”
Reading Time: 4 minutesWordPress is one of the most popular Content Management Systems on the Internet. Due to it’s popularity, it is also the target of many hackers. We’re here to show you our top 5 recommendations on how to secure your WordPress site based on issues we’ve come across.
Continue reading “How To Secure Your WordPress Site”
Reading Time: 2 minutesWindows periodically checks for the latest updates and security features for your devices. Automatic updates are implemented with the intention of running your device smoothly and securely. With top security in mind, most Liquid Web servers are set to automatically install these updates thus saving you the task of remembering to implement critical updates or patches.
The vast majority of the times, windows updates complete successfully, keeping you and your customers safe. These updates rarely cause any server issues, but you may find that you want to roll back an update due to an unforeseen server change. Fear not, in this tutorial we’ll show you how to easily undo a Windows update on 2016, 2008R2 and 2012R2 servers.
Server 2016 with Windows 10
- Click on the Start button, search for Windows Update and hit Enter.
- Go to View Update History and select Uninstall Updates. Click the update you are wanting to uninstall/remove. (Generally, these are the most recent installs.)
- When the installed update window comes up, you can see the updates by name, KB number, type of program, version, and even the date of installation.
- Select the update and choose Uninstall. Follow the on screen instructions.
- Depending on the update, there may be a need to reboot the server to complete removal.
- While you are still in the Windows Update screen, select the offending update and click Hide Update. ** Once the Update is fixed and it is safe to install, then you can go in and manually install it on your system.
Complete the removal of the update by rebooting the server.
Server 2008R2 and 2012R2 with Windows 7/8
- Go to the Start button and select Control Panel.
- Go to Programs >> Uninstall a program.
- Select the program and right-click to Uninstall.
- Select the update you would like to revert.
- Select Yes to uninstall the selected update.
- Select the Restart Now button.
- While you are still in the Updates screen, select the offending update and right-click, to select Hide Update. ** To re-instate the update you can manually install it on your system.
Complete the removal of the update by rebooting the server.
Reading Time: 5 minutes
Times are changing, and possibly your hostname is too if you are reading this article. You may have come across a scenario within the business that requires you to change your hostname. You might ask yourself why you would need to change your hostname? The most common scenarios would be due to a domain name change, your business has changed its course, or because you have thought of something better.
Sometimes you might forget to renew the domain names before they expire. Unfortunately, this can be a time where a domain broker purchases the domain name out from under you. These are agencies that take popular sites and purchase with the intent of holding the domain until their inflated price is met. As unfortunate as this may be, sometimes it is best to purchase a new domain name for cost efficiency.
Reading Time: 2 minutes
We recently posted an article on Upgrading MariaDB 10.0 to 10.3.9 on Ubuntu 16.04. We are now going to provide insight on upgrading MariaDB 10.0.X to 10.3.X on a CentOS 7 server. Continue reading “Update MariaDB from 10.0 to 10.3 on CentOS 7”
Reading Time: 6 minutesIf you are still using Ubuntu version 16.04, you may want to consider updating to the latest Long Term Support release, version 18.04. In this post, we will cover what a Long Term Support release is and why you would want to use it. You will also learn the significant changes between 16.04 and 18.04. Last, but not least, you will also learn how to upgrade your server from Ubuntu 16.04 to Ubuntu 18.04.
Reading Time: 2 minutesWP-CLI is a very handy set of commands. You can run anything that you would run in wp-admin on a WordPress site but from the command line. Useful commands which WP-CLI employs to keep WordPress core updated plugins including the default themes which come with WordPress.
Reading Time: 3 minutesMariaDB is quickly becoming the de facto open-source database software to use in development, production, and even enterprise environments. Our very own Cloud Sites product uses the newest in MariaDB as it’s mostly known for being a fork and drop-in replacement to MySQL, which is created and maintained by the original MySQL developers.
Reading Time: 16 minutesAs we explored in our previous article of our MySQL Perfomance Series: MySQL vs. MariaDB there are very few downsides to using MariaDB over standard MySQL. Our high-availbility MariaDBs have proven itself to be a worthy successor with easily migitated drawbacks. As the last article in our series we will focus on upgrading to various MySQL and MariaDB version on the following servers:
- MySQL to MariaDB on CentOS 6/7 with cPanel
- MySQL to MariaDB on CentOS 7 with Plesk Onyx 17
- MySQL 5.1-5.5 to MariaDB 5.5 on CentOS 6
- MariaDB 5.5 to MariaDB 10.0 on CentOS 6
Reading Time: 3 minutes
PHP is a programming language that can run with Apache or Microsoft IIS and works with your server to execute the requests that make up your website. 88% of online sites run on, soon to be vulnerable PHP 5.X technology. At the close of this year, scheduled by Dec 31, 2018 security support will end for our dear old friend PHP 5.6, meaning bugs and security fixes will not be tended to and could lead to security vulnerabilities. Each PHP version gets supported actively for two years while the third year only gets critical security updates. Luckily, the PHP gods had smiled upon us and extended the life for just a year longer than the typical PHP version before giving us the new year deadline. For all of you developers out there wanting to know exactly what is changing, here’s a helpful migration guide from PHP 5.6 to PHP 7.X.