Installing Apache2 With PHP5 And MySQL Support On OpenSUSE 13.1 (LAMP)
LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an OpenSUSE 13.1 server with PHP5 support (mod_php) and MySQL support.
MySQL is the proud Training Sponsor of PHPTek. This is a great event and I am speaking on Exploiting New MySQL Features on the morning of the 23rd. See you at training day on the 19th!
And do not forget the Chicago MySQL Users Group meeting on the 21st. Yes, there will be pizza at 6:30 but RSVP so we know how much to order.
Oracle Offices
233 South Wacker Dr.
45th Floor
Chicago, IL
Very happy to see this announcement “MySQL 5.6 now available in Cloud SQL: full text search, geospatial queries and online schema changes.”
Foreign Keys are often a mystery to new DBAs in the MySQL world. Hopefully this blog will clear some of this up.
In this example, we will have a table for employee data and a
table for the data on offices. First we need the two
tables.
CREATE TABLE employee (
-> e_id INT NOT NULL,
-> name CHAR(20),
-> PRIMARY KEY (e_id)
-> );
CREATE TABLE building (
-> office_nbr INT NOT NULL,
-> description CHAR(20),
-> e_id INT NOT NULL,
-> PRIMARY KEY (office_nbr),
-> FOREIGN KEY (e_id)
-> REFERENCES employee (e_id)
-> ON UPDATE CASCADE
-> ON DELETE CASCADE);
Those who do not use Foreign Keys will not be familiar with the last four lines of the building table. The trick is that there are two e_id columns, one in each table. In the employee table …
[Read more]
MariaDB 10.0 had a stable release last month. It is a good time
to take a look and see how it compares to the stable version of
MySQL, MySQL 5.6 (as for Percona Server, it doesn’t have its own
optimizer features).
Changelogs and release notes have all the details, but it’s
difficult to see the big picture. So I went for diagrams, and the
result is a short article titled What is the difference between MySQL and MariaDB
query optimizers. It should give one a clue about what are
the recent developments in query optimizers in MySQL world.
In case you’re interested in details about optimizer features in MariaDB 10.0, I’ve shared slides from a talk about MariaDB 10.0 query optimizer.
There are a couple of posts about setting up Percona XtraDB Cluster on Vagrant and Percona Server on MySQL Sandbox – those are two of the top tools used by the Percona Support team for testing and bug processing among other things.
In this post, however, I will show you how to use Docker with Percona Server on Ubuntu 12.04.
As per Docker’s official site:
Docker is an open-source engine that automates the deployment of any application as a lightweight, portable, self-sufficient container that will run virtually anywhere.
Docker containers can encapsulate any payload, and will run …
[Read more]#DBHangOps 05/15/14 -- MySQL Fabric!
You can watch the recording below:
Hello everybody!
Join in #DBHangOps this Thursday, May, 15, 2014 at 11:00am pacific (18:00 GMT), to participate in the discussion about:
Be sure to check out the #DBHangOps twitter search, the @DBHangOps twitter feed, or this blog post to get a link for the google hangout on Thursday!
See all of you on Thursday!
Helpful Resources for MySQL Fabric
Choosing the right database to drive your business-critical applications can be a daunting task. Unlike several years ago when MySQL dominated the open-source market, companies today now have dozens of choices when it comes to open-source databases. MySQL is still one of the most popular options, but a new class of solutions has emerged—NoSQL—and it’s gaining popularity and delivering surprising results.
This white paper provides a high-level overview of the characteristics of relational (MySQL) versus non-relational (NoSQL) open-source databases along with a detailed comparison of how each one approaches scalability, performance, and data modeling. The purpose of this paper is to help companies understand the differences between the databases and know what to look for when choosing a solution best suited to their environment.
Please fill out the form to download this whitepaper.
The post …
[Read more]The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.11. This is a Stable (GA) release.
See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 10.0? page in the MariaDB Knowledge Base for general information about the MariaDB 10.0 series.
[Read more]The PHP UnConference is taking place on May 17-18, 2014 on the Island of Majorka. MySQL team is going to be presented by Ulf Wendel at this event. As usual for all UnConferences there is no sessions/talks schedule announced prior the conference, attendees might vote for the most interesting topics at the event. So, do not miss to come to PHP UnConference at lovely Island of Majorka!! (in the case you still do not know whether come or not, maybe the price of tickets, weather forecast and/or flight ticket from several locations might convince you...).
The Solutions Linux & OpenSource …
[Read more]