Sorry I don’t know because I’ve already downgraded to
2.2.9.
Version 3.x wasn’t stable under Ubuntu 14.04 and I don’t have
enough time to play with it and I need a working radius server in
production environment :)
(I tried 3.0.3, 3.0.8, 3.0.9).
Because somebody asked for it on Freenode:
CREATE FUNCTION DATE_TRUNC(field ENUM('microsecond', 'millisecond', 'second', 'minute', 'hour', 'day', 'week', 'month', 'quarter', 'year', 'decade', 'century', 'millennium'), source datetime(6)) RETURNS datetime(6) DETERMINISTIC BEGIN IF field IN ('millisecond') THEN SET source = source - INTERVAL MICROSECOND(source) % 1000 MICROSECOND; END IF; IF field NOT IN ('microsecond', 'millisecond') THEN SET source = source - INTERVAL MICROSECOND(source) MICROSECOND; END IF; IF field NOT IN ('microsecond', 'millisecond', 'second') THEN SET source = source - INTERVAL SECOND(source) SECOND; END IF; IF field NOT IN ('microsecond', 'millisecond', 'second', 'minute') THEN SET source = source - INTERVAL MINUTE(source) MINUTE; END IF; IF field NOT IN ('microsecond', 'millisecond', 'second', 'minute', 'hour') THEN SET source = source - INTERVAL HOUR(source) HOUR; END IF; IF field NOT IN ('microsecond', 'millisecond', 'second', …[Read more]
Wed, 2015-10-07 17:43Roger Levy
At this week’s re:Invent conference, Amazon Web Services (AWS) announced it is joining the MariaDB community with the introduction of its Relational Database Service (RDS) for MariaDB. Amazon’s decision was driven by the growing demand among its customers for MariaDB, which now has over two million users in 45 countries.
The new offering will provide additional options for how users can deploy and consume MariaDB. Companies can leverage the AWS MariaDB offering for cloud-based managed database services or for building hybrid cloud/premises architectures for cloud bursting and disaster recovery. Look for additional announcements from MariaDB in the near future about cloud based deployment options that can further enable these architectures.
For companies choosing to leverage the AWS service, MariaDB can provide help and support in areas such as:
- Optimized high-performance …
Complimenting the expanded CREATE USER
syntax introduced in
MySQL Server 5.7.6 is more useful ALTER USER
syntax.
Before MySQL Server 5.7.6, ALTER USER
could only be
used to expire a user’s password. That’s pretty limited.
With changes made in MySQL Server 5.7.6, a better
distinction is made between privilege-level attributes (those
which are managed via GRANT
and REVOKE
statements) and account-level attributes (those managed using
CREATE USER
and ALTER USER
statements).…
We love developer conferences, they are informative, fun and a great way to network with like minded people. The sessions can help you and your organization discuss and address technology challenges, learn how others are solving problems and exchange knowledge. Even if you can’t make it, most of these conferences are streamed online. Here are the 5 DevOp conferences you should consider attending.
The annual cloud conference, by market leaders themselves, is an event which is jam-packed and sold out, months before the actual event. Amazon Web Services (AWS) knows the importance of educating and constantly innovating on the cloud and encourages organizations to migrate their IT infrastructure to embrace the cloud. AWS re:Invent 2015 has a mammoth 313 sessions with 491 speakers. This event should top any DevOp’s list.
…
[Read more]We love developer conferences, they are informative, fun and a great way to network with like minded people. The sessions can help you and your organization discuss and address technology challenges, learn how others are solving problems and exchange knowledge. Even if you can’t make it, most of these conferences are streamed online. Here are the 5 DevOp conferences you should consider attending.
The annual cloud conference, by market leaders themselves, is an event which is jam-packed and sold out, months before the actual event. Amazon Web Services (AWS) knows the importance of educating and constantly innovating on the cloud and encourages organizations to migrate their IT infrastructure to embrace the cloud. AWS re:Invent 2015 has a mammoth 313 sessions with 491 speakers. This event should top any DevOp’s list.
…
[Read more]Any idea how to make work if freeradius is all ready installed?
Next week, all the MariaDB Server developers will descend to Amsterdam for the developer’s meeting. As you know the meeting is open to all interested parties, so we hope to see you in Amsterdam Tuesday Oct 13 – Thursday Oct 15. The schedule is now online as well.
In addition to that, Monday Oct 12 2015, there is also a meetup planned with the MySQL User Group NL. As the organiser Daniël van Eeden wrote, this is a one of a kind meetup: “This is a very unique event, it is not often possible to find so many MariaDB developers together and speaking about what they work on.”
Yes, we’re doing it lightning talk …
[Read more]Introduction
The purpose of this article is to describe how Galera Cluster multi-master replication provides high availability for MySQL beyond simply replicating all updates to multiple nodes.
High availability has multiple dimensions, such as being able to detect and tolerate failures in individual components and be able to recover quickly. We will discuss the different failure modes that can happen in a cluster and how Galera facilitates the detection and recovery from each situation.
Your load balancer and application may be governed by different timeouts and recovery mechanisms, but an operational Galera Cluster will provide a stable foundation to recover the rest of your infrastructure in case of a widespread outage.
Failures of Individual Nodes
Synchronous replication requires the participation of all nodes but a Galera Cluster will detect and automatically remove a node that has gone down within …
[Read more]
Cross-posted on Google Cloud Platform Blog.
Cloud native
technologies like Kubernetes help you compose scalable services out
of a sea of small logical units. In our last post, we introduced Vitess (an open-source
project that powers YouTube's main database) as a way of turning
MySQL into a scalable Kubernetes application. Our goal was to
make scaling your persistent datastore in Kubernetes as simple as
scaling stateless app servers - just run a single command to
launch more …