A complete guide to get started with phpMyAdmin 3.3 and master its features
The best introduction to phpMyAdmin available
Written by the project leader of phpMyAdmin, and improved over several editions
A step-by-step tutorial for manipulating data with phpMyAdmin
Learn to do things with your MySQL database and phpMyAdmin that you didn’t know were possible!
In Detail
phpMyAdmin is an open source tool written in PHP to handle MySQL administration over the World Wide Web. It can execute SQL statements and manage users and their permissions. However, when it comes to exploiting phpMyAdmin to its full potential, even experienced developers and system administrators are left baffled.
Mastering phpMyAdmin 3.3.x for Effective MySQL Management is an easy-to-follow, step-by-step guide that walks you through every facet of this efficient tool. Author Marc Delisle draws on his experience as one of the leading developers and project administrator of phpMyAdmin and uses his unique tutorial approach to take full advantage of its potential. This book is filled with illustrative examples that will help you understand every phpMyAdmin feature in detail.
The book helps you get started with installing and configuring phpMyAdmin and looks at its features. You then work on a sample project with two basic tables and perform basic actions such as creating, editing, and deleting data, tables, and databases. You will learn how to create up-to-date backups and import the data that you have exported. You will then explore different search mechanisms and options for querying across multiple tables.
Integrate the flexibility of Python and the power of MySQL to boost the productivity of your Python applications
Implement the outstanding features of Python’s MySQL library to their full potential
See how to make MySQL take the processing burden from your programs
Learn how to employ Python with MySQL to power your websites and desktop applications
Apply your knowledge of MySQL and Python to real-world problems instead of hypothetical scenarios
A manual packed with step-by-step exercises to integrate your Python applications with the MySQL database server
In Detail
Python is a dynamic programming language, which is completely enterprise ready, owing largely to the variety of support modules that are available to extend its capabilities. In order to build productive and feature-rich Python applications, we need to use MySQL for Python, a module that provides database support to our applications. Although you might be familiar with accessing data in MySQL, here you will learn how to access data through MySQL for Python efficiently and effectively.
This book demonstrates how to boost the productivity of your Python applications by integrating them with the MySQL database server, the world’s most powerful open source database. It will teach you to access the data on your MySQL database server easily with Python’s library for MySQL using a practical, hands-on approach. Leaving theory to the classroom, this book uses real-world code to solve real-world problems with real-world solutions.
The book starts by exploring the various means of installing MySQL for Python on different platforms and how to use simple database querying techniques to improve your programs. It then takes you through data insertion, data retrieval, and error-handling techniques to create robust programs. The book also covers automation of both database and user creation, and administration of access controls. As the book progresses, you will learn to use many more advanced features of Python for MySQL that facilitate effective administration of your database through Python. Every chapter is illustrated with a project that you can deploy in your own situation.
Extend MySQL to suit your needs with this unique guide into the world of MySQL plugins
A practical guide with working examples explained line by line
Add new functions to MySQL with User Defined Functions
Export information via SQL using the INFORMATION_SCHEMA plugins
Search within PDFs, MP3s, and images; offset user typing errors with fulltext parser plugins
Access your custom data formats with a storage engine plugin
In Detail
MySQL has introduced a Plugin API with its latest version – a robust, powerful, and easy way of extending the server functionality with loadable modules on the fly. But until now anyone wishing to develop a plugin would almost certainly need to dig into the MySQL source code and search the Web for missing bits of the information.
This is the first book on the MySQL Plugin API. Written together with one of the Plugin API primary architects, it contains all the details you need to build a plugin. It shows what a plugin should contain and how to compile, install, and package it. Every chapter illustrates the material with thoroughly explained source code examples.
Starting from the basic features, common to all plugin types, and the structure of the plugin framework, this book will guide you through the different plugin types, from simple examples to advanced ones. Server monitoring, full-text search in JPEG comments, typo-tolerant searches, getting the list of all user variables, system usage statistics, or a complete storage engine with indexes – these and other plugins are developed in different chapters of this book, demonstrating the power and versatility of the MySQL Plugin API and explaining the intricate details of MySQL Plugin programming.
A hands-on guide for MySQL application developers to creating feature-rich plug-ins.
Publisher: Packt Publishing; 1st New Edition (March 15, 2010)
Language: English
ISBN-10: 1847197965
ISBN-13: 978-1847197962
eBook Description:
99 great recipes for mastering MySQL configuration and administration
Set up MySQL to perform administrative tasks such as efficiently managing data and database schema, improving the performance of MySQL servers, and managing user credentials
Deal with typical performance bottlenecks and lock-contention problems
Restrict access sensibly and regain access to your database in case of loss of administrative user credentials
Part of Packt’s Cookbook series: Each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible
In Detail
MySQL is the most popular open-source database and is also known for its easy set up feature. However, proper configuration beyond the default settings still is a challenge, along with some other day-to-day maintenance tasks such as backing up and restoring, performance tuning, and server monitoring. These tasks have not been covered thoroughly in the default documentation.
This book provides both step-by-step recipes and relevant background information on these topics and more. It covers everything from basic to advanced aspects of MySQL administration and configuration. One of the things you are really going to love about this book is that all recipes are based on real-world experience and were derived from proven solutions used in an enterprise environment.
This book shows you everything you need to know about MySQL Administration. You will learn to set up MySQL replication to manage load balancing and deal with online backup and fail-over scenarios. As you consider the benefits of backing up, you might like to back up your database efficiently with advanced techniques covered in this book.
The book demonstrates how to create, modify, and delete indexes. You will also learn to identify duplicate indexes, which hinder your MySQL server performance. This book focuses on administration tasks and will help you as an administrator to optimize the database for efficiency and reliability.
You will learn to manage data efficiently by inserting data in existing database content and importing and exporting databases. The sooner you learn about taking advantage of metadata from this book, the sooner you can start using the space efficiently. Get to know about managing users and assigning privileges and regaining lost administrative user credentials. Finally, learn to manage the database schema by customizing it to automate database schema evolution in the context of application updates. Download eBook Free »
Publisher: Packt Publishing; 1st New Edition (April 27, 2010)
Language: English
ISBN-10: 1847199941
ISBN-13: 978-1847199942
eBook Description:
Over 60 simple but incredibly effective recipes focusing on different methods of achieving high availability for MySQL database
Analyze and learn different high availability options, including clustering and replication solutions within MySQL
Improve uptime of your MySQL databases with simple recipes showing powerful high availability techniques for MySQL
Tune your MySQL database for optimal performance.
The only complete, practical, book of MySQL high availability techniques and tools on the market
Part of Packt’s Cookbook series: Each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible
In Detail
High Availability is something that all web sites hope to achieve, especially those that are linked to big companies.
MySQL, an open source relational database management system (RDBMS), can be made highly available to protect from corruption, hardware failure, software crashes, and user error. Running a MySQL setup is quite simple. Things start getting complex when you start thinking about the best way to provide redundancy. There are a large number of techniques available to add ‘redundancy’ and ‘high availability’ to MySQL, but most are both poorly understood and documented.
This book will provide you with recipes showing how to design, implement, and manage a MySQL Cluster and achieve high availability using MySQL replication, block level replication, shared storage, and the open source Global File System (GFS).
This book covers all the major techniques available for increasing availability of your MySQL databases. It demonstrates how to design, implement, troubleshoot and manage a highly available MySQL setup using any one of several techniques, which are shown in different recipes. It is based on MySQL Cluster 7.0, MySQL (for non clustered recipes) 5.0.77, and CentOS / RedHat Enterprise Linux 5.3. Download eBook Free »
Entries
