In MySQL 5.7.6 we’ve done some major spring cleaning within the GIS function namespace. We have deprecated 66 function names and added 13 new aliases. Please see the release notes for a complete list of all the changes. But why have we done this, and what impact does this have for you?
Standardization
GIS is a growing area, and to keep MySQL up to speed we have made the GIS namespace more SQL/MM compliant. …
[Read more]The MariaDB Foundation Board has been meeting monthly since February and on Monday this week had the third meeting of the year. Here is an update on a couple of things from the meeting.
We’re happy to announce that Booking.com has renewed their support to the foundation. As a major corporate sponsor Booking.com has been offered a seat on the Foundation board. Booking.com nominated Eric Herman. Eric has a history with MySQL dating from 2004 where he joined MySQL working on the server and tools. In 2010, Eric joined Booking.com where he works on database scaling challenges and BigData. As a community member, he has contributed to the perl MySQL client driver, the perl interpreter, and other Free Software. To represent community and industry interests in line with the Foundation mission, Eric Herman has joined the Board.
…[Read more]Today, a lot of CMS are existing, WordPress, Joomla, Magento, and others, in this blog I will share my experience Concrete5 through a web agency specialized based in Geneva: 8 Ways Media
Not only a CMS (Content Management System) open source based on a
webserver, it is coded in PHP using a MySQL database, but also
it's a great Framework for developers. A simplified system
(optional), URL rewriting is present to increase the performance
of indexing sites from search engines.
C5 can also be used in the development of Web applications.
C5 also provides, through its content management and user rights,
create intranets for companies (small scale in my opinion, it is
better for an …
MySQL replication is among the top features of MySQL. In
replication data is replicated from one MySQL Server (also knows
as Master) to another MySQL Server(also known as Slave). MySQL
Binlog Events is a set of libraries which work on top of
replication and open directions for myriad of use cases like
extracting data from binary log files, building application to
support heterogeneous replication, filtering events from binary
log files and much more.
All this in REAL TIME .
INTRODUCTION
I have already defined what MySQL Binlog Events is, to deliver on
any of the above use-cases, you first need to read the event from
the binary log. This can be done using two types of transports:
1) TCP transport: Here your application will connect to an online MySQL Server and receive events as and when they occur.
2) File transport: As the name suggests the application will connect to an …
[Read more]In November last year I announced a program I wrote called pstop. I hope that some of you have tried it and found it useful. Certainly I know that colleagues and friends use it and it has proved helpful when trying to look inside MySQL to see what it is doing. A recent suggestion provoked me … Continue reading new to pstop – vmstat style stdout interface
This tutorial shows how to install an Ubuntu 15.04 (Vivid Vervet) server (with Apache2, BIND, Dovecot) for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: Apache or nginx web server, Postfix mail server, Courier or Dovecot IMAP/POP3 server, MySQL, BIND or MyDNS nameserver, PureFTPd, SpamAssassin, ClamAV, and many more. This setup covers the installation of Apache (instead of nginx), BIND (instead of MyDNS), and Dovecot (instead of Courier).
by Erkan Yanar
Docker is an open platform for developers and sysadmins to build, ship, and run distributed applications. Consisting of Docker Engine, a portable, lightweight runtime and packaging tool, and Docker Hub, a cloud service for sharing applications and automating workflows, Docker enables apps to be quickly assembled from components and eliminates the friction between development, QA, and production environments. As a result, IT can ship faster and run the same app, unchanged, on laptops, data center VMs, and any cloud.
This is the first of a series of blog posts about using Galera with Docker. In this post, we are going to get started with Docker and Galera:
* Build a basic Docker Image (which we will extended in later posts)
* Deploy on a test cluster on a local machine
The instructions have been tested on Ubuntu 14.04 with Docker 1.5.
Build a basic Docker image
In …
[Read more]Codership will be joining OpenStack Summit Vancouver May 18-22. Visit our booth T52. Codership will have demo theater presentation about Galera in cloud, Time Warner Cable will tell how they use Galera and MariaDB gives best practises to use MariaDB Galera Cluster.
OpenStack Summit is the must-attend OpenStack event. The OpenStack Summit is a five-day conference for developers, users, and administrators of OpenStack Cloud Software. It’s a great place to get started with OpenStack.
Codership’s demo theater presentation at Vancouver:
Do More with Galera Cluster in Your OpenStack Cloud
Galera Cluster is already the way to achieve active/active HA for OpenStack back-end databases. Yet, it is possible to do a great deal more: Galera can provide cloud user with a fully redundant database cluster in place of the traditional …
[Read more]VividCortex, the monitoring solution for the modern data system, continues building a product that enables IT departments to manage distributed, diverse systems effectively and improve workflow.
Charlottesville, Virginia (PRWEB) May 05, 2015 - VividCortex, the monitoring solution for the modern data system, received the MySQL Community Award for Application of the Year at Percona Live 2015. Since launching in April 2014, the SaaS product for database monitoring has provided unparalleled query insight and given customers a clear view of what is happening on their production servers, allowing companies to improve application and server performance and maximize resources. This award recognizes the new standard for database monitoring, one that goes beyond graphs and charts to provide actionable data. VividCortex will continue to build a service that enables IT teams to manage distributed systems and continuous workflows …
[Read more]In the MySQL Labs version of MySQL version 5.7, there is a new HTTP plugin. The HTTP plugin documentation from the labs site provides this information (from MySQL Labs):
The HTTP Plugin for MySQL adds HTTP(S) interfaces to MySQL. Clients can use the HTTP respectively HTTPS (SSL) protocol to query data stored in MySQL. The query language is SQL but other, simpler interfaces exist. All data is serialized as JSON. This version of MySQL Server HTTP Plugin is a Labs release, which means it’s at an early development stage. It contains several known bugs and limitation, and is meant primarily to give you a rough idea how this plugin will look some day. Likewise, the user API is anything but finalized. Be aware it will change in many respects.
In …
[Read more]