On Fri, Jun 19, 2015 at 12:34 PM, Tom Worster wrote:
> Thanks Geoff, I never would have though of this without your mentioning it.
>
> Unless I think there might be defects in my tables, do you think there's a
> need to run mysql_upgrade for 10.0.15 -> .19?
>
There's not usually a need to run mys
I would also recommend setting wsrep_OSU_method to RSU before running
mysql_upgrade on each node.
Honestly I don't normally run mysql_upgrade for minor version changes, but I
probably should and the docs do recommend doing so:
https://mariadb.com/kb/en/mariadb/mysql_upgrade/. With the ability f
I agree the wording is a little confusing but you are correct that the server
will decide between IST and SST based on whether galera.cache is large enough
to hold the write sets that occur during the upgrade. Note that if an SST is
required then the changes to the table structure made by mysql_
Thanks Geoff, I never would have though of this without your mentioning it.
Unless I think there might be defects in my tables, do you think there's a
need to run mysql_upgrade for 10.0.15 -> .19?
Tom
From: Geoff Montee
Date: Friday, June 19, 2015 at 1:22 PM
To: Tom Worster
Cc: maria-discu
Thanks Guillaume.
The doc says
> Unless you use Incremental State Transfer, as you bring each node back online
> after an upgrade, it initiates a full State Snapshot Transfer, which can take
> a long time to process on larger databases and slower state transfer methods.
The wording suggests that
Hi Tom,
On Fri, Jun 19, 2015 at 9:55 AM, Tom Worster wrote:
> Can I upgrade a production cluster from 10.0.15 to 10.0.19 while the cluster
> remains in service, upgrading one node at a time?
>
Yes, you can do this. If you plan to run mysql_upgrade on each node
after upgrading, you may want to se
Yes.
http://galeracluster.com/documentation-webpages/upgrading.html
2015-06-19 18:55 GMT+02:00 Tom Worster :
> Can I upgrade a production cluster from 10.0.15 to 10.0.19 while the
> cluster remains in service, upgrading one node at a time?
>
> ___
> Mai
Can I upgrade a production cluster from 10.0.15 to 10.0.19 while the cluster
remains in service, upgrading one node at a time?
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://l
Hi
On Fri, 2015-06-19 at 10:59 +0200, Benoit Panizzon wrote:
> Hi all
>
> I stumbled over that problem, while trying to graph mail traffic..
>
> I have two different counters for emails sent with authentication and
> without.
> Aggregated per hour.
>
> I would like to total the both values pe
“you have to use GROUP BY for it to work as expected.”
Not in this case you don’t. There’s no value in the SELECT to group by.
From: Maria-discuss
[mailto:maria-discuss-bounces+rhys.campbell=tradingscreen@lists.launchpad.net]
On Behalf Of Guillaume Lefranc
Sent: 19 June 2015 10:03
To: Benoi
Hello Benoit,
It might be useful to supply your table definitions. I did the following test
and I can't find a problem. I am using 10.0.19-MariaDB.
CREATE TABLE t1
(
col1 INT, # have also tried defined as VARCHAR. No problem either.
col2 INT
);
INSERT INTO `t1` (`col1`, `col2`
Hi Benoit,
MAX() is an aggregate function, you have to use GROUP BY for it to work as
expected.
e.g. select MAX(mail_out_anon+mail_out_auth) FROM domaincounters GROUP BY
timefunction;
Hope this helps
-Guillaume
2015-06-19 10:59 GMT+02:00 Benoit Panizzon :
> Hi all
>
> I stumbled over that probl
Hi all
I stumbled over that problem, while trying to graph mail traffic..
I have two different counters for emails sent with authentication and without.
Aggregated per hour.
I would like to total the both values per row, to create a graph of outgoing
emails per hour.
MariaDB [maildb]> select
13 matches
Mail list logo
