The LEMP stack is a web development platform for hosting static and dynamic websites. It is a combination of free ...
The post How to Install LEMP on Ubuntu 18.04 appeared first on RoseHosting.
Feb
28
2019
Feb
20
2019
In this tutorial, we will show you how to install and improve the security of MySQL on Ubuntu 18.04. MySQL ...
The post How to Install MySQL on Ubuntu 18.04 appeared first on RoseHosting.
May
31
2018
Let us show you how to install MySQL on your CentOS 7 server. MySQL is a relational database management system ...
The post How to Install MySQL on CentOS 7 appeared first on RoseHosting.
Feb
21
2018
The conference session schedule for the seventh annual Percona Live 2018 Open Source Database Conference, taking place April 23-25 at the Santa Clara Convention Center in Santa Clara, CA is now live and available for review! Advance Registration Discounts can be purchased through March 4, 2018, 11:30 p.m. PST.
Percona Live Open Source Database Conference 2018 is the premier open source database event. With a theme of “Championing Open Source Databases,” the conference will feature multiple tracks, including MySQL, MongoDB, Cloud, PostgreSQL, Containers and Automation, Monitoring and Ops, and Database Security. Once again, Percona will be …
[Read more]
Feb
08
2018
Percona has revealed the line-up of in-depth tutorials for the Percona Live 2018 Open Source Database Conference, taking place April 23-25, 2018 at the Santa Clara Convention Center in Santa Clara, Calif. Secure your spot now with Advanced Registration prices (available until March 4, 2018). Sponsorship opportunities for the conference are still available.
Percona Live 2018 Open Source Database Conference is the premier open source database event. The theme for the upcoming conference is “Championing Open Source Databases,” with a range of topics on …
[Read more]
Aug
20
2017
Duration: 30 min
Level: Intermediate
In this tutorial we are going to install and experiment with Dynimize using MySQL running the Sysbench OLTP benchmark. We also play around with the Linux perf command, top and vmstat. This tutorial assumes that you have MySQL and the Linux perf tool installed, and that there are no other CPU intensive workloads on the system other than those being tested. In order for the Linux perf tool to report CPU event counts, this tutorial should be completed on either a bare metal Linux server, or if using a virtual machine guest then virtual PMU support must be enabled by the hypervisor.
The initial part of this tutorial is meant to illustrate how to determine if there is potential for Dynimize to speedup a mysql (or any other program) workload, by checking to …
[Read more]
Apr
25
2017
Welcome to the first day of the Percona Live Open Source Database Conference: Percona Live 2017 tutorials day! While technically the first day of the conference, this day focused on provided hands-on tutorials for people interested in learning directly how to use open source tools and technologies.
Today attendees went to training sessions taught by open source database experts and got first-hand experience configuring, working with, and experimenting with various open source technologies and software.
The first full day (which includes opening keynote speakers and breakout sessions) starts Tuesday 4/25 at 9:00 am.
Some of the …
[Read more]
Mar
01
2017
We’ll show you, how to secure LEMP stack. LEMP, it stands for Linux, (EngineX) NGINX, MariaDB (or MySQL) and PHP. Due to its flexibility and simplicity, NGINX slowly takes over the Internet. In this tutorial, we will attempt, through examples of bad and good practices, to go through the steps of properly securing your Linux web server. […]
Jan
26
2017
SQL databases tend to be rigid.
If you have worked with them, you would agree that database design though it seems easier, is a lot trickier in practice. SQL databases believe in structure, that is why it's called structured query language.
On the other side of the horizon, we have the NoSQL databases, also called schema-less databases that encourage flexibility. In schema-less databases, there is no imposed structural restriction, only data to be saved.
Though every tool has it's use case, sometimes things call for a hybrid approach.
What if you could structure some parts of your database and leave others to be flexible?
MySQL version 5.7.8 introduces a JSON data type that allows you to accomplish that.
In this tutorial, you are going to learn.
- How to design your database tables using …
Dec
14
2016
We’ll show you, how to set up MySQL Cluster on Ubuntu. The MySQL NDB Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (Network DataBase). We will use a total of 4 virtual servers, one for the management, one SQL node and two data nodes: 172.16.1.1 – management VPS 172.16.1.2 […]