How To Install Nginx With PHP And MySQL (LEMP Stack) On CentOS 7
Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a CentOS 6.5 server with PHP support (through PHP-FPM) and MySQL (Mariadb) support.
Mon, 2014-07-21 09:00carlaschroder
It's time to get to know four of the most commonly used
administration commands for your MariaDB server:
mysql, mysqladmin,
mysqldump, and mysqlimport.
The examples run these commands on the server rather than over the network. You'll be prompted for your password; if you want to save a few keystrokes you can record your password in a configuration file, which also solves the problem of how to pass a password if you want to use any of these commands in an unattended script. Doubtless you're aware of how to pass in your password directly in your commands, but doing this creates a security hole because it records your passwords in your shell …
[Read more]MySQL Replication allows servers to copy changes from one instance to another. Take the MySQL for Database Administrators course to learn about replication, including:
Replication is one of the many topics covered in the MySQL for Database Administrators course. You can take this 5-day instructor-led course as
I recently worked on a case where one node of a Galera cluster had its schema desynchronized with the other nodes. And that was although Total Order Isolation method was in effect to perform the schema changes. Let’s see what happened.
Background
For those of you who are not familiar with how Galera can perform schema changes, here is a short recap:
wsrep_OSU_method setting. Both have benefits and
drawbacks, it is not the main topic of this post.
When you send a query to MySQL, you usually don’t need to think explicitly about the types of the expressions in your query. If you compare this to a lot of programming languages, you’ll find that it’s not always the way things work. In strongly typed languages like Java, for example, typing is very strict.
In this respect, MySQL is much more like a dynamically typed language such as PHP or Perl — a DWIM (do what I mean) typing system. Yet, internally, every expression in MySQL has a type, and it does conversions amongst them as needed.
Sometimes, you might wonder how does this query work and exactly what’s happening to the variables in these expressions? Importantly, does it always work right?
Examples of MySQL Type Conversion
Let’s look at MySQL in action and see if we can figure out how it’s handling expression types. I’ll start with a simple example: it’s actually possible to add a …
[Read more]Place your bets now – it’s gonna be a good fight. The cloud is the arena where the next big tech giant battles will be taking place.. We’ll have to sit down as watch as the go head-to-head to win the customers who have started the mass migration to the cloud.
If you are thinking of migrating your databases to cloud, your vote will count towards determining the winner. As you evaluate your options, we suggest you consider these guys first and foremost.
In a comment on my post about Using SSL with MySQL xiaochong zhang asked if
it is possible to decode SSL/TLS encrypted MySQL traffic. The
short answer is: It depends.
To test this we need a MySQL server which is SSL enabled. I used
MySQL Sandbox to create a sandboxed 5.6.19 server. Then I used
mysslgen to create the config and the
certificates.
$ make_sandbox 5.6.19
$ ./mysslgen.py --config=sandboxes/msb_5_6_19/my.sandbox.cnf --ssldir=sandboxes/msb_5_6_19/ssl
This assumes there already is a extracted tarball of MySQL 5.6.19
in ~/mysql/5.6.19
The mysslgen.py script will return a message with the changes you
should make in your mysqld and client sections of the
my.sandbox.cnf file. Then restart the server to make …
MariaDB 10.1.0 was recently released, and is available for download here:
https://downloads.mariadb.org/mariadb/10.1.0/
This is the first alpha release of MariaDB 10.1, so there are a lot of new changes and functionalities added, which cover a wide variety of areas such as: Performance, InnoDB/XtraDB, WebScaleSQL, Optimizer, Security, Storage Engine functionality, & Administration Improvements.
These are 9 of the most notable changes in MariaDB 10.1.0 (but do check out the release notes and changelogs below for the full list of changes):
We are pleased to announce that MySQL Enterprise Monitor 3.0.13 is now available for download on the My Oracle Support (MOS) web site. It will also be available via the Oracle Software Delivery Cloud in a few weeks. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log.
You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet.
You will also find the binaries on the Oracle Software Delivery Cloud in a few weeks. Choose "MySQL Database" as the Product Pack and you will …
[Read more]
I addressed the secure_auth errors before when it blocks
replication in this blog post.
However, I figured I would make this blog post a more general fix
when connecting via MySQL clients. This is for servers before
MySQL 5.6.
So if you get a secure_auth error when connection to MySQL the
following steps should clear this error.
+---------------+-------------------------------------------+
| User |
Password
|
+---------------+-------------------------------------------+
| authdtestuser | …