Replication is one of the most popular features used in RDBMS’s today. Replication is used for disaster recovery purposes (i.e. backup or warm stand-by servers), reporting systems where query activity ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Dany Lepage discusses the architectural ...

Jack Wallen walks you through the process of connecting the DBeaver GUI tool to a remote MySQL server. If you manage a database server, you are probably always in search of a tool to make that process ...

Every business intelligence solution needs data, which might come from a variety of sources and in different formats. Microsoft SQL Server Integration Services, or SSIS, allows you to extract data ...

MySQL is a common database amongst many organizations. As such, when building an automation script that needs to query data from somewhere, you might run into the need to query a MySQL database. By ...

While many popular website applications (WordPress, Drupal, Joomla, etc.) are open source and therefore freely available, running these PHP-based apps on a Windows IIS web server requires a bit of ...

Uniform Server is a freeware server solution that lets you easily host a functional website on your Windows PC. It comes packed with Apache, MySQL, Coral, PHP and some other utilities. It is basically ...

Get up to speed on MySQL basics with this step-by-step tutorial on how to create a database, add a table, and input data into the table. I talk a lot about server software and apps that require the ...

Come October 2023, MySQL 5.7 will no longer receive updates or security patches. It’s time to understand your options and plan for the path ahead. MySQL is the most popular open source database in the ...