Re: can't start mariadb with client certs specified

f I'm not mistaken that's all that Master/Master is? Is there anything else I need to worry about really, in terms of achieving HA? Not sure if I'm oversimplifying this Thanks, Tim On Wed, Jul 22, 2015 at 10:38 AM, Reindl Harald wrote: > > > Am 22.07.2015 um 16:24 sch

Re: can't start mariadb with client certs specified

---+---+ 9 rows in set (0.00 sec) Can you please help me out with this one as well? Thanks, Tim On Wed, Jul 22, 2015 at 4:31 AM, Reindl Harald wrote: > > > Am 22.07.2015 um 06:39 schrieb Tim Dunphy: > >> Hey guys, >> >> I'm trying to setup

can't start mariadb with client certs specified

Hey guys, I'm trying to setup multi master replication using SSL under MariaDB 10.20. I've been able to specify my client certs on the second node (db2) with no issue and start up the mysql service. But for some reason when I do the same on the first node (db1) the mysql service takes a really lo

Re: can't authenticate ssl user account

/client-cert.pem ssl-key=/opt/mysql/client-key.pem Any idea why that's happening or how to correct it? Thanks, Tim On Tue, Jul 21, 2015 at 4:25 AM, Reindl Harald wrote: > > Am 21.07.2015 um 05:03 schrieb Tim Dunphy: > >> I see absolutely NO indication as to why the login for th

can't authenticate ssl user account

Hey all, I need to setup replication via SSL. 2 nodes master/master for H/A. Then 2 slave nodes for backup. Node 3 will slave off of node 1, and node 4 will slave off of node 2 for redundant backups. Nodes 3 & 4 will store backups to a directory mapped to S3 via S3FS. All nodes are physical. We'

Re: alter table modify syntax error

; version of the alter table syntax from. Definitely not sweatin' this detail tho, I am totally fine with what you showed me that works. Thanks again for your input! Tim On Sat, Jun 28, 2014 at 9:14 PM, Jesper Wisborg Krogh wrote: > Hi Tim, > > > -Original Message- >

Re: alter table modify syntax error

M, Jesper Wisborg Krogh wrote: > Hi Tim, > > > -Original Message- > > From: Tim Dunphy [mailto:bluethu...@gmail.com] > > Sent: Sunday, 29 June 2014 03:45 > > Cc: mysql@lists.mysql.com > > Subject: Re: alter table modify syntax error > > > > Hey guys

Re: alter table modify syntax error

l(7,2) | YES | | NULL|| ++--+--+-+-++ 7 rows in set (0.01 sec) I appreciate your suggestions so far and it would be great if I could get some help with this one too. Thanks Tim On Sat, Jun 28, 2014 at 1:34 PM, Tim Dunphy wrote: > Cool guys, that did it.. > >

Re: alter table modify syntax error

ote: > On 28-06-2014 19:11, Tim Dunphy wrote: > >> Hello, >> >> I'm trying to use a very basic alter table command to position a column >> after another column. >> >> This is th

alter table modify syntax error

Hello, I'm trying to use a very basic alter table command to position a column after another column. This is the table as it exists now: mysql> describe car_table; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--

mysql failed login attempts

hello, currently my php app is failing logins to it's mysql database. My config file is set like this: [mysqld_safe] general-log=1 general-log-file=/var/log/mysqld-general.log log-output=/var/log/mysqld-general.log log=/var/log/mysqld.log log-error=/var/log/mysqld-error.log pid-file=/var/run/mys

Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted

Why not use a load balancer such as HA/Proxy as a way of maintaining high availability on your mysql nodes? http://blogs.reliablepenguin.com/2011/03/31/mysql-load-balancing-with-haproxy http://linuxadminzone.com/how-to-install-setup-and-config-haproxy-loadbalancer-for-content-switching/ http://

Re: delete all hosts using a wildcard

ice I intend to use. Best tim - Original Message - From: "Paul DuBois" To: "Tim Dunphy" Cc: mysql@lists.mysql.com Sent: Saturday, January 14, 2012 6:46:38 PM Subject: Re: delete all hosts using a wildcard On Jan 14, 2012, at 5:23 PM, Tim Dunphy wrote: > hello l

Re: delete syntax

luding enough information last time. best tim - Original Message - From: "Krishna Chandra Prajapati" To: "Tim Dunphy" Cc: mysql@lists.mysql.com Sent: Thursday, December 1, 2011 9:03:46 PM Subject: Re: delete syntax delete from mysql.user where user='mail_admin'

delete syntax

hello list, I am attempting to delete a user from the mysql.user table without success. mysql> delete from mysql.user where user='mail_admin@%'; Query OK, 0 rows affected (0.00 sec) mysql> select user,host from mysql.user where user='mail_admin'; ++---+ | u