mysql | Linuxaria

Install MariaDB Galera Cluster on Ubuntu 16.04

Dec 112017

Today I’m glad to publish a guest post about Galera a software that I’ve used in the past to manage a multi-master mysql cluster:

MariaDB Galera Cluster is a multi-master cluster for MariaDB. MariaDB Galera Cluster currently supports only the InnoDB/XtraDB storage engine. It is mostly used for database redundancy as it consists of multiple master servers that are synchronized and connected to each other. In today’s tutorial we are going to learn how to install MariaDB Galera Cluster on a clean Ubuntu 16.04 VPS, on optimized MariaDB hosting.

Supercharge WordPress, Part 1

Articles, Guides No Responses »

Mar 052012

This article of mine has been original published on Wazi

WordPress, the popular content managing system (CMS), is easy to set up and use, and well supported by both its community and professional consultants. WordPress depends upon a complete stack that comprises an operating system, database, web server, and PHP. If you can optimize this stack, you can enhance the performance of your site. Here are some tricks and best practices for a setup that will improve your throughput without forcing you to upgrade your hardware.

Let’s start with a look at the Linux operating system, MySQL database, and nginx web server. Later we’ll get to PHP, some setup and plugin work with WordPress itself, and Varnish Cache, a web application accelerator.
Continue reading »

Permanent SSH Tunnels with autossh

Guides 14 Responses »

Nov 212011

Article by Truelite.it already published on their useful wiki (in Italian)

There are many occasions where you need to create connections to machines and services that are protected by firewalls because it is appropriate to adequately protect them, but for which the creation of a VPN becomes an excessive burden.

For this reason, the ability to port forwarding via SSH is very useful for creating an encrypted tunnel from one machine to another, allowing you to enable only local access (such as a MySQL only listens locally) safely, with the only the problem that in case of problems, the SSH connection (and its tunnels) could fall.

Monit – your best employee

06/11/2011
Monit – your best employee
Posted by linuxari at 19:15
1 Response
Guides
Tagged with: linux, monit, monitor, mysql, nginx, ssh

If you are in charge of some services probably you have set up some monitoring system to notify you if something go wrong (email, sms or a Tweet), and so you can fix it quickly. But do you really want to be always available 24×7 every day of the year ? I’m not for sure, […]

Oracle World Domination

09/17/2010
Oracle World Domination
Posted by linuxari at 23:40
No Responses
Articles
Tagged with: java, linux, mysql, open source, openoffice, oracle

Oracle Open world is starting once again in San Francisco, gathering more and more public every year, that’s perhaps normal considering that oracle is buying a new big company every year. Oracle OpenWorld is the world’s largest and most important conference for Oracle technologists, business users, and partners. Perhaps you think: i’m not intested in Oracle […]