Hi,
1) Shutdown the MySQL and have a backup of data directory.
2) Replace the MySQL binary files.
3) start the MySQL server with the old data directory.
4) Run the mysql_upgrade to fix the internal tables.
Go with mysql 5.1 to MySQL 5.5. Then move on to MySQL 5.6. MySQL 5.7 will
be GA by next wee
You can force all the the users to use SSL by enabling "ssl-only" on the
mysql config ( /etc/my.cnf ) and enabling SSL in user creation ( REQUIRE
SSL ). Make sure that you application has the client certs installed.
The below query will provide you the list of users who do not have SSL
( REQUIRE
S
We work on a Galera cluster with 1.5 TB data on each node. Galera is
synchronous and you do not need a management node .
Reducing your Isolation level will reduce the deadlock in Galera.
More over Galera uses the standard InnoDB engine for operations and NDB is
completely a different engine with
Rajesh,
You need an alternative to MySQL NDB cluster or MySQL Cluster Manger NDB.
NDB Cluster is more enterprise oriented. If you need an HA cluster in MySQL
please try out Galera Cluster for MySQL.
Regards,
karthik.P.R
http://remotemysqldba.blogspot.in/
Regards,
KarthiK.P.R
On Wed, Apr 22,
Tue, Mar 31, 2015 at 2:04 PM, Ajeesh Kannan
wrote:
> Hi Karthik,
>
> Thank you for your update.
>
> My mysql server is running with old version 5.1 and it is hard to upgrade
> at the moment.
>
> On Mon, Mar 30, 2015 at 5:48 PM, P.R.Karthik wrote:
>
> > Hi ,
> &
Hi ,
The slave lag for a few seconds is common. It might be heavy writes on
master delaying the replication. As replication in MySQL is single threaded
it can happen ( Hope you are not using Multi threaded replication in MySQL
5.6 ).
What is the binglog format ?
Is the queries are tuned along wit
Hi Ravi,
I am a MySQL DBA. If you have any doubts do not hesitate to ask me.
Regards,
KarthiK.P.R
On Tue, May 20, 2014 at 8:55 PM, Thyagarajan தியாகராஜன் <
citizenof...@gmail.com> wrote:
> Hi Ravi,
>
> Do not top post.
> To know what is top posting please refer
> http://ilugc.in/mailinglist-g