The tutorial guides you through MySQL Database connectivity with Entity Framework
We are facing entity framework database provider compatible with version could not be found for your data connection issue while connecting with MySQL 5.7 and 8.0. Problem with MySql.Data.Entity.EF6.dll missing and not able to connect with Entity framework
As per my requirements, the customer wants to migrate MSSQL to MySQL server. So I want to use any version of MySQL, installed with below configurations and achieve the connectivity
1.MySQL Server : 5.6.41
2.MySQL Connector/Net : 6.9.12
3.Entity Framework : 6.2.0
4.Visual Studio : Professional 2017
Configuration steps are below,
1. Download required versions,
MySQL - https://dev.mysql.com/downloads/windows/installer/5.7.html
Visual Studio - https://visualstudio.microsoft.com/downloads/
2. Once downloaded, Launch web API project and Install entity framework 6.2.0 through NuGet Packages
3.Install the MySQL 5.6 with Connector/Net
Once you installed, yo…
This blog provides step by step tutorial for setting up McAfee MySQL Audit Plugin in MySQL-Server-5.5.37 and platform Linux 2.6.39-400.17.1.e16uek.x86_64 #1
It is difficult task comparing with others auditing tasks.Auditing much important for all DBMS.Comparing with other DBMS MySQL auditing need to be third party plugins otherwise use MySQL Enterprise Audit Log Plugin.Using general log its performance degradation in production environment.
Third party plugin as McAfee MySQL Audit Plugin.McAfee and this plugin provide audit capabilities for MySQL Database and MySQL started supporting for plugins API since MySQL 5.1.
Below processes successfully tested in my local environment.
Prerequisites: Installing McAfee Audit Plugin needs MySQL 5.1 to latest version of MySQL Server.Only Linux Environment is feasible for McAfee Audit Plugin.Step 1 : Download Audit plugin for your version
[root@selva]# wget https://github.com/downloads/McAfee/mysql-audit/audit-plugin-MySQL-5.5-1.0.5-473-Linux-x86_6…
We are running 5 node percona cluster on Ubuntu 16.04, and its configured with master-slave replication. Suddenly we got an alert for replica broken from slave server, which was earlier configured with normal replication
We have tried to sync the data and configure the replication, unable to fix that immediately due to huge transactions and GTID enabled servers. So we have decided to follow with innobackupex tool, and problem fixed in 2 hours Followed all the steps from percona doc and shared the experience in my environment Steps involving to repair the broken Replication : 1.Backup master server 2.Prepare the backup 3.Restore and Configure the Replication 4Check Replication Status 1.Backup master server We need to configure the complete master server database into a slave. So we are taking a full backup from the master server, before proceeding the backup we should check disk space available for the backup because of its system-level backup
On windows me had this problem two times , first in my own laptop , second time in my friend laptop . I took long time to resolve this issue but before done so many methods to resolve it .
I will share the experience to resolve the instance configuration error step by step,
Error : MySQL Server Instance Configuration Wizard (Windows is Not Responding)
Steps to resolve it ,
First we clear when you get this error,in my experience first time had installed the MySQL server and deleted MySQL folder in my machine or you have tried to uninstall and install MySQL Server.
Step 1 : In your windows installation driver , you have Program files(x64),Program files and Program Data.You need to delete MySQL Folder in these three folders.But few of you installed InnoDB Table Settings in some other drive , so you need delete in that installed driver.I have installed into D drive.
Step 2 : Uninstall MySQL Server in Control Panel\All Control Panel Items\Programs and Features\MySQL
Step 3 : In your keyboar…
Sounds interesting from Percona Backup tool for MongoDB !!! I just wants to try and explore the tool with docker on today !!! Docker is first time for me , but in few days docker become favorite one to use for all kind of HA scenario works
Lets move into today's practices and issues , Note : Percona Backup for MongoDB supports Percona Server for MongoDB or MongoDB Community Server version 3.6 or higher with MongoDB replication enabled Step 1 : Launched the Ubuntu 16.04 machine from AWS , then updated the latest packages and installed the docker sudo apt-get update sudo apt install docker.io sudo systemctl start docker sudo systemctl enable docker
Once docker installed with latest package verify the docker version using docker --version Step 2 : Installed two docker mongo containers with replica set enabled